Get() a record using a temporary record

(4) Share

Report

Posted on by Rudylar

115

Hi,

In order to get a static list of records from a FindSet(), I did the following because this record has 7 PK of different types and I couldn't reference in a list:

var
PurchasePriceTemp: Record "Purchase Price" temporary;
begin
PurchasePriceL.SetRange("Vendor No.", inVendorNo);
if PurchasePriceL.FindSet() then begin
repeat
PurchasePriceTemp.Init();
PurchasePriceTemp := PurchasePriceL;
PurchasePriceTemp."Minimum Quantity" := 9999; // just as an identifier to make sure those temp records will not be saved on the real table
PurchasePriceTemp.Insert();
until PurchasePriceL.Next() = 0;
end;

if PurchasePriceTemp.FindSet() then begin
repeat
PurchasePriceL.Get(PurchasePriceTemp."Item No.", PurchasePriceTemp."Vendor No.", PurchasePriceTemp."Starting Date", PurchasePriceTemp."Currency Code", PurchasePriceTemp."Variant Code", PurchasePriceTemp."Unit of Measure Code", PurchasePriceTemp."Minimum Quantity");

And this is precisely when I try to Get() that exception is raised saying the record (temp) does not exist...

Any idea ?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

YUN ZHU 101,250 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi, it seems that PurchasePriceL and PurchasePriceTemp only differ in the value of "Minimum Quantity". Why don't you just add your processing directly after insert?

I personally don't think adding a second loop is necessary.

As for your question, change PurchasePriceTemp := PurchasePriceL; to assign a value to the field separately.
In addition, you can also add a message after if PurchasePriceTemp.FindSet() then begin
repeat
to check whether the value you are trying to get is empty.

If you think the key is too long, you can also try to obtain it using SystemId.

Dynamics 365 Business Central: How to get a record by its SystemId

https://yzhums.com/13242/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,444 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

For other helps: https://community.dynamics.com/forums/thread/details/?threadid=0f25bb0d-ba1a-f011-998a-00224833c1bb

Was this reply helpful? Yes No
Rudylar 115 on at

Like (3)

Report
Copy link

Link copied!

I used the SystemId and it works great.

Thank you

Was this reply helpful? Yes No

Join the conversation

Community site session details

Get() a record using a temporary record

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Meet the Microsoft Dynamics 365 Contact Center Champions

Congratulations to the April Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Get() a record using a temporary record

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Meet the Microsoft Dynamics 365 Contact Center Champions

Congratulations to the April Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates