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

Case Studies

Retail

Alba Spectrum Technologies

Club with Retail Stores

Situation

Big company had the club, where its employees were honored for sponsored services and purchases. This club needed its Retail Management System integration with Great Plains Accounts Receivable module

Our role

We helped customer’s Great Plains var with the integration

- Transferring all the sales from RMS to Great Plains

- Uploading Employee bonuses as credits into RMS

Results

- Seamless RMS and Great Plains integration

Industry: Retail

Applications: Great Plains, RMS

Technologies: .SQL Stored Procs, Dexterity

This integration is available through Focal Solutions: www.focalsolutions.com

Retail Outlet

Situation

Outlet had a need for customizable Retail Application with multiple receipt forms (like gift receipts without price), gift cards/vouchers, sophisticated merchandize return/exchange policies, etc.

Our role

We helped in

- POS Hardware Installation and setup, connection to Citibank credit card processing

- Microsoft RMS Setup/inventory conversion

- Receipts customization

- Gift Cards/Vouchers setup

- Cashiers/Store Manager training

Results

- POS implementation

Industry: Retail

Applications: RMS

Technologies: RMS XML Templates Programming

Furniture Retailer

Situation

Company had multiple stores in several regions. Currently it was mailing salary/commission payroll checks to all its employees and salespeople. There was a possibility to replace current check mailing to its employees by enabling them over the internet via web report from Great Plains payroll module.

Our approach

We suggested secured login and Crystal Report web publishing for employees in the following form:

- .Net aspx pages

- Crystal Report engine

Results

- Elimination of extra paper work

- Meeting government requirements

Industry: Retail

Applications: Great Plains

Technologies: .Net, C#, Web Publishing, Crystal Reports

Small Merchant

Situation

Client needed self-hosting of its Web Server due to the specific of its products and the need to provide online-store from its SQL database via direct web publishing. This was not possible in case of hosting through the third party web hosting providers. On the other hand – the way of purchasing T1 or DSL line with static IP address wasn’t financially and technically possible.

Our approach

We suggested

- Using current cable internet with dynamics IP address assignment

- Web service client call from actual web server, with dynamics IP address to web service on the so-called skeleton web site, hosted through web hosting company and doing dynamic IP address regular update

Results

- Client was enable to have its full-featured web server exposed to its customers via inexpensive cable internet dynamics IP address

Industry: Retail

Applications: Other

Technologies: .Net, C#, Web Services

Jewelry Stores

Situation

Client needed to switch from its legacy Fixed Assets management system to Great Plains fixed assets module. Prior to go live – they needed to try several depreciation scenarios to correct their legacy depreciation modules

Our approach

We suggested

- Import assets and assets-books records into GP Fixed Assets module

- Create SQL scripts and Great Plains macro to change depreciation methods and averaging/switchover conventions

Results

- Client found the best depreciation scenario for multiple depreciation books

- Fixed Assets Integration into Great Plains system

Industry: Retail

Applications: Great Plains

Technologies: SQL Queries