Each corporate ERP application should be exposed to Crystal, SSRS, or any other designer reporting tool via ODBC or native database driver connections. In the general case, where you are a programmer and report you try to get first aid, check to see if your ERP or Accounting Corporate Application Software Development Kit (SDK), when its technology-layer for software developers, programmers and designers Reports should be documented. In this small publication we will concentrate on Microsoft Dynamics GP tables structure, fields, tables, and groups how to get more information in the reports, design. The most typical reports, as we heard from Dynamics GP, Great Plains Dynamics Sales customers are the Commission, the sales by product / Item Class / region, product profitability (where you order Sales Link and order buy Processing Modules data for specific class article or article group), Article barcode printed report (versus primarily in the retail, warehouse management operations, where customers will have rather Dynamics GP as initial Barcoding source, whether in applications such as Microsoft Retail Management System), Project Report , etc. As a bonus issues, we will also touch some international business corporate ERP issues, especially if your company plans to expand to Russia and Brazil. If your event is not listed here feel free to contact us directly. Let’s start with:

1st Dynamics GP SDK. As a current version of the 10th GP 0 as well as earlier versions: 9 0, 8 0, 7 5, 7 0, 6 0, 5 5 have been or distributed on CDs, you can install SDK from CD # 2. We expect version 11 0 be distributed on DVD (it should be published in May or in the first half of 2010). Microsoft Dynamics GP SDK has the complete table chart that you could print or write on your screen. This method is very good for the profound analysis (if you really expect complex report, the combination of several modules in a GP report). Dynamics GP eConnect SDK is sometimes confused and called GP (SDK is primarily devoted to e-commerce Dynamics GP developers, currently meets the majority eConnect for Dynamics GP modules and functionality. For version 10 0 eConnect SQL stored procedures automatically installed as they are required 10th 00:00 version art)

2nd Shortcut to get the information faster than GP-table, field or form. If you think that investing is no need for you to spend your time in Dynamics GP SDK tables structure diagram, you can simply log in Great Plains and then to Dynamics GP -> Options -> Resource Description -> tables ( fields, or Windows). Feel free to do self – as a typical example, we would like to Sales Order Processing Work Group Transaction Tables: Select Tables, product name Microsoft Dynamics GP, series sales, sorted by name Technical Table Group, and then find Sales work would. You should be able to find SOP10100 (Sales Transaction work – that is your SOP document header table) and SOP10200 (Sales transaction is working – this is SOP document line chart). These tables are very popular in e-commerce reporting, and integration scenarios for Microsoft Dynamics GP Great Plains

3rd Additional advice about Crystal Report, SSRS design. In our consulting Dynamics GP we saw several cases where Crystal Reports designer, completely denied the report delivery. Typical error was to try CR-assistant for the link GP tables on the report level. We highly recommend that you check the separation of reports, presentation and data pull logic. Crystal Reports, SSRS – these are very good reporting tools, but they do not have perfect base in reports SQL query programming. If you want to enjoy the flexibility and total control over the report results should report separate SQL login Drawing in MS SQL Server, Union, View or Stored Procedure. If these tips, questions such as line duplication (follow this error is very difficult to catch, such as CR does not allow debugging service, and you are usually for reproduction, if the debt is already in production report)

4th Design Reports for older versions of Dynamics Great Plains, Great Plains eEnterprise or Accounting for DOS, Windows or Mac. Here you have ODBC connections to provide Pervasive SQL 2000 (or Btrieve, but large numbers of Great Plains accounting systems have been ported with Pervasive SQL 2000 SP3 or 4). If you are on Pervasive SQL 2000, you should DDF files generation (for GPA and Great Plains Dynamics on Pervasive SQL review / Btrieve) or ODBC driver Ctree connection methods. You can also consider creating reports in Microsoft Access, where robust linked table option or MS SQL Server 2000/2005 server building (this method is linked strongly recommended because it will cross-platform data on the same report, for the combination allows example from the Oracle-based Sales Order Processing external application and Great Plains Dynamics on Pervasive SQL 2000)

5th Crystal Reports for SAP Business One. SB1 is recommended if you relatively small multinational group headquartered in the U.S., Canada, Australia, New Zealand or South Africa with Microsoft Dynamics GP Corporate ERP application and be extended to regions such as Brazil, China, Russia, Germany, Japan, Korea where Dynamics GP is not in its localized version. Please write SAP B1 SDK to understand SBO tables structure and relationships. It is also possible, tables and field names to write when you select in SAP Business One, File -> View system information and log then position the cursor on the form and field – technical info (table and field names) will be displayed in the main window, lower left corner of the status bar. SAP B1 was first developed with International Business considerations and we know examples when multinational companies complete conversion of Microsoft Dynamics GP (Great Plains) decided to SAP Business One at its headquarters in the implementation of SAP Business One, Brazilian for the subsidiary. SAP Business One of the limitations of the ASCII table, and it supports Unicode and hieroglyphs: Chinese, Japanese, Korean (this is very limited or almost impossible in Dynamics GP – you can try, limited Crystal Reports for Great Plains, with the support of the Chinese language, if you look at NJ Star-extensions)

6th Dynamics GP / SAP Business One puzzle, if you Russian, Ukrainian, Kazakh market as a multinational company in motion. Technically Russian language is compatible with ASCII standard. However, Russia has very complex accounting and compliance requirements. Microsoft Dynamics GP is not for the Russian market (or Navision Axapta you can see localized, if your budget allows foreign company corporate ERP). SAP Business One is available and certified in Russia (where it is hard to compete with the local accounting packages, such as for example, has Bukhgalteria 1S). We plan special cycle of articles dealing with Russian companies, the ERP market, where we will discuss SAP, Microsoft Dynamics and published local packages advantages and disadvantages, FAQ in 2010

7th Dynamics GP / SAP B1 combination for Brazilian subsidiary. This could given the situation, similar as described above for Russia. In Brazil you have located and Microsoft Dynamics AX and NAV (with some restrictions) and SAP Business One is very advanced, but in tough competition from local companies such as ERP packages Microsiga

8th Please call us at 1-866-528-0577, help @ alba spectrum. com http://www. alba spectrum. com We speak English, Spanish, Portuguese, Chinese, Russian. Our consulting rates are very competitive and we should be able to your national and Worldwide Corporate ERP consulting and support cover. We support all versions of Microsoft Dynamics GP, Dynamics Great Plains, eEnterprise, Great Plains Accounting, SAP Business One