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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / T&L Inventory Cate...
Finance | Project Operations, Human Resources, ...
Unanswered

T&L Inventory Categorization limitation

(0) ShareShare
ReportReport
Posted on by Suhail Chogle 5

Hello,

I'm given to understand that within T&L, profiling an item (SKU) within Inventory, the categorization is dependent on a single table whereby all data within each level of category has to be unique. Isn't this fundamentally wrong since I may have similar product characteristics that fall into different product categories?

Eg., Perfumary->Aftershave->50ml

                                             ->100ml

                         ->Cologne   ->50ml

                                             ->100ml

(please excuse the simplistic example)

Our Implementor (Microsoft partner) insists the above cannot be done. If true, how have other trading/retail institutions circumvented this limitation? 

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Suhail,

    I think you have to give us a bit more information especially on the following elements:

    * You mentioned that the categorization is dependent on a single table. Is this table on that you created/customized?

    * When you say 'characteristics', what AX element do you use for recording and differentiating the different characteristics?

    Best regards,

    Ludwig

  • Suhail Chogle Profile Picture
    Suhail Chogle 5 on at

    Hello Dr. Ludwig,

    Single Table:

    I was given to understand by the implementers that Product Category is stored in a single table with the unique key set. In layman terms that would mean all data stored within this table would have to be unique. I do not know if this is a AX 2012 R3 standard table or not.

    Characteristics:

    I was simply describing the different attributes or characteristics of a product that one may use for reporting. These attributes/characteristics we would like to store within the Product Category feature. In other words (going by the example I provided), if I were to do this:

    [Category] Perfumery ->[sub-Category] Type (eg. Aftershave) ->[sub-sub Category] 100ml (volume)

    I would then be able to provide reports where within [Category] Perfumery, I could see my sales for [sub-sub Category] 100ml across all [sub-Category] Type (ie., Aftershave, Cologne etc.).

    And in order to be able to do that I would have to repeat the Volume (50ml, 100ml etc) in sub-sub Category for each Type (Aftershave, Cologne, Eau de Toilette etc.) in the sub-Category.

    I hope I'm making sense.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 688

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 524 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 301

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans