03-28-2009 01:28 PM - edited 03-29-2009 09:58 AM
My Client is on MAS500 7.2 and we are using FRx 6.7.7032 with the currency translation add-on for his financial reports.
I'm looking for a trial balance with 4 columns for the functional currency and then 4 columns for the converted numbers.
I'm using the CCAVG for the conversion format code and have entered monthly conversion rates in the 'daily rates' folder for 12/31/06 thru 3/31/09. They don't want to get into historical rates at this point.
I created a Trial Balance Row Format and for my columns I have Desc, GL-CUR/BB, CUR DR's only, CUR CR's only, GL-YTD (I have this for the functional currency and then repeated the columns for USD currency). I have FUNCT in the Curreny Display for the 1st set of columns and USD in the second set.
The beginning balances are causing me problems. They were entered as beginning balances for 1/2007 in MAS500 and when generating the report for period 1/2007, I was getting an error "Subscript out of Range".
I asked the implementation person to enter these beginning balances as transactions with a date of 12/31/06 which she did by creating a 1 day year - MAS500 sees this as period 1/2006. In realty it's period 12/2006 - not sure if this is causing me any problems which is why I'm stating this fact. I'm still getting the same message when I run the Trial Balance for period 1, 2006. When I click ok, the report generates with Current Month Activity translated but not the beginning and ending balances (they are 0). Same thing for period 1, 2007. Period 2 runs without error, but the beginning balances are the net of the transactions from the prior month (and do not include the actual beginning balances).
Does anyone have any experience with this add-on in FRx that can help me out?
I did find out that one of the errors I'm getting 'error setting filters in CCAVE YTD columns' is fixed with service pack 10, I'm hoping this resolves the problems.
I also was looking at my test database on my system and found the beginning balances were entered as a batch type of 'beginning balance' vs 'standard' or 'transactions'. I entered another entry as a standard using a BB journal and that entry will show as a beginning balance the following month. So maybe FRx doesn't recognize the 'Beginning Balance' batch types? However, this was not the case on my clients live data, beginning balances were entered as 'standard'. But hoping SP10 will correct as stated in previous paragraph.
07-06-2009 12:02 PM
Not sure if this is your issue, but page 16 in the SP 10 release notes mentions the following in the "Issues specific to Sage MAS 500 ERP 7.0 and 7.05.
The Currency Translation amount is not bringing in the correct amount if the
GL column is pulling in prior year, Base-1/USD and the Company's
Home(Functional) currency is USD.