This report shows the quantity of components required for released and in progress production orders. This allows the user to assess which orders can be completed with the current stock allocation. Available and on order quantities of components are shown and compared to the required quantities, and displays possible shortages. The report determines possible shortages assuming that orders in progress will be picked first, and remaining orders picked in order of Required By date.
The report does NOT display definite allocation, but assumes the user will allocate components according to order priorities.
NOTE: This report considers only the components needed for Released and In Progress production orders. Production demand from sales orders or any other order is not considered.
Users can have read-only or full access to these reports with the Production Reports permission.
Prerequisite
Data from this report can be exported in Excel, PDF or RTF format or saved to Google Drive.
Input:
| Layout | Set to the Default layout. Allows selection of saved layouts, if any. |
| Save Layout As | Allows saving a layout for potential future use. |
| Reset Layout | Resets the layout to the default layout or selected saved layout. |
Select Apply Filter to set filter fields for the report and Update to display the most recent data. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters.
Users can check Hide components without shortages to only show production orders with a shortage of at least one component, or leave unchecked to show all production orders.
Output:
The following output fields are available for this report. You may have to open the Configure Layout menu to add some of them to your report.
| Fields | |
| Component | Product used in the production process: SKU: Component name. |
| Status | Production order Status. |
| Production Order # | Production order number. |
| Location | Shopfloor production location. |
| Notes | Production operation notes. |
| Release Date | Release date of the production order. |
| Required By Date | Required by date of the production order. |
| Finished Product | Name of the Production BOM product: SKU: Finished Product name. This is the main finished product for which order is created. |
| Quantity | Quantity of main finished product specified by production order. |
| Category | Component product category. |
| Brand | Component product brand. |
| Unit | Unit of the component product. |
| Family | Component product family. |
| Tags | Comma-separated tags of the component product. |
| Version | Bill of Material version number. Applies only to Production and Make to Order BOM. Default version is marked. |
| Component Additional Attribute 1-10 | Values of product additional attributes. |
| Production Additional Attribute 1-10 | Value of additional production attributes (only visible if production process has additional attribute) |
| Data Headers | |
| Required | Component quantity required in production process. This is the sum of quantities for component indicated in operation/order. |
| Available | Component quantity available for production process in shopfloor. |
| On Order | Component quantity On Order to the shopfloor location. |
| Shortage | Component quantity shortage for production process. Shortage = Required - On Order - Available |
NOTE: If you have added an Additional Attribute set to your purchase process, the attributes will appear as additional report fields.