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
- Open Advanced Line Filter from the worksheet.
- Set the sales line and transfer line filters you need.
- Save the filter with a name.
- 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.
Related Order Fulfillment Worksheet features
All Order Fulfillment Worksheet features →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.