745
Hi,
We have a request from customer service department to upload sales transactions into SOP module from Excel using integration manager.
What does it take to acheive this task?
Is there any other better solution.?
Regards
Vincent
*This post is locked for comments
Vincent,
Below post may help you to understand type of integrations available in Dynamics GP.
http://sandipdjadhav.blogspot.com/2010/04/types-of-integration-method-with.html
Thanks
Sandip
Hi Kevin,
To achieve this, in short, you will need to set up an Integration in Integration Manager. Assuming you own the module and you have it installed. There are a number of sample integations included that will give you an idea of where to start. If you have people in house who are experienced in setting up Integrations, they should be able to make a good attempt at it.
Realistically, the only other option for SOP is eConnect. Econnect takes data from an external system and integrates it into GP - obeys all of the business logic etc. The error reporting is very good, and the management time required can be zero or at least very limited. There are a few things to watch out for, so really, an experienced eConnect person would be required. Lok for someone who has done a few in the recent past and ask for references...and talk to the references. Of course, if you have a GP Partner helping you, you should talk to them.
Where is the data coming from before it ends up in XL? If it is coming from another system, then eConnect should be able to take the data straight, no need to spend time exporting to XL, formatting it for Integration Manager, then running the integrations etc. It might be economically viable, so would be worth looking at.
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (