Distribution Front End integration with Microsoft Great Plains technology notes - Alba Spectrum

If you are Nationwide distributor and you are accepting salesorders via established and legacy Sales Order Processing application, which you willneed to integrate with backoffice ERP, in our scenario with Microsoft Dynamics GP,then we would like to share our Great Plains implementation, customization,programming, report design and business processes mapping experience as well asintegrating technology options:1. Sales System. It is often the case that your sales order processing applicationsits on Linux or Unix platform and is implemented in Java/EJB, Oracle, Sybase, orPHP/MySQL/Redhat. We assume that you are comfortable in supporting this Unix box,including ongoing data fixes, business logic changes, required in MRP lifecycle2. Purchasing System. It is often integrated with your legacy Sales system,described in the first paragraph. If you are reseller or integrator, you mayutilize vendor drop ship purchase order scenarios, where vendor invoice or shipmentnotification or bill of lading trigger customer invoice issuance3. The reasons to implement Microsoft Great Plains. Typical reason is companygrowth, where you invite outside investors or grow internally when you formalizeyour management typical recommendation is to implement strong ERP application foraccounting, and financial reasons4. Integration bridge. To give you the most typical scenario GP IntegrationManager allows you to integrate text files, exported from your front end businesssystem. IM also can read ODBC data sources, for example if you are on Oracle, youcan implement ODBC call to Oracle from IM directly. Another option of integrationbridge is Web Service, which in turn deploys eConnect technology to feed and editrecords in Great Plains. An obsolete version of web integration is popular in thepast http request/response mechanism5. EDI. If you order goods from large manufacturers, you may need ElectronicDocument Interchange integration with their ordering systems. As EDI rules aretypically simple fixed length text fields in the text file, consider simple way offormatting SQL select statement output with convert and cast commands6. Sales Tax. If you sell to all 50 states, Sales Tax calculation accuracy and taxfiling should be addressed. In Great Plains it is reasonably straightforwardroutine and you may deploy Sales Tax web service from various vendors: Avalarawould be one of them7. Reporting. You should be ready to face cross-platform DB queries to addressreporting requirements. From MS SQL Server you can create Linked Servers to createdistributed queries: SQL Views and Stored Procedures. Then you deploy standardreporting tools: Crystal Reports or Microsoft SQL Server Reporting Services SRS. In the case of strictly financial reports, including consolidated financialstatements, you should consider FRx reporting. FRx is proper tool for BalanceSheet, P&L, Statement of Cash Flow, it allows you to pull GL data from GP databasesas well as combine budgets and simple balances from Excel

Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com -help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving customers USA/Canadanationwide: Illinois, California, New York, Quebec, Ontario, Colorado, Utah,Wisconsin, Florida, Texas. Local service is available in Houston & Dallas: Richmond,Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, MissionBend, Jersey Village, Fort Worth; serving GP customers in Chicago, IL: Naperville,Aurora, Joliet, Wheaton, Bolingbrook, Romeoville, Lyons, Niles, Downers Grove,Lisle, West Chicago, Barrington, Schaumburg, Elk Grove Village, Lombard, Morris,Ottawa, Marseilles, Seneca, Oswego, Plainfield, Darien, Winchester, Hinsdale.

Source: Express-Press-Release.com

Get RSS updates on latest computer technology and software related press releases   

You are welcome to include these headlines in your own pages. If you want to find out how to parse this RSS file please read our tutorial How to parse RSS feeds with PHP.