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

Steve,

How do you get zero posted to accounts payable? It should be a debit matching the credit to bank.

Perhaps they are doing nothing but Cash Invoices and consolidating the Ledger transactions?

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.

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

Should AP not generate it, GL not retrieve it, GL not post it, or GL consolidate it out of the account?

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.

In the meantime, you could customize the report and have it select only non-zero entries.

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

That's why I asked the question. What if Ledger discarded $0.00 transactions on retrieve?

That would definitely work.

Andrew:
I think Steve's suggestion makes sense. There are other situations where a $0.00 transaction comes from AP to the GL. For instance, if a detail line is being added to an AP invoice and a tax amount is calculated (using a Distribution Code) but then zeroed out manually, the $0.00 tax entry flows to the GL (issue sent recently to Support).

In this case I don't think the transaction should even be created at all in AP.

Some people want to see the $0.00 transaction so they know it was "considered".

Andrew:
I can see that being a possibility in some transactions but I doubt it's the case in the example I described; Certainly the client that pointed it out thought it was unnecessary and confusing.

But if that's an issue, then discarding the entry at the time of retrieval to the GL would be a reasonable compromise.

Doing it on the retrieve to Ledger makes it available for all modules.

Hi Steve,

I've found that the option in Adagio Payables to 'Send check instead of cash invoice' (on the Integration tab) is the cause of the 0.00 detail in the GL retrieved batch. Disabling this option (and thus writing the cash invoice value to the Reference field of expense details) in the current shipping release will cause the GL batch to have separate GL debit/credit detailst that offset.

Yes, I've discovered that too. However, it is the enabling of the option that makes former Adagio Checks users happy.

Steve