- Great Plains Report Writer (ReportWriter) – this is built-in reporting tool. All the original report in Great Plains are written in ReportWriter. ReportWriter itself is Dexterity module. You should use this tool if you would like to modify existing Great Plains reports, such as Blank Invoice Form – here you can place your company logo, change the positioning, fonts, colors, etc. ReportWriter will allow you also do new reports – simple option if you want to export all the records from one Great Plains table – use it. New report, however doesn’t have interface where you would enter parameters – so it is not useful for real custom reports. Another limitation of ReportWriter – you can not do cross-modules report – when you need sales and purchasing info on the same report for example.
- FRx. This is excellent tool when deal with financial reporting – it works on the General Ledger level (Balance sheet, P&L, Cash Flow Statement, etc.). It also allows you to do multiple companies consolidation – when you do consolidated Balance Sheet (with inter-companies transactions elimination).
- Smart List – Export to Excel – this is nice feature in Great Plains – you could create a