web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to capture the las...

Small and medium business | Business Central, N...

Answered

How to capture the last transaction of location code

(0) Share

Report

Report

Posted on by Jade Ng

261

Hi all experts,

I'm new to AL language.
I want to capture the location code in the Item Ledger Entry - Last transaction of the location code (Highlighted in Red Box)

As currently my report is printed the location code with first record, so now i wish to capture the last record of location code.

I direct pulled the field location code in item ledger entry, but it print the first record in report layout.

How can i write the code and print in the report?

Below is my screenshot.

Thank you.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Vaishnavi J 3,094 on at

Like (0)

Report
Copy link

Link copied!

Hi

you can use FindLast function to get the last record.

and then you have to create a report if you have it then simply use its ID in RunModal Function.

Example:

ItemLedgerEntry : Record Item Ledger Entry;

If ItemLedgerEntry.FindLast() then

Report.RunModal(50101, true, true, ItemLedgerEntry);

Below is the link for more information.

docs.microsoft.com/.../record-findlast-method

docs.microsoft.com/.../page-runmodal--method

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 1,804 Super User 2026 Season 1

#2

YUN ZHU 1,103 Super User 2026 Season 1

#3

Kamal Khakhkhar 695

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans