Correct out of Balance or missing Purchase Journals entries in GL.

Question:

How do I correct out of Balance or missing Purchase Journals (__PJ) entries in GL?      

Resolution:

To re-create the entries, take option 8-Reverse G/L Entries by Period from the AP Month End Processing menu. 

Enter the Corp# and the period# where the problem exists and press ENTER. 

If the period has already been closed, a message appears to that effect - press F20 to proceed. 

A GL Journal Entry posting report is produced showing the entries being dropped from the GL.  Then take option 1-Close Month and key a '6'=Force GL, in the Option column on the left next to the Corp/Period you want to fix.  Press ENTER and F7 to proceed. 

This job re-creates the __PJ and __DJ entries for the period, based on what is currently in the AP system.  All the normal AP month end reports are produced, including the GL Journal Entry report.  Make sure that the batch is accepted by looking at the last page.  If not, check the report for errors - errors have asterisks (**) under fields with errors, so should be fairly simple to find. Most reasons for not posting are: accounting period closed, Rejection mask issues, 4 level entity validation, etc.

For more information about closing the month and forcing new GL J/E's please see Accounts Payable manual starting on page 80.