Hi,
Is there a way to know if a PO is attached to a SO in the SO table?
Ex: I have a SO ABC and I want to know if there's a PO attached to it.
Is there a flag in the SOP table?
*This post is locked for comments
There is only one table for SOP/POP Link
Display Name : SOP_POPLink
Physical Name : SOP60100
SELECT PONUMBER FROM SOP60100 WHERE SOPNUMBE = @SOPNUMBER
Using the below query you can find whether the PO has been created from SO or not.
SELECT QTYONPO,PURCHSTAT,* FROM SOP10200 WHERE SOPNUMBE = @SOPNUMBER
SOP60100 will tell you exactly what sales orders are linked to what purchase orders.
There's the PURCHSTAT field in the SOP10200 table:
I copied the below from Victoria Yudin's site.
PURCHSTAT (Purchasing Status):
1 – None (will always be this for Quote, Return and Invoice)
2 – Needs Purchase
3 – Purchased
4 – Partially Received
5 – Fully Received
There's also the SOP60100 table that is specifically for the POP/SOP Link table
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,436
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
