Skip to main content

Notifications

Announcements

Forum Structure Changes Coming on 11/8
Give Back to the Community this Month
News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Attributes
Business Central forum
Suggested answer

Attributes

(1) ShareShare
ReportReport
Posted on by PRao
How to get attribute wise item counting? Suppose we have X item and that also have used the variant and defined the attribute. Incase of attribute how to get stock count based on attribute. Below is the scenario. 

Item No. A100
Item Name : Table 
Variant :  Wood, Metal, Plastic or Red, Green, Yellow, Blue 
Attributes : Either define Type : Option (wood, Metal, Plastic etc. ) or Define Type: option ( Red, Green, Yellow, Blue etc. ) 
Stock is getting increased either by Purchase receipt, Item Journal, Production or configuration package. How stock details counting can be getting based on attribute? 

Your suggestion will be appreciated. 
 
Thanks, 
PR
Categories:
Business Central
Business Central
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 23,499 Super User 2024 Season 2 on at
    Attributes
    I don't believe that's possible out of the box as attributes don't really work like that. You would either have to create a custom report that does that for you, either in the system or using third party tools such as Power BI or Jet Reports, or you could consider using dimensions instead of attributes. But using dimensions you would have to include a dimension value every inventory transactions. 
     
  • PRao Profile Picture
    PRao on at
    Attributes
    Hi GR, 

    Thanks for your input. My question is not to upload the Attributes basically my question is how to get the item count (quantity) based on attributes if attribute type is option where item uploaded with multiple option value..
     
    Item X, Variant x1, attribute Red (100qty
    item X, Variant x1, attribute Blue,( 200 qty)
    Item X, Variant x1, attribute Green (110qty)
    Item X, Variant y1, attribute Red (120qty
    item X, Variant y1, attribute Blue,( 150 qty)
    Item X, Variant y1, attribute Green (100qty)
     
  • gdrenteria Profile Picture
    gdrenteria 10,600 Most Valuable Professional on at
    Attribute

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

News and Announcements

Forum Structure Changes Coming on 11/8
Give Back to the Community this Month

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans