Job Costing Materials Report

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.


Prerequisite:


Data from this report can be exported in Excel, PDF or RTF format. 


Input:

Time PeriodAllow user to select the time period from a list of options are set custom a custom date range
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving of a layout for potential future use.
Reset LayoutResets 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. 


Output:

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. 


Fields
Job #Job number.
CustomerCustomer name the job is done for.
DateDate when expense happened.
JobJob description.
StatusStatus of the job.
SKUSKU of the product spent for the job.
ProductName of the product spent for the job.
UnitProduct unit of measure.
YearYear of the date when expense happened.
QuarterQuarter of the date when expense happened.
MonthMonth of the date when expense happened.
TagsComma-separated product tags.
CategoryProduct category.
BrandProduct brand.
FamilyProduct family name.
AddressJob address.
ContactJob contact details.
SupplierSupplier from whom materials were bought. Empty for Issue to Production and Finished Goods expenses.
Product Additional Attribute 1-10Values of product additional attributes.
Data Headers
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)


Did you find it helpful? Yes No

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