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








1 comment:

  1. PLSQL Android Apps - Useful productivity solution for Oracle consultants, please it checkout in google play store :

    Code profiler App
    https://play.google.com/store/apps/details?id=appinventor.ai_pshreedhar.PLSQL_Review1

    Plsql Flowchart App
    https://play.google.com/store/apps/details?id=appinventor.ai_pshreedhar.PLSQL_Flow2

    and also check out the solution demo in Youtube

    https://youtu.be/Wckm1_s9Y0M?list=PLqfoPI5nmJaNJNleopCOYh3rqX-8zraqU

    ReplyDelete