Filter Purchase/Sales order line page by Status

(0) Share

Report

Posted on by Frida_Admotion

387

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

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

MahGah 15,529 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report
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

Was this reply helpful? Yes No