Appears to be like Microsoft Fantastic Plains will become a lot more and much more well-known, partly mainly because of Microsoft muscle groups powering it. Now it is focused to the full spectrum of horizontal and vertical industry clientele. Small organizations use Little Organization Manager (which is centered on the exact technologies – Great Plains Dexterity dictionary and runtime), Excellent Plains Standard on MSDE is for smaller to midsize consumers, and then Excellent Plains serves the rest of the market place up to massive businesses. There are quite a few reporting resources out there and you definitely want to know which one particular to use for unique sorts of stories.
If you are developer who is asked: how do we develop report for Microsoft Good Plains – examine this and you will have the clues on where by to glimpse further.
- Wonderful Plains Report Writer (ReportWriter) – this is crafted-in reporting device. All the initial report in Fantastic Plains are written in ReportWriter. ReportWriter alone is Dexterity module. You must use this device if you would like to modify present Good Plains experiences, this kind of as Blank Invoice Type – in this article you can area your firm logo, transform the positioning, fonts, hues, and many others. ReportWriter will permit you also do new reviews – simple option if you want to export all the data from one Wonderful Plains desk – use it. New report, having said that won’t have interface in which you would enter parameters – so it is not practical for genuine custom made experiences. A further limitation of ReportWriter – you can not do cross-modules report – when you want profits and purchasing info on the very same report for illustration.
- FRx. This is great device when deal with money reporting – it operates on the Common Ledger amount (Stability sheet, P&L, Income Circulation Assertion, and so on.). It also will allow you to do numerous providers consolidation – when you do consolidated Balance Sheet (with inter-businesses transactions elimination).
- Intelligent Listing – Export to Excel – this is pleasant function in Excellent Plains – you could generate a list with easy requirements and then export it to Excel.
- Crystal Studies. It provides you unlimited functionality. Obviously versatility needs you to know Good Plains desk structure: Start Wonderful Plains and go to Instruments->Resource Description->Tables. Uncover the desk in the suitable sequence. If you are hunting for the customers – it should be RM00101 – buyer grasp file. If you need to have historical Gross sales Purchase Processing files – they are in SOP30200 – Gross sales Record Header file, and so forth. Produce ODBC relationship to GP Corporation database. Use the very same technique as when you develop standard ODBC relationship for GP workstation – but improve default databases to focused firm databases. Generate SQL Query to probe the data – we always recommend tuning your question and see that you are finding suitable success – in any situation – Crystal Report is just a pleasant software to exhibit the final results of your question.
- Immediate Internet Publishing off Wonderful Plains databases – indeed – it is quick now with Visual Studio.Net and you can seek the services of great programmers. This is excellent – Microsoft Organization Solutions products and solutions: Great Plains, Solomon, Navision and Axapta will be integrated into so called Microsoft Organization Portal – which will have web interface – you can get the thought if you glimpse at Microsoft CRM website customer – so direct net publishing is good flavor.
- SQL Queries. If you have SQL background – this is great field for you. You know – with effectively formatted SQL query you can understand easy EDI export/import for the integration with legacy systems.
Content developing! If you want us to do the work – give us a get in touch with 1-866-528-0577! [email protected]