Any idea about. To change the valuation rate of Particular item on opening.
- Created a Stock reco Purpose - Opening Stock ( 100 Qty with 10.00 INR Valuation Rate )
We need to change it to 11.20 INR ( Valuation Rate ) Qty was correct.
How can we achieve this ??? i tried many ways and with 0 Qty i posted entries in stock reco and reposted that item with given warehouse didn’t work for me.
Put the Qty 100 only and change the Rate to 11.20 and the Amount (100 * 11.20) in the Stock Reco entry.
@mangroliya i tried that way also, but it created two opening entries.
Total 200 Qty.
There is no difference in qty
You need to select the purpose as “stock reconciliation” and not opening entry.
Also keep the same Warehouse and Batch if you enabled the Batch.
Still same i tried with many ways . even with Purpose as “Stock reconciliation”.
Stock Balance Before Stock Reconciliation
Now Go to Stock Stock Reconciliation and Create the Stock Reconciliation as follows:
Choose the purpose: Stock Reconciliation
Add items in Grid by clicking on the “Fetch Items from Warehouse Button”
Current Stock and Valuation rate will be populated as follows in the Grid:
Now Change the Valuation Rate before Save keeping the Qty as it is:
Now Save and Submit the Document:
Check the Stock Balance Report Again and you can see the change.
@mangroliya Thank you for the very detailed Info…
I tried the same. I think you are using v13
I am in v14 latest branch.
I am also on the version-14
@mangroliya Thank you so much … Actually, it was Batch wise Item so that was the error.