Hi, has anyone managed to run an item attribute report in Jet linking to MS Dynamics 365BC?
I am trying to pull the attribute values out.
If anyone does please have an example or have a formula for the links.
Many thanks
Cameron
Date
Votes
5 comments
-
CascadiaDataworks Is this like a BOM report? I haven't heard of this report but I know sometimes reports are called different things by different companies.
-
Cameron Starling Hi, no its off the Item card, linking table 27 ITEM to the attributes. Thanks
-
CascadiaDataworks I can't test, but I might guess that you may find those attributes in a table like Item Variant or Default Dimension (will need to link on No and Table No). I believe in NAV 2018 (and a lot of the structure is still there in BC) there was an Item Attribute set of tables but I'm not sure how they connected to the Item table. https://dynamicsdocs.com/nav/2018/w1/table/item-attribute
-
mike young You need to use a few tables...
Table 27 "Item"
Table 7505 "Item Attribute Value Mapping"
return the field "Item Attribute Value ID"
Filter the Item "No."
Filter the Item "Item Attribute ID"
Table 7501 "Item Attribute Value"
return the field "Numeric Value" or "Value"
Filter the Item "Attribute ID"
Filter the Item "ID" -
Cameron Starling Thanks to both Mike and BobRoss. I have managed to link the tables, its not pretty but it works. I used NL functions which I assume is the way to go.
Struggled to get the linking to work all on one tab so split '7501 Item attribute Value' and '7505 Item attribute Value Mapping' on to two tabs and then need a lookup between the two tabs to return the fields I needed against the Item No. (table 27).
Any better ideas would be appreciated.
Thank you
Please sign in to leave a comment.