Putting values in a table on executing custom action

(1) Share

Report

Posted on by Muhammad Anas Naeemi

382

Hello community,

I have created a custom action button ("Post WHT") on a custom page ("WHT Transaction"). Now I want that whenever the action is executed all the values currently present on the custom page should be appended to the payment journal new line. Below pictures will clear this more. In the first image, the custom action and custom page is shown and in the second image payment journal lines are shown. Now whenever I execute the action, the values from my custom page should be appended to the new line of payment journal. I tried posting this but I am getting primary key error in shown in third image. There is no primary key used in the custom table or page. Kindly help.

All responses (33)

Answers (4)

Muhammad Anas Naeemi 382 on at

Like (1)

Report

RE: Putting values in a table on executing custom action

It worked for me. Thanks to both of you Mohana and Pankaj. Your efforts are highly appreciated specially Pankaj. Thank you once again.
Verified answer

Mohana Yadav 59,194 Super User 2024 Season 2 on at

Like (0)

Report

RE: Putting values in a table on executing custom action

You have to use Rec_payment_journal .Insert and not Modify.
Suggested answer

pankaj.k 962 on at

Like (0)

Report

RE: Putting values in a table on executing custom action

you need to user debugger that will help you more of share your full code and error detail
Muhammad Anas Naeemi 382 on at

Like (0)

Report

RE: Putting values in a table on executing custom action

It is done. Thank you. but I'm getting the error below. Although I have inspected the payment journal page and the first line no. is 10000 so the second should be 20000 but still I'm getting error.
Suggested answer

pankaj.k 962 on at

Like (0)

Report

RE: Putting values in a table on executing custom action

use your table name befor the function

Rec_payment_journal
Muhammad Anas Naeemi 382 on at

Like (0)

Report

RE: Putting values in a table on executing custom action
pankaj.k 962 on at

Like (0)

Report

RE: Putting values in a table on executing custom action

Show your code.
Muhammad Anas Naeemi 382 on at

Like (0)

Report

RE: Putting values in a table on executing custom action

But Pankaj GetNewLineNo is not a built-in method. So I am getting an error when using this.
Verified answer

pankaj.k 962 on at

Like (1)

Report

RE: Putting values in a table on executing custom action

Use the below function that will help to increase the line number.

LineNo := GenJnLine.GetNewLineNo(SRSetup.LoanAutoPstTemplate, SRSetup.LoanAutoPstBatch);

GenJnLine."Line No." := LineNo;

for check the line No. on the page of Gen Jour.. open the Page Inspection use the shortcut key CTRL + ALT + F1
Muhammad Anas Naeemi 382 on at

Like (0)

Report

RE: Putting values in a table on executing custom action

Hi Mohana, GetNewLineNo is a user-defined method maybe. Can you give me the source code?