Inventory aging report - Calculate aging days from GRN date always.

Posted on by CU27051036-0

Scenario- If a item A is having a quantity of 3.40 which was received on the year 2017 with a specific batch, when users run an Inventory aging report storage it is showing under the period bucket 5 with 120 days.

On the bases of requirement- if user moves the partial inventory from the existed WH to new warehouse as of current date and when user generated the report, system is displaying the moved quantity in 30 days bucket.

Business Expectation- As the existed inventory was received in the year 2017 and though user move the quantities from current warehouse to required warehouses, Inventory aging report storage should show the data in period 5 bucket-(120 days).

Summary - The aging days should be calculated from the GRN date, regardless of any changes in the warehouse location in between.

Categories:

Inventory and warehouse management