Handling Stock Mismatch After Data Migration in ERPNext

ERPNext Customize ERPNext
,
1

Hi everyone,

We recently migrated five years’ worth of data from a previous application to ERPNext. However, we face an issue where the stock does not match the current opening balance.

Problem:
I attempted to adjust the stock using Stock Entry, but some stock items(Serial) already exist in the migrated warehouse.

This causes discrepancies in stock valuation and availability.

Question:
What is the best way to reconcile stock mismatches in ERPNext after migration?

Should we use Stock Reconciliation, or is there another recommended approach to ensure correct opening balances?

Could you provide guidance on the correct steps to fix this issue?

2

Working with historic data during migration is a big job and consumes extensive time and effort to reach to a final result.

In your case, it is advisable to set a nearest cut off date sometime in near past and run stock recon with accurate final balances and move on with accurate daily recording for the current period.

This is how you can go along and fix the issue.