Description |
+ *Issue:* +
Calc Net Price is reducing Exemptions, due to oversight in rounding needs with CF-1327 changes.
+ *Steps:* +
Import CF Transactions matching the following Pricing Scenarios:
Updated Price Profile Calculations
* Transfer Cost (Local/Network, Remote, Extended Remote )
** Original Net Price = Net Transfer Cost
** Calc Gross Price = Round(Net Transfer Cost + Profile Rate + Adjustment Rate + Round(Calc Taxes / Quantity,6), 6) + .009 Rounding
** Calc Net Price = Round( (Round(Calc Gross Price * Quantity,2) - (Calc Taxes) )/ Quantity,6)
* Pump Price Adjustment (Local/Network, Extended Remote)
** 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)
* Local Index Retail (Local/Network)
** Original Net Price = Round( (Round(Original Gross Price * Quantity,2) - Original Taxes) / Quantity, 6)
** Calc Gross Price = Round(Index Price + Profile Rate + Group Adjustment Rate - Round(Calc Exempt Taxes / Quantity,6) , 6) + .009 Rounding
** Calc Net Price = Round( (Round(Calc Gross Price * Quantity,2) - (Calc Taxes) )/ Quantity,6)
* Local Index Cost (Local/Network) and Remote Index Cost (Remote)
** Original Net Price = Round( (Round(Original Gross Price * Quantity,2) - Original Taxes) / Quantity, 6)
** Calc Gross Price = Round(Index Cost + 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)
* Local Index Fixed (Local/Network)
** Original Net Price = Round( (Round(Original Gross Price * Quantity,2) - Original Taxes) / Quantity, 6)
** Calc Gross Price = Round(Index Cost + Profile Rate + Group Adjustment Rate,6) + .009 Rounding
** Calc Net Price = Round( (Round(Calc Gross Price * Quantity,2) - (Calc Taxes) )/ Quantity,6)
* Other types to all use the same as Pump Price Adjustment
** Network Cost
** Import File Price
** Credit Card
** Posted Trans from CSV
** Origin History
* Non Price Profiles that will use Net Price to calculate Gross Price
** Contracts (Local/Network)
*** Calc Net Price = Contract Price
** Special Pricing (Local/Network)
*** Calc Net Price = Special Pricing Price
** Inventory Pricing (Local/Network)
*** Calc Net Price = Inventory Price
** Calc Gross Price = Calc Net Price + Round(Calc Taxes / Quantity, 6)
+ *Acceptance:* +
Net Price should be calculated according to pricing match
|