Share
Reportteam, anyone ever populated GP pop10390 table? how are all values calculated. seq#,actindex,amts, disttype. thanks
*This post is locked for comments
You’re offline. This is a read only version of the page.
270
team, anyone ever populated GP pop10390 table? how are all values calculated. seq#,actindex,amts, disttype. thanks
*This post is locked for comments
Hi Gurpreet,
I like Warren's answer. You can accomplish this using only integration manager, but it is a lot of work. Nolan's solution is so much better than writing (and maintaining) custom integrations.
IM is an incredible tool made even more incredible by their support personnel. I am not much of an XML programmer, but you can do some really neat stuff with the more conventional data sources.
Thet have some great pictures
Hi Gurpreet - not really. Apart from the fact that it would be proprietary information, and the fact that your setup / requirements etc. would be different, it would be impossible to post here. There is a lot of code etc. Your best bet is to study eConnect help files.
Best regards,
Ian.
Hi Ian, can you post what you have done in past using eConnect?
thanks
Hi Gurpreet,
What you want so would be fairly straightforward to achieve with eConnect. We've done it a good few times and there are no 'Gotchas'... Doing it yourself would mean that you have control for future upgrades, and can build in any logic specific to you company that you need.
Will ther be a multicurrency translation issue? ie US$ to CAN$?
Best regards,
Ian.
Hi Leslie, yes that is it. Thanks
Gurpreet,
The recommendations to use eConnect are definitely well placed. If you are planning on doing much GP integration it is well worth taking the time to learn.
However, you might want to consider ISV solutions. Nolan Business Solutions has a utility called IC POP to SOP which does pretty much what you are looking to do. It eliminates the double entry and handles things like currency and unit of measure translations. There may be others that handle this as well but this is one that I am familiar with and it seems to work well.
www.nolanbusinesssolutions.com/.../ic-pop-to-sop
Warren Tenney
Hi Gurpreet,
I think I get it. Canada issues a PO to US. US creates a SOP document to fulfill the PO. When US posts the SOP Invoice, that tells you the stuff has been shipped to Canada. Instead of having Canada receive the PO manually, you would like to 'automate' the receiving from the posting of the SOP document by US.
Is this it?
Leslie
Hi Leslie, we have two separate database's for gp. Comp 1 is in US and comp 2 is in Canada. When Canada orders from comp1 we have product here in US warehouse and we ship that product to Canada. We can see from SOP30200/SOP30300 what was shipped and want to receive that in popXXXXX tables in Canada gp database so our Canadan warehouse users don’t have to manually enter this data. Thanks
Gurpreet,
I don't think I am fully understanding what you need to do. Does Company 1 create the PO and place the order with the vendor and receive the goods. Then after the goods are received by Company 1 they are sent to Company 2?
Does company 2 have a PO back to Company 1 so that Company 2 also 'receives' the goods?
So essentially, is Company 2 telling Company 1 it needs something and then Company 1 buys the something and sends it to Company 2?
Leslie
Hi Ian, I am very new at this and have not used econnect before. Is there API I can call to do this work? I just found out that our econnect is on a differenct server. Please advise.
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (