ICM put commissions back into the lines in ROSS if they were cleared

if Kim clears the commission off a rebate that was already processed and paid in ICM.

get the line commissions and export to excel from within ICM

If the rebate is still marked with "Y" 0 commissions, have Kim change it back.

the SCC_COMMISSION_DEDUCTION_FLAG should be "N".

RESET the flag:

UPDATE SA_DETAIL_LINES

 set SCC_COMMISSION_DEDUCTION_FLAG = 'N' where TRANSACTION_type='RB' and  TRANSACTION_NUMBER = 634459

If the commissions were set to 0, then you would need to force them back in as well but they are not.

SELECT  [GEM_DBKEY]

      ,[COMPANY_CODE]

      ,[DIVISION]

      ,[TRANSACTION_TYPE]

      ,[TRANSACTION_NUMBER]

      ,[TRANSACTION_LINE_NUMBER]

            ,[SCC_COMMISSION_DEDUCTION_FLAG]

      ,[SCC_COMMISSION_DEDUCTION_AMOUNT]

      ,[SCC_COMMISSION_CALC_AMOUNT]

            ,[SCC_COMMISSION_PRICE_CODE]

                  ,[SCC_COMMISSION_DEDUCTION_FLAG]

      ,[SCC_COMMISSION_DEDUCTION_AMOUNT]

      ,[SCC_COMMISSION_PART_CODE]

      ,[SCC_SA_COMMISSION_CVT_FLAG]

      ,[SCC_COMMISSION_DISCOUNT_PCT_1]

      ,[SCC_COMMISSION_DISCOUNT_PCT_2]

 FROM [fin_prod].[dbo].[SA_DETAIL_LINES]

  where TRANSACTION_type='RB' and  TRANSACTION_NUMBER = 634459

  order by TRANSACTION_line_NUMBER