Notifications
Announcements
No record found.
Has anyone created a smartlist that will show shipment receipts and the invoices tied to them?
*This post is locked for comments
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
Once your query is settled down, getting a smart list designed would be easier....
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
