Home - All Categories - Solutions by Business Process - Finance - Currency

Application User Facilities - Currency Maintenance

Datafile Software Application User Facilities - Currency Maintenance The Currency Maintenance option allows you to design the maintenance screen for the currency. On selection the current design is displayed. To enter text on the screen,...

Application Differences - Sales & Purchase Ledger Revaluations - Spot Rate Revaluation

Datafile Software Application Differences - Sales & Purchase Ledger Revaluations - Spot Rate Revaluation Where a spot rate revaluation is required the following steps would normally be taken. Alter the spot rates via the Currency Maintenance...

Foreign Currency Considerations

Datafile Software Foreign Currency Considerations This first section describes the principles on which Datafile Software based its foreign currency implementation; the terminology used in this manual; and the considerations to think through when...

Currency Principles

Datafile Software Currency Principles This section describes how Datafile Software foreign currency procedures operate. In general, financial management reporting needs to have a common unit of measure if a clear picture of a company’s...

Currency Rates File

Datafile Software Currency Rates File No Item Name Type Description 1 CODE X (8) Prime Index. Holds a combined code of the currency code and the period for which it applies. 2 01-RATE M Daily Spot Rate for the 1stof a month 3 02-RATE M Daily...

Application Differences - Cashbook - Cashbook Transactions

Datafile Software Application Differences - Cashbook - Cashbook Transactions Receipt and payment transactions can apply to base currency or foreign currency bank accounts. However, if a foreign currency bank account is used, then only that...

Daily Spot Rate History Changes

Datafile Software Daily Spot Rate History Changes The daily spot rate history feature can be used, as explained above, in certain sectors of commerce as an alternative to holding rates.In such cases each transaction is valued at the time it is...

Application Differences - Nominal Ledger - Nominal Transactions

Datafile Software Application Differences - Nominal Ledger - Nominal Transactions Nominal journals offer an additional prompt for currency.You can leave this blank, in which case transactions could be in a mix of currencies, or enter a specific...

Recall Standard Text

Datafile Software Recall Standard Text Recall Standard Text allows you to attach a word or phrase to a specific key combination (such as + ). Up to fifteen phrases can be entered and these are available for update into a...

Database Audit

Datafile Software Database Audit Use this option to check the internal integrity of any of the currency files. If you’re sure that a particular record is in the file but you cannot select it via the indexes then you might want to use this...

Ledger Enquiry Manager

Datafile Software Ledger Enquiry Manager There are no specific ledger enquiry options for the foreign currency system although, when introducing foreign currency into an existing system, you may want to amend the sales ledger, etc., to include...

Nominal Ledger Revaluations

Datafile Software Nominal Ledger Revaluations The need to revalue nominal ledger accounts normally comes about only due to changes of holding rate. Even in this event only certain balance sheet accounts may need to be revalued. Note that...

Nominal Ledger

Datafile Software Nominal Ledger The essence of the foreign currency nominal ledger is that all transactions are converted to base currency values. However, account balance and transaction details are also held in the foreign currency for all...

Converting Existing Ledgers - Sales & Purchase Ledgers - Database Changes

Datafile Software Converting Existing Ledgers - Sales & Purchase Ledgers - Database Changes New items are required on both the accounts and transaction files. In addition it has to be assumed that all existing accounts and transactions are...

Select Key Definition

Datafile Software Select Key Definition Whenever you press against a database within the currency maintenance the details displayed can be configured to show what you require. This is done via the ‘Select Key Definition...

Converting Existing Ledgers - Nominal & Cashbook - Menu Design

Datafile Software Converting Existing Ledgers - Nominal & Cashbook - Menu Design Options need to be added to support the revaluation of transactions and adding the option for the currency audit trail and bank statement reports. Nominal Menu...

Application Differences - Sales & Purchase Ledger Revaluations - Holding Rate Revaluation

Datafile Software Application Differences - Sales & Purchase Ledger Revaluations - Holding Rate Revaluation Should a management decision be taken to alter a holding rate, then a holding rate revaluation can be done. This is usually...

Application Differences - Cashbook - Bank Reconciliation

Datafile Software Application Differences - Cashbook - Bank Reconciliation Foreign bank accounts are automatically reconciled in the currency of the account.

Converting Existing Ledgers - Order Processing - Database Changes

Datafile Software Converting Existing Ledgers - Order Processing - Database Changes New items are required on both the order header and detail files. In addition it has to be assumed that all existing accounts and transactions are held in the...

Holding Rate Changes

Datafile Software Holding Rate Changes A screen similar to the one below is displayed. The currency is a three-character code, and you may use the key to see which currencies are defined, and which one to select for changing....

Converting Existing Ledgers - Nominal & Cashbook - Database Changes

Datafile Software Converting Existing Ledgers - Nominal & Cashbook - Database Changes New items are required on both the accounts and transaction files. In addition it has to be assumed that all existing accounts and transactions are held in...

Currency Codes

Datafile Software Currency Codes No Item Name Type Description 1 CODE X (3) Prime Index. Holds the three-letter identifier for the currency. 2 NAME X (30) Secondary Index. Holds the currency name. 3 SHORT-NAME X (10) Secondary Index. Holds short...

Controls & Audit Manager

Datafile Software Controls & Audit Manager The Controls and Audit Manager contains all the utility routines used to check the integrity of the database files, and to undertake various housekeeping actions. The tools supplied allow: Check...

Converting Existing Ledgers

Datafile Software Converting Existing Ledgers If you purchase the Foreign Currency application on initial installation of your system then the databases, menus and screens are configured to allow input and reporting of foreign currency values....

Sales and Purchase Ledger Revaluations

Datafile Software Sales and Purchase Ledger Revaluations The menu Currency Options, applicable for systems where the Foreign Currency application is in use, allows utilities to revalue outstanding invoices and credits via both Holding Rate...

Edit System Status Display

Datafile Software Edit System Status Display Displays the number of records in use and reserved in the currency codes and rates file.

Converting Exisiting Ledgers - Stock Control - Screen Design

Datafile Software Converting Exisiting Ledgers - Stock Control - Screen Design If using the option to record the stock cost in the currency of the supplier then you need to update the stock maintenance screen(s) to include these items. You may...

Converting Existing Ledgers - Stock Control - Database Changes

Datafile Software Converting Existing Ledgers - Stock Control - Database Changes New items are required on the transaction file and optional items can be added to the stock file. In addition it has to be assumed that all existing transactions are...

Application Differences - Invoicer, SOP & POP Applications - Order Processing Order Revaluation

Datafile Software Application Differences - Invoicer, SOP & POP Applications - Order Processing Order Revaluation Two options are available to the order processing systems to allow you to revalue the outstanding values on foreign currency...

Application Differences - Nominal Ledger - Year-End Procedures

Datafile Software Application Differences - Nominal Ledger - Year-End Procedures These operate exactly as for the standard ledger, except that when posting income and expenditure accounts to the profit and loss account, the currency values of...

Set Auto Expand Data Files

Datafile Software Set Auto Expand Data Files Datafile reserves a fixed space for database files and you need to expand that space should the file become full. This option allows you to set internal system parameters, so that it automatically...

Application Differences - Nominal Ledger - Reports

Datafile Software Application Differences - Nominal Ledger - Reports Even though you have installed foreign currency, all the standard reports print in the base currency. As such, there are no differences in the nominal ledger reporting...

Stock Control

Datafile Software Stock Control The stock control system essentially works in the base currency.Where stock movements are created through the sales and purchase order processing systems, and are processed in the currency of the account, then...

Converting Existing Ledgers - Sales & Purchase Ledgers - Menu Design

Datafile Software Converting Existing Ledgers - Sales & Purchase Ledgers - Menu Design Options need to be added to support the revaluation of transactions. Menu changes are enabled via the CONFIG sign-on. The menu changes are all held on a ...

Currency Management

Datafile Software Currency Management Before you can start to use the foreign currency features within your applications, you must first define some currencies and exchange rates. The application which manages your foreign currencies must be...

Application Differences - Nominal Ledger - Account Maintenance

Datafile Software Application Differences - Nominal Ledger - Account Maintenance Each account in the nominal ledger should have a currency allocated to it. In the absence of a currency code being allocated (for example if using the "New/Amend...

Application Differences - Cashbook - Bank Statements

Datafile Software Application Differences - Cashbook - Bank Statements The bank statement option under Bank Reconciliation only prints accounts in the base currency. If you use it on non-base currency accounts, you get a statement printed in the...

Cashbook

Datafile Software Cashbook As with the nominal ledger, the essence of the foreign currency cashbook is that all transactions are converted to base currency values. However, account balance and transaction details are also held in the foreign...

Spot Rate Changes

Datafile Software Spot Rate Changes These spot rates are used only for statutory revaluation purposes, so in practice you are likely to change spot rates only for the period you are working on. This program option works just like the holding...

Clear Old Rates

Datafile Software Clear Old Rates As noted above, a daily spot rate history record can be created for each currency for each month of each year as time progresses.However, the rate used is itself written into the transaction records, so these...

Configuration

Datafile Software Configuration Your Datafile Software ledger systems have a wide range of possible facilities, and you can undertake a great amount of structuring so that it suits your particular operation. This section describes how to use the...

Application Differences - Nominal Ledger - Updates from Other Systems

Datafile Software Application Differences - Nominal Ledger - Updates from Other Systems These operate exactly the same as for the standard nominal ledger. However, where updates are made from foreign currency transactions, then the currency...

Application Differences - Nominal Ledger Revaluations - Revalue a Nominal Account

Datafile Software Application Differences - Nominal Ledger Revaluations - Revalue a Nominal Account This procedure allows accounts to be selected one-by-one for revaluation, ether at the current holding rate or spot rate. Any exchange difference...

Expand Data Files

Datafile Software Expand Data Files If not setting the auto-expand options then this option allows you to manually expand the data files as necessary.

Application Differences - Sales & Purchase Ledgers - Allocating Transactions

Datafile Software Application Differences - Sales & Purchase Ledgers - Allocating Transactions Transaction allocation is done in the currency for the account so that an exact match can result. However, although the result of the allocation...

Compact & Audit Database

Datafile Software Compact & Audit Database The internal processing of databases does not necessarily re-use the space occupied by records that have been deleted. New records are always added to the end of the file. Therefore, over a period...

Converting Existing Ledgers - Nominal & Cashbook - Database Profiles

Datafile Software Converting Existing Ledgers - Nominal & Cashbook - Database Profiles The items added need to be updated into the Database Profiles for the Nominal Ledger (or Cashbook). Items added are referenced within A/C Currency – 1,...

Converting Existing Ledgers - Stock Control - Menu Design

Datafile Software Converting Existing Ledgers - Stock Control - Menu Design Options can be added to support the revaluation of orders. Menu Options Parameter Revalue A Order 1007 Revalue All Active Orders 1008

Document Design Manager

Datafile Software Document Design Manager Whilst there are no specific currency documents, documents for other applications can include currency details. Sales and Purchase Ledger Statements and Remittances are usually printed in the currency...

Set Application Code Formats

Datafile Software Set Application Code Formats Whist the code format for the currency and rates files are pre-determined this parameter screen does contain two parameter settings which relate to the foreign currency system. Company This is the...

Application Differences - Nominal Ledger Revaluations - Revalue All Nominal Accounts

Datafile Software Application Differences - Nominal Ledger Revaluations - Revalue All Nominal Accounts This option operates as above but allows the ability to revalue all, or selective, nominal accounts for a particular currency in one process...

Application Differences - Sales & Purchase Ledgers - Entering Payments and Payment Adjustments

Datafile Software Application Differences - Sales & Purchase Ledgers - Entering Payments and Payment Adjustments For payments on non-base rate currency accounts, the same total value, exchange rate, converted value and fixed rate questions...

System Profiles

Datafile Software System Profiles The System Profiles set the general configuration options for the currency system. Base Currency for this Company Enter here the three-character code of the currency defined as the base currency for this...

Converting Existing Ledgers - Sales & Purchase Ledgers - Screen Design, Reports and Statements

Datafile Software Converting Existing Ledgers - Sales & Purchase Ledgers - Screen Design, Reports and Statements The only mandatory change is to provide an option on the accounts maintenance screen(s) to enter the currency code for the...

Maintain Currency

Datafile Software Maintain Currency This option is used to add, change details of, view, or delete a currency from the system. With any of the sub-options of this menu choice are taken, a screen similar to the one shown below is presented. (Note...

Converting Existing Ledgers - Stock Control - Database Profiles

Datafile Software Converting Existing Ledgers - Stock Control - Database Profiles The items added need to be updated into the Database Profiles for Stock Control. Items added are referenced within Stock Optional 2 for the stock file and Trans...

Application Screen Layouts

Datafile Software Application Screen Layouts This option allows access to the ‘Maintain Currency’ section of the Application User Facilities. Refer to this section above for further details.

Invoicer, SOP and POP Applications

Datafile Software Invoicer, SOP and POP Applications In all three of these programs it is assumed that the values entered are in the currency of the account. When the sales or purchase ledger is posted after printing an invoice, then the...

Converting Exisiting Ledgers - Order Processing - Database Profiles

Datafile Software Converting Exisiting Ledgers - Order Processing - Database Profiles The items added need to be updated into the Database Profiles for Order Processing. Items added are referenced within Header Optional 2 for the order header...

Application Differences - Sales & Purchase Ledgers - Reporting Differences

Datafile Software Application Differences - Sales & Purchase Ledgers - Reporting Differences When printing a report or statement in the Sales or Purchase Ledger an additional parameter asks: Report Which Currencies There are three choices...

List of Currencies Report

Datafile Software List of Currencies Report This report lists all the currencies so far defined — codes, short name and full name.

Converting Existing Ledgers - Nominal & Cashbook - Screen Design and Reports

Datafile Software Converting Existing Ledgers - Nominal & Cashbook - Screen Design and Reports The only mandatory change is to provide an option on the accounts maintenance screen(s) to enter the currency code for the account.You may want to...

Security and User Manager

Datafile Software Security and User Manager The Security and User Manager allows you to set authority levels and passwords on specific application options and to define any user authority overrides. After selecting the application two screens...

Application Differences - Sales & Purchase Ledgers - Account Enquiry

Datafile Software Application Differences - Sales & Purchase Ledgers - Account Enquiry Although, by default, the transactions are listed in the base currency an additional option is offered to you under the facilities, to...

Application Differences - Sales and Purchase Ledgers - Account Maintenance

Datafile Software Application Differences - Sales and Purchase Ledgers - Account Maintenance The currency code to be used for each account must exist as a part of the account maintenance screen design (see installation procedures below). When a...

Database Structures

Datafile Software Database Structures The database structures for the currency code and rates files are fixed. User changes are allowed but only towards the end of the file.

Application Differences - Sales & Purchase Ledgers - Entering Invoices, Credits and Adjustments

Datafile Software Application Differences - Sales & Purchase Ledgers - Entering Invoices, Credits and Adjustments Foreign currency transactions are entered in the currency of the account, but the conversion rate and the base currency values...

Converting Existing Ledgers - Sales & Purchase Ledgers - Database Profiles

Datafile Software Converting Existing Ledgers - Sales & Purchase Ledgers - Database Profiles The items added need to be updated into the Database Profiles for the Sales and Purchase Ledgers. Items added are referenced within Account Currency...

Sales Nominal Codes & Purchase Nominal Codes Report

Datafile Software Sales Nominal Codes & Purchase Nominal Codes Report These reports list the additional nominal codes (exchange and revaluation differences etc.) defined for each currency for your reference.

Converting Exisiting Ledgers - Order Processing - Screen Design and Documents

Datafile Software Converting Exisiting Ledgers - Order Processing - Screen Design and Documents Changes are required to the order detail entry screen – when using the designable entry screen – to replace the displays of COST/PRICE and DETAIL...

Application User Facilities - Reports

Datafile Software Application User Facilities - Reports Here you define how the currency reports are to print.For most reports the parameters you must give include the print style (type of printing) and the data items to print. The set-up for...

Currency Rates Report

Datafile Software Currency Rates Report This report lists all the currencies together with the holding and revaluation spot rates which applied as at the "As At” date supplied when you initiated the report.

Holding Rates Report

Datafile Software Holding Rates Report This report lists the holding rates which apply for each period for each currency. It prints one page per currency. In addition to the standard report pre-ample given above, you are asked two extra...

System Status

Datafile Software System Status This option supplies information about the currency files, including the size of the files, records in use and the base currency for the system.

Spot Rates Report

Datafile Software Spot Rates Report This report gives you the daily spot rate history, listing the last three month’s rates — one page per currency. In addition to the standard report pre-ample given above, you are asked two extra...

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...

Application Differences - Cashbook - Account Maintenance

Datafile Software Application Differences - Cashbook - Account Maintenance Each account in the cashbook should have a currency allocated to it. In the absence of a currency code being allocated (for example if using the "Account Codes / Names”...

Application User Facilities

Datafile Software Application User Facilities The Application User Facilities allow configuration of the individual Foreign Currency options. The options – Period Holding Rates, Period Spot Rates, Daily Spot Rates, Clear Old Rates and System...