G/L files

[DonQuixote]

We use the old "Financial Report Generator" for our G/L reports.  What files are used? Specifically, I'm looking for the budget amounts.  The G/L budget report from the "Financial Report Generator" is not matching the report from the Budget Listings on only one account.  Any suggestions on tracing down the problem.

[Tom Pellitieri]

Original Budget numbers are posted in CA attribute 3 and CA.STAT attribute 6.  These attributes store MONTHLY budget values in a multi-value matched to the Fiscal Period in Attribute 2 in both files.

In your financial reports, you need to make certain the sign of the budget numbers are appropriate to the account type.  For example, if your report subtracts costs from sales to get gross profit, your budget numbers for cost must be positive, not negative.

Also, make certain that you are including all of the GL items in the financial report detail section.  For example, we have multiple locations and departments, but we limit which ones we use in certain parts of the report.  When we add a new department, we have to add that GL wildcard to the appropriate section.

You should review the definition for the line in the report that is incorrect, as well as the sign on the budget values.

We generate our budgets in Excel before we load them into Prelude.  There are over 1,000 GL entries with budget values to update each year, so it was easier for us to verify the budget in Excel and transfer them rather than have someone manually enter 12,000+ values, which have to be entered as whole dollars.

[DonQuixote]

I cannot say for sure the real cause or solution but this is what I do know. 
The budget values in CA & CA.STAT files did not match. 
I ran the 'C/A Wild Card Cross Ref Build' &  'Report Explosion' which i understand should be run whenever there is a change in the G/L accounts or descriptions (which is happening).  Still no change
Then I ran the "Rebuild CA Description Prefixes" and re-ran the reports. Magic. Balanced.