Great,Plains,VAR,Technology,Pa computer Great Plains VAR, Technology Partner and Reseller Newsflash:
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
Dynamics GP reporting tools selection for specific case is subjectof this small publication: 1. FRx. Ifwhat you need is pure financial reporting: Profit & Loss Statement (P&L),Balance Sheet, Statement of Cash Flow, plus consolidated versions of thesestatements - then on the first place consider FRx. FRx has connector to Dynamics GP GeneralLedger: summary tables, posted and unposted transactions. If you would consider generic reporting tool,such as Crystal Reports GL link has to be designed in Crystal from scratch,and this is not as simple as you may expect. Dynamics GP GL has Period summary tables, open transactions (for openyear), historical transactions to give you some information forconsideration. FRx connectors do allmentioned above. FRx consolidatedreporting if in Dynamics GP you have multiple companies, FRx reporting treeallow you to consolidate BS, P&L, SCF. If you need international consolidation, FRx supports multicurrency,plus you can export your overseas subsidiary GL into Excel Spreadsheet (fromSAP Business One, for example) and consolidate international branches withDynamics GP headquarters on MS Excel level 2. Great Plains ReportWriter reporting. Here you typically modify existing forms: SOPBlank Invoice form, GL Trial Balance, RM Historical Aging, Fixed AssetsDepreciation Ledger, etc.. If DynamicsGP RW doesnt have report that you need, consider SSRS or Crystal Reports 3. Crystal Reports. Here you typically create non-financial reports: Sales, Purchasing,Inventory, Manufacturing, Payroll custom reports, often combining data withExternal data sources: Oracle, Lotus Notes, Microsoft Access, WarehouseManagement Databases to give you few examples. CR can combine data from multiple Dynamics GP companies, as well as fromHeterogeneous Databases on ODBC connection level as well as using native DBdrivers. Before you dive into CrystalReports design sea, we recommend you to review available reports for SSRS (MicrosoftSQL Server Reporting Services) for Microsoft Dynamics GP. In Crystal Report design we recommend you toseparate DB records selection login from CR itself: consider work out reportselection in SQL Server Stored Procedure (where procedure parameters translateinto CR parameters) or SQL View. Horrible stories about Crystal Report records duplications are typicallyassociated with the fact that CR designer tried to use Crystal Reports Wizard (whichdoes ad-hoc queries from Crystal directly to DB tables) all these you canavoid by separating CR design from DB query (in SQL stored procedure or view) 4. If you need further help, feel free to call oremail us, we are experienced Great Plains Consultants, Programmers andDevelopers
Great,Plains,VAR,Technology,Pa