ROSS: TP Rebate Post Invoice Discounts not updated to AR

If the AR_Transactions are not updated for a Rebate.

Facility:  SCC_TP_U_001_INV    tp\src\tp_u_update_post_invoice_after_inv.dml

Message:   MESSAGE("P_52231")   "Invalid Credit note Line"

Select by the Rebate transaction number or leave blank to see what is available to update:    (REBATE_NUMBER = 638161)

SELECT        TOP (200) GEM_DBKEY, COMPANY_CODE, DIVISION, REBATE_NUMBER, REBATE_CODE, REBATE_PERCENT, CUSTOMER_NUMBER, INVOICE_ADDRESS_CODE, SALESPERSON_CODE, BROKER_CODE, TRANSACTION_DESCRIPTION, CUSTOMER_SALES_ACCT_NUMBER, REBATE_DATE, STATUS_FLAG, PERIOD, YEAR, SYSTEM_DATE, USERNAME, TOTAL_REBATE_VALUE, SYS_CURRENCY_CODE, SYS_BASE_CURRENCY,  SYS_CURRENCY_RATE, SYS_CURRENCY_DATE, SYS_CURRENCY_FIXED_FLAG, SYS_CURRENCY_RATIO_INDIC, SYS_RATE_AUTHORITY, SYS_RATE_TYPE, SYS_CURRENCY_2_RATE, SYS_CURRENCY_2_RATIO_INDIC,   AR_SHORT_CODE, AR_FULL_ACCOUNT, COST_CENTER, TOTAL_REBATE_VALUE_BASE, NOTES, SALES_COMMISSION_CODE, LOCATION, SALES_ANALYSIS_GROUP, CUSTOMER_CONTACT, SA_SUMMARY_FLAG, SA_YEAR,   SA_PERIOD, CREDIT_NOTE_PRINT_FLAG, BATCH_NUMBER, SCC_ALLOCATION_STATUS, SCC_REBATE_APPROVAL_FLAG, SCC_REBATE_APPROVED_BY, CUSTOMER_SALES_ACCT_NAME, SCC_STATUS_OF_REBATE,   SCC_SOLD_TO_EU_DATE, SCC_FACILITY_REJECT_FLAG, SCC_RM_COMMENTS, SCC_CONTRACT, SCC_SUBMIT_BATCH_NUMBER, SCC_SUBMISSION_DESCRIPTION, SCC_MANUAL_BID_CREDIT, SCC_REBATE_DATE_LOADED, SCC_USE_PRICE_INCR_DATE_FLAG, SCC_USE_ALTERNATE_START_ALLOC, SCC_USE_CURRENT_BACK_FLAG, RSI_PDF_GENERATED

FROM            SCC_REBATE_HEADERS

WHERE        (REBATE_NUMBER = 638161)

the period needs to be changed to the current period.

if the rebate was updated last month and the AR was not created, then change to the current period.

now you can update the Rebate.

Select * FROM            AR_TRANSACTIONS  WHERE        (TRANSACTION_NUMBER = 638161)

Now it is updated.

Select *  FROM            TP_POST_INVOICE_DISCOUNTS  WHERE        (TRANSACTION_NUMBER = 638161)

Select *  FROM            TP_POST_INV_DISC_DETAILS       WHERE        (TRANSACTION_NUMBER = 638161)

These records will show as TP_Value_To_Update before the update.

After the update they will look like this:

*********************************************************************************

If there are   N O    TP records to update.

check for missing TP

Add records to 2 tables:

Select * FROM            TP_POST_INVOICE_DISCOUNTS

WHERE        (TRANSACTION_TYPE = 'RB') AND (TRANSACTION_NUMBER >= 640572)    ORDER BY TRANSACTION_NUMBER

Select * FROM            TP_POST_INV_DISC_DETAILS

WHERE        (TRANSACTION_TYPE = 'RB') AND (TRANSACTION_NUMBER >= 640572)    ORDER BY TRANSACTION_NUMBER

1.  Copy an existing record   460573 in this case which was already updated.

2.  change the transaction number, line #, quantities.    

     A.  repeat quantities in all the fields except:  

               1.  TP_Updated_Flag  = 0

               2.  TP_Updated_Value = 0

               3.  TP_Value_TO_Update = line value

               4.  TP_Outstanding  fields will be filled in automatically by the system as the record is created 

               5.   R E P E A T    for all the lines in the rebate to be updated