Our client was previously using Microsoft Dynamics 365 Business Central, but the system was implemented incorrectly by the previous implementer. According to the client, incorrect unit cost calculations resulted in invalid General Ledger entries being posted over time.
We are currently reviewing the live G/L data and have found several unusual entries, including multiple negative entries, negative account balances, and transactions with extremely large amounts. At this stage, it is unclear whether these negative entries are valid corrections or reversals, or whether they were created because of incorrect unit costs, costing adjustments, configuration issues, or incorrect posting processes.
Since this is live production data, obtaining and validating all historical records and supporting documents from the client will take considerable time.
Is there a reliable way to backtrack G/L entries in Business Central and determine which entries are correct and which are incorrect?
Can this issue only be resolved if the client provides a cleaned and validated dataset, or is there a way for us to independently trace and validate the existing data within Business Central?
We would like to understand the fastest and most effective approach to:
- Trace the original source of a G/L entry
- Understand why multiple negative entries were created
- Determine whether negative entries represent valid reversals, corrections, cost adjustments, or incorrect postings
- Identify whether an entry originated from inventory costing, cost adjustment, production, purchasing, sales, or a manual journal
- Link the G/L entry to the related Value Entry, Item Ledger Entry, G/L Register, and source document
- Verify whether the unit cost and resulting G/L amount were calculated correctly
- Identify duplicate, reversed, adjusted, or incorrectly posted entries
- Determine the financial impact of the invalid entries
- Identify the root cause of the incorrect postings
- Correct the entries using the appropriate Business Central process
- Maintain a proper audit trail
- Proceed safely with the production go-live
We do not want to delete or directly modify posted ledger entries. Our objective is to identify which entries are valid, which entries require correction, and whether the existing data can be independently validated without waiting for the client to provide a completely cleaned dataset.
Are there any standard Business Central pages, reports, reconciliation tools, or recommended investigation procedures that can help with this type of issue?
Any guidance, best practices, or experience with a similar costing and G/L reconciliation issue would be greatly appreciated.
Thank you.
