Microsoft Great Plains is main accounting / ERP application from Microsoft Business Solutions, targeted to the U.S. market. It serves the whole of the vertical and horizontal market: most industries and company sizes. Crystal Reports on the other side is the industry leader in reporting software and Microsoft is willing used as the reporting tool Crystal principal of the Great Plains, Solomon, Microsoft CRM,. NET, etc.

If you are developer who is question: how to extend Great Plains ReportWriter with a little more sophisticated read this and will have the clues on where to look further.

1. Great Plains tables structure-first, you need to know the link tables. Launch Great Plains and go to Tools-> Resource Description-> Tables. Find the table in the correct series. If you are looking for customers for the A – a master file should be RM00101 customers. If you need historical Sales Order Processing Documents are in Â-Â-SOP30200 Sales History Header file, etc.
2. Create ODBC connection to GP database of the company. Use the same technique as when you create standard ODBC connection for GP workstation – the default database, but the change database of the target company.
3. Account the views of SQL A-If you want Dona't complex links in Crystal Report itself or if you need unionization from a number of companies SQL view is the answer.
4. Consider SQL Stored Procedures. Sometimes you can not extract the data in one order-needed temporary tables that are created and the final question must be based on these temporary tables Â-this is when you need stored procedure.
5. Call Crystal Report from GP screens through VBA / Modifier A-If the user wants to call Crystal report for example – printing Invoices in GP and do it from SOP Entry window, you can use switches and VBA to call Crystal Reports engine.
6. Create SQL queries to investigate data Â-always recommend tuning your query and see that you are getting adequate results in any case Â-Crystal Report is a good tool to show the results of the consultation.

Customizing Happy, consultation and design! If you want us to do the job – give us a call 1-866-528-0577! Help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies – USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, Los Angeles, San Francisco, San Diego, Boston, New York, Houston, Dallas, Miami, Atlanta, Minneapolis, Seattle and having locations in multiple states and internationally (http://www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

Tool Live 10-21-96 Pushit @ San Francisco CA

The Cafes of San Francisco: $10.84 The Cafes of San Francisco

San Francisco Chronicle Cookbook $15.16 San Francisco Chronicle Cookbook

Fodor’s San Francisco 2006 $11.86 Fodor’s San Francisco 2006

Walking San Francisco: $12.88 Walking San Francisco

San Francisco Bay Area $9.06 San Francisco Bay Area

Savoring San Francisco $15.16 Savoring San Francisco

A San Francisco Christmas / San Francisco Girls Chorus $30.99 San Francisco Girls Chorus:185535

The Cafes of San Francisco (Fourth Edition): $10.84 The Cafes of San Francisco (Fourth Edition)

San Francisco Symphony At 100 – Itzhak Perlman (Violin), San Francisco Symphony, Michael Tilson Thom $35.49 San Francisco Symphony:0052

---