I recently upgraded Simply Accounting to the 2012 version and upgraded Adagio FX to version 9.0B. I had a report that worked fine until the upgrade now having issues with to totals on the report.

The report is a summary of revenue and expense by department.
There is a row for each department, summarizing the revenue in a range of accounts from 4000 to 4999. The expense is also summarized on rows by department for the range of accounts 5000 to 5999. The columns are actuals compared to budget, for current month, ytd, annual budget and budget remaining.

The report specifications are:
Col. A contains .RangeDept
Col. B contains account number range
Col. C contains coding to get the Department code from Simply
Col. D contains coding to get the Department name from Simply
Col. F and on are the colums for actual, budget, variance etc.

With the rows rolled down, I get the appropriate summary for each department.

The problem is at the totals row.
The actuals total is correct, the budget totals are doubled.

The issue appears to be reading the budget data from Simply Accounting. Simply has a budget amount for account number (with no departments) as well as a budget amount for each department.

The row for each department is correct for actuals and budget. When it gets to the end of the departments, the total of all departments includes the budget amount for the account number as well as the departments.

How can I get the report to not include the budget amount on the 4 digit account number and only the budget amounts for the Account-Department.

the actuals are OK because they are allocated to departments and not to the four digit account.

Thanks

Edit the Budget figures in Adagio FX (under Edit | Budget data) to zero the amounts Simply stores at the account level. You could also zero these amounts by importing a file of the account numbers and defaulting the budget figures to zero.

When you next retrieve your Simply data, enable the "Use existing budgets/forecasts" option on the retrieve dialog to prevent having to repeat this process.

Thanks, I will try this.

At this point I don't know what other reports are being run that might need budgets at the account level. Just courious, what changed in the upgrade to the latest version of Adagio FX or Simply because the report worked fine before.

This behaviour is mentioned in the FX Release Note.