Item List

(0) Share

Report

Posted on by Community Member

I am trying to generate a list for ALL item, with the default financial dimensions that are visible when in the EDIT item (full screen view of all the section groups that are in AX. I need to verify that all items that are setup have the correctly. What tables contain this info (using SQL Server Studio)

Thank you.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Mea_ 60,284 on at

Like (0)

Report

Hi CharlieTinlin,

Released products could be found in inventTable table, there is a field DefaultDimension you can use to join with DefaultDimensionView to get financial dimensions.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

so, if I am not using METHODS to get to it through the Add-in, and need to find the table that has the actual data stored in it, what table would have this information? I am new to this, and trying to understand where everything is stored and linked. Thank you.

Was this reply helpful? Yes No
Richard Wehmeyer 1,004 on at

Like (0)

Report

Items: INVENTTABLE

dimensions: DEFAULTDIMENSIONVIEW

in SQL:

SELECT        dbo.INVENTTABLE.ITEMID, dbo.DEFAULTDIMENSIONVIEW.DISPLAYVALUE
FROM            dbo.INVENTTABLE INNER JOIN
                         dbo.DEFAULTDIMENSIONVIEW ON dbo.INVENTTABLE.DEFAULTDIMENSION = dbo.DEFAULTDIMENSIONVIEW.RECID AND dbo.INVENTTABLE.PARTITION = dbo.DEFAULTDIMENSIONVIEW.PARTITION

Was this reply helpful? Yes No