Software informational articles

Treatment tools for microsoft great plains ? overview for developers - software


Looks like Microsoft Great Plains becomes more and more popular, partially since of Microsoft muscles after it. Now it is under attack to the whole spectrum of horizontal and vertical advertise clientele. Small companies use Small Commerce Boss (which is based on the same expertise - Great Plains Adroitness thesaurus and runtime), Great Plains Average on MSDE is for small to midsize clients, and then Great Plains serves the rest of the advertise up to big corporations. There are quite a few treatment tools obtainable and you beyond doubt need to know which one to use for another types of reports.

If you are developer who is asked: how do we coin bang for Microsoft Great Plains - read this and you will have the clues on where to look further.

1. Great Plains Article Journalist (ReportWriter) - this is built-in exposure tool. All the earliest article in Great Plains are on paper in ReportWriter. ReportWriter itself is Adroitness module. You must use this tool if you would like to adjust accessible Great Plains reports, such as Blank Account Form - here you can place your circle logo, alter the positioning, fonts, colors, etc. ReportWriter will allow you also do new gossip - down-to-earth opportunity if you want to export all the report from one Great Plains table - use it. New report, in spite of this doesn't have edge where you would enter parameters - so it is not constructive for real custom reports. A further limitation of ReportWriter - you can not do cross-modules article - when you need sales and purchasing info on the same account for example.

2. FRx. This is exceptional tool when deal with fiscal exposure - it works on the Common Ledger level (Balance sheet, P&L, Cash Flow Statement, etc. ). It also allows you to do numerous companies consolidation - when you do consolidated Compare Sheet (with inter-companies transactions elimination).

3. Smart List - Export to Excel - this is nice aspect in Great Plains - you could build a list with clean criteria and then export it to Excel.

4. Crystal Reports. It gives you ad lib functionality. Apparently flexibility requires you to know Great Plains table structure: Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the accurate series. If you are looking for the customers - it must be RM00101 - consumer master file. If you need chronological Sales Order Dealing out id - they are in SOP30200 - Sales Annals Heading file, etc. Conceive ODBC bond to GP Business database. Use the same modus operandi as when you construct accepted ODBC bond for GP workstation - but alter evade catalog to beleaguered business database. Construct SQL Query to probe the data - we constantly advocate tuning your query and see that you are receiving enough outcome - in any case - Precious stone Article is just a nice tool to show the domino effect of your query.

5. Direct Web Publishing off Great Plains databases - yes - it is easy now with Visual Studio. Net and you can hire good programmers. This is good - Microsoft Affair Solutions products: Great Plains, Solomon, Navision and Axapta will be integrated into so called Microsoft Affair Entrance - which will have web boundary - you can get the idea if you look at Microsoft CRM web client - so derecti web publishing is good taste.

6. SQL Queries. If you have SQL backdrop - this is great field for you. You know - with accurately formatted SQL query you can accomplish down-to-earth EDI export/import for the integration with birthright systems.

Happy designing! if you want us to do the job - give us a call!

About The Author

Andrew Karasev is Chief Know-how Administrator in Alba Spectrum Technologies - USA generally Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Boston, San Francisco, Los Angeles, Houston, Atlanta, and Miami and having locations in numerous states and globally www. albaspectrum. com, he is Dexterity, SQL, VB/C#. Net, Precious stone Gossip and Microsoft CRM SDK developer.

akarasev@albaspectrum. com

1-866-528-0577 help@albaspectrum. com

Developed by:
home | site map © 2018