Hi
For a customer I need to convert a old AX4 view into D365FO
This is the SQL to create the view
SELECT DISTINCT TOP (100) PERCENT dbo.SALESLINE.SALESID AS SalesOrderNum,
dbo.SALESLINE.LINENUM AS POLineNum,
dbo.SALESLINE.ITEMID AS ItemNum,
dbo.SALESLINE.NAME AS ItemDesc,
dbo.SALESLINE.SALESUNIT AS UOM,
dbo.SALESLINE.PURCHORDERFORMNUM AS PONum,
dbo.SALESLINE.EXTERNALITEMID AS ACCPartNum,
CONVERT(INT, dbo.INVENTITEMINVENTSETUP.MULTIPLEQTY) AS QTY,
dbo.SALESTABLE.SALESSTATUS AS [SO Status],
dbo.SALESLINE.SALESSTATUS AS [Line Status]
FROM
dbo.SALESLINE WITH (NOLOCK) LEFT OUTER JOIN
dbo.INVENTITEMINVENTSETUP WITH (NOLOCK) ON dbo.SALESLINE.ITEMID = dbo.INVENTITEMINVENTSETUP.ITEMID LEFT OUTER JOIN
dbo.SALESTABLE WITH (nolock) ON dbo.SALESLINE.SALESID = dbo.SALESTABLE.SALESID
WHERE
(dbo.SALESLINE.SALESSTATUS = 3) AND (dbo.SALESTABLE.SALESSTATUS = 3)
ORDER BY POLineNum
My problem is that I need to create this as view and then convert the view to a Data entity to be used by an external app
the big 'problem' is this part: SELECT DISTINCT TOP (100) PERCENT
