Microsoft FRx

FRx Financial Report Designer

Financial Report Writer is ideal for accountants. It features a spreadsheet type interface which enables powerful Profit and Loss or Balance Sheets reports to be created in literally minutes. It effortlessly hooks into GL segments for powerful 3-dimensional divisional performance reporting. By combining 3 easy to set up, building blocks - Row Formats, Column Layouts and Trees, very powerful reports can quickly be created. Reports can be based on any periods from the General Ledger and for unlimited budgets and can also draw from other data sources, such as spreadsheets. Reports can be output to: paper, drill-down viewer, e-mail, Excel, pdf or XML.

FRx Options

Numerous options are available to disseminate reports and manage reports in a controlled and secure fashion. Reports may be published to a Report Server, Web Server, Business Portal or to SharePoint. Drill-down viewer licences are available enabling users to drill into detail without having to purchase a full designer licence.

FRx Currency Translator

Within Dynamics GP multi-currency transactions are converted to the functional currency for that company - typically the currency in which that company operates. Quite often though (especially for consolidation purposes) there is a need to convert this again to a reporting currency.

For example, a UK subsidiary of a US Corporation transacts with a German company and records these transactions in the original currency Euros and Sterling equivalent value (Sterling being the functional currency). The US parent however requires results to be converted to US dollars to enable consolidation of all of its subsidiaries.

FRx currency translator performs this reporting currency translation using exchange rates either from within Dynamics GP or from its own tables. Options include historical, average or spot rates and it is easy to use different rates for different elements, for example fixed assets to use historical rates and P&L to use average rates.