Hey! I am trying to get a report that will show me the aged payables by the document date... basically the open payables report but with a nice 30,60,90 column and I cant seem to be able to create this, can anyone point me in a direction?

Try the Aged Cash Requirements report.

Chris:

The current version of AP (v8.1E) has this report. It is the Aged Overdue Payables, using the 'Calculate as of' option.

Hi Ralph,

Both of these reports age by Due Date. Only the Open Payables (which is not aged) processes by Document Date.

We are hoping to address this shortcoming in a Service Pack, but the reports are complex.

Any chance of getting a report that sorts by due date i.e.

July 19, 2014

XXY Corp. $5,234.56
ABC Corp. $1,234.56

July 21, 2014
XXY Corp. $9,234.56
ABC Corp. $3,234.56

For the time being I'm trying gridview using A/P Transaction History table. What is a Uniquifier?

Thanks

That's the Aged Cash Requirements report.

BTW - the AP History file only contains fully paid transactions.

Hi Mike

GridView is the only way you'll get a report that sorts and subtotals by day, which is what you seem to want. But like Andrew implied, you'll definitely want to use the A/P Transactions table, not the History table, and you'll want to filter on non-zero current balances only.

Steve

But it sorts by customer. Any chance of getting it to sort by due date so that I can look and see what I have due for a particular day. A lot of times we send out post dated cheques and we use the Aged Cash but we have to go through each customer to see what's coming due. Not too bad when we're not busy.

Thanks Steve, just saw your post.

Still like to know what a Uniquifier is though.

A Uniquifier is a number assigned by the program to make sure that the record key is Unique, when there is a possibility of multiple records having the same key.