Share
Report
2,395Hi all, i'm trying to make a POP smartlist with the following information:
PO Number
PO line number
Item ID
Item description
Vendor ID
Qty ordered
Qty delivered
Required date
Promised date
Released date
Vendor name
Buyer ID
Actual cost
UofM
Invoiced qty (if any)
Comment ID
What I have so far is:
SELECT TOP (100) PERCENT POP.PONUMBER, POP.ORD, POP.ITEMNMBR, QTYRCP.POPRCTNM, QTYRCP.QTYSHPPD, POP.ITEMDESC, POP.VENDORID, POP.LineNumber, POP.REQDATE,
POP.PRMSHPDTE, POP.PRMDATE, POP.QTYORDER, dbo.IV00101.CURRCOST, POP.UOFM, QTYRCP.QTYINVCD, dbo.POP10100.USER2ENT, dbo.PM00200.VENDNAME, POP.POLNESTA AS estado,
POP.Released_Date, dbo.POP10100.DOCDATE
FROM dbo.POP10500 AS QTYRCP INNER JOIN
dbo.POP10100 ON QTYRCP.PONUMBER = dbo.POP10100.PONUMBER INNER JOIN
dbo.POP10110 AS POP INNER JOIN
dbo.PM00200 ON POP.VENDORID = dbo.PM00200.VENDORID LEFT OUTER JOIN
dbo.IV00101 ON POP.ITEMNMBR = dbo.IV00101.ITEMNMBR ON QTYRCP.POLNENUM = POP.ORD AND QTYRCP.ITEMNMBR = POP.ITEMNMBR AND ISNULL(QTYRCP.QTYSHPPD, 0)
< POP.QTYORDER
WHERE (POP.POLNESTA IN (1, 2, 3, 4))
ORDER BY POP.PONUMBER, POP.ITEMNMBR
But I keep getting duplicated records, hope someone can help me with this.
*This post is locked for comments
All responses (
Answers (
