Attributes

(1) Share

Report

Posted on by PRao

394

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,

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Gerardo Rentería Ga... 25,236 Most Valuable Professional on at

Like (1)

Report

Hi

I hope this can help you and give you some hints

Dynamics 365 Business Central: Show Item Attributes on the page (For Example: On Item List page) | Dynamics 365 Lab

Dynamics 365 Business Central: Bulk add/update Item Attributes (Edit the attributes of multiple items at the same time) – Customization | Dynamics 365 Lab

Business Central Item Attributes Sales Order Factbox – Josh Anglesea

Best

GR

Was this reply helpful? Yes No
PRao 394 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,481 Super User 2025 Season 2 on at

Like (2)

Report

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.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (1)

Report

Hi, I agree with Valentin, the purpose of Attribute in BC is an Item, there is only one set of Attributes, so there is no different inventory for different Attributes.

Unless you customize it, but this is also a bit complicated. Users need to enter attributes when shipping out and shipping in, and the data after posting also needs to be added.

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No