Aged Payables or Aged Sales reports AS AT date selections

[Geoff6]

Hi

Is anyone having trouble with the Aged sales and Purchases reports in Summary or detail, bot including the transactions outside the Date run for the report.

Example at 31/1 it includes purchases entered in Feb and just shows them in the Jan column

Sales will also show invoices paid in Feb and close them out instead of still being there at 31/1

Is it a man look or simply missing something

Cheers Geoff

[Mike_James · Accepted solution]

Hi @Geoff6 , welcome to the forum. Try using the receivables/payables reconciliation reports instead of the aged reports. The date on the reconciliation reports is a true cut-off date, whereas for the aged reports, all open transactions are included, and the date only affects the aging calculations. 

[Geoff6]

Hi Mike,

Perfect, so easy so was a Man look so close but just one down

Cheers geoff