Posting $0 Entires to the General Ledger

[Diver69]

We use a custom made integrated client facing solution to communicate with ACCPAC (5.3) It creates all of our transaction activity into the Accounts Receivable module. This includes all of our complimentary items.

During the testing phase before the integration went live, testing was done to ensure that the AR sub-ledger was receiving the data accurately, which it was, including $0 complimentary items.

We recently discovered that any $0 line item in any GL posting batch, whether from AR, or GL Transactions, it will not post the transaction line. The system does not return an error, but the line itself will not appear in the transaction listing report, nor in the account history activity.

We were expecting to use this information for reporting (and it works great for anything with a transaction value), however, without the complete information, the reporting is useless.

Is there an option that can be activated to allow $0 transactions to process normally?

Could this be a Pervasive setting? Could i make some SQL adjustments to allow this sort of functionality?

Thanks for your input

Sr. Financial Analyst
Toronto, Ontario

 

[Jay Converse]

Nope, not a thing you can do. $0 = 0 GL, makes perfect sense. You'll have to do your reporting from AR tables.

 

[DjangMan]

If you turn on quantity tracking on the account and assign a non-zero quantity to the transaction then it will post to the GL.