AX 2012 - SQL script to fetch Color, Size, Site and Location based on item id
Hi AX Technical, In this post, we will use SQL script/query to fetch Color, Size, Site and Location based on item id. --// How to fetch Color, Size, Site and Location based on item id --// SQL script written by Chirag Gupta select ITEMID, INVENTCOLORID, INVENTSIZEID, INVENTSITEID, INVENTLOCATIONID from INVENTDIMCOMBINATION join INVENTDIM on INVENTDIM.INVENTDIMID = INVENTDIMCOMBINATION.INVENTDIMID where INVENTDIM.DATAAREAID = 'MGP' --// Change DataAreaId according to your need order by ITEMID; Author: Chirag Gupta Microsoft Dynamics 365 AX Technical Consultant at IBM Bangalore Date: 3-Sep-2019 Happy Learning !!