• Registered: 11/15/2009
  • Posts: 18

Topic: aged supplier report problem

Hi,

When I use the 'aged supplier' report it seems to just display all outstanding invoices, the 'end date' does not seem to effect the outcome.

If I have a payment term of 30 days set for each supplier, how do I get the report to only display invoices that are 30 days+ older than the 'end date' on the report screen?

Thanks for any help,

David

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: aged supplier report problem

For Invoices and credit notes the due date is used as comparing to the end date. For payments it is trans date.
So if you have an invoice with trans date 01/01/2010 (MM/DD/YYYY) and a due date 01/10/2010 and an amount $1000 and an end date of 01/04/2010
this amount will show up under current.
If the end date was 01/12/2010 the amount will show up under 1 - 30 days. Given these operations I guess you can set the end date to display your needed information.

/Joe

  • Registered: 11/15/2009
  • Posts: 18

Re: aged supplier report problem

Hi Joe,

Thanks for the info.

What I am after is an aged creditors report that will show only the invoices due at a certain end date. For Invoices/Credits FA uses the due date and for payments it uses the Invoice date (trans date?). The same with aged debtors, you only really want to know the ones due for payment or for chasing.

So if the end date is 15/01/2010 (dd/mm/yy) then it would display only the invoices etc that are due on or before that date-I'm sure I could work out a report with repgen.

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: aged supplier report problem

Maybe you could run the Supplier Balances Report instead.

/Joe