Home » Categories » Solutions by Business Process » Finance » Currency

Currency Reports

Datafile Software

Currency Reports

Selecting the Currency Reports menu offers six application reports plus allows a link for any additional reports you may have defined within the Report Generator tool.

Prompts Used Throughout Reporting Procedures

Throughout the reporting features, there is a common set of pre-run parameters whenever a report is printed. These are supplemented by others for specific reports which will be discussed on the individual reports where appropriate.

If the pre-run parameters are set as required then you can select the PRINT option directly and proceed to print the report.

Date of Report

It is usual to print the system date on the report.This is displayed and maybe accepted or amended as required.

Report "As At” Date

Whilst the ‘Date of Report’ represents the date the report was printed, this date represents the date up to which transactions have been entered. For example, on the 3rd March 20xx you may want to produce reports up to the 28th February 20xx. Other than the Aged Analysis reports, where this date controls the aged analysis, the ‘As At’ date has no effect on the accounts or transactions reported.

Specify Any Selection Criteria

Leaving this input blank processes all records in the file.If you wish to apply criteria select this option.

The OPTIONS Button

The Options button allows configuration facilities for the printing of the report – selecting margins and fonts. When you select the OPTIONS button a pop-up form is displayed.

Before discussing the parameters you should note the buttons available at the footer of this parameter screen.


Default - This option updates the individual parameters from your user default when they are set, overwriting presets where applicable. If no user defaults are set then this option is ‘greyed’ out and cannot be selected.

Accept - This option accepts your entered parameters for this print only, reverting to defaults next time the report is run.

Save - Depending on whether the user is configured as an ‘Install’ user then the next option will be SAVE. This saves your set parameters so they are offered as default next time this report is run (Note: this is system wide not per user). Setting the user as an ‘Install’ user is achieved through the user configuration available under the MASTER sign-on.

Abandon - This option abandons any changes made and returns you to the report screen.

The report parameters available are:

Paper Size – select the paper size the report is to be printed to (i.e. A4).

Default Printer Font – a font dialog is displayed allowing you to select as required, the default font to be used for this report

Selecting the Font Size

Generally you can’t go far wrong with 10point. However, if you have a lot of data items on your report, and are printing in portrait, 10point may be too big to fit all the required information without overlapping fields.

The positioning of fields across the page is determined by the item size – if you imagine a report that shows, the record number (6 characters), transaction date (8), the reference (6), the description (20), the amount (14), the tax code (3 – as field name of TAX is longer than field then the print size is based on name), the tax amount (14) and total (14), together with spaces between the items this gives a total of 103 characters, or columns required, across the page (think graph paper – you have 103 ‘cells’ across the page).


Those 103 columns are split equally across the available page (page size and margins taken into account) as starting positions for data items – so the record number starts at column 1, the date at column 8 (record number plus 1), etc. If you select a font size too big then the record number may not finish printing before the date starts causing the date to overlap the end of the record number. If this occurs then you may need to either reduce the font size or consider swapping the report to landscape orientation if the font size would go too small.

Print in Landscape – set to default the printed report to landscape, leave blank for usual portrait orientation. You may want to set larger width reports to landscape as these reports require a large amount of detail to be printed and otherwise the font size required to fit all the text could be too small.

Show Time in Report Headings – set to include the printed time in the report headings in addition to the printed date.

Include Selection Criteria – set to print any selection criteria that were applied to the report.

Email as Text Attachment – if send this report via email this option allows you to send as a text file attachment as opposed to, if left blank, PDF.

Omit Full Page Headings – When printing a multi-page report the system repeats the headings for each page. Setting this option reduces the heading details for the second and subsequent pages allowing more record detail to be printed per page.

Default Output to Spooler – Usually, when printing a report, the default printer is the last print device used. Select this option to set the default printer as the spooler for this report.This acts only as a default and doesn’t prevent you electing to print the report instead.

Allow Change of Printer Alias – when these options are configured then it is assumed you are printing as ‘direct windows print’ and this is the alias set by default. Setting this option allows you to change the default alias at run-time to one of the list of Datafile configured printers. If you change the alias to a ‘DOS’ style alias then the page size (length/width) and font are again picked up from the Print Style Profile, although other settings such as ‘include time’ etc. remain from the OPTIONS display.

Print Negatives in Red – on selected reports, assuming you have a colour printer; it may be useful to print negative values in red. This option allows this.

Allow Excel Pivot Table / Default Output to Pivot Table – set whether the report is to allow printing to an Excel pivot table and whether, if allowed, should default to pivot table. Would be unusual to do this for most reports.

Characters Per Line – the system displays the width of the report items on the right. If you leave this value at 0 (recommended) then the report width used in determining the start column positions of data items (as discussed above with regards to font size) is the larger of either the report print items or 80 columns.You can manually set a report width – from 64 to 255 columns. You may want to increase the number of columns on (say) a landscape report with few print items to bring the fields closer together to aid in reading.

Lines Per Page – if left at 0 (recommended) then the number of lines per page is determined by the font and page size. Alternatively you can set a number of lines per page, perhaps to give a greater gap between rows of data items.

Left Margin (mm) – set the size of the left hand margin (relative to page orientation in millimetres.

Right Margin (mm) – set the size of the right hand margin.

Top Margin (mm) – set the size of the top margin.

Bottom Margin (mm) – set the size of the bottom margin.

Default Printer – if using a stand-alone Datafile system then you can set a default printer to output to. This option only applies when sending to a print device; if last printer was spooler or fax then this remains the default. If using a networked Datafile system then you can still set this where you are printing to a networked printer – provided all terminals have a consistent device path. If the print device isn’t valid then the normal printer is offered instead.

Send to Email – if the report is sent to email then here you can enter an email address that is to be used by default for this report – though it can be amended at run-time.

Excel Template – this option allows you to reference a template for use when printing to a pivot table which would allow formatting of the output. Once a file is set here then on first use the template will be created based on the standard layout (this can subsequently be modified within Excel itself), subsequent use will use the existing template.

Once you’ve set the desired parameters select the ACCEPT option to apply the settings for this print or, if available, the SAVE option to apply for this and future prints.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Application Differences - Nominal Ledger Revaluations - Revalue a Nominal Account
Viewed 914 times since Tue, Jun 26, 2012
Expand Data Files
Viewed 877 times since Tue, Jun 26, 2012
Application User Facilities
Viewed 847 times since Tue, Jun 26, 2012
Currency Codes
Viewed 938 times since Tue, Jun 26, 2012
System Status
Viewed 856 times since Tue, Jun 26, 2012
Nominal Ledger
Viewed 980 times since Tue, Jun 26, 2012
Converting Existing Ledgers - Sales & Purchase Ledgers - Database Changes
Viewed 955 times since Tue, Jun 26, 2012
Converting Existing Ledgers - Stock Control - Database Changes
Viewed 959 times since Tue, Jun 26, 2012
Database Structures
Viewed 819 times since Tue, Jun 26, 2012
Spot Rates Report
Viewed 825 times since Tue, Jun 26, 2012