Seems like Microsoft Great Plains becomes more common and more, partly due to Microsoft muscles behind it. Now it’s qualified towards the entire range of vertical and outside market clientele.
If you should be designer who’s requested: how can we apply Great Plains integration/software along with other program or your heritage – read this and you’ll possess the indications on where you can look more.
1. Great Plains Integration Manager – that is instead end user device – it’s extremely intuitive, it validates 100% of business reason, earns/updates master documents (suppliers, records, workers, customers. etc.) earns purchases into worktables. The issue of Integration Manager – without displaying them it will use GP windows behindthescenes – so it’s fairly slow – you are able to provide 100 documents – however when you’re referring to hundreds – it’s not really a wise decision. Incidentally you are able to plan Integration Manager with VBA.
2. eConnect – it’s kind of Software Development Kit with examples in VB.Net. Clearly the development environment must be Visual Studio.Net. eConnect allows you to combine master documents – for example new clients, suppliers, workers, etc., plus you are able to provide purchases into so-called Great Plains work-tables (eConnect does not permit you to provide open or old documents – you have to post-work documents in Great Plains, the exact same issue pertains to Integration Manager above) eConnect is quite for continuous integration. It was made to Great Plains for eCommerce software integration.
Obviously you’ve options and infinite control with SQL queries. You have to understand data flow and Great Plains tables design. Launch Great Plains and visit Resources-“>>Resource Information-“>>Tables. Discover the stand within the appropriate sequence. If you should be searching for the clients – it ought to be RM00101 – client master file. If you want historic Revenue Order Processing files – they’re in SOP30200 – Sales History Header record, etc. DoN’t alter existing tables – don’t produce new areas, etc. you also have to understand that each GP desk has DEX_ROW_ID – id column. It is sometimes great idea to make use of inbound/outbound XML within the guidelines – you then can use web-service like a middle party between two methods.
You may also release this device for EDI export/transfer.
Sometimes customers would rather have easily incorporated into GP software custom displays – for guidelines options and initiating integration. Skill is a great option remember – it’s usually easier to generate new custom screen versus customizing existing one – because of the future update problems.
6. Modifier/VBA custom links about the current displays – option to Skill is you’re confident with ADO and VBA.
7. Msaccess – if you should be doing one-time transformation as well as your heritage has aged ODBC compliant system – you should use Msaccess to produce related tables there – or transfer into Msaccess.http://www.mb2-713.xyz/