In Business Central, we have a report that provides inventory aging details. However, there are a few issues with this report:
1. When stock is transferred to a new location after a certain period, it is treated as fresh stock, which is incorrect.
2. Similarly, for sales returns, if inventory was sold in December 2023 but returned in February 2024, it is reflected as February inventory, which is misleading.
3. Additionally, it would be more efficient to combine quantity and value into a single report instead of having them in separate reports.
4. The report currently does not support backdated inventory aging, which limits to customers to check what was the status as in back date.
Comments
Hi All, This is still a major issue when attempting to calculate correctly the "real" age of inventory when using multiple locations and transfer orders........... has anyone found a way? or using Power Bi to remove the constraint from the standard report within BC?
Category: Inventory
I feel this current logic of inventory aging report is not correct. it really gives false information
Category: Inventory
The 1st point is very critical. Any company with multiple branches will surely have stock transfers between locations. These transactions should not be taken as fresh stock inward. Stock should be considered as ageing until it is sold out of the company This should be simple logic to apply irrespective of the fact that product is with serial number or notConcur with points 2.3.4 alsoAn immediate solution will be appreciated
Category: Inventory
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team