Material Revaluation with negative stock

[Former Member]

Good Afternoon,

Iu2019m working with negative stock, standard valuation method and item cost by warehouse in SAP B1 2007 SP01 PL08.

I need to update the standard cost of all items and I'm trying to do that using the Stock Revaluation Transaction but I have the error message: u201CItem XXXXX has been selected with a negative stock quantity and cannot be revaluedu201D and u201CSelected items cannot have a negative quantityu201D. There is any option to work around these messages and update the standard cost?

Thank you,

Susana Cunha

[senthil_m · Accepted solution]

Hi,

When youu2019re doing stock revolution for an item with a negative quantity, sap system will not allow you to revaluating for an item. It has to be in positive value or zero value. Negative inventory management is a bug in SBO.

M. Senthil

[Former Member · Accepted solution]

Hi Senthil,

I don't know how could you so sure about Negative inventory management is a bug in SBO. You know, there is not much you can do once the inventory become negative. SAP allows it happen simply because some one may not or may not have a way to care about the accuracy of the inventory. The best way is setting to not allow it. The negative inventory is never logical for any applications to MANAGE them.

Thanks,

Gordon

[senthil_m · Accepted solution]

This message was moderated.

[JesperB1 · Accepted solution]

Hi,

Indeed negative inventory is not a bug. SAP would not recommend using negative stock but the system allows it and also has functionality to cater for it accounting wise and valuation wise.

Hope that clrifies the issue.

Jesper

[Former Member]

Hi Susana Cunha,

There is no other work around if you leave the negative stock for revaluation. You have to adjust the stock to 0 or positive quantities first. Then you could revaluate them. Afterward, reverse the inventory back to original quantities.

Thanks,

Gordon