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.


Only users with the Inventory Reporting permission can access this report.


Prerequisite:


Table of Contents:


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. This can also be a service/labour item. 
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)


FAQs

[back to top]


Is there a report in DEAR that provide the GP per job? Can DEAR provide information about the actual time spent per job vs budgeted labour per the BOMS?

To get a Profit report for the Jobs made in DEAR, use the the Job Costing Profit & Loss Report at. Unfortunately, we don't keep track of the actual duration (ex. hours) spent per job so we don't provide any report for such but you could get budgeted labour using the Job Costing Materials Report at and combining either the Finished Goods Analysis Report or the Bill of Materials (under Inventory > Products > View All > Export > Bill of Materials).




Still no answer to your question? Please do not hesitate to get in touch with DEAR support.

Did you find it helpful? Yes No

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