I was task to develop this report based on the following user's requirements:

1) Aging by Warehouse/item.
2) Aging is calculated from the date the inventory is received into warehouse from vendor (purchase receipt).
3) If an item is transferred from warehouse A to warehouse B, then the aging for this item in warehouse B should be calculated from the date when the inventory is received warehouse A from vendor.
4) Items are not lot control.
5) User should be able to print the report based on a passed date.
6) User has sevaral warehouses of which the inventory can be transferred within this warehouses.

Can anyone tell me if I have the enough information to build this report. If yes, can I know the tables.

Thanks in advance.

HI Teddy,

For preparing Inventory Aging Report, your Inventory Outbound method must be FIFO or LIFO in order to track the inventory date.

I have prepared a SRS, may be this can help you, just go through it.

Hi Nishant,

Thanks for the reply.

If an item is transferred from one warehouse to another (Point 3 in my first post), how can you find the GRN date in the original warehouse ?

HI Teddy,

There is not impact of Transfer Date or GRN Date on Inventory Date, your Inventory Date will remain same till it is out from your system & the Inventory Date will be generated when you recieve the Inventory in ur system for the first time.

Hi nishant,

Remember that our inventories are not on lot controlled. So, the inventory date is not available in table whinr140.

Please correct me if I am wrong.

Hi Teddy,

If your Inventory is LIFO/FIFO controled then definetly whir140 is updated with inverory transaction date..

Well if you are not finding date in whinr140 , it means your inventory is location controled .

Now come on the solution part.
Take the selection of Item, Warehouse , And transaction date from table whina112.
If whina112.qstk<>whina.qskt then use the whina.qskt= In hand Inventory.
Now store the whina112.koor,whina112.orno, whina112.pono, whina112.srnb, whina112.itid.

Now the basis of whina112.itid open the table whina124. Find the whina124.tror
if the whina124.tror=’64’( Warehouse receipt) . then open the table whina114 on the basis of whina112.koor,whina112.orno, whina112.pono, whina112.srnb and find the whina114.trtd( The GRN date)
else
In Case of whina124.tror = ‘1’(purchase order)/production receipt then whinh124.trtd is actual receipt date.

Hope this will help in your scenario.

If any further query please mail me @ rajiv.bobby@gmail.com

Hi,

As i hav already mentioned in my first post, you need to have FIFO OR LIFO outbound method to calculate the correct age of stock lying in your W/H.

If you calculate the Age on the basis of Inventory Transaction date, you can't get the correct age, as Inventory Transaction date will update for each nd every transaction (in warehour transfer also which u hav mentioned in ur query) & you can never track your inventory without a unique ID.

As per me you hav to use LIFO/FIFO outbound method to track your inventory.

Hi,

I am agree with you !! if we use FIFO/LIFO then we can get correct agging according to your given SRS, But if the Inventory is not LIFO/FIFO controled. In that case, we can also get the agging through mentioned procedure in my previous post.
In my post i am also consedering, Whether the transaction is purchase/Production/warehouse transfer, If it is warehouse transfer, then system go back and capture the actual Transaction date when GRN was made.

It might be a lengthy logic .. but according to my observation , i will work accordingly

Hi Rajeev, nishant,

Thanks for all the suggestion.

Our inventory is not FIFO/LIFO. So, have to consider Rajeev's suggestion.

Once again, many thanks for the great help.

hi,
I tried with almost the same logic, Iam in ERP LN FP7 and my outbound is by location.
and it is not by LIFO/FIFO.
I ve found the list of GRNS made which is ending up in whina112.qstk by going inside a loop between 112 and 114 tables, but how do i match the resultant whina112.qstk in the list of GRNs which is obtained from query.
My to be consumed qty (whina112.qskt) is after many transfers between 2 warehouses.