Inventory Total stock Quantity Key figure issue

[former_member219411]

Hello all,

I have encouter issue with Total stock quantity key figure calculation.

details as below

Have material XXXXXX with below details in ECC

Total received quantity is "9" EA

Issued quantity is "0.500" EA

Total stock as on Date shows as 8.5 EA.

Problem in BW report

Where as when it comes to BW ,in inventory report the total stock quantity shows as "9" EA whcih is wrong.

The total quantitiy figure shoud show as "8.5 " EA .

I have verified cube and underlying DSO and found that both received quantity and issued quanitity have been loaded correctly.

Please help me to figure out how the key figure "Total stock quanatity " is not considering Issued quantity value"0.500" EA.

I have problem with only this material remaining materals are loaded correctly.

Thanks & Regards,

Puru

[mr_v · Accepted solution]

In query, click KF 'total stock quantity' and in 'Display' check decimal places. You should select 0.0

[former_member219411 · Accepted solution]

Hello,

I chaged as suggested, but still total stock Quantity shows as 9.0 EA

not as 8.5

Any further suggestions ?

Thanks ,

Puru