Page 1 of 2 1 2 >
Topic Options
#34589 - 12/28/12 12:59 PM Payables integration with Ledger
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4446
Loc: Wynnewood, PA
From a client...

Is there a way to stop the zero posting to accounts payable in the GL for every check that is written?

Steve

Top
#34591 - 12/28/12 01:22 PM Re: Payables integration with Ledger [Re: Steve Schwartz]
Ralph Allan Offline
Adagio Virtuoso

Registered: 06/02/04
Posts: 694
Loc: Prince George BC
Steve,

How do you get zero posted to accounts payable? It should be a debit matching the credit to bank.
_________________________
Ralph Allan
Business Computer Centre
Prince George BC Canada

Top
#34592 - 12/28/12 02:58 PM Re: Payables integration with Ledger [Re: Ralph Allan]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10493
Loc: Canada
Perhaps they are doing nothing but Cash Invoices and consolidating the Ledger transactions?
_________________________
Andrew Bates

Top
#34593 - 12/28/12 03:00 PM Re: Payables integration with Ledger [Re: Ralph Allan]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4322
Loc: Vancouver, BC
Steve:

Why would you want to stop it, it's part of the audit trail?

Ralph:

Zero dollar cheque (check) to clean unmatched transactions in AP - Dr Bank $0 Cr Payables $0.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#34596 - 12/29/12 03:58 AM Re: Payables integration with Ledger [Re: Douglas Dickie]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4446
Loc: Wynnewood, PA
They migrated from Adagio Checks to Payables, and all they ever do is enter Cash Invoices into Manual Check batches.

They are not consolidating, but they do have the box "Send check instead of cash invoice" ticked, and that setting causes a consolidation of the Payables account activity so the amount being sent to Ledger is one line totalling $0.

They don't want that zero dollar transaction to post in the Ledger, a pretty reasonable request.

Steve

Top
#34597 - 12/29/12 06:01 AM Re: Payables integration with Ledger [Re: Steve Schwartz]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10493
Loc: Canada
Should AP not generate it, GL not retrieve it, GL not post it, or GL consolidate it out of the account?
_________________________
Andrew Bates

Top
#34598 - 12/29/12 08:15 AM Re: Payables integration with Ledger [Re: Retired_Guy]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4446
Loc: Wynnewood, PA
AP should not generate it. It shouldn't be in the Print/Consolidate GL Transactions report; right now it's there with a blank amount, almost like a comment.

Top
#34599 - 12/29/12 11:05 AM Re: Payables integration with Ledger [Re: Steve Schwartz]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10493
Loc: Canada
In the meantime, you could customize the report and have it select only non-zero entries.
_________________________
Andrew Bates

Top
#34600 - 12/29/12 12:59 PM Re: Payables integration with Ledger [Re: Retired_Guy]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4446
Loc: Wynnewood, PA
I could, but they don't actually print the report, they retrieve the underlying data into the Ledger. I don't see any workaround for that.

Steve

Top
#34601 - 12/29/12 01:32 PM Re: Payables integration with Ledger [Re: Steve Schwartz]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10493
Loc: Canada
That's why I asked the question. What if Ledger discarded $0.00 transactions on retrieve?
_________________________
Andrew Bates

Top
Page 1 of 2 1 2 >


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 46 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1848 Members
5 Forums
14242 Topics
69746 Posts

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