Software informational articles

Microsoft great plains exposure ? overview for developer - software


Looks like Microsoft Great Plains becomes more and more popular, partially for the reason that of Microsoft muscles after it. Now it is embattled to the whole spectrum of horizontal and vertical bazaar clientele. Small companies use Small Big business Executive (which is based on the same equipment - Great Plains Agility glossary and runtime), Great Plains Average on MSDE is for small to midsize clients, and then Great Plains serves the rest of the promote up to big corporations. There are more than a few treatment tools existing and you absolutely need to know which one to use for assorted types of reports.

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

  • Great Plains Account Journalist (ReportWriter) - this is built-in exposure tool. All the fundamental article in Great Plains are in print in ReportWriter. ReportWriter itself is Ability module. You be supposed to use this tool if you would like to alter free Great Plains reports, such as Blank Bill of lading Form - here you can place your circle logo, adjustment the positioning, fonts, colors, etc. ReportWriter will allow you also do new gossip - down-to-earth option if you want to export all the account from one Great Plains table - use it. New report, in spite of this doesn't have border where you would enter parameters - so it is not constructive for real custom reports. A new limitation of ReportWriter - you can not do cross-modules arrive - when you need sales and purchasing info on the same account for example.
  • FRx. This is admirable tool when deal with pecuniary exposure - it works on the All-purpose Ledger level (Balance sheet, P&L, Cash Flow Statement, etc. ). It also allows you to do numerous companies consolidation - when you do consolidated Calculate Sheet (with inter-companies transactions elimination).
  • Smart List - Export to Excel - this is nice attribute in Great Plains - you could coin a list with austere criteria and then export it to Excel.
  • Crystal Reports. It gives you ad nauseam functionality. Evidently 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 - buyer master file. If you need past Sales Order Doling out papers - they are in SOP30200 - Sales Chronicle Description file, etc. Conceive ODBC association to GP Circle database. Use the same modus operandi as when you coin accepted ODBC association for GP workstation - but alteration defaulting file to embattled ballet company database. Construct SQL Query to probe the data - we continually counsel tuning your query and see that you are being paid passable domino effect - in any case - Precious stone Bang is just a nice tool to show the fallout of your query.
  • 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 Gateway - which will have web boundary - you can get the idea if you look at Microsoft CRM web client - so aim web publishing is good taste.
  • SQL Queries. If you have SQL conditions - this is great field for you. You know - with by the book formatted SQL query you can appreciate clean EDI export/import for the integration with bequest systems.
  • Happy designing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum. com

    Andrew Karasev is Chief Expertise Executive in Alba Spectrum Technologies - USA countrywide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, New York, Florida, Georgia, Minnesota, Oregon, Arizona, Canada, UK, Australia and having locations in compound states and globally (www. albaspectrum. com), he is Dexterity, SQL, C#. Net, Gemstone Hearsay and Microsoft CRM SDK developer.


    WorkWave to Acquire TEAM Software  Silicon Prairie News

    Iris Software Acquires Conarc

    Developed by:
    home | site map © 2021