Has anyone implemented Inventory Aging in D365FO based on a batch date instead of the standard transaction receipt date?
We have a client requirement to calculate inventory aging using a batch-related date such as batch creation date . As per my understanding, the standard Inventory Aging Report uses inventory transaction receipt dates and not batch dates.
Our client wants to know:
The actual age of the inventory item based on when it was originally received and warehouse where the inventory is currently stored.
Example:
Item is received into Warehouse 1 on January 1.
After 90 days, the item is transferred from Warehouse 1 to Warehouse 2.
The client expects the item age to remain 90 days because the inventory itself is 90 days old.
However, when Warehouse is enabled as a dimension in the Inventory Aging Report, the aging appears to be recalculated based on the transfer transaction, resulting in a younger age than expected.
When Warehouse is not included in the aging report, the age is calculated correctly, but then we lose visibility of the warehouse where the inventory currently resides.
Has anyone encountered a similar requirement? If so:
How was it addressed?
Was a standard solution available, or was customization required?
Looking forward to learning from your experience and recommendations. Thanks in advance.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
463
