How to capture the last transaction of location code

(0) Share

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 (1)

Answers (0)

Suggested answer

Vaishnavi J 3,062 on at

Like (0)

Report

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