Production Schedule Variance
Lists your work orders with the start and finish they were planned for, the start and finish they actually had, and how early or late each was. Use it to find runs that slipped, and to see which stage caused it.
Quick look
- Go to Reports › Production Reports and click the Production Schedule Variance card.
- The report opens on the April to March year that holds today and runs by itself.
- Look at Finish variance and Against due date: "late" means behind plan.
- Open a row's Stages tab to see which stage was late.
Done. You see one row per work order with its start, finish and lateness.
Full guide
What it shows, and when to use it
One row per work order dated in the period. A run that was planned and never started still appears, which is the point: you see it as a plan with no actual dates. Runs are picked by the work order's own date, not by when they were planned or worked. Use it to chase late runs and to check whether your plan was realistic.
Filters and date range
Fields in this section
| Field | Required | What to enter |
|---|---|---|
| Reports | No | Switch to another Production report. |
| Date Range | No | The work order dates to cover. Opens on 1 April to 31 March around today, in every region. Up to 366 days. |
| Status | No | Draft, In Progress or Completed. See Problems. |
| Work Order | No | Limit to one work order, using its internal id rather than the work order number. See Problems. |
Columns
Fields in this section
| Column | What it shows |
|---|---|
| Run | The work order number. |
| Status | The work order's status. |
| Batch | The batch number. |
| Quantity | The quantity the run was to make. |
| Planned start | The earliest planned start among the stages. |
| Actual start | The earliest actual start among the stages. |
| Start variance | Actual start against Planned start. |
| Planned finish | The latest planned finish among the stages. |
| Actual finish | When the last stage finished. Only filled once every stage that started has finished. |
| Finish variance | Actual finish against Planned finish. |
| Against due date | Actual finish against the work order's expected completion date. |
A variance reads like "2h 15m late", "40m early" or "On time". A dash means one of the two dates is missing, for example a run with no actual finish yet; it is not zero.
Open a row's Stages tab for each stage's status, planned and actual start and finish, and their variances.
Nothing records whether a run was planned forwards from its start or backwards from its finish, so the report reads the variance against the planned finish and says so in a note under the table.
Sorting is not available and there is no pager: rows come oldest work order first, in one list. Use the column chooser in the table header to hide or show columns.
Drill-down
The Stages tab on each row is the only drill-down. A row does not open the work order on the web.
Export, print, PDF and email
Click the green spreadsheet icon above the table (it appears once there are rows) to download an Excel file (.xlsx). It starts with the period, then the eleven columns for every row. The stage lines are not in the file.
Print, PDF and email are not available on this report.
Who can see it
Open the report with View on Production Reports. Without it the report list shows a No Access page. Production Reports has only View and Add/Edit, and a report changes no record, so Add/Edit makes no difference here. A role limited to its own records still sees every work order in the business unit.
On mobile
Open Reports, choose Production Reports, then Production Schedule Variance. It differs from the web in these ways:
- It opens on your financial year, from the start month in your settings, not always April to March.
- Filters holds From and To, Status as tappable chips and a Work Order text box. Tap Run Report to apply.
- Each work order is a card with its number, the batch, and Status, Planned Start, Actual Start, Start Variance, Planned Finish, Actual Finish, Finish Variance and Due Date Variance. There is no stage breakdown.
- If your role has View on Work Orders, tap a card to open that work order.
- Pull down to refresh. There is no sorting or download.
The date pickers differ by phone: a spinner with a Done button on iPhone, the system calendar on Android. Everything else is the same on iPhone and Android.
The Android app is on Google Play. The iPhone app is coming soon to the App Store.
Problems and fixes
Choosing a Status shows no work orders
Clear the Status and run the report again. The Status list does not match the way work order statuses are stored, so a chosen status finds nothing, and it offers only three of the statuses. Read the Status column instead.
The Work Order box says "workOrderId is not a valid id."
The box wants the work order's internal id, not the work order number shown in the Run column. Leave it empty and find the run in the list.
Actual finish and the variances are dashes
A run has no actual finish until every stage that started has also finished. Until then the finish variance and the due-date variance stay dashes.
The report says the range covers more than 2,000 work orders
Narrow the Date Range.
The report page says No Access
Your role does not have View on Production Reports. Ask an administrator to turn it on.