Filter Purchase/Sales order line page by Status

(0) Share

Report

Posted on by Frida_Admotion

359

Hi!

I think the Sales order line page and Purchase line pages are very useful. However, I am really missing the possibility to filter the lines by Open/Release status for the main order they appear on.

Is there a way to do this without using excel to put togehter Sales order line page and the Sales order page?

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (1)

Verified answer

YUN ZHU 81,422 Super User 2025 Season 1 on at

Like (0)

Report
RE: Filter Purchase/Sales order line page by Status

Hi, as MahGah said, status is not in Sales Line.

So the easiest way is to create a flowfield.

For example:

tableextension 80100 SalesLineExt extends "Sales Line" { fields { field(50100; Status; Enum "Sales Document Status") { Caption = 'Status'; FieldClass = FlowField; CalcFormula = lookup("Sales Header".Status where("No." = field("Document No."))); } } } pageextension 80104 SalesLinesExt extends "Sales Lines" { layout { addafter("Document Type") { field(Status; Rec.Status) { ApplicationArea = All; } } } }

Hope this will help.

Thanks.

ZHU
Suggested answer

MahGah 15,437 on at

Like (1)

Report

RE: Filter Purchase/Sales order line page by Status

Hi

I checked and status are not in Line. Beside the method you mentioned you need to ask for minor development to add status to line (copy from header to line).

Or use ODATA in Excel and build the Power Query.