Stock Reposting In ERPNext
The Repost Item Valuation option is utilized to correct stock quantity or valuation discrepancies resulting from wrong inputs, partial system commits, or data corruption in the Stock Ledger.
It enables you to repost and restore the stock ledger according to an Item-Warehouse combination or a given stock transaction (e.g. Purchase Receipt, Delivery Note).
1. When Do You Use Repost Item Valuation?
Use this tool when:
You see incorrect stock values or stock quantities in reports.
There are mismatches in valuation because of absent or incorrectly posted Stock Ledger Entries.
Custom scripts or bugs resulted in partial commits, and the stock transaction is not adequately shown in stock ledgers.
You are sanitizing data prior to financial year close.
2. How It Works
You can initiate a Repost Item Valuation in two manners:
1. Based on Item and Warehouse: - Use this to correct stock valuation mistakes for a particular item in a particular warehouse.
- The system will re-compute the stock value from the specified point onwards.
2. Based on Stock Transaction:
Select a document such as:
Purchase Receipt
Delivery Note
Stock Entry
Purchase Invoice or Sales Invoice (with stock)
The system will repost stock valuation according to the chosen transaction and afterwards recalculate the valuation of subsequent transactions if needed.
3. Re-create Stock Ledger Entries (Advanced Feature)
In a few unusual situations, because of a system failure or incorrect custom logic, stock ledger entries can fail to be created for a transaction. For those scenarios:
Select the checkbox Recreate Stock Ledgers.
This will do the following:
Recreate the Stock Ledger Entries for the chosen transaction.
Repost future transactions automatically to display the revised valuation.
This checkbox only displays when reposting is performed based on a transaction, rather than item + warehouse.
4. Important Financial Year Consideration
Use extreme care while applying this function for transactions of a closed financial year.
Reposting in a closed fiscal year will alter the closing stock balance, potentially affecting financial statements.
Always carry out a stock audit prior to year-end closing.
If you find problems, run the Repost Item Valuation prior to closing your books.