Forum Discussion

Geoff6's avatar
4 years ago

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

  • 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. 

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User

    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

      Hi Mike,

       

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

       

      Cheers geoff