Skip to main content

Read the Open Production report

The Open Production report lists the units you've ordered but not received yet. For each open purchase order line, it shows what the units are worth, how much of that your paid deposits already cover, what you still owe, and how far the manufacturer has got. Use it to see the cash tied up in production and when the goods should arrive.

Before you begin​

  • You need access to Open Production under Report Access in your role.
  • To fill the Production Status column, set up production milestones and record their actual dates on each purchase order. See Track logistics milestones on purchase orders. Until you do, a banner at the top of the report says so, with a Set up milestones link to Settings → Purchasing → Logistics Tracking Fields. There, Add production milestones adds the six standard ones in one click.
  • Prepaid comes from deposits recorded on the purchase order itself. See Manage vendor deposits.

Steps​

  1. Go to Insights → Reports and open Open Production.
  2. Read the cards at the top:
    • Open value: what the units still to arrive are worth at their purchase order cost, with the number of units and purchase orders behind it.
    • Prepaid: the part of the open value your paid deposits already cover.
    • Balance owed: open value less prepaid. This is what you still have to pay.
    • Open lines: purchase order lines with units still to receive.
  3. Under Totals by supplier, read the same figures for each supplier. To total by product instead, click SKU.
  4. To narrow the list, use Supplier or Production Status. To see only lines your deposits already cover in part, set Prepaid to Prepaid only. For anything else, such as an Expected Receipt date range, open Advanced Filters.
  5. Read each line under Open Lines. See What each column means.
  6. To download the lines, click Export, then choose XLSX (Excel) or CSV. The file uses the same filters as the list.

What each column means​

The list has one row per product line, on an open purchase order, that still has units to receive. Draft and closed purchase orders aren't included. On a blanket order, a line shows only what its open releases still carry, and a blanket order with nothing released yet isn't listed.

ColumnWhat it shows
Ordered, Received, Open UnitsUnits on the line, units received so far, and units still to arrive.
Unit Cost, Open ValueThe line's unit cost in your base currency, and open units × unit cost.
PrepaidThe line's share of the purchase order's paid deposits, less refunds, that haven't been applied to a supplier invoice yet. This is the order's prepayment balance. The amount is split across the order's open lines by their open value, and never exceeds a line's open value.
Balance OwedOpen Value less Prepaid.
Prepaid %Prepaid as a share of Open Value.
Production StatusThe furthest active milestone that has an actual date on the purchase order, such as Production start, with that date. Not started means no milestone has an actual date yet.
Expected CompletionThe Production complete milestone date: the actual date, otherwise the estimate. Without one, the purchase order's ETD. A label under the date says which: Completed, Estimated or From ETD.
Expected ReceiptThe purchase order's ETA.

PO Date is hidden by default. Add it from the column selector.

When an order's deposits are more than everything still to arrive on it, a warning icon appears beside Prepaid. Hover over it to see the extra amount. The Prepaid card shows the total of these extra deposits under its value.

Next steps​

Last verified: