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