AP Aged Invoice Report does not match AP Trial Balance Report in Sage 100
Description

Example: An invoice with an Invoice Date of 09/30/2015, posted with a Transaction Date of 10/02/2015, will display on the Aged Invoice Report (assuming aged by Invoice Date) when printed as of 09/30/2015. The same invoice will not display on the Trial Balance Report when it is printed as of 09/30/2015.

Example: An invoice with an Invoice Date in 09/30/2025 (mistakenly posted into the future), posted with a Transaction Date of 09/30/2015, will not display on the Aged Invoice Report (assuming aged by Invoice Date). The same invoice will display on the Trial Balance Report when it is printed as of 09/30/2015.

Example: An invoice with an Invoice Date in 09/30/2015 was posted with a Transaction Date of 09/30/2025 (mistakenly posted into the future). A negative adjustment was made to the invoice (via Invoice Data Entry) and updated with a Transaction Date of 09/30/2025. The same invoice was then positively adjusted and updated with a Transaction Date of 09/30/2015. Whether the invoice will display on the Aged Invoice Report now depends on if the report options of Exclude Future Dated Transactions is selected or not, and if Invoices to Print is set to "Open" or "All".

Cause
Resolution
[BCB:5:Third-party support:ECB]

The two reports are not generally expected to match.

  • The A/P Aged Invoice Report selects invoices to print based on the Invoice Date (or Due Date, depending on Age Invoices By option is selected for the report) and can also be set to Exclude Future Dated Transactions or not.
  • The A/P Trial Balance Report prints invoices based on the Transaction Date which is the posting date used to update to the General Ledger module's G/L accounts.

Since these two reports use different dates, they are not designed to match. Once you locate the invoice with the wrong transaction/posting date or invoice date, you will need to correct using one of the following Knowledgebase articles:

DocLink: How to reconcile Accounts Payable to General Ledger
DocLink: AR Aged Invoice Report does not match AR Trial Balance Report

[BCB:155:Chat 100 US:ECB]
Defect ID
Steps to duplicate
Related Articles