cancel
Showing results for 
Search instead for 
Did you mean: 

Inventory issue with negative quantity

Former Member
0 Kudos

Hi Everybody,

My project is in Production Support & I'm stuck at one point.

I have an inventory cube which shows correct quantity values for issues and receipts but shows negative in the file.

We send a file to business through infospoke.

I have done various analysis but never got to the root cause of the issue.

Can anybody give me suggestions or different ways of analysis???

Parthiv.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

You should compare the values of inventory in cube with the database table, which you get data from R/3 ! That brings you to be sure the data is correct or not? If it is correct you cant do anything !!! That has happened me before.

With Regards,

En.

Answers (1)

Answers (1)

Former Member
0 Kudos

Thanks for your reply Engin,

You are right with that. I have checked and it is good till the cube. The total quantity matches with database table. There is a BAdI implementation at the infospoke to export the data to a file.

The file contains negative quantity values for more than 156,000 records.

The code used in BAdI :

i_data_out-material = i_data_in2-material.

i_data_out-plant = i_data_in2-plant.

i_data_out-stor_loc = i_data_in2-stor_loc.

i_data_out-totalstock =

i_data_in2-rectotstck - i_data_in2-isstotstck.

But the file shows negative value of isstotstck as total quantity.