Inventory valuation Report negative cumulative value

[Former Member]

Hi Experts,

When i have checked the inventory valuation report for one item it showed me negative cumulative value although the qty reflecting is positive.what should be to avoid to reflect in balance sheet. At the time of importing opening stock since stock was not proper so negative inventory was allowed.i think that might be one reason but whta should be the solution

mona

[Former Member]

Logged to SAP

[Former Member]

Hi Mona,

I have experienced similar thing in the past and the reason was:

1. Inventory was not managed Per WH.

2. Item Cost for items was substatially higher in WH01 than Wh02. Stock accounts for WH01 and WH02 are different and G/L account determination is by warehouse

3. Stock Audit Report is taken on "Summarise By Account".

For example

1. GRPO 2 Qty on WH01@$100 :Avg is $100

2. GRPO 2 Qty on WH02 @ 20: Avg now is $60. Note that inventory is not managed by WH

3. Sales Invoice on WH02 for 1 qty; it will go out of stock at $60

4. Stock audit report taken on stock account of WH02 will show cumulative qty 1 and cumulatve value -20

Regards

Dave

[Former Member]

i HAVE LOGGED TO SAP THE ISSUE..................

[Former Member]

Hi Mona...........

As per your problem it seems you didnt enter the unit price while uploading opening stock because of which you will get the stock updates but will not get value updates. So obviously it should go negative (Cumulative).

Let me think abt the solution and will positively reply you.

Regards,

[Former Member]

Hi,

Will SAP handle this issue at the time of Inventory Valuation Check?

Regards-

Mona.

[Former Member]

Dear Mona,

Inventory Valuation Report is actually a fictitiuos report that shows you what the "Fictitious Stock Audit Report" will be like if we had our range of items configured as another type of Valuation Method instead of the current one. To see if your inventory really have negative cumulative value, run the Stock Audit Report.

Im not sure if SAP will handle them in IVC anot, but to know if your database is eligible for IVC, you may run a IVC Check SQL Script to see if your database is affected by legacy SBO bugs or not.

Hope it helps!

Warmest Regards,

Chinho