Filtering Items on Sales Line

(0) Share

Report

Posted on by Peter Taylor FP

Hi....I want to filter the list of items when looking up in the No. field on the sales order line. Specifically, I want to only show items with a certain BRAND (Global Dimension 1), where the 'Allowed Brands' are configured against the customer. So if I have 10 brands, A to J, and customer X is allowed to buy items with brands B, E and H, on looking up on the No. field from the sales line, only items that have brands B, E and H are listed. This means I need a table/page linked to the customer to record that customer X can only buy items with brands B, E and H. I think this will almost certainly need custom code, but wondered if anyone had any ideas on how to achieve this?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 101,600 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, Yes, it looks like it needs to be customized.
Because you need a corresponding table of items and customers, this is not a standard function of BC.
And if you want to filter easily, you can try the following functions.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No