Share
ReportHas anyone created a smartlist that will show shipment receipts and the invoices tied to them?
*This post is locked for comments
You’re offline. This is a read only version of the page.
Announcements
Has anyone created a smartlist that will show shipment receipts and the invoices tied to them?
*This post is locked for comments
Did you ever get something working on this issue. We are just now trying to develop something as well and don't want to reinvent. Read response on SQL view, great attack on problem but it does not seem to be the turn key solution since is does not isolate a one for one relationship. Would appreciate any suggestions you might have found to resolve.
Check this out in your test environment against you test company db.
declare @ponumber as varchar(21) = 'Enter po number here'
--Receipts with vendor doc number
--Purchasing Receipt History
select * from POP30300 where POPRCTNM in (select POPRCTNM from POP30310 where PONUMBER = @ponumber )
--Purchasing Receipt Line
select * from POP30310 where PONUMBER = @ponumber
--Purchasing Receipt Line Quantities
select * from POP10500 where PONUMBER = @ponumber
-- Invoices...
select * from Pm20000 where
docnumbr IN (select vnddocnm from POP30300 where POPRCTNM in (select POPRCTNM from POP30310 where PONUMBER = @ponumber )) and
vendorid IN (select vendorid from POP30300 where POPRCTNM in (select POPRCTNM from POP30310 where PONUMBER = @ponumber ))
select * from PM30200 where
docnumbr IN (select vnddocnm from POP30300 where POPRCTNM in (select POPRCTNM from POP30310 where PONUMBER = @ponumber )) and
vendorid IN (select vendorid from POP30300 where POPRCTNM in (select POPRCTNM from POP30310 where PONUMBER = @ponumber ))
Once your query is settled down, getting a smart list designed would be easier....
#1
Almas Mahfooz
3
User Group Leader
All responses (
Answers (
