229
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.
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.
#1
André Arnaud de Cal...
292,923
Super User 2025 Season 1
#2
Martin Dráb
231,788
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
