web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Insert record in Temporary table

(0) ShareShare
ReportReport
Posted on by 3,099

Hi

  I have below code . Is there any better way to save data in Temporary table . I have ILERec with Record DataType & SubType = Item Ledger Entry. Temporary = 'Yes'

Item Ledger Entry - OnAfterGetRecord()

ILERec.RESET;
ILERec.SETRANGE("Item No.","Item No.");
ILERec.SETRANGE("Lot No","Lot No");
IF ILERec.FINDFIRST THEN Begin
CurrReport.Skip;
end else begin
ILERec."Entry No." := "Item Ledger Entry"."Entry No.";
ILERec."Item No." := "Item Ledger Entry"."Item No.";

ILERec."Lot No" := "Item Ledger Entry"."Lot No";
ILERec.INSERT;
End;

Thanks

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    14,300 Super User 2026 Season 1 on at

    ILERec.RESET;

    ILERec.SETRANGE("Item No.","Item No.");

    ILERec.SETRANGE("Lot No","Lot No");

    IF NOT ILERec.ISEMPTY THEN

    CurrReport.Skip

    else begin

    ILERec.RESET;

    ILERec.INIT;

    ILERec := "Item Ledger Entry";

    ILERec.INSERT;

    End;

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans