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.