This report shows sale price fluctuations for all active products by location and price tier.



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
Currency
Allow user to select Currency for 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, there are following output field available for this report 



SKU

 Product SKU.

Product

 The name of the product.

Unit

 Product unit of measure.

Invoice Date

 Date when price changed to new value.

Price

 Price without discount in customer currency specified in Currency field.

Year

 Year of price change date.

Quarter

 Quarter of price change date.

Month

 Month of price change date.

Location

 Location this sale is dispatched from.

Category

 Product category.

Brand

 Product brand.

Product Tags

 Comma-separated product tags.

Family

 Product family name.

Currency

 Currency code this quote is created in.

Price Tier

 Name of the price tier the sale is made in.