Posts

Showing posts with the label SQL Query

Fetch product number and storage dimension group in AX 2012 using SQL Query

Image
Hi Readers, Today, in this post we will share a SQL Query to fetch product number and storage dimension group in AX 2012. Requirement : We need to fetch product number and storage dimension group in AX 2012. Solution : Open SQL Server Management Studio (SSMS) and create a new query. Copy, paste the below query and execute it. -- SQL Query written by Chirag Gupta select EcoResProduct.DISPLAYPRODUCTNUMBER as 'Product Number',  EcoResStorageDimensionGroup.NAME as 'Storage Dimension Group'  from EcoResStorageDimensionGroup join EcoResStorageDimensionGroupProduct on EcoResStorageDimensionGroupProduct.STORAGEDIMENSIONGROUP = EcoResStorageDimensionGroup.RECID join EcoResProduct on EcoResStorageDimensionGroupProduct.PRODUCT = EcoResProduct.RECID where EcoResStorageDimensionGroup.NAME = 'SWL' We hope this solution helped you to fetch product number and storage dimension group in AX 2012 using SQL Query. Please comment yo...

Illegal data conversion from original field ProdParameters.PKA_BOMQtyEdit to ProdParameters.PKA_DisableNewDeletePickingList: unable to convert data types to anything but character field type (14 to 49)

Image
Hi Technical, Today, in this post we will talk about a very interesting topic about illegal data conversion from original field to newly created field. Here, we need to understand this error occur while DB synchronization. Error : Illegal data conversion from original field ProdParameters.PKA_BOMQtyEdit to ProdParameters.PKA_DisableNewDeletePickingList: unable to convert data types to anything but character field type (14 to 49) Note : PKA_BOMQtyEdit  and PKA_DisableNewDeletePickingList are ProdParameters table fields. Solution : Note : Please perform below action if you are DBA or having knowledge on SQL Queries in AX. Check the fields id in AOT and compare it with SQLDictionary table in SQL with the following query: --To Check: select * from SQLDICTIONARY where TABLEID in (select TABLEID from SQLDICTIONARY where name = 'ProdParameters') and NAME = 'PKA_BOMQtyEdit' select * from SQLDICTIONARY where TABLEID in (select TABLEID from SQLDICTION...

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