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

Registered: 09/25/13
Posts: 186
Loc: Victoria, BC Canada
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: 4509
Loc: Wynnewood, PA
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: 186
Loc: Victoria, BC Canada
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: 186
Loc: Victoria, BC Canada
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
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: 186
Loc: Victoria, BC Canada
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
Unposted stuff is never reflected in any report but the batch listings.
_________________________
Andrew Bates

Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 82 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14459 Topics
70635 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
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