Notifications
Announcements
No record found.
Has anyone found a way to create a report showing outstanding sales orders and the vendor purchase orders to which they are lined? Is there a data base that holds this information?
*This post is locked for comments
Not a database but a table within the Database. And the link is in an SOP Table SOP60100. If you have ReportBuilder you could build a report to see which SOP Sales Oders have PO's. It is called the SOP_POPLink (SOP60100)
Thanks for your help, Susan. It is my perception that SOP60100 contains historical data. I am looking for this link between Open documents. Am I incorrect in this observation? My goal is to create a Crystal Report that lists all Open Customer Orders and the Vendor Purchase Orders attached so that I can follow up on the progress of the order. Let me know what you think.
Thanks in advance.
The SOP60100 table contains all commitments between any sales orders and the corresponding purchase orders. The open and historical links will be in this table.
Please have a look on the below link from "MVP Victoria Yudin" website and create a SQL view for "SOP and POP links" in your company database then use it from the Crystal report.
victoriayudin.com/.../sql-view-to-show-items-with-sop-pop-link
Hope this helps!!!
Thanks, Richard! I will give it a try. I appreciate you taking the time to help solve this question.
Thanks, Somakarpagamorthy K! I will definitely give this a try. You are very kind!
Enjoy the dayQ
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
