Need report for Item attributes

(0) Share

Report

Posted on by Community Member

I setup item attributes and associated them with an item category. I then associated the category with an item. All works as expected. Now I would like to create a report to print each item number and the specific attributes. What is the best method to report on item attributes?

Thank you,

Steve

*This post is locked for comments

All responses (6)

Answers (0)

Community Member on at

Like (0)

Report

RE: Need report for Item attributes

juhl.blog/.../print-item-attributes-on-report
ManishS 80 on at

Like (0)

Report

RE: Need report for Item attributes

You can develop a report or a matrix page to display the attributes based on item master.
Tina Menezes 2,582 on at

Like (0)

Report

RE: Need report for Item attributes

Hi Stephen,

You need to create a report with two data items i.e. your Item table and the Item category table and create a link between the two tables with the unique field between them in the properties or using C/AL code. You will then get all the items in the report along with their corresponding item attributes.
Suggested answer

Suresh Kulla 47,688 on at

Like (0)

Report

RE: Need report for Item attributes

Stephen,

You need to create report with Item as main data item and then link it to the Item Attribute table using item category. Are you looking for an example or the steps to create ?
Suggested answer

tpupko 2,048 on at

Like (1)

Report

RE: Need report for Item attributes

Hi Stephen,

You can create report using table 7505 Item Attribute Value Mapping where you can find attributes for items.

Tatiana
Suggested answer

dkatson 2,263 on at

Like (0)

Report

RE: Need report for Item attributes

as 1 item can have many attributes so this should be custom report. But it can be created in list view , where all possible attributes are columns, as normal columns.