Topic Options
#68515 - 08/08/22 03:12 PM AP List by Accounting Date?
Hugh Offline
Adagio Maven

Registered: 09/25/13
Posts: 182
Loc: Victoria, BC Canada
Hi,
Is there a way of printing an AP Open Payables list by Accounting date rather than Transaction Date?
I'm trying to prove my year end GL balance for the AP Control Account and there were a couple of invoices dated the next month which I booked into the previous month to get the expense in the right period, but when I pull the Open Payables list it doesn't show those transactions...
Thanks for your thoughts!

Top
#68516 - 08/08/22 03:54 PM Re: AP List by Accounting Date? [Re: Hugh]
Patricia B. Offline
Adagio Maestro

Registered: 06/26/08
Posts: 1108
Loc: Langley, BC
Hi Hugh:

You can only run an Aged Open Payables which has the option to print by Transaction Date or Accounting Date. To balance this with the Control Account, you should have Edit Accounting Date enabled in the Company Profile in Payables and have retrieved the transactions in the GL by Subledger Date.
_________________________
Patricia Balbuena Cotlear
AP SMART SUPPORT
236 991 3060





Top
#68517 - 08/08/22 03:57 PM Re: AP List by Accounting Date? [Re: Patricia B.]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4443
Loc: Wynnewood, PA
And to add to what Patricia wrote, there is no good reason to run the Open Payables report now that the Aged Open Payables report exists, unless you want to see the discount date on the report. If Softrak had removed the Open Payables report, someone would have complained about the discount date, so they left it there.

Steve

Top
#68569 - 09/01/22 01:25 PM Re: AP List by Accounting Date? [Re: Steve Schwartz]
Hugh Offline
Adagio Maven

Registered: 09/25/13
Posts: 182
Loc: Victoria, BC Canada
Hi All!
Sorry for the delay... I actually managed to take a vacation!

So.... I guess what I really don't know how to do is to toggle between transaction date and accounting date on the report...
Does anyone know where I would make that selection?

edit: I also see that Aged Open Payables is greyed out... so maybe the option is obvious once I enable that report? I'm on 9.3C (220223) so it wouldn't be a release issue I don't think...


Edited by Hugh (09/01/22 01:28 PM)

Top
#68570 - 09/01/22 02:27 PM Re: AP List by Accounting Date? [Re: Hugh]
Bruce Gardner Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3491
Loc: Toronto ON, Canada
Hugh:

Congratulations on the vacation. smile

if the "Aged Open Payables" report is greyed out, you have to adjust your Security Group so that you have access. And once you do that, you will see the option to toggle between the dates on the report dialogue.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#68571 - 09/01/22 02:39 PM Re: AP List by Accounting Date? [Re: Bruce Gardner]
Hugh Offline
Adagio Maven

Registered: 09/25/13
Posts: 182
Loc: Victoria, BC Canada
Brilliant! Thanks Bruce!
One of those areas that you set up and then don't think about again for the next 9 years...


Edited by Hugh (09/01/22 02:40 PM)

Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 40 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1846 Members
5 Forums
14222 Topics
69648 Posts

Max Online: 359 @ 11/18/19 09:08 PM
March
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