You’re offline. This is a read only version of the page.
Announcements
289
So I have had a production integration for many years now. Using eConnect to port Excel sheets over into GP for new Purchase Order documents. Using a C# project. Now there is a new requirement, in terms of what fields to port over into the new GP POP document.
The endusers want to populate the Contract Number and Confirm With fields that appear in the Purchasing Vendor Detail Entry form. Which can be accessed in the client UI when the enduser clicks on the right arrow next to the Vendor ID in the POP header.
Wondering how to accomplish this using eConnect in my C# project. Currently I have defined the taPoLine_ItemsTaPoLine[] eConnect class member for the POP lines and the taPoHdr eConnect class member for the POP header. But I don't see where the Purchasing Vendor Detail Entry form comes into play in relation to the PO Header in eConnect.
Any suggestions?
Perfect! Added that custom script to the taPoHdrPost stored proc and it works flawlessly. Thanks so much!
Hi Greg,
Just alter taPoHdrPost with update script
update POP10100 set POPCONTNUM='12345' where PONUMBER= @I_vPONUMBER
and in taPoHdr there is node for confirm 1 field with name @I_vCONFIRM1
Here is a reference document I was referring to --> dyndeveloper.com/eConnectField.aspx. I was able to connect the CONFIRM1 field, so that now is populated. It's just the POPCONTNUM field that seems to be missing as far as I can tell.
These particular fields are associated with the POP header, not the POP lines. And these header values are what appear on the PO hardcopy that's printed.
Can you build your code for these fields and add this code to the taPoLine_ItemsTaPoLine post script?
Looking at the fields in the POP10100 SQL table I see the POPCONTNUM represents the Contract Number field. And CONFIRM1 represents the Confirm With field. But I don't see the POPCONTNUM field exposed in eConnect as a class member.
#1
André Arnaud de Cal...
293,302
Super User 2025 Season 1
#2
Martin Dráb
232,108
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
