New: Order Detail Report BETA

At the core of this enhancement, we want to improve the way our reports handle discount transactions in the Order Detail Report.

There are 4 ways a price of a product can be reduced from the original Retail Price.

- In the Product page, there is a field for Retail Price and Sale Price.  The difference between the two values is a type of price reduction.

- There is a way to set a Price Level to your product.  There will be a difference between the Price Level price and the Retail Price.

- You can override the price of a product manually. The difference between the starting price and the overriden price is another way to reduce price (Price Override).

- Lastly, you can set up promotions under Store > Promos.  You can set up discounts to apply under certain conditions and another type of price reduction (Promotions).

To report on these different price reductions more accurately, we have added 3 new columns.  Here are the columns we added and how it's designed to display the data:

- Price Adjustment = Product Retail Price - Sale Price or Price Level price.

Summary: The difference between Retail Price and Sale Price on the Product page at the time of the transaction.  If you are using Price Level, then it is the difference between the Retail Price and the Price Level price.

- Ext Price Adjustment = Qty x Price Adjustment

Summary: Sum this column for the total difference between the Retail Price and the Sale Price.

- Ext Item Discount = Qty x Item Discount

Summary: Sum this column for the total discount provided through Promotions and Price Override.

Daily Activity Report BETA

We only made one change in Daily Activity Report BETA. The Gross Sales field on the Daily Activity Report has been adjusted.  Previously, it would calculate its value by looking at Qty x Original Item Price.  We have adjusted this so it would calculate using Qty x Retail Price, which will provide a more accurate representation of Gross Sales.

There are differences between Retail Price and Original Item Price.  The Original Item Price refers to the price of a SKU when it is pulled into an order.  The Retail Price column refers to the value stored in the Retail Price field of the Product page at the time of the transaction.  This difference manifests most commonly for Product that has a Retail Price and a Sale Price value in the Product page.  In this scenario, the Original Item Price will be the Sale Price, but the BETA which uses Retail Price will only refer to Retail Price.