Personalization at Adjustment/Sales order/Credit Memo application form

This component can be used, for requirement related to personalization where we want to restrict the user to create RMA/Adjustment/Credit memo if certain(user defined) conditions are not met.

Personalization at Transaction/Adjustment Form

Responsibilty: Receivables

Form       : Transaction

This personalization will restrict the users to create adjustments against the invoices depending on the condition.

Condition:   'N'=(SELECT NVL(ATTRIBUTE15 ,'N')FROM

RA_CUSTOMER_TRX_ALL WHERE customer_trx_id=:ADJ_ADJUST.CUSTOMER_TRX_ID

AND TRX_DATE>'03-APR-2018')

Personalization at sales order form for RMA creation

Responsibility: Order Management

Form       : Sales Order

This personalization will restrict the users to create RMA against the invoices depending on the condition

Condition : 'N'=(Select NVL(b.attribute15,'N')

  from ra_customer_trx_all b

 where b.customer_trx_id=:Line.return_attribute1

and b.trx_date>'03-APR-2018') and (:ORDER.ORDER_TYPE LIKE '%C/n' or :ORDER.ORDER_TYPE LIKE '%C/N')

Personalization at Transaction/Application Form

Responsibilty: Receivables

Form       : Transaction

This personalization will restrict the users to create credit note memo against the invoices depending on the condition

Condition:  'N'=(SELECT NVL(ATTRIBUTE15 ,'N')FROM

RA_CUSTOMER_TRX_ALL WHERE customer_trx_id=:APP_FOLDER.CUSTOMER_TRX_ID

AND TRX_DATE>'16-FEB-2018')