Extracting value from table to another

(0) Share

Report

Posted on by Muhammad Anas Naeemi

436

I want to add some of the fields from Payment Journal table like "Posting Date", "Document Type", "Document No.", "Account Type", "Account No.", and "Description" (shown in fig1) in another customised table i.e. "G/L Table" (shown in fig 2). I have used a loop but the main issue that I am facing is that it is getting only the last record rather than all the records. I have also attached the code screenshot (fig 3). Kindly help me with this issue.

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

You have to use with Gen. Journal Line variable with Repeat until with Template and Batch filter and then write your code inside that loop.

Thanks.

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

Like (0)

Report
Copy link

Link copied!

Not working. Can you send me the code for this?

Was this reply helpful? Yes No
Suggested answer

Amit 2,563 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Below the code for your reqirement.

GenJournalLine.Reset;

GenJournalLine.Setfilter("Journal Template Name",'GENERAL');

GenJournalLine.Setfilter("Journal Batch Name",DEFAULT');

if GenJournalLine.Findset then begin

Repeat

check.init;

check."Posting Date" := GenJournalLine."Posting Date";

check."Document No." := GenJournalLine."Document No.";..... so on

.......

Check.Insert;

Until GenJournalLine.Next =0;

end;

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
Verified answer

DAnny3211 11,423 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hello

you can now use this very powerful function

learn.microsoft.com/.../devenv-data-transfer

DAniele

Was this reply helpful? Yes No
Verified answer

YUN ZHU 102,578 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, I vote for Amit's code.
Another problem in your code is that you cannot use Get method, the Get method will only get one record, you should use Setrange or Setfilter.

In your sample, you should fitler try first, then repeat.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-get-find-and-next-methods#get-method

Hope this helps as well.

Thanks.

ZHU

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

Like (1)

Report
Copy link

Link copied!

Issue resolved. Thanks to all.

Was this reply helpful? Yes No