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

Announcements

News and Announcements icon
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
    101,850 Super User 2026 Season 1 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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,386 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,774 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,515

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans