Description |
* Objective:
** Ensure that transactions for the same customer will price the same regardless of the quantity.
* Requirements
** Change Calculations of Gross Price to use Estimated Quantity of 100,000 instead of actual transaction quantity to calculate estimated taxes per unit.
*** This will adjust the following calculations: [http://inet.irelyserver.com/display/ICF/Net-Gross+Pricing+Calculations]
***
**** For Example in Pump Price Adjustment we have:
***** Calc Gross Price = Round(Orig Gross Price + Profile Rate + Group Adjustment Rate - Round(Calc Exempt Taxes / Quantity,6) , 6) + .009 Rounding
***** Calc Exempt Taxes should use 100,000 quantity
***** Division by Quantity should use 100,000.
**** Example:
***** Orig Gross Price = 2.999
***** Profile Rate = 0
***** Group Adjustment Rate = 0
***** Tax 1 = .184
***** Tax 2 = .576 (exempted)
***** No Rounding to .009
***** Quantity = 14.5
***** Calc Cross Price = 2.999 + 0 + 0 - ((Round(.576 * 100,000,2)) / 100,000
****** 2.999 - .576 = 2.423
***** Old Method = 2.999 + 0 + 0 - Round(.576*14.5,2) / 14.5
****** 2.999 - 0.575862 = 2.423138
** Calculations Tax Amounts will use Actual Quantity.
** Calculations of Net Price will continue to use Actual Quantity to ensure compatability with AR rounding to the same extended total.
|