Extracting value from customized field of one table to another table field.

(0) Share

Report

Posted on by Muhammad Anas Naeemi

386

I have created fields technically using AL in "Payment Journal" named as "Total WHT Amount" and "WHT Bal. No". The field "WHT Bal. No" has a table relation with "G/L Account" table and is getting the "No." of the table. I have functionally created an account named "WHT and other" (No. = 24250) in "Chart of Accounts" list page(Table: G/L Account). For this specific account, I have created a field "Remaining Balance" in which I want to get the "Total WHT Amount" from the "Payment Journal" after posting the invoice by using the "POST" action. "WHT Bal. No" in "Payment Journal" and "No." in "Chart of Accounts" are the same so I have built a conditional statement between these two for getting the value but it isn't working. Below are the screenshots attached. Kindly help me with this issue.

All responses (6)

Answers (1)

Muhammad Anas Naeemi 386 on at

Like (0)

Report

RE: Extracting value from customized field of one table to another table field.

No problem Daniele Incalza. Thank you.
Suggested answer

DAnny3211 9,276 Moderator on at

Like (0)

Report

RE: Extracting value from customized field of one table to another table field.

sorry it was a slip of the tongue

I wanted to write

test.modify
Muhammad Anas Naeemi 386 on at

Like (0)

Report

RE: Extracting value from customized field of one table to another table field.

Solved. Thank you for your cooperation.
Suggested answer

Nitin Verma 21,548 Moderator on at

Like (0)

Report

RE: Extracting value from customized field of one table to another table field.

You have to use Test.Modify() after you are updating the Remaining Balance.

Thanks.
Verified answer

Amit_Sharma 2,547 on at

Like (0)

Report

RE: Extracting value from customized field of one table to another table field.

Use test.modify

Regards

Amit Sharma

www.erpconsultors.com
Suggested answer

DAnny3211 9,276 Moderator on at

Like (0)

Report

RE: Extracting value from customized field of one table to another table field.

Hi

you should do the test.INSERT

DAniele