.png)
Best selling styles by units or by customer count, gross margin by style, sell cost markup and margin, cut and sold, season and division scorecards, style adjustments history and BI pivots.
The style analysis reports in AIMS360 read customer orders, invoices, production and stock by style, color and size and turn them into the questions a merchandiser asks: what sold best, to how many accounts, at what margin, in which season and division, and whether you cut what you sold. Ranked, dated, costed and exportable, from the same records the order desk and the warehouse are working in.
A set of reports that measure each style's performance from the orders, invoices, production and stock already in the system: the hot list ranks top sellers by units sold or by the number of customers who bought; the shipped tab totals units and dollars sold for any period; cut and sold shows WIP, stock, orders, open to sell and life of style shipped per style and color; who bought what gives gross margin by style; sell, cost, markup and margin checks costing against wholesale price; order line item detail scores a season by style; style adjustments lists every transaction that moved a style's inventory; and Order BI and Invoice BI pivot all of it by season, division, class or any custom field.
They exist because a style has two stories. The demand story is who ordered it, how many, and at what price. The supply story is what was cut or bought, what landed, what is still open and what was returned. Most systems make you export both and join them in a spreadsheet. Here the style master already carries the season, division, class, cost and size scale, so every report can filter by them, print them, and cost against them without a lookup table.
| Report | What it answers |
|---|---|
| Hot list (top selling styles) | Reports, styles. Ranks styles by quantity sold (ordered plus shipped minus returned) or by the number of customers who bought, by style and color or by style alone. Order date by start or completion, a date range, a style selection, a minimum quantity so the long tail drops off, and print with or without the style image. The two sort orders often disagree, and that disagreement is the point: the style you sold the most units of and the style the most accounts bought are usually two different styles. |
| Shipped (style summary reports) | Styles, summary reports, shipped tab. Units shipped per style and color for a period, with quick presets such as last year, a style selection with tagging by style and color, and include dollar values for the sales dollars beside the units. The one to run when the question is simply how many of this style did we sell in a year. |
| Cut and sold | Styles, summary reports, cut and sold tab. Per style and color: division and season codes, WIP, stock, available (WIP plus stock), picked, orders on open or hold status, OTS (available minus orders), units shipped and units ordered plus shipped for the life of the style. The detailed version lays sizes across the page, prints historical data by size for a date range, and its minus column flags any size sold past what exists. Life of style sell in and sell out on one line. |
| Who bought what (gross margin) | Reports, customers. Date range, warehouses, detail by style and color or summary by style: units shipped, units returned, sales dollars, cost of goods and gross margin. Cost basis is your choice: maximum, purchase landed, purchase FOB, manufactured, or make or buy. The style level profitability report, with the customer detail behind it when you want it. |
| Sell, cost, markup and margin | Reports, styles. Wholesale price, cost by the method you select, markup and margin per style, filtered to styles above or below a margin or markup percent. Built to catch styles whose costing is missing or wrong before the season ships: if the brand expects a 50 percent margin, anything more than two or three points either side needs a look at the bill of materials or the importer cost. |
| Order line item detail | Reports, orders. Units ordered, open, shipped and canceled by style for a season or a date range, sorted by style with a color subtotal. The season scorecard: one run per season, every style and color on it, canceled units in their own column so a style that booked well and then fell apart shows up as what it was. |
| Style adjustments | Styles, summary reports, adjustments tab. Every transaction that changed a style's inventory in a date range, each tagged by type: manual adjustments, automatic adjustments from inventory reconciliation, invoices, manual invoice adjustments, credit memos, purchase order receipts, cut receipts, garment dye receipts, physical inventory, EasyShop, case pack and unpack, and transfers in and out between warehouses. Run by transaction date or by the date it was posted, include or exclude any type, add dollar values, and send it to the grid for the exact time, user and workstation behind each line. |
| Production history by style | Vendor purchase order details report sequenced by style and color, with a date range, listing every purchase order a style was on including canceled units. The faster route is the WIP list view: all POs, line details by size, filter to the style, sum the ordered and received columns, or group by color for the quantities per color. See production tracking for cut tickets. |
| Style BI | Order BI and Invoice BI in the built in BI. Drag style, season, division, class, style group or any custom field into rows and columns, years or months across the top, booked or shipped units and dollars as the values, percent of grand total, and year over year as a calculated field. The cross tab the printed reports do not have. |
Stock, open to sell and aging by style are on inventory analysis; booked, shipped and open by customer and rep are on sales order reports. The sell through math itself, with a calculator, is in the sell through rate guide.
Hot list, order date by start, the season's date range, sorted by quantity. Then run it again sorted by number of customers and compare the top ten.
Who bought what, summary by style, gross margin version, cost basis set on purpose. Sales dollars, cost of goods and margin per style with returns in their own column.
Cut and sold. WIP, stock, orders and OTS beside life of style shipped, per style and color. Detailed version for the size that was oversold.
Order BI: style in rows, season in columns, booked units as the value, percent difference as a calculated field. Or order line item detail once per season.
Style adjustments for the style and date range. Every receipt, invoice, credit, count, transfer and manual adjustment, with the user and time in the grid view.
Vendor purchase order details sequenced by style and color, or the WIP list view summed by style and grouped by color. Ordered, received, and the difference.
For the reorder decision that follows, the production forecast on inventory analysis turns trailing sales into a replenishment quantity per month. For the season calendar behind the questions, see wholesale order management by season.
Best sellers: hot list. Margin: who bought what or sell, cost, markup and margin. Supply against demand: cut and sold. A season by style: order line item detail. A style's inventory history: style adjustments. Across seasons or divisions at once: Order BI.
Order start or completion date on the hot list and the order reports; invoice date on the shipping log and who bought what. The same month measured two ways gives two totals, and both are right for what they count.
The styles button opens the list you already filter by season, division, style group, class, status or any custom field. Tag, done. Or sequence by style and color and take the whole line.
Quantity or customer count on the hot list, with a minimum quantity to trim the tail. Above or below a margin or markup percent on the costing reports. Minimum OTS of -1 on cut and sold for problems only.
Screen first, with the Excel style controls to sort and filter. Print with images for the sales meeting. Export to Excel for the file, or hand the standing version to Live Excel so it refreshes on its own.
The higher of the style's manufactured cost and its purchased cost. The default on every report that offers a cost option, so a style costed both ways reports its more conservative margin.
The landed price on a style bought finished on a vendor purchase order. Where a style carries both FOB and landed, the landed price is used.
The cost rolled up from the style's bill of materials. The right basis for styles cut in house or through contractors, and the one that moves when fabric prices move.
Every margin report reads the cost on the style master at the moment you run it. That makes the reports fast and consistent, and it makes them planning numbers. Actual landed cost lives in purchase order actualization and the accounting close; the weighted average cost guide covers how brands carry it into the books. Pick the basis on purpose, and pick the same one every time the report goes to management.
Two short reads on the math: how to calculate profit margin in fashion and setting wholesale and retail prices, with a margin calculator.
Season and division are fields on the style master, not tags you add at report time. So the style selection on any report filters by them, cut and sold prints both codes on every line, margin by order runs by division, and Order BI and Invoice BI put either one in rows or columns. A brand running a contemporary label and a diffusion line as two divisions gets the same style reports per division, and a season over season read is one BI view with two columns.
Style group, class and up to ten dropdown custom fields on the style master filter the same way, which is how brands report by fabric, by category, by designer or by anything else the line is planned around. Custom fields do not print on the standard reports, but they filter the selection and they pivot in BI.
| Control | What it does |
|---|---|
| Order date basis | Start date or completion date on the hot list and the order reports. Invoice date on the shipping log and who bought what. Pick the basis that matches the question, and expect the two families to disagree at the edges of a period. |
| Period | A date range, or a quick preset such as last year or current year on the summary report tabs. Leave the period empty on cut and sold detailed for the life of the style. |
| Style selection | The styles button opens the same filtered list you use everywhere else: season, division, style group, class, status, any custom field. Tag, done, run. Or sequence by style and color and take everything. |
| Sort and rank | Hot list by quantity sold or by number of customers. Margin reports above or below a percent. Cut and sold with a minimum OTS of -1 for problems only or 1 for clean only. |
| Minimum quantity | On the hot list, drops styles below the threshold so a ranking of 600 styles becomes the 40 that matter. |
| Cost basis | Maximum (the higher of manufactured and purchased) is the default on every margin report. Purchased uses the landed price. Manufactured uses the bill of materials. Choose deliberately; the margin moves with it. |
| Style and color or style only | Most reports print one line per style and color with a style total, or roll up to the style. The hot list ranks either way. |
| Images | Hot list and open to sell print the style default image beside the line, which is what makes them presentable to a sales meeting without a second document. |
| Dollar values | A checkbox on the summary report tabs and the adjustments report. Off by default, so units only unless you ask. |
| Output | Screen, printed page, Excel export, or the grid. The grid carries extra columns the printed page does not, such as the user and time on an adjustment. |
Reports follow the same role based permissions as the rest of the system: a role without cost access sees units and sales but not margin, and a sales rep user sees the customers assigned to them.
The shipping log counts by invoice date. The hot list counts by the order's entered or completion date. Late and early shipments cross period boundaries, so the same month can total differently on each. Similar reports were built for different questions; check the date basis and the filters before assuming one is wrong.
Cost of goods on every margin report is the standard cost on the style master at run time. It does not read the actualized purchase order or the general ledger. For an actual margin after freight, duty and adjustments, take the units and sales from these reports and the actual cost from the accounting close.
Style reports keep sizes in 24 numbered buckets, 0 to 23, mapped to the style's size scale. An Excel export prints qty0, qty1, shp0, alloc0 and so on; on an XS to XL scale, qty0 is XS. The printed report shows the names.
Orders waiting in WebLink or RemoteLink are excluded from open to sell everywhere until a report's include pending web orders option is ticked, and that option covers only those two apps. Orders not yet imported from any other integration are never counted.
The reports that read orders, invoices, production and stock by style, color and size and answer how each style performed. The hot list ranks top sellers by units or by number of customers. The shipped tab of the style summary reports totals units and dollars sold for a period. Cut and sold shows WIP, stock, orders, OTS and life of style shipped per style and color. Who bought what gives gross margin by style. Sell, cost, markup and margin checks costing against wholesale price. Order line item detail totals a season by style. Style adjustments lists every transaction that moved a style's inventory, and the vendor purchase order details report gives production history. Order BI and Invoice BI pivot the same data by season, division and any custom field.
Run the hot list under styles in reports. Choose whether the order date means start or completion, set the date range, pick styles or take them all, and sort by quantity sold or by the number of customers who bought. Set a minimum quantity to trim the tail, and print with images if the list is going to a meeting. Run it both ways; the top style by units and the top style by customer count are often different, and the second one is usually the safer reorder.
Yes. Who bought what reports units shipped, units returned, sales dollars, cost of goods and gross margin by style, or by style and color, for a date range and the warehouses you choose, with the cost basis you select. Sell, cost, markup and margin shows the planned margin per style from wholesale price and cost before anything ships. Margin by order does the same per customer order, and Order BI and Invoice BI let you pivot margin by season, division or class.
Markup is the amount above cost as a percent of cost. Margin is the amount above cost as a percent of the selling price. A style that costs 20 and sells for 50 has a 150 percent markup and a 60 percent margin. The sell, cost, markup and margin report prints both, and lets you filter styles above or below either one.
The cost on the style master at the time you run the report, by the method you select. Maximum is the default and takes the higher of manufactured and purchased cost. Purchased, or importer costing, uses the landed price. Manufactured uses the bill of materials. Because the cost is a standard, estimated cost, margin reports are planning numbers; confirm actuals through purchase order actualization and your accounting close.
Order line item detail under orders, filtered to the season, sorted by style with color subtotals, gives units ordered, open, shipped and canceled per style. For the same view across several seasons at once, put style in rows and season in columns in Order BI. Cut and sold prints the division and season codes on every line, so a life of style run can be read season by season too.
Yes. Every style carries a division code, the style selection filters on it, cut and sold prints it beside the season, margin by order runs by division, and BI puts division in rows or columns. Brands running several labels or channels as divisions get a per division view of the same styles without a second company file.
Run sell, cost, markup and margin for the season's styles with the cost basis you plan on. Anything showing no cost, or a margin more than two or three points from what the brand expects, is a style whose bill of materials or importer cost needs finishing. Doing this before line sheets go out is cheaper than finding it in who bought what after the goods shipped.
The hot list is a ranking of demand. Cut and sold is the supply side against it: for each style and color, what is in production, what is in stock, what is picked, what is ordered, what is open to sell, and what has shipped over the life of the style. It is the report for did we make what we sold, and its detailed version flags any size sold past what exists.
The shipping log counts shipped units by the invoice date. The hot list counts by the order's entered or completion date. Late and early shipments push units across period boundaries, so the two totals for the same month can differ and both are correct for what they measure.
They filter differently. Who bought what always includes both factored and non factored invoices for the customers selected, and it lets you pick warehouses. The sales journal has a factor filter and no warehouse selection. Set the journal to all factors and who bought what to all warehouses and the shipped dollars line up.
Run the style adjustments tab of the summary reports for the style and date range. Every transaction prints with its type: manual and automatic adjustments, invoices, credit memos, purchase order and cut receipts, garment dye receipts, physical inventory, EasyShop, case pack and unpack, and warehouse transfers in and out. Choose transaction date or posted date, add dollar values, and run it to the grid for the user, time and workstation on each line.
Two ways. The vendor purchase order details report sequenced by style and color with the date range lists every purchase order the style was on, canceled units included. Or open the WIP list view, choose all POs with line details by size, filter to the style and sum the ordered and received columns; group by color for a per color total. Ordered minus received minus damages is the canceled quantity.
Who bought what takes a warehouse selection, so sales and margin by style can be run per location. The hot list, the shipped tab and cut and sold total across warehouses. For stock by warehouse, use the stock report on inventory analysis, which runs all warehouses, by warehouse or one location.
Who bought what reports units returned in its own column and its gross margin version omits returns from sales. The hot list ranks on ordered plus shipped minus returned. Credit memos appear on the style adjustments report as their own transaction type.
Style reports store sizes in 24 numbered buckets, 0 through 23, mapped to whatever size scale the style uses. An export shows qty0 to qty23, shp0, alloc0 and so on. On an XS to XL scale, qty0 is XS, qty1 is S, qty2 is M. The printed report shows the size names; the export shows the buckets.
Some reports offer include or consider pending web orders. It adds orders waiting in WebLink or RemoteLink that have not been imported yet. They are excluded from OTS everywhere by default, including the style list, and the option covers only those two apps, not unimported orders from other integrations.
Reports in the left navigation. The hot list, sell, cost, markup and margin, and the summary reports with their shipped, cut and sold and adjustments tabs sit under styles. Order line item detail is under orders. Who bought what is under customers. The vendor purchase order details report sits with the purchasing reports, and Order BI and Invoice BI are in the BI group.
Best sellers, margin by style, cut against sold, season over season. We will run the reports on your own styles in a demo and show you which one answers which question.
