| Description |
+ *Issue:* +
Import File Price incorrect. Current and old calculation needs verification.
According to Specs (Old)
* Original Net Price = Round( (Round(Original Gross Price * Quantity,2) - Original Taxes) / Quantity, 6)
* Calc Gross Price = Round(Orig Net Price + Profile Rate + Group Adjustment Rate + Round(Calc Taxes / Quantity,6) ,6) + .009 Rounding
* Calc Net Price = Round( (Round(Calc Gross Price * Quantity,2) - (Calc Taxes) )/ Quantity,6)
Current
* Original Net = Round((Round(@dblOriginalPrice * @dblQuantity,2) - @totalOriginalTax) / @dblQuantity, 6)
* Calc Gross Price = ROUND (Round((Round(@dblOriginalPrice * @dblQuantity,2) - @OriginalTax) / @dblQuantity, 6) + ISNULL(@dblAdjustments,0) + ROUND((ISNULL(@CalculatedTax100kQuantity,0) / @dbl100kQuantity),6),6)
* Calc Net Price = ROUND(((Round((@GrossPrice(not base on 100k qty) * @dblQuantity),2) - (ISNULL(@CalculatedTax,0)) ) / @dblQuantity),6)
* Calc Total Price = ROUND((@GrossPrice(not base on 100k qty)* @dblQuantity),2)
+ *Steps:* +
1) Import CF trans that will calculate Import File Price
2) Verify Price calculation
+ *Acceptance:* +
Calculate Import File Price accordingly.
[~brian.kay] Confirm what calculation to use.?
|