Change: Create a report for transactions with price change.

Justification

1. In prior versions when the price was changed it was treated as a discount, we no longer give a discount on the price change. Hence, in version 933, we removed the price change details from the Discount Report. Case 9202
2. There is no report in the system to validate the sales in which the cashiers or supervisors have changed price in POS.
3. This is an important requirement for most clients mostly supermarkets for example Extra. They want to be able to track all sales made where selling price was changed.

We can create a new report similar to the Discount Report with below modifications. Refer to Figure 1, for a sample.

1. Change the Report Name.
2. Update the report notes.
3. Rename the "Discounted Price Column" to New Price.
4. Rename the "Discounted Column" to  Price Change

This change requires the following design:

1. Add a new field in "order detail" called "RRPUnitPrice" to store the product price loaded at the time of sale.
2. Create a new report to display as requested.

Estimated effort:

1. Add new field, update replication view: 1hr
2. Create new report: 4hr
3. System test: 4hr

Discussion notes: Alvis, Sanjay, Rashna. Agreed to implement the following:

1. Add a new field in "order detail" called "ProductUnitPrice" to store the product price loaded at the time of sale.
2. Add new field, update replication view
   
3. Change Discount Report as follows:
   1. Quantity
      
      Group 2. and 3. with title "Product Price"
   2. ProductUnitPrice = display as "Unit Price"
      
   3. Total = Quantity x ProductUnitPrice
      
      Group 4. and 5. with title "Sold At"
   4. Sold At (Unit Price) = Unit Price of POS Grid
   5. Total = Quantity  x Sold At (Unit Price)
      
      Group 6. and 7. with title "Difference"
   6. Difference Unit Price = display as Unit Price
   7. Difference Total = Product Total - Sold at Total
      
      
   8. Notes
   9. Add a filter for "Discount/Price Change/All"
   10. Change title to Discount/Price Change Report

   
   

The following changes have been made:

1. Added "ProductUnitPrice" column to "LBS_POS_OrderDetail" table
2. Added "ProductUnitPrice" column to "LT_REPL_LBS_POS_OrderDetail_vw" view
3. Added "ProductUnitPrice" parameter (nullable) to "LBS_POS_OrderDetailsInsert" procedure
4. Renamed "Sales Discounted Items Report" to "Sales Discount/Price Change Report"
5. Changed "Sales Discount/Price Change Report" as designed in comment 4.
6. Updated report notes

Next Step:

1. Make changes to POS application to send "ProductUnitPrice"
2. Identify all procedures used in POS that require changes to implement "ProductUnitPrice"

Hi Sanjay, 

Documentation for the case has been updated under

• Link Web->Busness Intelligence -> Reports->POS Reports - Sales Discounted/ Change Price report.
• BO -> Point of Sales Reports -> Operational -> Sales Discounted/ Change Price report.

Thanks
Rashna