1. Please feel free to check more information regarding to Closed Period.

2. Go to pc_ETL database from your SQL server.  

  • Tables -> dbo.ClosedPeriod -> right click on it and choose Edit Top 200
  • Find the right sourceID, EntityCode, year and month
  • If you need to find SourceID information, please go to your SQL server -> pcINTEGRATOR -> Tables -> dbo.source
  • Put 0 in ClosedPeriod_Counter
  • Put True in UpdateYN
  • Make sure your mouse is in next row, to make this change work.



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. Login modeler -> financials model -> re-process model button.

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