This report shows materials and stock used on a particular job during the selected time period. It also indicates where this material was purchased if it did not come from inventory already in stock. Use this report to see the quantity and cost of job costing materials.
Data from this report can be exported in Excel, PDF or RTF format.
|Time Period||Allow user to select the time period from a list of options are set custom a custom date range|
|Layout||Set to the Default layout. Allows selection of saved layouts, if any.|
|Save Layout As||Allows saving of a layout for potential future use.|
|Reset Layout||Resets layout to the default layout or selected saved layout.|
Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters.
The following output fields are available for this report. You may have to open the More Fields dropdown menu to add some of them to your report.
|Job #||Job number.|
|Customer||Customer name the job is done for.|
|Date||Date when expense happened.|
|Status||Status of the job.|
|SKU||SKU of the product spent for the job.|
|Product||Name of the product spent for the job.|
|Unit||Product unit of measure.|
|Year||Year of the date when expense happened.|
|Quarter||Quarter of the date when expense happened.|
|Month||Month of the date when expense happened.|
|Tags||Comma-separated product tags.|
|Family||Product family name.|
|Contact||Job contact details.|
|Supplier||Supplier from whom materials were bought. Empty for Issue to Production and Finished Goods expenses.|
|Product Additional Attribute 1-10||Values of product additional attributes.|
|Quantity||Quantity of SKU used in the job expense.|
|Price||Product purchase price in base currency.|
|Tax||Tax if any in base currency.|
|Total||Total purchase invoice line without tax / Total manufacturing cost of the product. (Price x quantity)|