Nice Plains Dynamics GP Reporting Instruments and Studies Design Overview
Microsoft Dynamics GP ERP has a number of reporting instruments: Report Author, Crystal Studies, MS SQL Server Reporting Providers, FRx, Microsoft Entry studies, Excel reporting. Seeing such quite a lot of instruments, you might want to know that report design device choice relies on the report nature. For instance if you might want to hyperlink a number of modules in Dynamics GP, comparable to Gross sales Order Processing and Buy Order Processing (when your venture is finished for gross sales fee launch, when gadgets and providers are bought and items are delivered by your distributors) - then you must think about Crystal Studies or SRS, the place you possibly can create SQL Saved Process or View as report background. Let's briefly evaluate reporting instruments choice and their capabilities:
1. FRx. FRx report designer hyperlinks on to Nice Plains Basic Ledger. Which means that you must think about this report design instruments for GL stage studies, together with consolidated studies, working over FRx reporting tree. Additionally it really works with GL budgets in addition to has an choice to consolidate your GP corporations with digital corporations, that are exported into Excel worksheet - FRx has Excel linking mechanism.
2. Dynamics GP ReportWriter. The sturdy factors of this device are direct name of current studies from GP person workstation with parameters screens. RW is seamlessly built-in with GP interface and person safety realm. Such studies as SOP Bill Clean type is among the hottest for RW modification - you bought to put your organization brand on Gross sales Bill Kind. You may also create RW suitable report in Nice Plains Dexterity customizations and these studies might be out there by way of GP Customise menu. Such Dex studies are often called GP Alternate Modified studies. RW is much less versatile than Crystal Studies or SRS, however it may have GP parameters entry display inside GP person safety realm
3. Crystal Studies and SRS. It's possible you'll suppose that these two instruments are coming from totally different distributors and unlikely are comparable. Nonetheless within the case of Nice Plains report design they're comparable in report programming know-how - the very best studies are based mostly on MS SQL Server Saved process or SQL view
4. MS Entry, Excel and generic MS Visible Studio .Internet report publishing. Excel and MS Entry can hook up ODBC compliant DB platform, comparable to MS SQL Server in VBA scripting. C# or VB .Internet programmer or Nice Plains Technical Guide can construct GP report by way of SQL choose assertion in ADO.Internet. If you're .Internet MS Visible Studio developer, please think about eConnect programming versus direct SQL choose statements. Should you want GP tables construction, please set up GP SDK from CD #2