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

(0) Share

Report

Posted on by Muhammad Anas Naeemi

390

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.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

Hi

you should do the test.INSERT

DAniele

Was this reply helpful? Yes No
Suggested answer

Amit 2,559 on at

Like (0)

Report

Use test.modify

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

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

Thanks.

Was this reply helpful? Yes No
Muhammad Anas Naeemi 390 on at

Like (0)

Report

Solved. Thank you for your cooperation.

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

sorry it was a slip of the tongue

I wanted to write

test.modify

Was this reply helpful? Yes No
Muhammad Anas Naeemi 390 on at

Like (0)

Report

No problem Daniele Incalza. Thank you.

Was this reply helpful? Yes No