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 !!

Comments

Popular posts from this blog

[Solved] : Error: String or binary data would be truncated. Cannot execute a data definition language command on Vendor (VendLedgerReconciliationTmp)

AX 2012 - Command prompt compilation / AxBuild.exe for Parallel Compile on AOS of X++ to P-code / Parallel Compilation

AX 2012 - How to send SSRS report in email as an attachment using X++

AX 2012 - How to stop AOS when services got stuck at stopping status

AX 2012 - How to make a form field mandatory

Error: There was no endpoint listening at net.tcp://your_server_name:8201/Dynamics AX/Services…

Fetch vendor address using X++ in AX 2012

AX 2012 - How to print current date and time on SSRS Report

[Solved] : AX 2012 - No connection could be made because the target machine actively refused it 192.168.10.249:8201

[Error] - Error in unit of amount in currency KES. Must be rounded to 0.01 | The unit of 37.563.5343100000000000 KES being posted to account 32710001-- is outside the current penny rounding threshold | Posting has been canceled