Skip to content
Order Fulfillment Worksheet app iconOrder Fulfillment WorksheetViews and filters

Advanced Line Filters for Microsoft Dynamics 365 Business Central

Header filters narrow the worksheet by order, but many fulfillment decisions depend on the lines: a product group, a type of item, a particular kind of line. Order Fulfillment Worksheet lets you create Advanced Line Filters on sales lines and transfer lines, save them, and apply them again whenever you need that slice of the work.

How Advanced line filters works in Order Fulfillment Worksheet

  1. Open Advanced Line Filter from the worksheet.
  2. Set the sales line and transfer line filters you need.
  3. Save the filter with a name.
  4. Apply it, then recalculate to allocate across the filtered orders.

Key capabilities

Line-level filtering

Filter on order line fields to bring forward only the orders whose lines match, rather than filtering on header fields alone.

Sales and transfer lines

Sales line filters and transfer line filters are set separately, because the two document types carry different fields.

Saved for reuse

Create a filter once, save it, and apply it again whenever the same slice of work comes up.

Works with views

Use a saved filter together with a custom view to sort and narrow the worksheet before you recalculate.

Details that matter on the floor

Filtering changes allocation

Allocation runs across the displayed orders, so a line filter also narrows which orders receive stock at the next recalculation.

Who uses Advanced line filters

Order fulfillment specialists

Work one product group or line type at a time.

Warehouse managers

Keep standard filters that the team applies the same way every day.

Questions about Advanced line filters

Can I filter the worksheet by order line fields?

Yes. Advanced Line Filters filter on sales line and transfer line fields, and can be saved for reuse.

Do line filters apply to scheduled runs?

Job queue entries carry their own filters. Advanced Line Filters are used on the worksheet itself.

Which fields can I filter on?

Most sales line and transfer line fields. A few header-type fields are not supported in line filters; use the worksheet's own filters for those.

Order Fulfillment Worksheet app icon

Part of Order Fulfillment Worksheet

Optimize your order fulfillment process by focusing on in-stock orders.

Have a question about Advanced line filters?

Send us a note and the Order Fulfillment Worksheet team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.

Ask a product question

Product Questions