Maintain Foreign Currency {FCSO-21}


The Debtor, Creditor, Cashbook, Research and Long-term Loans systems can accommodate transactions for foreign currencies. 


In this three (3) panel box option, users can define the types of rates that are valid for each of the abovementioned systems. The Debtor and Cashbook systems can accommodate multiple types of rates.  The types of rates being: 

Various foreign currency codes can be defined for foreign countries. Users can decide which type of rates applies to each of the currency codes along with the applicable exchange rates. Thus, a foreign currency can have exchange rates for each of the types of rates mentioned above. Users can also define whether the exchange rates can be updated when used in the financial systems.  

Fields in the option:

Panel Box 1:  Subsystem Type of Exchange Rates

Field Type
&
Length
Description
Subsystem A2  This field is not updateable by the user. The subsystems to which Type of Rates can be linked to are:

Subsystem Code Subsystem Description
AR Accounts Receivable
CB Cashbook
CT Counter System
IM Research System
PM Procurement Management
SD Student Debtors
Type of Document A2 This field is not updateable by the user. The only documents that are valid for foreign exchange transactions are indicated as follows :

Subsystem  Type of Document
AR ACCOUNT RECEIVEABLE AL All documents
CB CASHBOOK EX Expense
CB CASHBOOK IN Income
CT COUNTER SYSTEM EX Expense
CT COUNTER SYSTEM IN Income
IM RESEARCH SYSTEM AL All documents
PM PROCUREMENT MANAGEMENT AL All documents
SD STUDENT DEBTORS BL Bursary/loans
SD STUDENT DEBTORS DC Manual journals
SD STUDENT DEBTORS IC Cancel Invoice
SD STUDENT DEBTORS RF Raise financial debits.
Type of Rate A1 Supply the Type of Exchange Rate applicable to the subsystem. The user must now define for each subsystem what type of exchange rate must be applied. For example, the institution may decide to raise fees, in respect of foreign students, at a set fee irrespective of the fluctuating exchange rate. The Type of exchange rate for the subsystem SD, type of document RF will then be set to (F)ixed rate of exchange. Users must note that should they apply (F)ixed rate, it is intended to be fixed for the medium to long term. With reference to our example, the institution may decide that the fee to be raised for foreign students is revised on an annual basis and thus the (F)ixed rate of exchange will remain in force for one year. Other valid values for this field are (B)uy, (S)ell and (N)ormal
Updateable A1 When processing transactions, may the user update foreign currency exchange rates, (Y)es or (N)o.

The persons Student Debtors {SREGB-1}, Accounts Receivable Debtors {FARO-21} and Creditors {FPMM-2} are defined with a currency. If the currency of the person and the currency of the institution {GCS-1} are not the same, transactions for the person are processed in the person currency. When transactions are processed the currency amount is converted to local currency using the exchange rate for the rate type and date as  indicated else an exchange rate of one (1) is used.

Local Currency Transactions
If the currency of the person and the currency of the institution are the same it means the transaction is processed in local currency and the field exchange rate fixed and the exchange rate is not updateable in applications where these fields are displayed.

Foreign Currency Transaction
If the currency of the person and the currency of the institution are not the same it means the transaction is processed in foreign currency.
  • Exchange Rate Updateable = No
    • The fields Exchange Rate Updateable and the Exchange Rate are  not updateable in applications where these fields occur. 
    • An variations of the rule applies with in the PM system, if the document is copied form another document in the PM document hierarchy and the copied Exchange Rate Updateable is set to Yes, both the fields Currency Fixed and Exchange rate are updateable.
  • Exchange Rate Updateable = Yes
    • The fields Exchange Rate Updateable and the Exchange Rate are updateable in applications where these fields occur. 
    • An variations of the rule applies with in the PM system, if the document is copied form another document in the PM documents  hierarchy and the copied Exchange Rate Updateable is  No, neither  the fields Currency Fixed or Exchange rate are updateable.  

Example:

fcso-21b1p1i1.jpg



Panel Box:  Fixed Foreign Currencies

On this panel box, users can define currency codes and descriptions for those foreign countries with which they have dealings with and indicate the exchange rates for those whom the (F)ixed type of rate applies. For those whom the (F)ixed type of rate does not apply, the rate of exchange will be set to 0.000. Fluctuating rates of exchange are defined on panel box 3 and not here. Thus, when applying rates on this panel box, it is implied that the rate is for the medium to long term period and should not be adjusted too often.


Field Type
&
Length
Description
Code A3 Define suitable currency codes for foreign countries.
Name A30 Supply a suitable description to describe the foreign currency codes defined above.
Exchange Rate N4.3 Supply the rate of exchange, in the institution's own currency, which is equivalent to one (1) foreign currency.

Example, one (1) USD is fixed at R6.00. Should the currency of the institution be SAR - SA Rand, the rate here would be  6.000 for the foreign currency code USD - US Dollar.

Note : Only supply rates of exchange to those foreign currencies for which the (F)ixed type of rate applies.
Denomination Rounding Factor
N5.2

The Denomination Rounding Factor per currency is used to allow the system to handle a situation where denominations of that currency are discontinued, or where an institution prefer not to accept specific denominations of a currency when cash payments are received through the counter system on {FCTO-3}.


Example:

fcso-21b2p1i1.jpg



Panel Box 3:  Variable Foreign Currencies

On this panel box, users indicate, for the foreign currencies defined on panel box 2, the rates of exchange for the (B)uy, (S)ell and/or (N)ormal type of rates. Fixed rates of exchange are defined on panel box 2 and not here. Thus, when applying rates on this panel box, it is implied that the rate is of a fluctuating nature and therefore can be changed at any time.

Field Type
&
Length
Description
Currency Code A3 A <LIST OF VALUES> containing foreign currency codes which are defined on panel box 2 is available. Users cannot create new foreign currency codes here. Should new foreign currency codes be required for this panel box, they must be defined on panel box 2 with an exchange rate of 0.00.
Description A30 The name will default from panel box 2 where the currecny code name is defined. The name cannot be updated here.
Date DD-MON-YYYY Supply the date from when the rate of exchange is effective.
Type of Rate A1 Indicate whether the (B)uy, (S)ell and/or (N)ormal type of rate is applicable to the currency code. 
Exchange Rate N5.3 Supply the rate of exchange, in the institution's own currency, which is equivalent to one (1) foreign currency.

Example, one (1) USD is equivalent to R6.00 SAR. Should the currency of the institution be SAR - SA Rand, the rate here would be 6.000 for the foreign currency code USD - US Dollar.
Orders Updated Y/N Have orders been updated (Y)es or (N)o. This field is not updateable by the user and is only updated when the exchange rate calculation program is run on Update Document button.
User A8 On <COMMIT> of this panel box, the user who updated Type of Rate and Exchange Rate above is recorded here.
  All updates to this option are written to a log file. The log file can be found on menu option {FCSMR1-3} option 17.


Example:

fcso-21b3p1i1.jpg




Processing
Rules
 
  No special processing rules


See Also:



History Of Changes

Date System Version By Whom Job Description
25-Apr-2007 v01.0.0.0 Amanda Nell t133479 New manual format.
28-Apr-2009 v01.0.0.1 Marchand Hildebrand i160208 Better describe the function of the field currency updateable
07-Mar-2013
v03.0.0.0
Christel van Staden
t186723
Add Denomination Rounding Factor
27-Jun-2013
v03.0.0.1
Nokuthula Mafenuka
t191714
Edit field name description
05-Dec-2016 V04.0.0.0 Morgan Ntshabele T208911 Removed any reference to discontinued "Investment" and "Long Term Loans" Subsystems
20-Aug-2019 V04.1.0.0 Zainib Essop T236416 Updated Manual