Description |
*Background:* Oregon Taxes are unique. Sometimes the tax is part of the transfer cost, and sometimes it is not.
*Requirements:*
* Store Multiple Costs on CF Transaction
** Inventory Cost (no taxes)
*** Local Network and Foreign Sales Transactions only
*** Update from Inventory on Import and again at time of posting
** Gross Transfer Cost (with Taxes)
*** Extended Remotes, Remotes, Foreign Sales, Local Network if available (PacPride Only)
** Net Transfer Cost (no taxes)
*** Extended Remotes, Remotes, Foreign Sales, Local Network if available (PacPride Only)
*** Calculation:
**** Net Transfer Cost = Gross Transfer Cost - Original Taxes / Quantity
* Margin Calculation Changes
** Extended Remote, Remote
*** Calc Net Price - Net Transfer Cost
** Local/Network, Foreign Sale
*** Calc Net Price - Inventory Cost
** Store Margin on the Transaction and re-calc when the costs changes.
* Change Price Profile Calculations
** Remote Transaction > Transfer Cost
*** Original Net Price = Net Transfer Cost
*** Calc Gross Price = Net Transfer Cost + Profile Rate + Adjustment Rate + Calc Taxes / Quantity Rounding
*** Calc Net Price = (Calc Gross Price * Quantity - (Calc Exempt Taxes + Calc Taxes) )/ Quantity
** Extended Remote Transaction > Discounted Price
*** Change Option in Price Profile Screen= *Transfer Cost*
*** Use same calculation as Remote Transaction > Transfer Cost listed above
** Extended Remote Transaction > Full Retail
*** Change Option in Price Profile = *Pump Price Adjustmen* t
*** Original Net Price = Original Gross Price - Original Taxes / Quantity
*** Calc Gross Price = Orig Net Price + Profile Rate + Group Adjustment Rate + Calc Taxes / Quantity + Rounding
*** Calc Net Price = (Calc Gross Price * Quantity - (Calc Exempt Taxes + Calc Taxes) )/ Quantity
** Local Transaction > Transfer Cost
*** Same Calculation as Remote Transaction > Transfer Cost
** Local Transaction > Pump Price Adjustment
*** Same Calculation as Extended Remote Transaction > Full Retail
** Local Transaction > Local Index Retail
*** Original Net Price = Original Gross Price - Original Taxes / Quantity
*** Calc Gross Price = Index Price + Profile Rate + Group Adjustment Rate - (Calc Exempt Taxes) / Quantity + Rounding
*** Calc Net Price = (Calc Gross Price * Quantity - (Calc Exempt Taxes + Calc Taxes) )/ Quantity
** Local Transaction > Local Index Cost
*** Original Net Price = Original Gross Price - Original Taxes / Quantity
*** Calc Gross Price = Index Cost + Profile Rate + Group Adjustment Rate + Calc Taxes / Quantity + Rounding
*** Calc Net Price = (Calc Gross Price * Quantity - (Calc Exempt Taxes + Calc Taxes) )/ Quantity
** Local Transaction > Local Index Fixed
*** Original Net Price = Original Gross Price - Original Taxes / Quantity
*** Calc Gross Price = Index Cost + Profile Rate + Group Adjustment Rate + Rounding
*** Calc Net Price = (Calc Gross Price * Quantity - Calc Taxes )/ Quantity
** Remote Transaction > Remote Pricing Index
*** Change Option in Price Profile = *Remote Index Cost*
*** Same Calculation as Local Index Cost
** Remote Transaction > Transfer Price
*** Obsolete, no longer available after PacPride moves to CFN format on December 1
** Other types to all use the same as Extended Remote Transaction > Full Retail
*** Network Cost
*** Import File Price
*** Credit Card
*** Posted Trans from CSV
*** Origin History
* Create Data conversion routines to change Existing Price Profile Names on Transactions and Profiles
** Remote Transaction > Remote Pricing Index to *Remote Index Cost*
** Extended Remote Transaction > Discounted Price to *Transfer Cost*
** Extended Remote Transaction > Full Retail to * *Pump Price Adjustment* *
|