Great Plains Dexterity Dynamics eEnterprise Microsoft CRM Microsoft RMS Crystal Reports SQL .Net C# International Integration Manager Case Studies

Case Studies

Integration Manager

Alba Spectrum Technologies

Collection Agency

Situation

Company had UNIX based collection system. However feeding data into accounting package with billing and payment functionalities was a need. The old accounting system was too small to serve growing business volume. The uniqueness of the business processes required automatic switch from the original creditor to the bank, who bought the AR from this creditor

Our approach

We suggested deployment of Great Plains Integration Manager to feed data from UNIX based collection system into Great Plains

- VBA vendor translation in Integration Manager

- VBA for payment check date and additional fields modification formula programming

Results

- Integration of Collection System with Great Plains

Industry: Services

Applications: Great Plains

Technologies: VBA, Integration Manager

Soft Drinks Maker/Wholesaler

Situation

Business System had multiple loosely integrated subsystems, some of them had obsolete technology, discontinued by manufacturers and with no longer support available. Meanwhile company needed daily international sales reporting by multiple criteria. The choice should be made between expensive OLAP/Datawarehousing solutions, integrated with new Mid-Market accounting package and less expensive solution, deploying set of relatively flexible Crystal Reports, pulling information from Mid-Market accounting. Also the complexity of the transition year was the necessity to address existing legacy system data in reporting system

Our approach

In order to save money we suggested less expensive and easy to maintain Great Plains and Crystal Reporting solution, based on the distributed queries from legacy database with following year end switch to Great Plains

- Data conversion with Integration Manager and SQL custom queries from legacy accounting to Great Plains on Microsoft Windows 2000 server

- Light Manufacturing automation via Bill of Materials

- Crystal Reports for providing daily sales reporting needs

- Integration Manager for GL and Purchasing data import

Technology:

- SQL Distributed views and stored procs

- Crystal Report, based on distributed queries

- Light Dexterity triggers for Bill of assemblies

- Integration Manager, Frx

Results

- All company operation are now based on one system: Great Plains

- Sales reports do not require additional maintenance, maybe called by request and pull the information from standard Great Plains databases

- Customer requests are processed in real time through Great Plains inquiry screens

Industry: Distribution, Manufacturing

Applications: Great Plains

Technologies: SQL Server: Stored Procs, Views, Dexterity, Integration Manager, FRx

Machinery Manufacturer

Situation

Due to some downsizing and major manufacturing procedures outsourcing management approached us for suggestions to simplify company full-featured manufacturing system. Current system required more people to enter manufacturing information, than the number of assembly workers. Company had Great Plains accounting and third party manufacturing.

Our approach

We suggested deployment of Great Plains Bill of Materials module as an alternative to current manufacturing system

- Data conversion from legacy manufacturing to GP Inventory via Integration Manager

- Manufacturing Bill of Materials conversion via SQL queries

Results

- 70% reduction of expenses for data entry

- Legacy manufacturing annual support fee elimination

- All the operation are now in one Great Plains system

Industry: Manufacturing

Applications: Great Plains

Technologies: Integration manager, SQL queries