When perplexed Sage 100 users call me while trying to reconcile the General Ledger and ask, “Where in the world did this posting come from?” I can almost see the furrowed brows and tilted heads looking at computer screens with oversized magnifying lenses. Never fear. Detective Knudsen is here to solve the mystery!
How can you track down a GL posting in Sage 100?
First, you’ll need to understand how General Ledger entries are generated.
The two-digit source journal can be generated in the following ways:
- Automatically processed as a “Register” within modules such as AR Sales Journal and AR Cash Receipts Journal
- Manually processed as a “Journal” in a General Journal entry
- Manually processed as a “Journal” in a ‘Transaction Journal entry
To see the distinction between the numbering of registers and journals, look under the General Ledger > Setup > Source Journal Maintenance (Image 1)
There are two ways to determine whether a source journal has been used in a register posting or in a journal entry.
- The General Ledger Detail Report (not condensed) shows the source module of the entry. Is the source a module other than General Ledger? If yes, that posting was generated when printing and posting a register. (Image 2)
- In the Customizer module, add the Source Module column to the Account Inquiry > Transactions Screen. (Image 3)
(See Appendix below for instructions.)
Follow the Source Journal code to determine the specific process that has occurred.
The list below is not comprehensive, but it does include many of the usual suspects. Also, while daily transaction register posts these entries to the General Ledger, you can trace the source journal code to the menu option required to generate this entry.
Here are the steps to add the Source Module to the General Ledger > Main > Account Inquiry >Transactions Screen: Customizer > Main > Customizer Selection (Image A1)
Expand the General Ledger | Account Maintenance folders. Choose the PTRANSDTL (Transaction Detail Panel). Click the Edit Panel Icon located to the right of the panel.You can now create a new panel or modify an existing entry. (Image A2)
Click on Panel Map. (Image A3)
Highlight LB_TRANSDTL. Click the Edit Item button. (Image A4)
Go to the Format Tab. Click the Add button. (Image A5)
Highlight “Source Module.” Click “Select.” (Image A6)
Click OK. Click “Save” to save the panel. Close the panel. To see the new column, go into Account Inquiry. (Image A7)