Software informational articles

Precious stone gossip for microsoft great plains ? overview for developer - software


Microsoft Great Plains is main accounting / ERP attention from Microsoft Affair Solutions, beleaguered to the US market. It serves the whole of vertical and horizontal market: most of the industries and ballet company sizes. Gemstone Information on the other hand is the director in the treatment software commerce and Microsoft is agreeable to use Gemstone as main exposure tool for Great Plains, Solomon, Microsoft CRM, . Net platform, etc.

If you are developer who is asked: how do we delay Great Plains ReportWriter with rather more clever - read this and you will have the clues on where to look further.

  • Great Plains Tables Structure - first of all you need to know the tables to link. Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the appropriate series. If you are looking for the customers - it be supposed to be RM00101 - buyer master file. If you need past Sales Order Doling out id - they are in SOP30200 - Sales Annals Legend file, etc.
  • Create ODBC link to GP Business database. Use the same performance as when you coin banner ODBC correlation for GP workstation - but alteration evade catalog to under attack band database.
  • Consider SQL Views - if you don't want complicated links in Gem Account itself or if you need unionization from a number of companies - SQL view is the answer.
  • Consider SQL Stored Procedures. Every so often you can not pull the data in one view - you need brief tables to be produced and the final query be supposed to be based on these temp tables - this is when you need stored procedure.
  • Call Rock Article from GP Screens via VBA/Modifier - if the user wants to call Rock arrive for case in point - printing Invoices in GP and do it from SOP Entry chance - you can use Modifier and VBA to call Rock Gossip engine.
  • Create SQL Query to probe the data - we constantly advise tuning your query and see that you are in receipt of enough fallout - in any case - Precious stone Article is just a nice tool to show the domino effect of your query.
  • Happy customizing, querying and designing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum. com

    Andrew Karasev is Chief Equipment Bureaucrat in Alba Spectrum Technologies - USA generally 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 numerous states and worldwide (www. albaspectrum. com), he is Dexterity, SQL, C#. Net, Rock Information and Microsoft CRM SDK developer.


    WorkWave to Acquire TEAM Software  Silicon Prairie News

    Iris Software Acquires Conarc

    Developed by:
    home | site map © 2021