Share
Report
66I am currently migrating opening balances from our old production company to a new production company for the period 1 January 2026 to 31 July 2026.
During the migration, I found that some Item Ledger Entries and related Value/Ledger Entries were posted with incorrect unit costs. Because these incorrect cost entries were used in subsequent transactions, they have resulted in incorrect G/L balances, including negative amounts in some Chart of Accounts.
The database contains around 30,000 ledger entries, so manually identifying and correcting each affected transaction is not practical.
I would appreciate your advice on the following:
- Is there a recommended way to identify all ledger entries that were impacted by incorrect item costs?
- Is it possible to exclude or remove only the incorrect ledger entries before migrating the opening balances to the new production company?
- What is the best practice for ensuring that only the correct balances are migrated so that the new production company starts with accurate Chart of Accounts balances?
- Has anyone handled a similar migration where historical cost errors affected the G/L, and if so, what approach did you take?
Any guidance, best practices, or suggested tools/reports would be greatly appreciated.
Thank you!
Categories:
I have the same question (0)
All responses (
Answers (
