If you are looking for new ERP, MRP, warehouse management, logistics application, we would like to recommend Microsoft Dynamics GP, formerly known under Great Plains Dynamics name, as the candidate for consideration
If you already have GP implemented in your organization, we are offering Dynamics GP reporting highlights in this small publication, written for technical people in your IT department:
1. GP Reporting Tools. You have pretty wide selection: FRx for financial reporting (Balance Sheet, Profit and Loss Statement, Statement of Cash Flow), Report Writer for existing reports modifications, Crystal Reports, SSRS for advanced (usually not financial) industry reports. If you are comfortable with MS Access reports, Excel, or any other ODBC compliant reporting tool, you should be able to use it as well for Industry reports
2. FRx. This reporting tool allows you reasonably quickly design Financial statements, plus with FRx you can work with Consolidated reporting (either multiple companies or one company with multiple divisions or product lines). FRx also supports Excel worksheets, typically useful when you are consolidating your main company with smaller branches, where you are receiving summaries in Excel
3. GP ReportWriter. You usually modify existing reports, such as SOP Blank Invoice Form by placing your company graphical logo file on the left top side. You also may need to alter such reports as Trial Balance, Sales Tax Report, etc. RW is Dynamics GP Dexterity based module and it is restricted in its table linking power to the Dex preset rules
4. Crystal Reports. Good taste in our opinion is SQL call separation from the report design itself. In such model you first test your report logic via SQL Stored Procedure or View result set in SQL Management Studio. When you are satisfied with results, you finish your report in CR Designer. This approach should be preferred over the temptation to use Crystal Report wizard, especially for complex report logic, and if you want to eliminate annoying results rows duplication, etc.
5. SSRS, MS Access, Excel, and other tools. If you follow the rules, drawn in paragraph #5, you will see that reporting tool is not a critical point
6. If you have questions, concerns, or need help, please feel free to call us in California or US nationwide: 1-866-528-0577, help@albaspectrum.com
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQ
Planning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.
Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella
