Stock Overview report

[Former Member]

Hi Experts,

Need your advice,

This is regarding standard Stock overiew report, where report displays

1. Quantity Total Stock

2. Stock in Transit

3. Issue Total Stock

4. Receipt Total Stock

but my requirement is

Initial stock : stock at particular day (Variable : cal day)

goods receipts in particular period. (variable)

similarly for other KF's.

so for this I'm creating Restricted KF for initial stock

Quantity Total Stock

CAL day

but after executing this nothing is comming up (no data exists).

Can you please share some ideas, how to achive this?

Thanks In advance,

Cheers,

Rags.

[Former Member]

hi,

the problem lies with the RKF restriction, you can try to restrict the calday value as <= calday variable rather than =calday.

regards,

Arvind.

[Former Member]

Hi Arvind,

Thanks for quick response, now initial stock seems to be fine.

But how to get goods receipt or goods issue in selected period, when trying to restrict KF 'Receipt Total Stock' with cal day (interval) agian it does not display any records.

Thanks & Regards,

Raghavendra

[Former Member]

hi,

check out if there is any additional restrictions somewhere in the query which is restricting the data.

open tcode LISTCUBE and see the data in the cube for the same restrictions and see if it is there in cube.

regards,

Arvind.

[Former Member]

Hi,

I can get initial stock now, but not able to get Total Goods receipts and total goods issue.

I tried following but it's showing total quantity but i need qty in selected period not total qty,

created restricted KF on

K.F = 0RECTOTSTCK

0CALDAY

greaterthan and Equal to start day

lessthan and equal to end day

above RKF still display total qty but I need receipts qty in between start and end period.

For eg:

Total receipts til date is 1000, but receipts happened yestarday is 10, so when I select y'day it should display 10 not 1000.

Thanks & Regards,

Rags

[Former Member]

hi,

K.F = 0RECTOTSTCK

0CALDAY

greaterthan and Equal to start day

lessthan and equal to end day

if your interval for 0CALDAY will work properly then it will always give the stock quantity in that period.

the KF is cumulative only, please check the variables you are using for the interval.

regards,

Arvind.

[Former Member]

Hi Arvind,

Thanks for the response but, now facing a strange issue, when I ran the report in my development system, it's showing values, but same report after transporting to Quality, it's showing all zeros,

SC: Reporting Entity Product Initial Stock at Total Goods Receipt Total Goods Issue Final Stock a Final Stock in Transit

IT01 1000 0 ZUN 0 ZUN 0 ZUN 0 ZUN 0 ZUN

IT01 1001 0.000 KG 0.000 KG 0.000 KG 0.000 KG 0.000 KG

IT01 2001 0.000 KG 0.000 KG 0.000 KG 0.000 KG 0.000 KG

IT01 5003 0 EA 0 EA 0 EA 0 EA 0 EA

Can you let me if I'm missing anything.

Thanks & Regards,

Rags

[Former Member]

hi,

Please check the data in the cube in Quality system and if not present then load.

regards,

Arvind.

[Former Member]

Hi Arvind,

I'v already done these checks, anything other then this which is required for Inventorymanagement.

like checking validity period etc..

Thanks & Regards,

Rags

[Former Member]

hi,

check for other report restrictions.

regards,

Arvind.