ROSS: TP Change: Return to normal discounts

ROSS:  TP Change:  Return to normal discounts

1. SCC Customer Maint
   1. Change CUSTOMER_GROUP   from JSIPGX  to JSIPG (normal TP)
      1. at this point the customer will not get the special TP discounts
      2. they may still be excluded from some regular discounts so continue with the changes
         1. it is good to change them so that they are no longer "looking like" they should get special discounts
2. SCC Order Entry Spartan NEW
   1. always test on an order 
      1. include 1 part code from all the quantity discounts possible
      2. include 1 promo item to make sure it is not discounted
      3. this is a good sample order lines entry

    3. SQL change to table:  TP_CUSTOMER_ASSOCIATIONS 

1. Leave customer_group = 'JSIPGX'   
   1. this is why the TP does not apply if the customer group is changed to JSIPG and the customer# is good.
2. check for B O T H places for this customer:
   1. change the customer# from 0654401 to 0654401x
   2. change the statement account from 0654401 to 0654401x

SELECT         GEM_DBKEY, COMPANY_CODE, TP_PROMOTION_CODE, TP_SEQUENCE_NUMBER, DESCRIPTION, DIVISION, CUSTOMER_NUMBER, CUSTOMER_GROUP, ADDRESS_CODE, BROKER_CODE, SALESPERSON_CODE,                          LOCATION, STATEMENT_ACCOUNT, TP_INCLUDE_EXCLUDE, TP_PROMOTION_STATUS, SCC_WEIGHT_TIER_CODE, SCC_CHANGE_DATE, SCC_CHANGE_REASON
FROM TP_CUSTOMER_ASSOCIATIONS
WHERE        (CUSTOMER_NUMBER = '0654401') OR  (STATEMENT_ACCOUNT = '0654401')

Change the customer # from 0654401 to 0654401x this way it will not try to apply the TP to the real customer 0654401.

Leave customer_group = 'JSIPGX'   this is why the TP does not apply if the customer group is changed to JSIPG.