Software informational articles

Gem gossip for microsoft great plains - software


Microsoft Big business Solutions - Great Plains is calculated to meet and broaden the needs of small and mid-size organizations for its big business success. Its all-inclusive accounting and commerce management applications also give businesses with capabilities to adapt a range of modules of the Great Plains software to fit to their definite needs. Since of these potentials, Great Plains has been under attack to the whole spectrum of both horizontal and vertical clientele.

A come to of industry-specific applications integrate well with Great Plains. This allows for more flexibility and incomparable approach to in a row that aids in decision-making and chemical analysis of performance.

Crystal Information is a report-writing software that can integrate itself to Great Plains' database. It goes away from the bang conception deal with of Great Plains' own Article Writer. As a developer, Gem Gossip will help your client admission decision-driving in rank to aid in administration their businesses more effectively. So, how do we use Rock Gossip to continue Great Plains Article Writer?

Great Plains Table Structure

When a affair creature is processed, the in sequence is in black and white onto the Great Plains list tables. This can be found by launching Great Plains, then: Tools > Source Class > Tables. Find the fitting Table:

RM00101 - Buyer Master File

SOP30200 - Sales Annals Heading File

Create ODBC Connection

Open Folder Connectivity (ODBC) is an integration tool to attach a client concentration to an ODBC-compliant database. It allows exchanging in rank among databases and by far integrates with a wide range of award systems. Great Plains uses the ODBC drivers installed by Microsoft SQL Server.

To construct an ODBC link to a Great Plains business database, one conventional way is with the use of the Data Cause dialog box. It prompts you to fix to the correct data source. Desire the band folder that you are targeting that contains the data considered necessary for your Gemstone Hearsay arrive generation.

SQL Views

Microsoft SQL Ma?tre d' has a virtual table that you can contact to decrease the complication of looking at links in Gemstone Intelligence itself. By referencing the view name in a Transact-SQL statement, a user can admittance this virtual table and retrieve the data for hope assortment to be practical into Rock Reports.

SQL Stored Procedures

There are instances in which you will not be able to pull all your looked-for data into one view. In this situation, you would need an SQL stored-procedure - distinct as a group of Transact-SQL statements compiled into a distinct execution plan. With the help of a stored procedure, you do not need to admittance character tables to use in Gemstone Reports.

Calling Gemstone Information via VBA/Modifier

It is likely to call the Gemstone Hearsay engine from one Great Plains claim to do a administer with the use of Modifier and VBA. For example, you want to print a Rock Gossip bill in Great Plains from the Sales Order Giving out window, use Modifier and VBA to call up the Rock Hearsay engine.

SQL Query

Using SQL Query Analyzer can help in creation sure you are in receipt of acceptable outcome in your account generation. In addition, it debugs stored procedures and query act problems. It can also copy accessible catalog items and locate, view or work with these items contained by the database.

Need more information?

Contact us: 1-866-528-0577 or help@albaspectrum. com

For customization work and advice, delight commerce Andrew Karasev, Alba Spectrum Chief Expertise Officer. His works consist of advance of applications with the use of Dexterity, SQL, C# . NET, Rock Intelligence and Microsoft CRM SDK.

Divine Rigor is the Industrial Essayist for Alba Spectrum Technologies USA ( http://www. albaspectrum. com ), a Great Plains, Microsoft CRM customization company. We are based in Chicago with locations in California, Arizona, Texas, Florida, Georgia, New York and contacts in global markets.

Jan 2005 Alba Spectrum Technologies USA

Developed by:
home | site map © 2018