Import Trans > Oregon PUC/CET in Original Price/Costs Scenarios

Issue No: CF-1319
Created 10/10/2017 9:05:16 PM
Type Feature
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 17.3
Description *Background:* In Oregon, some Taxes will be part of the Calculated but not in the Original Taxes We need a way through setup to indicate this.   *Requirements:*   * When Overriding Tax Group on Transactions ** By Ignore Import Taxes and assume that provided Taxes are the Same for Both Calculated and Original Taxes ** Use Special Taxing Rules to adjust Original Taxes *** Designate Taxes that are not part of the Transfer Cost/Original Retail Prices *** Designate Sites that do not include specific Taxes in Transfer Cost/Original Retail Prices ** Special Taxing Rules can also apply to Network Original Taxes if no Tax Group is Provided * New Setup Screen - Special Taxing Rules ** Add to Setup Screen as new Tab with Grid with list of values ** New Button/Remove Buttons ** New Screen with the following Fields *** Rule Description **** Text Field defined by customer for purposes *** Rule Type **** Drop Down - Exclude Tax from Original Price/Network Cost **** In future we may add new rule types as needed. *** Grid of Tax Codes Impacted (left half) *** Grid of Sites Impacted (right half) **** Site Group **** Site **** Either a Site Group or a Site must be provided. * How it Works ** Apply Special Tax Rule *** When a Transaction has a Tax Code that belongs to the Rule *** And **** When a Transaction matches a Site that belongs to the Rule **** OR when a Transaction matches a Site Group that belongs to the Rule ** Tax Not Included in Original Price/Network Cost *** Original Taxes will be 0 for the tax codes specified *** Original Net Price will be reduced by Original Taxes *** Net Transfer Cost will be reduced by Original Taxes * Example 1: Remote Oregon Site where Special Tax Rule applies to Tax 2 ** Quantity = 1 ** Profile = Transfer Cost + 0 ** Transfer Cost = 2.243 ** Tax 1 Rate = .243, Calc Tax = .24, Orig Tax = .24 ** Tax 2 Rate = .30, Calc Tax = .30, Orig Tax = 0 ** Calc Net Price = 2.00 ** Calc Gross Price = 2.543 ** Orig Gross Price= 2.243 ** Orig Net Price= 2.00 * Example 2: Extended Remote Oregon Site where no special Tax rules applies ** Quantity = 1 ** Profile = Full Retail + 0 ** Full Retail = 2.999 ** Tax 1 Rate = .243, Calc Tax = .24, Orig Tax = .24 ** Tax 2 Rate = .30, Calc Tax = .30, Orig Tax = .30 ** Calc Net Price = 2.456 ** Calc Gross Price = 2.999 ** Orig Gross Price= 2.999 ** Orig Net Price= 2.456 * Example 3: Extended Remote Oregon Site where Special Tax Rule Applies to Tax 2 ** Quantity = 1 ** Profile = Full Retail + 0 ** Full Retai = 2.699 ** Tax 1 Rate = .243, Calc Tax = .24, Orig Tax = .24 ** Tax 2 Rate = .30, Calc Tax = .30, Orig Tax = .00 ** Calc Net Price = 2.456 ** Calc Gross Price = 2.999 ** Orig Gross Price= 2.699 ** Orig Net Price= 2.456