The Inventory Age Report allows the user to view physical inventory information based on the date that the physical inventory item was added to stock. To run a report, access Reports > Inventory > Age.
The date that is captured by RevolutionEHR for reporting purposes is set by the date that the stock quantity is changed or added for a specific physical inventory item. This can occur in three different ways:
- When the physical inventory item is first added and stock quantity is set at that time.
- Stock quantity can be changed at anytime by manually entering a new quantity number in the quantity field.
- Receive Stock allows the user to add to the stock quantity.
When stock quantity on a specific physical inventory item is greater than one, the following rule is applied when that quantity is decremented: The first item added is the first item removed. For example, the stock quantity on a specific frame is changed to one on January 3rd, and the quantity is then increased to two on January 15th. When a frame is sold, RevolutionEHR removes the frame that was added on January 3rd first. Therefore, the age report on the remaining frame displays the age based on the frame added on January 15th.
Using the rule above, the inventory age report displays the age based on current stock, in addition to the age based on any stock that ever existed for that item.
In addition to the standard columns displayed in all inventory report grids, the age report contains six columns referencing the age:
- Min Age Stk: The age of the newest stock for this specific physical inventory item that is currently still in stock.
- Max Age Stk: The age of the oldest stock for this specific physical inventory item that is currently still in stock.
- Avg Age Stk: The average age of the stock for this specific physical inventory item based on the items that are still currently in stock.
- Min Age: The age of the newest stock for this specific physical inventory item. This number is historic, and represents the age of the newest stocked item including items currently in stock and items no longer in stock.
- Max Age: The age of the oldest stock for this specific physical inventory item. This number is historic and represents the age of the oldest item stocked including items currently in stock and items no longer in stock.
- Avg Age: The average age of all stock for this specific physical inventory item. This number is historic and represents the average age of the items stocked including items currently in stock and items no longer in stock.