In this article, we will look at Microsoft Dynamics GP Reporting Tools.
Microsoft Dynamics GP ERP has numerous revealing devices: Report Writer, Crystal Reports, MS SQL Server Reporting Services, FRx, Microsoft Access reports, Excel detailing. At the purpose once you see such an assortment of apparatuses, you ought to realize that the selection of report configuration instruments relies upon the thought of the report.
For instance, within the event that you simply need to interface various modules in Dynamics GP, for instance , Sales Order Processing and buy Order Processing (when your undertaking is run deals commission discharge, when things and administrations are sold and merchandise are conveyed by your providers) – at that time you would like to think about Crystal Reports or SRS , where you’ll make SQL Stored Procedure or deem a report foundation. we should always quickly survey the selection of announcing devices and their abilities:
FRx. FRx reports creator connects legitimately to Great Plains ledger . this suggests you need to consider these report configuration instruments for GL level reports, including united reports, that take an attempt at the FRx announcing structure. It additionally works with GL spending plans and has an alternate to solidify your GP organizations with virtual organizations, which are sent bent Excel worksheet – FRx has Excel connect instrument.
Elements GP Report Writer. The qualities of this device are the immediate call of existing reports from the GP workstation with parameter screens. RW is flawlessly coordinated with the GP interface and therefore the client assurance region. Such reports like SOP Invoice Blank structure is one among the foremost documented for RW change – you’ve got to place your organization logo on Sales Invoice Form.
You’ll likewise make a RW perfect report in Great Plains Dexterity Adjustments and these reports are going to be accessible through the GP Adjust menu. Such Dex reports are referred to as GP Alternate Modified reports. RW is a smaller amount adaptable than Crystal Reports or SRS, however it’d have a GP parameters section screen inside the GP client’s security territory
Gem Reports and SRS. you’ll feel that these two instruments originate from various providers and are probably not getting to be similar. Nonetheless, on account of Great Plains report plan, they’re comparative in report programming innovation – the simplest reports depend upon the MS SQL Server Stored system or SQL see
MS Access, Excel and nonexclusive MS Visual Studio .Net report distribution. Exceed expectations and MS Access can associate ODBC perfect DB stage, for instance , MS SQL Server in VBA scripting. C # or VB .Net programmer or Great Plains Technical Consultant can fabricate GP report by means of SQL select proclamation in ADO.Net.
On the off chance that you simply are a .Net MS Visual Studio engineer, consider considering eConnect programming versus direct SQL Select explanations. within the event that you simply need the structure of GP tables, introduce GP SDK from CD # 2