Problem: The balance sheet report shows wrong values compared to the ERP system.


Solution: It's often caused by the fact that the table holding the balances is out of sync within the ERP system.


1. Within E9/E10 menu, recalculate the GLPeriodBal table


2. Edit the ClosedPeriod table in the ETL database.

2.1. Version 1.2 & later - Run the setup program for EFP/pcFinancials, if you have EFP r1.2 -> ClosedPeriod


Find the Source, EntityCode and periods you want to update & set it as ClosedPeriodCounter=0 & UpdateYN is ticked.


2.2. Before Version 1.2 - You can do this from SQL as below: 

In ETL database -> ClosedPeriod table -> make sure the period you want to update is set back "ClosedPeriod_Counter = 0 " & "UpdateYN = 1 or true".



3.1. Run the night load job manually from SQL as below: 


3.2. Or you can wait it to run automatically. Default time is 2:00AM every night.


4. You should be able to see your actual data in EFP now. You can do a extract actual + month from excel end to verify this.