web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Filtering Items on Sales Line

(0) ShareShare
ReportReport
Posted on by 96

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?

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    95,718 Super User 2025 Season 2 on at

    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.

    pastedimage1669247459745v1.png

    pastedimage1669247506360v2.png

    pastedimage1669247514355v3.png

    pastedimage1669247519301v4.png

    Hope this helps.

    Thanks.

    ZHU

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,664

#2
YUN ZHU Profile Picture

YUN ZHU 960 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans