How to correct valuation issues caused by old incorrect Repack Stock Entries in bulk?

ERPNext
, ,
1

Hi everyone,

We are facing a stock valuation issue in ERPNext caused by old incorrect Repack Stock Entries created in the past.

Background:

  • Our company works in the laptop refurbishing industry.

  • Repack entries were used to convert components into finished laptop SKUs.

  • Some of these old repacks were created incorrectly (wrong quantities / wrong components).

  • Because of this, current stock valuation is incorrect for several items.

Problem:

  • The incorrect repacks were created several months ago and stock transactions have happened after them.

  • Simply cancelling them is risky because it may affect many later stock entries.

  • We have many such repacks, so correcting them one by one manually is not practical.

Questions:

  1. What is the recommended way in ERPNext to correct valuation issues caused by historical repack entries?

  2. Is there a safe way to adjust valuation in bulk without breaking the stock ledger?

  3. Would using Stock Reconciliation be the correct approach to reset valuation for affected items?

  4. Has anyone handled a similar case where historical repacks caused valuation errors?

Goal:
We want to correct the valuation while keeping the stock ledger consistent and avoiding manual correction of hundreds of entries.

Any guidance or recommended approach would be really helpful.

Thanks!

2

Hi @AshishPrajapati

Welcome to the community

I have not done it on large number of transactions but just a few

I would suggest go with the stock reco option as you dont know the unintended consequences if the system will break under stress

Thats my 2 cents… hope it helps

3

@AshishPrajapati

I would suggest to Repost Item Valuation better than stock recon as stock recon will break stock ledger as well as accounting for stock adjustment.

Repost item valuation will re run the valuation posting without breaking anything.