Thursday 26 April 2018

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








4 comments: