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′)

  • April 27, 2018 | 19 views