Frx Training

If your Microsoft Dynamics GP is implemented successfully, the next step is probably Reporting Tools selection of specific reports that you have on your list. As you might expect, the reports could be categorized and each category has its own favorite tool. If you have Crystal Reports designer career, we respect your return may each report could (theoretically) designed in Crystal Reports, however, for companies in the midmarket ERP, such as Microsoft Dynamics GP business logic may be too complicated for something like compiling profit and loss in Crystal Reports. Let's review report types and preferred reporting tool for each type. As a commentary on the style - we'll try to be quite technical and at the same time not too technical to keep the balance of IT and non IT professionals in your organization. Let's start with financial information:

1. FRx financial reporting. The advantage of FRx is the automation of connection to General Ledger tables. FRx is simple and yet very powerful open GL for various platforms corporate ERP: Dynamics GP, AX, SL, NAV, larger non-Microsoft, such as Epicor. If you are a controller or VP Finance, it should be easy for you to get basic training in FRx reports creation block, such as the online format, columns, reports of trees, and a catalog (or a final report, such as the balance sheet, P & L Statement of cash flows). Reporting Tree allows Synthesis: the consolidation of several companies (although some of them are present on Excel spreadsheets), or account segments (or even parts of segments, or a generic account based). For those of you who are programmers - The catalog of FRx is hosted in Microsoft Access database. If you login FRx, then go to the company-> Specification Sets the default look and you will see that it is likely that in the file FrxRpts.f32. You can open this file in Microsoft Access (assuming you know how to open password protected MS Access database). And here you can set format FRx mass line automation routines for updates, for example. In the MS Access database FRx is very simple in the discovery, so we had several clients who have decided to export reports to MS SQL Server FRx and Crystal Reports based on these new points of view completely migrate FRx of Crystal Reporting. In our opinion - this is not absolutely necessary, nor recommended, but we will move to the next tool Crystal Reports Designer

2. Crystal Reports. For Dynamics GP drafted professional Crystal Reports are typically based on SQL View or stored procedure, stored procedure where you can deploy temporary tables, you can deploy the table records complex SQL cursors. CR is the best (or you may prefer SSRS, which even the design philosophy of reports) for Great Plains in an administrative capacity within, as the Commission Report (based on your own forms, and often complex, taking into account fee credit card, for example), the bill, Reporting International (Chinese hieroglyph bill, calling the data from the GP Sales Order Processing tables: SOP10100 and SOP10200) and custom SQL Server database when you connect Info Chinese related invoice is entered directly in Chinese. If you are new to Crystal Reports design, we would encourage you to investigate how the Committee could be based on SQL View first and then review the stored procedures. These approaches are more effective, compared to Crystal Reports wizard. natural question to designate CR is the place where I could find Dynamics GP tables structure - you can install Microsoft Dynamics GP SDK from CD # 2 or in simple tables UI GP Dynamics GP-> Tools Resources -> Description->. It is safer to create SQL views and stored procedures directly into Dynamics GP or database companies

3. Dynamics GP Report Writer. It is a natural choice for the GP modified forms, such as Sal.