Scenario :
Company's books have manually entered transactions that incorrectly utilized the system generated CTA Account that are logged in accounting period Dec 2020.
Company's books also have manually entered transactions that incorrectly utilized the system generated Retained Earnings Account that are logged in accounting period Jan 2018.
As a result, standard Financial Reports such as the Balance Sheet carries two CTA lines, one that totals the amount of the manually entered transactions, and the bottom line total, which NetSuite Customer Service has advised is a combination of the dollars on the manually entered transactions and the true system generated CTA dollars.
Regarding Retained Earnings, the Jan 2018 entries cause discrepancies between anything pulled via Saved Search and what is reflected in the standard Financial reports. **Understood that variances between Saved Searches and Financial reports are not terribly uncommon, but ours is in significant enough dollar amounts that it becomes difficult to translate to leadership internally, to BOD, and to any audit facilities.
Question :
Has anyone else dealt with this type of scenario, and if so, were you able to address and potentially correct the incorrect entries that occurred in the way-back-machine by any means at all that did not involve having to open long-closed periods? In addition to this not being best practice in general, the periods/years these transactions occurred in have long since been through audit processes.
If not, does anyone know of a means of suppressing those lines from appearing in reporting, and in a way that doesn't alter actual numbers being reported?
**Understood that this one is a bit messy, hopefully I've explained the issue clearly enough but please let me know if I've left out any relevant information.
