Notifications
Announcements
No record found.
How do you use the taSopToPopLink to create a SOP to POP link given that there is no way to specify the PO number?
*This post is locked for comments
Actually, this node creates the actual purchase order, so there's no need to specify the PO Number. In other words, the PO number field is populated in the SOP60100 after the fact.
And that is why I cannot use it. I already have the sales and purchase orders coming from another system. I just need to get this information into GP. I will leave my code the way it is then. I was hoping to fill in this last missing piece with eConnect. Both systems have to be an exact match with all the commitments. Thanks.
You can always extend the taSopHdrIvcInsert_POST stored procedure to insert the couple pieces of data you need into the SOP60100 table. I've done this numerous times and it works just fine. Remember, you can pass in user-defined fields to these procedures. One of them could very well be the purchase order number to allow you to link the two docs.
Interesting idea Mariano. I believe I have a user-defined field that I am not using to pass down the PO number. In my case I have imported a series of sales orders and then a series of purchases orders that have aggregated quantities from those sales orders. The final step would be to create the corresponding records in the SOP60100 table. Since the POs are imported last I would most likely use the taPoHdrPost stored procedure to complete the import.
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.
Community Member 2
mtabor 1
Victoria Yudin 1
