Form Personalization for custom reference value updation

CEL CLIENT

Form Personalization:

Requirement:

        In this form personalization I have updated the values for customer_reference column. This column is in

India Local Receivables

à   Receipts

o  Receipts

Enter the Payment_method=BI- HDFC BANK

                Receipt_number=100000

                Receipt_amount=2000

Then Select the Customer_name from lov.

        Customer_name=ACCURATE CAST ALLOYS PVT. LTD.

        Customer_no=5893

Then click Search and apply button.

 

Next Open the another form:

Then click the Preview(G) tab. Next automatically open this form.

In this form that customer reference column is blank.

In that column they need default values in form.

Solution:

First go to receipt form and do the personalization.

        Form_name : ARXRWMAI

       

Seq: 10

Description: UPDATE CUSTOMER REFERENCE  VALUES

Condition tab:

        Trigger_event: WHEN-VALIDATE-RECORD

        Trigger_object: APP_FOLDER

 

Action tab:

        Seq: 10

        Type: Property

Object type: Item

Targetobject: APP_FOLDER.CUSTOMER_REFERENCE

Property name:VALUE

Value: =(SELECT customer_reference FROM RA_CUSTOMER_TRX_ALL WHERE customer_trx_id=:APP_FOLDER.CUSTOMER_TRX_ID)

Then validate the personalization. Save it.

Close the form and open it. See the changes.

 

the customer_reference data is updated and it will be displayed.