In Corporate ERP model for mid-size and large business you typically need to build two types of report: Financial and Managerial. ERP and MRP application typically has strong selection of both, ready for alteration and modification.
Financial reports are Balance Sheet, Profit and Loss Statement, Statement of Cash flow as well as consolidated versions of those (where you have several branches or business subsidiaries and you are consolidating their BS, PL and CF into one report). Managerial Reporting is covers Sales, Purchasing, Inventory, Logistics, and other Business Management reports. In this small publication we would like to highlight reports design for Microsoft Dynamics GP, formerly known as Great Plains Dynamics:
1. FRx financial reporting. There is no reason to reinvent the wheel, especially in such a conservative discipline as Financial Reporting. In the case of Dynamics GP Great Plains FRx has established connectors to GP General Ledger and reports design just requires the understanding of the mathematics of the specific report, plus basic FRX skills: Row Format, Column Layout and Reporting Tree. FRx is also applicable for Dynamics AX Axapta, Dynamics NAV Navision, Dynamics SL Solomon
2. Managerial Reporting Tools for GP. Here you have a variety. Let’s begin with Great Plains ReportWriter, where reports are already available in standard Dynamics GP workstation code: AP and AR Aging, GL Trial Balance, Inventory Stock Count, SOP Invoice, Return, Back Order, Quotation, Packing Slip, Picking Ticket are good example or RW reports, candidates for so-called modification in Great Plains Report Writer (where you can add your company logo to Blank SOP Invoice form, for example)
3. Beyond GP Report Writer. Dynamics GP designers tried to fulfill commonly required reporting needs, however the real life may dictate new business models and alternatives. If Great Plains RW doesn’t give you an option, you should consider such generic reporting tools as Crystal Reports and Microsoft SQL Server Reporting Services. Here you should likely to abstract the report from GP user interface and call report separately, reporting will be pulling data directly from Great Plains company database. Crystal Report, in the most flexible scenario might be based upon SQL S Server custom stored procedure or view. SSRS is in many ways comparable to CR Designer and you have the option to build report based on SQL Stored Procedure or SQL view
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
