Dynamics,Partner,California,Gr computer Dynamics GP Partner California: Great Plains Reporting
----------------------------------------------------------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 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
If you already have GP implemented in your organization, weare offering Dynamics GP reporting highlights in this small publication,written for technical people in your IT department: 1. GPReporting Tools. You have pretty wideselection: FRx for financial reporting (Balance Sheet, Profit and LossStatement, Statement of Cash Flow), Report Writer for existing reportsmodifications, Crystal Reports, SSRS for advanced (usually not financial)industry reports. If you are comfortablewith MS Access reports, Excel, or any other ODBC compliant reporting tool, youshould be able to use it as well for Industry reports 2. FRx. This reporting tool allows you reasonablyquickly design Financial statements, plus with FRx you can work with Consolidatedreporting (either multiple companies or one company with multiple divisions orproduct lines). FRx also supports Excelworksheets, typically useful when you are consolidating your main company withsmaller branches, where you are receiving summaries in Excel 3. GPReportWriter. You usually modifyexisting reports, such as SOP Blank Invoice Form by placing your companygraphical logo file on the left top side. You also may need to alter such reports as Trial Balance, Sales TaxReport, etc. RW is Dynamics GP Dexteritybased module and it is restricted in its table linking power to the Dex presetrules 4. CrystalReports. Good taste in our opinion isSQL call separation from the report design itself. In such model you first test your reportlogic via SQL Stored Procedure or View result set in SQL ManagementStudio. When you are satisfied withresults, you finish your report in CR Designer. This approach should be preferred over the temptation to use CrystalReport wizard, especially for complex report logic, and if you want toeliminate annoying results rows duplication, etc. 5. SSRS,MS Access, Excel, and other tools. Ifyou follow the rules, drawn in paragraph #5, you will see that reporting toolis not a critical point 6. Ifyou have questions, concerns, or need help, please feel free to call us inCalifornia or US nationwide: 1-866-528-0577, [email protected]
Dynamics,Partner,California,Gr