News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Action on purchase lin...

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

Suggested answer

Action on purchase line to display change log entries linked

(0) Share

Report

Report

Posted on by Samantha73

2,663

Hi All

I'm trying to create an action that filters change log entries for the selected purchase order line. However, in change log entries table, line no is text so the code shows an error when trying to filter by line no which is integer on purchase line table:

RunObject = Page "Change Log Entries";

RunPageLink = "Primary Key Field 2 Value" = FIELD("Document No."),

"Primary Key Field 3 Value" = Field("Line No."),//Text to integer error

"Table No." = FILTER(39),

"Type of Change" = FILTER(Modification),

"Primary Key Field 1 Value" = FILTER(1);

ToolTip = 'Opens change log and display modifcations to Selected PO Line.';

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Vaishnavi J 3,058 on at

Like (0)

Report

RE: Action on purchase line to display change log entries linked

Hi,

You can write the above logic in this way which will open the change log entries.

trigger OnAction()

var

PageChangeLogentries: Page "Change Log Entries";

Rec_ChangeLogEntries: Record "Change Log Entry";

begin

Clear(Rec_ChangeLogEntries);

Rec_ChangeLogEntries.Reset();

Rec_ChangeLogEntries.SetRange("Primary Key Field 2 Value", Rec."Document No.");

Rec_ChangeLogEntries.SetRange("Primary Key Field 3 Value", Format(Rec."Line No."));

Rec_ChangeLogEntries.SetRange("Table No.", 39);

Rec_ChangeLogEntries.SetRange("Type of Change", Rec_ChangeLogEntries."Type of Change"::Modification);

if Rec_ChangeLogEntries.FindFirst() then begin

Clear(PageChangeLogentries);

PageChangeLogentries.SetTableView(Rec_ChangeLogEntries);

PageChangeLogentries.Run();

end;

end;

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,886 Super User 2025 Season 1

#2

Martin Dráb 231,766 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans