Change log entry has to show the 'sales header' and 'sales line' changes for particular sales order

Jacob1227 · 2019-09-10

Hi All,

I have created one action button(change log) in 'Sales order page' and I have written the below code in 'on action' action trigger.

RecRef.GETTABLE(Rec);
ChangeLogEntry.SETRANGE("Record ID",RecRef.RECORDID);
ChangeLogEntries.SETTABLEVIEW(ChangeLogEntry);
ChangeLogEntries.RUN;

While i am clicking the action button in any sales order, only it filtered the sales header changes and shown. But i want to show the both sales header and sales line changes.

Can you guide me to proceed further?

Thanks in advance,
Jacob.A

Wisa123 · 2019-09-10

How about

CLE.SETFILTER("Table No.", '%1|%2', 36,37);
CLE.SETRANGE("Primary Key Field 1 Value", Rec."Document Type");
CLE.SETRANGE("Primary Key Field 2 Value", Rec."No.")
//Settableview, run

Should (did not try it) work but is most likely really inefficient. But since you ChangeLog T36 and T37 efficiency isn't your primary concern anyway i figure

/Wisa

Wisa123 · 2019-09-10

How about

CLE.SETFILTER("Table No.", '%1|%2', 36,37);
CLE.SETRANGE("Primary Key Field 1 Value", Rec."Document Type");
CLE.SETRANGE("Primary Key Field 2 Value", Rec."No.")
//Settableview, run

Should (did not try it) work but is most likely really inefficient. But since you ChangeLog T36 and T37 efficiency isn't your primary concern anyway i figure

/Wisa

Jacob1227 · 2019-09-10

Hi Wisa,

Thanks for your suggestion.

RecRef.GETTABLE(Rec);
ChangeLogEntry.SETRANGE("Primary Key Field 2 Value",Rec."No.");
ChangeLogEntries.SETTABLEVIEW(ChangeLogEntry);
ChangeLogEntries.RUN;

The above code works as per your suggestion.

Change log entry has to show the 'sales header' and 'sales line' changes for particular sales order

Best Answer

Answers

Categories