Stock on hand as of any date, inventory position, cut and sold, open to sell by date, aged inventory with FIFO or LIFO valuation, time phased inventory and a production forecast, by style, color, size and warehouse.
The inventory analysis reports in AIMS360 read stock, work in process and customer orders together, by style, color and size, as of today or any date you name. What can ship now, what can be promised for a delivery, where production is short, what the stock is worth and how old it is, and how much to reorder for the styles that sell on. Printed, dated and exportable, from the same records the warehouse and the order desk are working in.
A set of dated inventory reports on styles and materials: stock on hand as of any date, inventory position, cut and sold, open to sell and open to sell by date, time phased inventory, aged inventory with FIFO or LIFO valuation, and a production forecast. Each one reads stock, work in process and customer orders from the same records, by style, color and size, and each can be filtered by warehouse, date and minimum stock.
They exist because stock on hand answers almost nothing on its own. An apparel brand needs to know what is on the shelf and not yet promised, what is in a cut or on a vendor purchase order and when it lands, which sizes are sold past what exists, what the goods were worth at the close, and how much of a core style to make again. Those are five different reports in most systems, run against five exports. Here they are one set, on live data, with the style, color and size grid and the warehouse already in every row.
Most inventory arguments in an apparel company come from two people reading two of these and thinking they are the same.
Stock minus customer orders. Immediate open to sell: what could go out the door today if every open order took its share first. The number for immediates and dropship feeds.
Stock plus work in process minus customer orders. Sometimes written OTS(w). What you can commit for a delivery once open cuts and purchase orders land. The default in the style list.
The warehouse number: stock minus allocations, pick tickets and goods in transfer. It ignores unallocated orders and anything in production, so it can sit above OTS(i) until orders are allocated.
A transfer between warehouses reduces open stock on the sending side the moment it is created, but the style's OTS does not move until the goods are received at the destination. For a day or two the two numbers disagree, and both are right.
| Report | What it answers |
|---|---|
| Stock on hand, as of any date | Styles, summary reports, stock tab. Units by style, color and size as of the date you pick, rebuilt from the full history of receipts, adjustments and invoices. Tick include dollar values for the ending inventory value accounting needs; the cost basis defaults to the higher of manufactured and importer cost. Run all warehouses combined, every warehouse listed under each style, or one warehouse at a time. Treat negative as zero when you want the report to ignore negative stock, and filter to styles below or above their minimum stock. |
| Inventory position | Date range, then styles, optionally narrowed by division, collection, style group or warehouse. One line per style and color with invoices and credit memos, stock, WIP, open orders, OTS, OTS(i), available to allocate and wholesale price. A second format drops the invoice history and lists the open production and the open or hold orders behind the numbers, with a color subtotal and a style total, the same view as cut and sold with the detail attached. |
| Cut and sold | Styles, summary reports, cut and sold tab. The quick check: per style and color, WIP, stock, available (WIP plus stock), picked, orders on open or hold status, OTS (available minus orders), shipped and ordered plus shipped for the life of the style. The detailed version adds the size scale across the page and a minus column that flags any size sold past what exists. Set the minimum OTS field to -1 to list only the problems, or 1 to list only what is clean. |
| Open to sell by date | Reports, orders. The production report. Set a WIP date range and an order date range, by start or completion date, to match your delivery calendar, and the report shows stock plus WIP minus every customer order through that date. Negative rows are where production is short. Exclude styles without orders to skip the manual selection. Formats add the extended wholesale value of stock, WIP, orders and the resulting position, or the style's default image. |
| Open to sell for sales | Styles, open to sell, with or without images. Same math, no customer detail, so it can go straight to the sales team: what is still available considering all stock, WIP and orders, or through a delivery date. Prints the style's default image when one is set. |
| Time phased inventory | Styles. A running position that changes every time an order or WIP date lands inside the range: the style line, then each cut, purchase order or garment dye receipt, then each customer order, then the new position after that date. A summary option rolls all orders or all WIP on one date into one row. Rendered in the Excel viewer, so export it to print. A worked example is in the time phased inventory report walkthrough. |
| Aged inventory, vendor purchase orders | Styles, aged inventory. An inventory valuation by age for brands who buy finished goods on vendor purchase orders. FIFO by default, LIFO available. Summary gives quantity and value per style and color; detailed grouped by style color shows the purchase orders behind the estimate; detailed without grouping lays units and cost out across 0 to 30, 31 to 60, 61 to 90, 91 to 180 days and older. The as of date option runs it for a past month end and a chosen warehouse. |
| Production forecast | Styles, production forecast. For core and ecommerce styles that sell on. Give each style a replenishment code with a percentage, pick how many months to forecast and how many months of sales history to use, choose whether the order start, complete or entered date drives the history, add an uplift percentage if you expect growth. The output shows trailing sales, forecast sales, open WIP, ending inventory and a replenishment quantity per month. How brands use it against over and underproduction. |
| Materials stock on hand and moving balance | The raw material side. Stock on hand for fabric, trim and components, and a moving balance that rebuilds an as of date report from every material transaction, with the value at cost when costs are selected. |
Sales and margin reporting on the same orders is on sales order reports; sell through by style is on style analysis. The pivot views of stock, WIP and allocation are in the built in BI, the live list views are the grids, and the standing view for management is a dashboard or Power BI.
Can I ship it: OTS(i) on inventory position or cut and sold. Can I promise it for March: open to sell by date. Where is production short: the negative rows on that same report, or the minus column on cut and sold. What was it worth at the close: stock as of date with dollar values, or aged inventory as of date.
As of date for a snapshot. For the forward looking reports, a WIP range and an order range, each by start or completion date, matched to your delivery calendar. Leave the start date empty to pull in past due WIP and late orders that still have to be filled.
The styles button opens the same list you filter and sort everywhere else, or use exclude styles without orders and skip it. All warehouses combined, every warehouse under each style, or one location. Role based permissions decide who sees costs and which warehouses a user can report on.
Summary or detail, with wholesale value, with the style image, with sizes across the page. The first page returns fast; the Excel style controls in the viewer let you widen, sort, filter and freeze columns before you read.
Memorize the criteria where the report offers it and run it from the dropdown next time. Export to Excel for printing or for the file, or hand the standing version to Live Excel.
Inventory position or cut and sold, read the OTS(i) column. Stock minus every open order, by style, color and size, before anyone allocates.
Open to sell by date with WIP and order dates set to the window. Stock plus what lands, minus what is already sold through that date.
Cut and sold detailed with minimum OTS at -1. Only the styles with a negative size print, and the minus column says by how much.
Stock as of the last day with include dollar values. The last page is the ending inventory value, at the higher of manufactured and importer cost by default.
Aged inventory, detailed without grouping. Units and cost across 0 to 30, 31 to 60, 61 to 90, 91 to 180 days and older, from vendor purchase order receipts.
Production forecast. Trailing sales, forecast sales, open WIP, ending inventory and a replenishment quantity per month, driven by the style's replenishment percentage.
For the dropship feed that sends OTS(i) to a retailer automatically, see the EDI 846 inventory advice. For how allocation consumes these numbers, see intelligent allocation.
| Control | What it does |
|---|---|
| As of date | Rebuilds the stock report from the full transaction history, so last month end, last year end or any day in between comes out exactly as it stood. |
| WIP dates and order dates | Set separately on the open to sell by date and time phased reports, each as a range or an end date, and each by start or completion date. Match them to your delivery calendar and the report tells you what production has to cover. |
| Warehouses | All warehouses combined is the default. Display stock by warehouse lists each location under the style. Selecting one warehouse reports only that location; for aging by warehouse, run once per warehouse. |
| Treat negative as zero | Negative stock should not exist, but where it does, this keeps it out of the totals and the value. |
| Minimum stock | Enter a MinStock per size on the style, then filter any stock report to styles below or above it. The forecast can consider it too. |
| Exclude styles without orders | The fastest way to run open to sell by date without picking styles by hand. Exclude orders past their completion date is the companion switch. |
| Include dollar values | Adds cost and ending inventory value to the stock report for the accounting close. The cost basis is the higher of manufactured and importer cost unless you choose otherwise. |
| FIFO or LIFO | Aged inventory values what is left by the most recent receipts (FIFO) or the earliest (LIFO). Confirm the method with your accountant; the report supports both. |
| Summary or detail | Nearly every report has a one line per style and color version and a version with sizes, purchase orders or customer orders behind each number. |
| Formats | Open to sell by date with extended wholesale value, open to sell with the style image, inventory position with cut and sold detail. Same criteria, different output. |
You have some quantity or you have zero. A negative usually means a pick ticket created without stock, goods received to the wrong style or an adjustment never posted. The stock report will count it unless you tell it not to, and the production forecast cannot do its math on a negative ending inventory, so find the cause before you trust the numbers.
Styles, summary reports, stock tab. As of date set to the close, include dollar values ticked, treat negative as zero if finance wants it that way. The ending inventory value is on the last page.
Display stock by warehouse with every location tagged puts each warehouse under the style on one report. A single warehouse selection reports that location alone.
Aged inventory as of date, FIFO unless your accountant says otherwise, detailed without grouping for the 30, 60, 90 and 180 day columns. One warehouse per run if the split matters.
Materials stock on hand for fabric and trim, or the moving balance rebuilt as of the close with value at cost.
Negative sizes on cut and sold, unposted adjustments, transfers not received. A cycle count of the styles that moved most catches the rest. Then run the pack again; the as of date makes the rerun exact.
Aging is calculated from purchase order receipts. Goods made on cut tickets or through garment dye are not aged by this report today. Use the stock report as of date for their value, and ask about the Live Excel aged inventory report, which the implementation team builds with up to three years of history.
Time phased inventory and the production forecast are built in the Excel viewer inside AIMS360. Export or email them and print from Excel; the viewer is for reading, sorting and filtering.
Select several warehouses and aged inventory totals them. For a per warehouse aging, run it once per warehouse.
Styles without a replenishment code are skipped. Create the codes with their percentages, assign them through global changes on styles, and give the report a history it can average.
The set of style and material inventory reports under reports: stock on hand as of any date, inventory position, cut and sold, open to sell and open to sell by date, time phased inventory, aged inventory for vendor purchase orders, the production forecast, and materials stock on hand with the moving balance. Together they answer what is on hand by style, color and size, what is in production, what is already promised, what is open to sell today and on any date, what the stock is worth and how old it is, and how much to replenish.
OTS(i) is stock minus customer orders: what you could ship right now. OTS, sometimes written OTS(w), is stock plus work in process minus customer orders: what you can promise once open production lands. OTS is not stock. Stock only changes when you invoice or receive goods; OTS moves every time an order is entered or a cut is issued.
Because they answer different questions. Open stock in the warehouse module is stock minus allocations, pick tickets and goods in transfer. It ignores unallocated customer orders and anything in production. OTS(i) subtracts every open order whether allocated or not, and OTS adds WIP. Take an order without allocating it and open stock stays put while OTS(i) drops.
The stock report, on the stock tab of the style summary reports. Pick the as of date and it rebuilds units by style, color and size from every receipt, adjustment and invoice in the history, with the ending value when include dollar values is ticked. For material inventory the moving balance module does the same job.
Run the stock report as of the last day of the month with include dollar values ticked; the last page carries the ending inventory value. The cost basis defaults to the higher of manufactured and importer cost. For an aged view of the same date, run aged inventory as of date, one warehouse at a time if you need it by location.
Open to sell by date. Set the WIP and order dates to your delivery window and every negative row is a style, color and size that has more orders through that date than stock plus production. The cut and sold detailed report is the quick version: its minus column flags any size sold past what exists, and a minimum OTS of -1 lists only the problems.
For a date range and a set of styles: invoices and credit memos, stock, WIP, open orders, OTS, OTS(i), available to allocate and wholesale price, one line per style and color. Its second format lists the open production and the open or hold orders behind the numbers with color subtotals and a style total, so you can see what is driving a position without opening each order.
A running inventory position that changes on every date an order or a WIP receipt is due. Each style and color shows its line, then the cuts, purchase orders or garment dye receipts, then the customer orders, then the new position after each date. A summary option rolls everything due on the same date into one row. It renders in the Excel viewer inside AIMS360, so export it to print.
By the vendor purchase order receipts that have not yet been consumed by customer orders, FIFO by default or LIFO if you choose, at the price on the purchase order line at receipt, or the actualized cost if you actualize purchase orders. The detailed report spreads units and cost across 0 to 30, 31 to 60, 61 to 90, 91 to 180 days and older.
Not today. The aged inventory report reads vendor purchase order receipts only. Brands that manufacture on cut tickets or garment dye use the stock report as of date with dollar values for valuation, and a Live Excel aged inventory report, which the implementation team can build with up to three years of aging history.
Forecast sales are the average of the selected months of history, lifted by any percentage you add. Replenishment is forecast sales times the style's replenishment percentage, minus the previous month end inventory and open WIP; if that is negative it is zero. Styles without a replenishment code are skipped, so assigning codes, most easily through global changes on styles, is the setup step.
Yes. Every stock report offers all warehouses combined, every warehouse listed under each style, or a single warehouse. Open to sell by date, time phased and inventory position take a warehouse selection too. Aged inventory totals whichever warehouses you select rather than splitting them, so run it once per warehouse when you need the split.
They count in the origin warehouse until they are received at the destination. In transit stock reduces open stock in the warehouse module on the sending side but does not move the style's OTS, which is why a transfer in progress can make the two numbers disagree for a day.
Yes. Enter a minimum per size in the MinStock column on the style, then choose total stock below set minimum on the stock report. Above minimum works the same way, and the production forecast can consider the minimum where a style has few or no orders.
Every report exports. Time phased inventory and the production forecast are built in the Excel viewer, so they have no direct print button; export them, or email them, and print from Excel. For a workbook that refreshes on its own, Live Excel reads the same inventory data; for a standing dashboard, Power BI does.
Yes, in the built in BI modules. Stock BI carries allocated stock quantity and available to stock quantity by style, color and size, WIP BI carries allocated quantity and available to allocate, and both let you drag warehouse, division, season or any custom field into rows and columns. The reports on this page are the printed and dated views; BI is the cross tab.
Yes. Reports follow the same role based permissions as the rest of the system. A user whose role does not include costs does not see the dollar values, and a warehouse user scoped to one location reports on that location.
Under reports in the left navigation: the style summary reports carry the stock, cut and sold tabs; inventory position, time phased inventory, aged inventory and production forecast sit in the styles section; open to sell by date is under orders; materials stock on hand and the moving balance are under materials.
What can ship, what can be promised, what it is worth. We will run it on your own styles in a demo, as of any date you name, and show you which report belongs to which question.
