Topic Options
#52142 - 12/27/16 01:59 PM AP Aging help
Hugh Offline
Adagio Maven

Registered: 09/25/13
Posts: 191
Loc: Victoria, BC Canada
(184.71.30.114)
Honest, I DID search, but couldn't find anything...

What I'm trying to do is an aged payable list that ages what's coming up due, rather than what's past due... virtually none of my payables are ever overdue, but I'm doing AP runs weekly and it would be nice to see columns showing what's coming up due in 15 days vs what's coming up due in 7, if you see what I mean...

Top
#52143 - 12/27/16 02:26 PM Re: AP Aging help [Re: Hugh]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4543
Loc: Wynnewood, PA
(96.245.177.5)
That's the Aged Cash Requirements report, you will probably want to edit the aging periods when you run it.

Steve

Top
#52145 - 12/27/16 03:00 PM Re: AP Aging help [Re: Steve Schwartz]
Hugh Offline
Adagio Maven

Registered: 09/25/13
Posts: 191
Loc: Victoria, BC Canada
(184.71.30.114)
Well don't I feel like a doofus! Thanks Steve!

Top
#52146 - 12/27/16 03:09 PM Re: AP Aging help [Re: Hugh]
Hugh Offline
Adagio Maven

Registered: 09/25/13
Posts: 191
Loc: Victoria, BC Canada
(184.71.30.114)
huh... not quite what I needed... no option to specify 'open' invoices, in other words the report doesn't reflect current payments. It shows paid item as part of the cash required... could this be a setting?

Top
#52147 - 12/27/16 04:41 PM Re: AP Aging help [Re: Hugh]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
(23.16.30.130)
When I print the report, it does not show any transactions with a Current Amount of $0.00. It only shows (and ages) transactions with a non-zero current amount. Paid (matched) transactions are not printing on the report.

BTW - There is a Cashflow report in BankRec that ages payables and receivables to determine likely cash position.
_________________________
Andrew Bates

Top
#52162 - 12/28/16 04:09 PM Re: AP Aging help [Re: Retired_Guy]
Hugh Offline
Adagio Maven

Registered: 09/25/13
Posts: 191
Loc: Victoria, BC Canada
(184.71.30.114)
Andrew, you crack me up! of COURSE there's a module for that!
Thanks for the reply, I'll have a look again and see if I can figure out why mine's still including the paid stuff... maybe it's because the payment batch hasn't been posted that it's not reflected?

Top
#52163 - 12/28/16 08:45 PM Re: AP Aging help [Re: Hugh]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
(72.143.227.30)
Unposted stuff is never reflected in any report but the batch listings.
_________________________
Andrew Bates

Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 111 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1873 Members
5 Forums
14553 Topics
71030 Posts

Max Online: 432 @ 01/20/25 10:17 PM
October
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31