| Accounts Payable and General Ledger are out of balance (accounting date changed on entries in GL) |
Cause | Future dated entries that are in Accounts Payable had the accounting date changed on the entries in General Ledger.
For example, an Accounts Payable entry was entered with a 10/1/2021 date instead of 10/1/2020. Instead of making the correction in Accounts Payable, the accounting date was changed on the entry in General Ledger using Tasks, Change Entries. Accounts Payable still has the entry as 10/1/21 but General Ledger has it posted to 10/1/2020. The reports for 10/1/2021 show Accounts Payable and General Ledger are out of balance. |
Resolution | [BCB:5:Third-party support:ECB]
- Refer to article ID 17905 "DocLink: How do I reconcile Accounts Payable to General Ledger using reports?" to identify the entries creating the out of balance.
- Determine the correction to be made in Accounts Payable.
- Using the example above, the invoice would have to be changed in Accounts Payable to the correct date of 10/1/2020 with the original date 10/1/2021 selected as the reversing entry.
- After correcting Accounts Payable, determine the correction to be made in General Ledger to get Accounts Payable and General Ledger back in balance.
- Using the example above, you could either change the accounting date on the rejected reversing entries in the GL new file from 10/1/2021 to 10/1/2020 as was done with the original entries, or use GL Tasks, Record Entries to record a reversing set of entries for 10/1/2020.
Contact your Sage 300 Construction and Real Estate Consultant for assistance with reconciling and determining the correcting entries needed.
Refer to article ID 50270 "DocLink: Accounts Payable and General Ledger are out of balance" for other possible causes and solutions.
DocLink: How do I reconcile Accounts Payable to General Ledger using reports? DocLink: Accounts Payable and General Ledger are out of balance
|
|