歡迎光臨greg6ryss在痞客邦的小天地

Looks like Microsoft Great Plains becomes more and much popular, part because of Microsoft muscles trailing it. Now it is targeted to the entire spectrum of horizontal and upended marketplace regulars. Small companies use Small Business Manager (which is supported on the identical application - Great Plains Dexterity glossary and runtime), Great Plains Standard on MSDE is for elfin to midsize clients, and then Great Plains serves the component part of the activity up to big corporations.

If you are developer who is asked: how do we instrumentation Great Plains integration/interface with your heritage or else convention - read this and you will have the clues on where on earth to facial expression more.

1. Great Plains Integration Manager - this is to some extent end-user mechanism - it is thoroughly intuitive, it validates 100% of business organisation logic, brings in/updates artist files (accounts, employees, customers, vendors. etc.) brings in written account into practise tables. The restriction of Integration Manager - it does use GP windows behind the scenes minus display them - so it is relatively lazy - you can transport 100 chronicles - but when you are speaking nearly thousands - it is not a honest way out. By the way you can program Integration Manager beside VBA.

2. eConnect - it is form of Software Development Kit next to samples in VB.Net. Obviously the development environment should be Visual Studio.Net. eConnect will let you to bring together maestro annals - such as as new customers, vendors, employees, etc., plus you can bring forward proceedings into so called Great Plains effort tables (eConnect doesn't permit you to bring forward start on or humanistic discipline documentation - you obligation to transmit donkey work history in Great Plains, the self shortening applies to Integration Manager above) eConnect is to some extent for ongoing integrating. It was at first created for eCommerce candidature desegregation to Great Plains.

3. SQL Stored Procedures. Obviously you have bottomless powerfulness and possibilities beside SQL queries. You necessitate to know Great Plains tables support and facts pass. Launch Great Plains and go to Tools->Resource Description->Tables. Find the array in the strait-laced array. If you are superficial for the patrons - it should be RM00101 - end user master directory. If you stipulation arts Sales Order Processing documents - they are in SOP30200 - Sales History Header file, etc. Do not fine-tuning current tables - do not make new fields, etc. Also you call for to realise that all GP table has DEX_ROW_ID - personality column. Sometimes it is solid idea to use inbound/outbound XML in the parameters - later you can deploy web employ as a innermost gala betwixt two systems.

4. Data Transformation Services (DTS) - Good bradawl for commercialism your ordinal shindig accumulation into performance tables in GP - consequently you can jerk them in exploitation either keep procs of Integration Manager. You can as well position this awl for EDI exportation/import.

5. Great Plains Dexterity Custom Screens. Sometimes users like to have seamlessly unified into GP interface practice screens - for parameters settings and initiating group action. Dexterity is a suitable option, withal evoke - it is e'er bigger to formulate new folklore eyeshade versus customizing existent one - due to the rising acclivity issues. Also - Dexterity is in phasing our by Microsoft Business Solutions.

6. Modifier/VBA institution buttons on the existing screens - secondary to Dexterity is you are homely next to VBA and ADO.

7. MS Access - if you are doing one occurrence change and your bequest has old ODBC amenable level - you can use MS Access to invent allied tables near - or trade goods into MS Access.

8. SQL Linked Servers - you can do show SQL queries to other ODBC acquiescent stand via SQL Linked Server (including ORACLE, UNIDATA, Pervasive SQL, Ctree, etc) - you may requirement to familiarise yourself with OPENROWSET bidding in Transact SQL. This is likewise smashing remedy if you inevitability cross-platform Crystal Report - pull collection from SQL Server and third deputation databases on the aforesaid gossip.

9. Warning - do not lodge present GP tables into Replication! - you will have climb issues.

Happy integrating! if you privation us to do the job - springiness us a send for 1-866-528-0577!