Stock Reconciliation For the Valuation Rate Only

[dineshpanchal432]

Dear Team,

Any idea about. To change the valuation rate of Particular item on opening.

1. 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.

[mangroliya]

Hi,

Put the Qty 100 only and change the Rate to 11.20 and the Amount (100 * 11.20) in the Stock Reco entry.

Thanks,

Divyesh Mangroliya

[dineshpanchal432]

@mangroliya i tried that way also, but it created two opening entries.

100 @10
100 @11.20

Total 200 Qty.

There is no difference in qty

[mangroliya]

Hi,

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.

Thanks,

Divyesh Mangroliya

[dineshpanchal432]

Still same i tried with many ways . even with Purpose as “Stock reconciliation”.

[mangroliya]

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.

Thanks,

Divyesh Mangroliya

[dineshpanchal432]

@mangroliya Thank you for the very detailed Info…

I tried the same. I think you are using v13

I am in v14 latest branch.

[mangroliya]

Hi,

I am also on the version-14

Thanks,

Divyesh Mangroliya

[dineshpanchal432]

[dineshpanchal432]

thank you it worked !!

[dineshpanchal432]

@mangroliya Thank you so much … Actually, it was Batch wise Item so that was the error.