This report shows materials used on the particular job during given period of time. It also indicates where this material was purchased if it did not come from the warehouse.



Input:

Following are input for this report



From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format



Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report



Job #

 Job number.

Customer

 Customer name the job is done for.

Date

 Date when expense happened.

Job

 Job description.

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.

Quantity

 Quantity used.

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.

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.

Category

 Product category.

Brand

 Product brand.

Family

 Product family name.

Address

 Job address.

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.