Stock Reconciliation - Set Valuation Rate of Zero in stock items

[mulyadi-agtechsg]

Hi,

I currently have some items 0 in quantity.

What I did was using the Stock Recon Tool to set its valuation rate. However, although it says submitted, when I checked my Stock Ledger, valuation rate is still 0.

Also, is it possible to allow negative quantity in stock recon?

Perpetual Inventory is checked. And we allow negative stock.

I have read the following threads

Stock Ledger Entry Table and its behaviour in saving the Valuation Rate

We never thought in that way, from the usability point of view. I agree with you, we can maintain valuation rate, even if available qty is zero. And we can use that valuation rate as default rate, in the next incoming stock entry.Can you please raise an github issue for this? We will fix this in version 4.0. On 16-Mar-2014, at 4:33 pm, Addy <ad...@gmail.com> wrote: Hi, I just noticed that the stock ledger table which stores the valuation rate for items is doing one thing wrong according to…

Thanks!

[umair]

Hello,

You have mentioned that Item’s current stock level is zero. Perhaps that’s the reason it is showing valuation rate as zero as well.

Please elaborate your requirement of negative stock and valuation with an example.

[mulyadi-agtechsg]

Hello @umair

Thank you!

I tried to do Material Receipt after Stock Recon but Valuation Rate is still $0.00

Negative stock happens usually at the start of using ERPNext when user have negative stock on hand. i.e. Purchased before ERPNext but delivered after.

The only way I can set the Valuation Rate to an item with zero stock is by doing the following.

1. Material Receipt of item to set quantity to 1
2. Do Stock Recon, set qty to item to 0 with Valuation Rate

Thanks.