ANTE User ManualInventory Aging
Inventory Aging shows how long the stock you have on hand has been sitting in each warehouse, what it is worth at buying price, and which customer order or Open PO it was bought for. Use it to spot slow-moving stock and stock bought ahead for a customer that has not been released yet.
Open Assets → Inventory → All Inventory and choose the Aging tab (next to Stock and Reservations). The report only reads your stock — nothing on it changes stock.
How the Age Is Counted
Ante already knows when every item was received. For each item in each warehouse, the quantity on hand is matched to the most recent receipts first (first in, first out: what is still on the shelf is what came in last). Each part then ages from the day it was received.
Example: 100 pieces on hand; the last receipts were 15 pieces 3 days ago, 20 pieces 31 days ago, 30 pieces 90 days ago and 25 pieces 91 days ago. The row shows 15 in 0–30 days, 20 in 31–60 days, 30 in 61–90 days, 25 in Over 90 days — and the 10 pieces no receipt explains in No receipt date.
Receipts that count: goods received against a purchase order (from a workflow step, a shipment upload or the Deliveries page), refills, beginning balances, stock adjustments that add stock, production output, and transfers or moves into the warehouse. A transfer starts a new age in the receiving warehouse; the row then says, for example, 12 via transfer under the item, so that stock is never read as freshly bought.
Stock that no receipt explains — for example stock put back by a cancelled POS sale or brought in by merging two items — is shown as No receipt date instead of being guessed into an age.
Reading the Report
The cards at the top total every matching row: the quantity in each age and the value at buying price. The list is sorted with the oldest stock first.
| Column | What it shows |
|---|---|
| Item | The item, with its SKU, brand and model number underneath. |
| Warehouse | Where the stock is. |
| Supplier | The suppliers of the purchase orders the stock came from, else the item's main supplier. |
| 0–30 days … Over 90 days | The quantity on hand in each age. Over 90 days is shown in red. |
| No receipt date | Quantity on hand that no receipt explains. |
| On hand | The total quantity on hand. |
| Value at buying price | Each part's quantity × the unit price it was received at, in the purchase order's currency (stock not bought on a purchase order is in your company currency). Stock bought in two currencies shows both. |
| For customer / Open PO | The order (and its customer) the stock was bought for, and the customer's Open PO when the order came from one. |
Filtering
Narrow the list by warehouse, age, brand, supplier or customer, tick Open PO stock only to see only stock bought for an Open PO, or search by SKU, item name or model number. The brand, supplier and customer lists only offer the ones that appear in your stock. Clear filters resets them.
To see stock bought ahead for a customer's Open PO that is still waiting for a release, tick Open PO stock only and choose Over 90 days.
Downloading to Excel
- Set the filters you want.
- Click Download Excel.
- Tick the columns to include and drag them into the order you want (SKU is always included). Ante remembers your choice.
- Click Export. The file has every row that matches the filters (up to 5,000).
How It Connects
Set up first
- Warehouse — the age is counted per warehouse.
- Item Master — brand, model number and main supplier come from the item.
Gets its data from
- Goods Received — every receipt is dated, which starts the age of what it put on the shelf.
- Purchase Order — gives the buying price, currency and supplier of the stock.
- Open POs — stock bought for an Open PO order is marked with its Open PO number.
- Beginning Balance — opening stock ages from the day it was entered.
Feeds into
- All Inventory — the same stock on hand, without the ages.
- Stock Reservations — release or move aged stock to the orders that need it.