Microsoft Excellent Plains Reporting – Overview for Developer

Seems like Microsoft Amazing Plains will get to get progressively much more well-known, partly due to the fact of Microsoft muscles for the rear of it Now it is concentrated to the full spectrum of horizontal and vertical market spot clientele. Scaled-down firms use Compact Organization Supervisor (that may be centered for the comparable know-how – Fantastic Plains Dexterity dictionary and runtime), Wonderful Plains Conventional on MSDE is for compact to midsize purchasers, after which Marvelous Plains serves the rest of your present-day marketplace as lots of as big firms. You can find quite a few reporting purposes obtainable and you simply just surely need to know which one to use for different forms of reports.

In the event you be developer which is requested: how can we establish report for Microsoft Amazing Plains – glimpse at this and you’ll maintain the clues on accurately wherever to appear far more.

Amazing Plains Report Author (ReportWriter) – this can be built-in reporting system. All of the initial report in Superb Plains are penned in ReportWriter. ReportWriter by itself is Dexterity module. It is advisable to use this software if you’d like to modify recent Very good Plains scientific studies, this kind of as Blank Bill Kind – in the following paragraphs it’s possible you’ll site your firm emblem, change the positioning, fonts, hues, etc. ReportWriter enables you also do new research – easy collection in case you like to export each individual of the information from 1 Great Plains desk – make the most of it. New report, even so would not have interface where ever you will enter parameters – so it may be not functional for precise personalised reports. Nonetheless an additional limitation of ReportWriter – you cannot do cross-modules report – when you must have gross product sales and buying details in excess of the very similar report for example.
FRx. This really is typically superb instrument when handle financial reporting – it really works within the Common Ledger degree (Harmony sheet, P&L, Cash Flow Statement, etc.). It also allows you to do multiple companies consolidation – whenever you do consolidated Equilibrium Sheet (with inter-companies transactions elimination).
Smart List – Export to Excel – this really is certainly nice feature in Excellent Plains – you could produce a list with uncomplicated criteria and then export it to Excel.
Crystal Experiences. It gives you unlimited functionality. Obviously flexibility requires you to obtain out Excellent Plains desk structure: Launch Superb Plains and go to Tools->Resource Description->Tables. Uncover the desk in the proper series. In case you are looking for the customers – it ought to get RM00101 – customer master file. In case you need historical Profits Order Processing documents – they are in SOP30200 – Gross gross sales History Header file, and so forth. Build ODBC connection to GP Enterprise database. Use the same technique as once you make common ODBC connection for GP workstation – but change default database to targeted business database. Make SQL Query to probe the data – we always recommend tuning your query and see that you are getting adequate results – in any case – Crystal Report is just a nice system to show the results of your query.
Direct Web Publishing off Great Plains databases – yes – it truly is easy now with Visual Studio.Net so you can hire good programmers. That is very good – Microsoft Business organization Solutions products: Wonderful Plains, Solomon, Navision and Axapta will be integrated into so called Microsoft Enterprise Portal – which will likely have web interface – you can be able to get the idea do you have to glance at Microsoft CRM web client – so direct web publishing is very good taste.
SQL Queries. For those who have SQL background – this really is excellent field for you. You know – with properly formatted SQL query you’ll be able to realize easy EDI export/import for the integration with legacy systems.