Share
ReportI have a Dynamics AX 2012 database only and I am looking in a way to make query to get ( sales order number from serial number)
witch tables should I search in ?
You’re offline. This is a read only version of the page.
50
I have a Dynamics AX 2012 database only and I am looking in a way to make query to get ( sales order number from serial number)
witch tables should I search in ?
The fact that all tables contain info doesn't mean that there exists a sales order for that Serial id.
I assume you can figure out what's the problem by looking at the data of the tables.
Start by one Serial Id, find the corresponding in InventDim, and then see if there's a SalesLine with that InventDimId.
Thanks for your reply,
I have tried that using the following query :
SELECT *
FROM [dbo].[INVENTSERIAL]
INNER JOIN [dbo].[InventDim] ON ([dbo].[INVENTSERIAL].[INVENTSERIALID] = [dbo].[InventDim].[INVENTSERIALID])
INNER JOIN [dbo].[SalesLine] ON ([dbo].[InventDim].[InventDimId] = [dbo].[SalesLine].[InventDimId])
where [INVENTSERIAL].[INVENTSERIALID]='XXX';
But I got empty record in return ( despite that all three tables contains info )
#1
André Arnaud de Cal...
292,923
Super User 2025 Season 1
#2
Martin Dráb
231,788
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
All responses (
Answers (
