28
G

Aged Inventory

Gareth Seymour on 8/19/2019 1:40:50 PM
On the same basis as customers and vendors, we need to have an Aged Inventory report from three perspectives. With the quantity of the unit of measure shown under the aged columns.

a) Days from initial Lot receipt (ie. days on the floor)
b) Days until expiry
c) Days since last tracked sale

This is important as it allows us to test for inventory obsolescence based on aging data. If possible it would also be useful to have the last used selling price and the latest unit cost.

To the left of the aging columns, it would be important to have this report run taking the Location, Lot number, Item code and Bin code.

Thanks
Category: Inventory
STATUS DETAILS
Needs Votes
Ideas Administrator

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.

Meanwhile, could you please have a look at available reports:
  • Item Expiration - Quantity (5809). Report shows an overview of the quantities of selected items in your inventory whose expiration dates fall within a certain period. The list shows the number of units of the selected item that will expire in a given time period. For each of the items that you specify when setting up the report, the printed document shows the number of units that will expire during each of three periods of equal length and the total inventory quantity of the selected item.
  • Item Age Composition - Quantity (5807) or Item Age Composition - Value (5808). Report show an overview of the current age composition of selected items in your inventory. The list shows the number of units or value of the selected item that were added to or removed from inventory and at which point in time. Items can be added to or removed from inventory as a result of purchases, sales, and positive and negative adjustments.


Best regards,
Business Central Team

Comments

G

G

RE: Aged Inventory

Toni Long on 4/12/2022 4:14:57 AM

The Item Age Composition - Value report, should reflect the Remaining Qty on hand during the period, multiplied by the Average Cost, however currently to arrive at average cost of month/period, it Adds all the Cost amount (Actual) /Add all the Quantity in that period, which gets an inaccurate Unit cost and then multiplies that by the Qty remaining. If this report is fixed so that the movements & values are ignored, but just the Remaining Qty is determined x Average Cost, the 5808 report will be much more accurate and informative, currently it can provide misleading information.

Category: Inventory