Financial Reporting

QAD Financials offers a robust reporting framework combined with a leading reporting product—Crystal Reports. The extensive reporting features in conjunction with configurable browses and views that are easily exported to Excel cover all business requirements and provide maximum flexibility and operational efficiency for users.

Reports can be run directly from the menu, by right-clicking on a record in a browse, or by using the Go To menu from a maintenance screen to select a related report.

Report output is first shown in a viewer, where powerful functionality is available for navigating and searching through the data. In addition to sending reports to a printer, data can be exported in many standard formats such as PDF, XLS, and DOC.

Most reports have a Reporting Currency option, which lets you print the amounts in any currency. The system translates the base currency amounts automatically to the specified currency using the latest spot rate. If you select the statutory currency as the reporting currency, the base currency values are translated to the statutory currency using the statutory exchange rate that was valid on the transaction date.

Many reports also contain the original transaction currency amounts; for example, the foreign currency amounts for customer and supplier transactions.

Default settings are provided for each report. These can be adapted based on your company standard to better support your best practices. Filter settings and layout can be given a name and stored as a report variant, for private use or to be shared amongst users or groups of users (roles).

Reports can be customized to optimally support your company processes and best practices. You can:

• Add or remove report filter criteria, assign default values, and save custom report variants by user, role, or system-wide.

• Use the designer tool to modify the report layout, add and remove data fields, add calculation logic, or change sort order and grouping.

• Customize system-supplied report templates that contain formatting information such as fonts, logo, and paper orientation (landscape, portrait).

• Define scheduling and e-mailing options for reports that enable saved reports to be printed in iterations, and e-mailed to system users and roles.

Using the same designer tool, you can customize documents sent to your customers or suppliers such as checks and reminder letters to meet the company requirements.

You can use the Language setting in the Report Options window to select the language used for report labels and data descriptions, regardless of the language you are using. The system managers other regional settings such as the decimal point, number of decimals, and the date format.