Production Orders’ Report
Generate and read a Production Orders’ Report
David Andrade avatar
Written by David Andrade
Updated over a week ago

You can quickly generate and download the information you need about your production orders. To access this data, follow the following steps:

1. Go to Reports menu

Click in ‘Reports’, on the left side of the screen, and then in ‘Production Orders’.

2. Then, filter and customize your data

Here you can customize your report by adding some selections, options and filters.

Selections - firstly, you are asked to make some choices about the status of the production orders (POs) you want to see. Even though some are opposites, they are not exclusive:

  • ‘Active’/ ‘Inactive’;

  • ‘Open’/ ‘Close’;

  • ‘Complete’/ ‘Not Complete’;

  • ‘Started’/ ‘Not started’;

  • ‘Archived’/ ‘Not Archived’;

Options - here, you can opt to see more columns than the standard ones on the report:

  • ‘Workers column’: workers assigned to the production order;

  • ‘Lots column’: products’ lot/batch numbers produced in production;

  • ‘Actual Workers column’: number of workers that actually worked in the production order;

  • ‘Operation detail’: if chosen, detailed information about the operation will be shown, such as:

    • ‘code operation’: the operation identifier;

    • ‘work time’: considers the time that the worker was actually performing work, i.e., with open production records, per operation;

    • ‘predicted time’: expected time per operation, that is calculated by multiplying the cycle time by the quantity produced;

    • ‘code product’: the unique product identifier;

    • ‘quantity ordered’: quantity ordered of each product within the PO;

    • ‘quantity produced’: quantity already produced of the same product as above;

    • completion details, such as ‘selected interval’, and ‘total’;

(check, in the image below, the red boxes that represent new columns and the blue boxes that represent columns already existing in the report but now with a different name)

  • ‘Products column’: will give you further details on the product, like:

    • ‘Code’;

    • ‘Name’: which purpose is to identify any product quickly;

    • ‘Quantity ordered’;

    • ‘Quantity produced’;

    • ‘Parameters’: a list of product parameters (what type of parameters?) will be shown;

  • ‘Lead time’: if selected, any other columns can be choosen. Additional other columns will automatically appear in the report:

    • ‘Products’: set of products included in the production order;

    • ‘Operations’: operations comprised in the PO;

    • ‘Total finished products’: same as quantity produced;

  • ‘Observations column’: if an observation was made on one product within the PO, it will appear here.


  • ‘Filter by due date’/ ‘Filter by close date’: choose whether you want your report ‘period’ to filter by the PO due date or by the date in which it was closed;

  • ‘Period’: refers to the time interval of the PO to be presented. You can either define it by clicking on the clock symbol, in a basic (selecting start and end date) or relative way (for example, ‘Today’, or ‘Last 7 days’). If you choose a relative time period, you can also choose to schedule the report - learn more about it here. The time interval cannot exceed one month.

  • ‘Sales Order’;

  • ‘Shipping’;

  • ‘Product Family’;

  • ‘Product’;

  • ‘Operation’;

  • ‘Machine’;

  • ‘Lot/Batch Number’ (produced);

  • ‘Lot/Batch Number (Consumption)’.

Once you get the filters defined, click ‘Generate Report’.

3. Interpret and download the results

After generating the report, you'll see the details about your production orders in the defined period.

Other than the chosen optional columns (mentioned above), the report will be generated with the following columns:

  • ‘Start date’: the date when the PO started;

  • ‘Estimated end date’: the expected date for the PO to end;

  • ‘Production order’: PO code, its unique identifier;

  • ‘Description’: brief description of the production order;

  • ‘Status’: it states if a PO is ‘Delayed’ (not completed and estimated end date is in the past), ‘Ongoing’ (not completed and estimated end date is in the future) or ‘Completed’;

  • ‘Actual end date’: date in which the production record for the last produced unit was completed (when PO ‘status’ goes from ‘Delayed’ or ‘Ongoing’ to ‘Completed’);

  • ‘End deviation (days)’: difference, in days, between ‘Actual end date’ and ‘Estimated end date’;

  • ‘Time’:

    • ‘Est.’: estimated production time, calculated by multiplying standard time and quantity ordered;

    • ‘Worked’: same as ‘work time’ in ‘Detailed operation’ filter - considers the time that the worker was actually performing work, i.e., with open production records in the defined ‘period’;

    • ‘Deviation’: difference between estimated and worked times; it takes the format hh:H:mm.

In case you have previously selected the ‘Operation detail’, ‘Products column’ or ‘Lead time’ filter, this information will appear grouped by ‘Production Order’.

Like any Autodesk Prodsmart report, you can either download it in Excel or PDF format by clicking on Excel Report or Export PDF.

If after reading this article you still have some doubts, feel free to reach out to us through our Live-chat feature, or directly to your CSM.

Need help? Request a Prodsmart expert to contact you here.

Did this answer your question?