Forum Discussion

Geoff6's avatar
Geoff6
User
4 years ago
Solved

Aged Payables or Aged Sales reports AS AT date selections

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's avatar
    Mike_James
    4 years ago

    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. 

2 Replies

Sort By
Replies have been turned off for this discussion
  • Mike_James's avatar
    Mike_James
    Ultimate Partner
    4 years ago

    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's avatar
      Geoff6
      User
      4 years ago

      Hi Mike,

       

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

       

      Cheers geoff