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.


Data from this report can be exported in Excel, PDF or RTF format or saved to Google Drive.


LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving a layout for potential future use.
Reset LayoutResets 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. 


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. 

ComponentProduct used in the production process: SKU: Component name.
StatusProduction order Status.
Production Order #Production order number.
LocationShopfloor production location.
NotesProduction operation notes.
Release DateRelease date of the production order.
Required By DateRequired by date of the production order. 
Finished ProductName of the Production BOM product: SKU: Finished Product name. This is the main finished product for which order is created.
QuantityQuantity of main finished product specified by production order.
CategoryComponent product category. 
BrandComponent product brand. 
UnitUnit of the component product.
FamilyComponent product family.
TagsComma-separated tags of the component product.
Bill of Material version number. Applies only to Production and Make to Order BOM. Default version is marked.
Component Additional Attribute 1-10Values of product additional attributes.
Production Additional Attribute 1-10
Value of additional production attributes (only visible if production process has additional attribute)
Data Headers
Component quantity required in production process. This is the sum of quantities for component indicated in operation/order.
AvailableComponent quantity available for production process in shopfloor.
On OrderComponent quantity On Order to the shopfloor location.
ShortageComponent 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.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.