The Ageing reports, both Customer and Supplier, work based on an Ageing Date. Any invoice or credit dated after this date will not be included in the report. This can cause situations where a credit note or payment may appear by itself without an invoice if the invoice is future dated.
Find future dated invoices, credit notes or payments
To find future dated invoices, credit notes or payments:
Go to Customers or Suppliers, Masterfiles, Customers or Suppliers, Enquire.
Use Trans (F5) to list the documents for the Customer/Supplier.
Find the missing document and note the date. If the document is dated in the future compared to the ageing date, this will be why the document is not appearing in reports.
Correct the date on a document the document needs to be reversed
To correct the date on a document the document needs to be reversed:
Reverse an Invoice: Reverse an invoice with a credit note dated on the same future day.
Reverse a credit note:
Reverse a payment:
Re-enter the document
Once the document is reversed, it should be re-entered with the correct date so that it appears in the report:
If an invoice, any existing credits or payments will need to be allocated to the invoice using Post Unallocated Trans.
If a credit or payment, it should be allocated to the relevant invoice