Stock ageing report without Batch Management

[Former Member]

Hi Gurus,

My client wants a Stock ageing report. But my concern here is can we achieve this without batch management

According to my client, Inventory ageing report should show stock quantities and stock value as follows,

1. Below one year

2. Between one and two years

3. Above two years

We can accumulate the goods receipt as per Material document date and movement type according to the above age requirement.

But, can we track goods issues from the above age groups without Batch Management.

Experts Pls reply and If possible, pls explain how we can achieve this.

Thanks

NDS

[csaba_szommer]

As you already noticed not only the input (GR) but the output (GI) is also important.

The date of the GR is only one thing, but after that you received the goods in your SLoc you cannot make difference between stocks received at different times.

As your stock is not distinguished in the system as per the GR date you cannot say that which sub-stock has been consumed during GI.

So, without batch management you cannot achieve your goal in standard system.

Of course, physically you can realize your idea by putting labels on different batches - this would mean batch management physically and not in SAP.

If you use warehouse management you can use a workaround: the GR date is stored in the quants and this makes possible to track the age of the stock without batch management. Please check:

http://help.sap.com/erp2005_ehp_04/helpdata/EN/c6/f83b5e4afa11d182b90000e829fbfe/frameset.htm

Regards,

Csaba

[Former Member]

Hi Naveen,

Pls have a look on the blw link which is the std sap reports, its provided by sap.. hope it will be helpful for u.

https://www.sdn.sap.com/irj/scn/wiki?path=/display/erplo/sapStandardReports