P99 Adjustments
On occasion, it is necessary to adjust the postings already made in the previous financial year. This is done in OpenAccounts using a P99 adjustment. This allows the overall figures to change, without affecting those reported in any given period
Prior to making your adjustment, it is advisable to run NL25: Trial Balance Report for P12-P99
Output the report as a Spreadsheet
Once the Spreadsheet has been produced, save it to the required folder
If the adjustments need to be made to the Project Ledger, it is also advisable to run a report for this ledger that outputs in a similar format (for comparison). The easiest way to get the data in the same format from the Project Ledger is to run PC14: Project Executive Enquiry
Once the enquiry has run, Select Activity Code to change the display
Then use the functions under the Right Mouse Button to export the data to Excel. Save this spreadsheet alongside the Trial Balance report run previously
Prepare the adjustments to be made on the appropriate Journal Type, for posting to P99. This will be either GLSTN, for the General Ledger or COJNL for the Project Ledger
Load your journal(s) using IF48: Spreadsheet Import. If you are unable to post to P99, contact your system Administrator for assistance
Audit and Update the journals
Re-run NL25/PC14 and save the new figures as spreadsheets. Check the new amounts to the originals to ensure the difference is correct