Work in progress inquiry
Related topics
On this page, you can view a summary of costs for all work orders in progress at a single production site.
| User type |
Admin Manager Employee |
|---|---|
| Permissions | Full rights: Admin, Manager, Employee |
| Prerequisites | |
| Tip |
Use this page to reconcile planned and actual production costs with Work in progress journal entries that are sent to your financial solution. |
| Restrictions | You cannot edit the work order costs. |
Inquire on work in progress at a production site
The default work in progress inquiry date is the current date. You can select an earlier date or a later date. To inquire on work in progress at a production site, enter or select the Site then select Search.
Results grid
Use the Results grid to reconcile planned and actual production costs with Work in progress journal entries that are sent to your financial solution. The information in the grid is display-only and cannot be modified. You can take advantage of standard grid options like sorting by displaying table filters and selecting which columns you want to display. You can open a work order from the link in the grid.
The Work in progress total for the Results grid is the cumulative total at the selected As of date. It remains as the calculated total if you filter the list of work orders.
When a work order is closed for an item costed at an average unit cost or a FIFO (first in, first out) cost, any difference from the planned cost is balanced with an actual cost adjustment to increase or decrease the unit cost of the produced stock. However, if the current stock on hand is less than the produced quantity or is no longer in stock, the unit cost cannot be adjusted and the amounts are recorded as not absorbed costs. In this inquiry, when the work order is closed the Work in progress total has balanced to zero because the non-absorbed amount has been posted as a production variance on a journal entry. The Closing variance displays the non-absorbed amount total, which was the Work in progress total value.
Export
When you export the work in progress Results grid, only those lines displayed in the search or filtered results are included in the export. This includes all lines across multiple pages if you have a large data set.
There are 2 export options: Excel or CSV. The default file name is Results.
After exporting the data, you can rename the file and edit the Excel spreadsheet or CSV file if needed before uploading to your accounting solution.
