You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to delete cancelled invoice and it's accounting entries?

One of our users mistakenly entered an invoice line with an incorrect amount—a 20-digit number. Although the invoice was later cancelled, it had already been accounted for and posted to the General Ledger (GL).

When we extract GL transactions into Excel, the amounts are not displayed accurately due to Excel’s limitation of handling only up to 15 digits in number fields. Digits beyond the 15th are replaced with zeros. For example:

Actual backend amount: 55602000000000000560.0000000000

Excel displays: 55602000000000000000.00000

As a result, the net balance in Excel does not reconcile to zero, which could raise concerns during audits - especially since all our financial reports are generated in Excel.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!