Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Using eConnect to crea...
Microsoft Dynamics GP (Archived)

Using eConnect to create purchase orders with a SOP to POP link

(1) ShareShare
ReportReport
Posted on by Richard Wheeler 75,730

I have successfully created a procedure using eConnect to import sales orders with sales tax. Now the time has come to create the corresponding purchase orders committed to each sales order. Looking at taSopToPopLink it only contains fields for the sales orders. There is nothing for the purchase orders. How do you use eConnect to link SOPs to POPs? Do you import all the SOPs and then import all the POPs and then run some eConnect procedure to commit the two or do you somehow do the commitment while the SOPs and/or POPs are being imported?

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Using eConnect to create purchase orders with a SOP to POP link

    Sandip, I will need to look into this as I did this several years ago. I know I was calling the eConnect nodes directly via stored procedures. I believe the SOP to POP link was done via a stored procedure.

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    RE: Using eConnect to create purchase orders with a SOP to POP link

    Hello Richard,

    May I know is it possible to share the code? I am looking for solution to link multiple SOPs to one PO 

    Thanks much
    Sandip Jadhav

  • UriZ Profile Picture
    UriZ 55 on at
    RE: Using eConnect to create purchase orders with a SOP to POP link

    Thank you!

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Using eConnect to create purchase orders with a SOP to POP link

    The SOP60100 table is the SOP to POP table.

  • UriZ Profile Picture
    UriZ 55 on at
    RE: Using eConnect to create purchase orders with a SOP to POP link

    Thanks Richard, I would just want to know which tables needed to be populated to make the link. I have the dropship PO and the SOP Invoice (we are not populating SalesOrders), I just need to make the link. Thanks.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Using eConnect to create purchase orders with a SOP to POP link

    Thank you Richard.

    I'll shoot you a PM with my contact infos. I'd interested to look at the code...

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Using eConnect to create purchase orders with a SOP to POP link

    Beat, this was code I actually wrote 20 years ago under Btrieve. I simply upgraded it to SQL about 10 years ago and then when I converted to using eConnected everything worked except for the POP to SOP link so I simply continued using this part of the code as a bridge. If you need more details just let me know.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Using eConnect to create purchase orders with a SOP to POP link

    Richard,

    Would this be pretty much the same logic for DropShip orders where you need to create the PO based on the SOP data ? I have a client that was looking into a way to automate the process for SOP's that were integrated from an external system, but would be flagged as DropShip items in GP..

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Using eConnect to create purchase orders with a SOP to POP link

    This was a very involved process. We already had code that was accumulating the sales order quantities. We also had code that generated PO's off the aggregate quantities per item per vendor. The tricky part was the code that then went line per line on the sales orders and then found a matching line on a PO. This code is what created the record(s) in SOP6010. It has been a while since I developed this but I could dig into it to provide a more detailed explanation if you need it.

  • UriZ Profile Picture
    UriZ 55 on at
    RE: Using eConnect to create purchase orders with a SOP to POP link

    We are looking to do the same. How did things end up? Any advice or direction? Thanks!

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans