Skip to main content

Notifications

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

Customer assortment management

Posted on by 21

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

Categories:
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,035 Super User 2024 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

  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,611 Super User 2024 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. 

  • 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.

  • 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".

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,035 Super User 2024 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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 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!

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans