This report shows the profit made for each product within a given period of time.



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



Location

 Location name.

SKU

 Product SKU.

Product

 The name of the product.

COGS

 Total cost of goods sold amount.

Sale Proceeds

 Sale proceeds for the product.

Production / Inventory / Transfer

 Cost of the product spent on non-sale transactions.

Profit

 Profit = "Sale Proceeds" + "Production / Inventory / Transfer" - "COGS".

Unit

 Product unit of measure.

Tags

 Comma-separated product tags.

Category

 Product category.

Brand

 Product brand.

Family

 Product family name.

Batch #

 Batch or Serial number.

Expiry Date

 Batch Expiry Date.

Year

 Year of stock movement date.

Quarter

 Quarter of stock movement date.

Month

 Month of stock movement date.

Product Additional Attribute 1-10

 Values of product additional attributes.