FRx and Crystal Reporting Peekskill NY

Microsoft Dynamics GP has the whole set of various reporting tools: FRx Financial Reporting, SQL Server Reporting Services, GP Report Writer, Crystal Reports, Microsoft Excel, Smart List. Dynamics GP reporting tools selection for specific case is subject of this small publication.

Local Companies

Staples
914-345-9401
339 Tarrytown Road
Elmsford, NY
Nextstep Computer and Software, Inc.
(845) 362-0429
1581 Route 202 #410
Pomona, NY
Imagework Technologies Corporation
(914) 681-0700
235 Main Street
White Plains, NY
PC Ware Business Solutions
(845) 371-9150
28 Dorset Road
Spring Valley, NY
Consult A Pro, Inc
(845) 426-5922
169 South Main Street 356
New City, NY
Staples
845-624-3161
230 West Route 59
Nanuet, NY
Staples
845-783-3226
31 Centre Drive
Central Valley, NY
Computer Headaches
(914) 228-0827
580 Barrett Hill Road
Mahopac, NY
Fishkill Computer Service
(845) 896-6899
428 McGrath Boulevard
Fishkill, NY
A and M Computer Repair
(845) 947-3522
24 Colonel Conklin Drive
Stony Point, NY
Data Provided by:
  

Provided By:

Great Plains VAR, Technology Partner and Reseller Newsflash: FRx and Crystal Reporting

Author: Andrew Karasev

Microsoft Dynamics GP has the whole set of various reporting tools: FRx Financial Reporting, SQL Server Reporting Services, GP Report Writer, Crystal Reports, Microsoft Excel, Smart List. Dynamics GP reporting tools selection for specific case is subject of this small publication:

1. FRx. If what you need is pure financial reporting: Profit & Loss Statement (P&L), Balance Sheet, Statement of Cash Flow, plus consolidated versions of these statements - then on the first place consider FRx. FRx has connector to Dynamics GP General Ledger: 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 open year), historical transactions to give you some information for consideration. FRx connectors do all mentioned above. FRx consolidated reporting ā€“ if in Dynamics GP you have multiple companies, FRx reporting tree allow 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 (from SAP Business One, for example) and consolidate international branches with Dynamics GP headquarters on MS Excel level

2. Great Plains ReportWriter reporting. Here you typically modify existing forms: SOP Blank Invoice form, GL Trial Balance, RM Historical Aging, Fixed Assets Depreciation Ledger, etc.. If Dynamics GP RW doesnā€™t 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 with External data sources: Oracle, Lotus Notes, Microsoft Access, Warehouse Management Databases to give you few examples. CR can combine data from multiple Dynamics GP companies, as well as from Heterogeneous Databases on ODBC connection level as well as using native DB drivers. Before you dive into Crystal Reports design sea, we recommend you to review available reports for SSRS (Microsoft SQL Server Reporting Services) for Microsoft Dynamics GP. In Crystal Report design we recommend you to separate DB records selection login from CR itself: consider work out report selection in SQL Server Stored Procedure (where procedure parameters translate into CR parameters) or SQL View. Horrible stories about Crystal Report records duplications are typically associated with the fact that CR designer tried to use Crystal Reports Wizard (which does ad-hoc queries from Crystal directly to DB tables) ā€“ all these you can avoid by separating CR design from DB query (in SQL stored procedure or view)

4. If you need further help, feel free to call or email us, we are experienced Great Plains Consultants, Programmers and Developers


About the Author:

Andrew Karasev, Alba Spectrum LLC. http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577. Web portal: http://www.pegasplanet.com We are Microsoft Dynamics GP technology partner, ERP and software integrator, who serves you USA, Canada, Mexico and Latin America nationwide. Local service is available in Chicago, San Diego, Los Angeles, Houston. We have customer in the following business metros: Phoenix, New York, Boston, Milwaukee, Buffalo, Rhino, San Jose, Miami, Atlanta, Minneapolis, San Francisco, Detroit, Montreal, Las Vegas, Oceania, Colombia, Caribbean, Poland, UK, New Zealand, Australia

Article Source: http://www.articlesbase.com/software-articles/great-plains-var-technology-partner-and-reseller-newsflash-frx-and-crystal-reporting-830707.html

Related Articles
- Ultimate Software for Network Printing Needs Peekskill NY
The print manager software comprises of several features in one package. You can charge differential charges for printing for all users individually and separately. Activities of other computers will not be disrupted this way. The software gives you the option to set quota for every user automatically.
- How to Make Audio File on Computer Peekskill NY
- Manufacturing Execution Software Peekskill NY
- Bug Reporting Software Peekskill NY