General Ledger Consolidation
Solution ID = KB-246
Goal : Perform General Ledger Consolidation "Account that has [Site: "Entity name"] and [Reports To Acct: (Blank) and [Account: "acct-no"] does not exist."
Version = All Version
Module : SLACCT
Fact : GL
Database : Progress, SQL
Fix
Every month, the Ledger Consolidation utility must be run. This will copy any ledger transactions not flagged as consolidated up to the entity or entities. The Budget Consolidation must be run each time after entering or editing budget amounts. Any errors with these utilities will print on the report generated when running these utilities. No errors will print to the screen, so it is very important to check this report after running these utilities.
When dealing with a multi-tiered multi-site hierarchy, if there are more than two levels of entities the chart of accounts must be remapped from the lower level entity to the higher level entity or entities. This can be done by going into the chart of accounts master in the lower level entity, and entering in the reports to field the account and sub account for the higher level entity. For example, if the Sales account is 40000 at the Regional entity and 41000 at the Corporate level entity, in the chart of accounts record for the Regional entity, account 40000, 41000 will be entered in the reports to field. If the reports to field is left blank, the Ledger Consolidation and Budget Consolidation utilities will fail at the higher entities with the error "Account that has [Site: "Entity name"] and [Reports To Acct: (Blank) and [Account: "acct-no"] does not exist. This mapping must be done for each account.
If the chart of accounts is the same for all sites and entities, and the account at the lower level entity is the same at the higher level entities, a utility can be obtained from support that will allow a mass update of the reports to field in Progress.
On rare occasions the Entity will need to be rebuilt, or a new entity will need to be created. This can be done by running the Set Ledger Consolidation Flag utility. This will set the existing consolidated ledger records to no (not consolidated). Then, the Change Reports To utility needs to be run, then the Ledger and Budget Consolidation.Script to automatically set the Reports To Account = Chart of Account for PROGRESS versions:
for each symix.chart exclusive-lock:
symix.chart.reports-to-acct = symix.chart.acct.
end.
Script to automatically set the Reports To Account = Chart of Account for SQL versions:
update chart
set reports_to_acct = acct
from chart
where reports_to_acct is null
