View Delta Price Reports

Delta price is used to add on the to average cost of the product, and it will show up in the sales report, to increase or decrease the cost displayed in the report, for the purpose of sales commission calculations. It does not have effect on the accounting.

Permission:
Inventory > General Inventory Module Permissions > Untick for view MA Cost

if user has permission to view MA Cost : The COGS column will show (MA Cost)*(Qty sold).

• Add on new column: Delta Cost column to show:
• if delta_price_retail_amt != 0 SHOW (MA Cost + delta_price_retail_amt)*(Qty sold)
• else if delta_price_retail_pct != 0 SHOW (MA Cost + (MA COST*delta_price_retail_amt))*(Qty sold)

if user does not have permission to view MA Cost : the report will only show the new column:

• if delta_price_retail_amt != 0 SHOW (MA Cost + delta_price_retail_amt)*(Qty sold)
• else if delta_price_retail_pct != 0 SHOW (MA Cost + (MA COST*delta_price_retail_pct))*(Qty sold)

Related Report:

1. SR-06 Stock Sales by Item Code
2. SR-08 Sales Report by Daily, Weekly or Monthly