ICM Verify: Commission by Transaction Number

Composer    Calculations    Commission by Transaction Number

compare to ROSS

First compare this list to this report:

Front end report:    Administrative Payroll Exports        Export:  Commission Report

Run for this pay period        open the RM that is different            Payout Summary            Regular Commissions

Compare                                 Product Net Sales                            Commission

these are listed 1 per transaction#

With this error, the transaction is N O T  Listed on the report because the   

compare each transaction to see which is different.

Issue 1:  Credit note# 814638 had 2 lines.

    one with ship to "SHP01".

    the other had "9-7" which was not a valid address code for this customer.

To fix this, I changed the delivery address code to the "SHP01" in SA_DETAIL_LINES and SA_DETAIL_HEADERS.

Issue 2: There were 2 transactions 931824 & 932468 that were changed after a move back to the old number.

0993701 customer# but the delivery address code was not valid for this customer.  

Delivery address code was "99-47" which existed in the original customer#.  

This address did not exist in ICM or ROSS for the new customer "0993701". 

To fix this, I changed the delivery address code to the "SHP01" in SA_DETAIL_LINES and SA_DETAIL_HEADERS.

I ran import again & I ran the calculation again.

    /* Verify details by transaction for 1 RM */  

  SELECT   s.location    ,l.transaction_type, l.transaction_number,  l.transaction_Date,  l.customer_number, a.SALESPERSON_CODE

,sum((l.sa_total_currency  - l.line_discount )* DORC_INDICATOR) as line_net    ,sum((l.SCC_product_net_sales )* DORC_INDICATOR) as prodNetSales     ,sum((l. SCC_COMMISSION_CALC_AMOUNT )) as ComAmt        

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

left outer join customers c  on c.customer_number = L.customer_number and c.sales_order_type <> 'EUORD'           

left outer join customer_addresses A on A.customer_number = C.customer_number and A.address_code = L.delivery_address_code             

left outer join salespersons s on s.salesperson_code = l.salesperson_code                                          

left outer join product_master M on m.part_code = L.part_code        

  where l.transaction_date >= '16-Jan-2024' and l.transaction_date <= '31-jan-2024' 

  and SCC_DO_NOT_INCLUDE_SALES_FLAG <> 'Y'     and SCC_COMMISSION_NOT_PAID_FLAG <> 'Y' and SCC_TRANSACTION_QUANTITY <> 0 and (l.warehouse ='FG' or l.warehouse = 'BK')  

  and(   l.salesperson_code = '347' )

group by l.transaction_Date, s.location, l.transaction_type, l.transaction_number,  l.customer_number, a.SALESPERSON_CODE        

order by l.transaction_type,l.transaction_number, l.transaction_Date, s.location    ,  l.customer_number