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

Community site session details

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

Customer assortment management

(0) ShareShare
ReportReport
Posted on by 24

Hi,

we are in process of implementing Microsoft Business Central in our company. So the system is pretty new to us. We are having customer for whom we are producing tailermaid products, which we store at our warehouse and each of these customers have an own shop in our webshop were they order. Today we have an assortment identifier per customer. I cant find anything about assortments in business central.

Does anybody now how we could handle our case in Business Central, or can recommend an add on we could use to manage our customers assortments?

Help would be much apprechiated

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,045 Moderator on at
    RE: Customer assortment management

    There is really no standard functionality that fills your requirement. What you could do is to create a customer price group per customer and then define a price list for that customer price group holding all the items that you want to be in the customers assortment.

    Maybe you can check out these apps on appsource and see if they have the functionality you need ?

    appsource.microsoft.com/.../apps

    And good luck with your implementation!

  • Suggested answer
    YUN ZHU Profile Picture
    93,438 Super User 2025 Season 2 on at
    RE: Customer assortment management

    Hi, Generally, it is recommended to use Dimension to manage the relevant attributes of customers in BC. This is a standard feature.

    More details:

    https://learn.microsoft.com/en-us/dynamics365/business-central/finance-dimensions#to-set-up-default-dimensions-for-customers-vendors-and-other-accounts

    pastedimage1675988894285v1.png

    Hope this helps.

    Thanks.

    ZHU

  • Michaela-Dobrila Tesinovic Profile Picture
    24 on at
    RE: Customer assortment management

    Dear Inge,

    thanks a lot for your feedback and support. We have now identified that we will use the "purchasing code" in order to identify items made for the customer and the assortment management we will do in the E-Commerce solution "Dynamic Web".

  • Michaela-Dobrila Tesinovic Profile Picture
    24 on at
    RE: Customer assortment management

    Hi Zulu,

    thanks a lot for reply and support.

    I learned that you can also assign dedicated attributes to an item. Can you help me understand when you would rather use the dimensions, then attributes?

    For identifying the customer stock items, we have now agreed to choose the field "purchasing code" as this also allows us, to filter in the requesition worksheet and make the replenishment planning for the customer. As we understand dimensions and attributes are both not available as filter or linked to the requisition worksheet, correct?

    The assortment we will manage in the websolution Dynamicweb. So I guess we could fix the issue ;-)

    But again thanks a lot. Great having people supporting.

  • Suggested answer
    Valentin Castravet Profile Picture
    30,066 Super User 2025 Season 2 on at
    RE: Customer assortment management

    Attributes is typically something that stays with the Item Card. Its another way of describing an item or providing more descriptive information about an item card. For example you have two similar items, you can use attributes to say what color each item is. 

    When an Item is used on a transaction, the attributes dont go anywhere i.e. on the document/posted document/ledger entries.

    For example:

    pastedimage1678223810543v1.png

    There are multiple way to think about Dimensions in Business Central. One way is as a reporting category, or as an additional piece of information you tag to a transaction. On each transaction you would select a dimension code such as a Department, and this code travels with the transaction to the posted document / ledger entry. You can then run reporting on different dimensions. i.e. the balance of a sales G/L Account is 1,000, but then you can break this down further and see that 500 is for dimension Department A and 500 is for dimension Department B

    To answer your question, dimensions would be used if you need this piece of information to travel to the posted transaction/document/ledger entry. If you simply need the information to stay with the item card, to provide more description, you would use attributes. 

    regarding your last question, as far as I know yes both cant be used as a filter in the requisition worksheet. 

  • Suggested answer
    YUN ZHU Profile Picture
    93,438 Super User 2025 Season 2 on at
    RE: Customer assortment management

    Hi, Valentin is right, if you want to apply them on filters, this requires a simple customization, first add the fields to the page.

    For example, 
    https://yzhums.com/2182/
    https://yzhums.com/5007/

    And, hopefully the following Microsoft documentation can also give you some hints.

    Item Attribute: https://learn.microsoft.com/en-us/dynamics365/business-central/inventory-how-work-item-attributes

    Dimensions: https://learn.microsoft.com/en-us/dynamics365/business-central/finance-dimensions

    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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Sumit Singh Profile Picture

Sumit Singh 2,204

#2
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 1,933

#3
YUN ZHU Profile Picture

YUN ZHU 1,885 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans