Currency Codes

This screen allows you to define currency codes and maintain ongoing exchange rates against each code.  The Currency Code routine has three screens:

List: showing the Currency Codes that are in Ostendo

Detail: The Currency Code maintenance screen

Rates: For entry of exchange rates

 

 

List Tab

 

Display fields

 

The displayed fields are taken from the Currency Code details entered into the ‘Detail’ tab.  The selection of which fields to display is at the user’s discretion.  To select the fields to display simply ‘right mouse’ in the main panel and select ‘Customize List Fields’.  On the displayed panel you can:

•

Click on the ‘Show field’ checkbox to display the field

•

Amend the column heading by changing the content of ‘Display Label’

•

Define the sort sequence of the records by going to the lower panel and dragging the field from ‘Available Fields’ to ‘Sort By’.

•

Click the ‘Save’ Button when done.

 

Data Display Options

 

Field Position - On the List screen you can move the field position by dragging the column heading left or right to the position where you want it to appear.

 

Filtering and Sorting - If you ‘check’ the checkbox then the displayed data is available for filtering and sorting:

•

To sort the data in a selected column simply click on the column heading.  Clicking against will sort in descending order.

•

Click on the black ‘down arrow’ to the right of your selected column heading and you can either select a specific entry to display all records containing that entry, or you can select (Custom…) to enter detailed selection criteria.

 

Searching - If you enter some text into the ‘Search’ field and click on the ‘binoculars’ Icon then all records will be interrogated and those records that contain the entered text will be displayed.   To revert back to displaying all records click on the ‘Eraser’ Icon

 

Buttons

 

Close: This will close the Currency Codes screen.  If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

 

Add: This will bring up the ‘Detail’ tab for entry of a new Currency Code

 

Save: Not applicable to the List panel

 

Cancel: Not applicable to the List panel

 

Delete: This removes the current Currency Code from this table

 

Related: This will bring up a list of functions that are related to Currency Codes. 

 

Reports: This will bring up a list of Reports that are related to the Currency Code.  You can immediately run the report whilst still remaining in the Currency Code screen.

 

 

Detail Tab

 

Entry and Display fields

 

Currency Code: Enter the Currency Code.  This is normally 3 characters and duplicate codes are not allowed.  For your information here are a few of the more common currencies and the International Codes relating to them

 

AED United Arab Emirates Dirham

AUD Australian Dollar

CAD Canadian Dollar

CHF Swiss Franc

CNY Chinese Yuan Renminbi

EUR Europe

GBP British Pound

HKD Hong Kong Dollar

INR Indian Rupee

JPY Japanese Yen

NZD New Zealand Dollar

RUB Russian Rouble

SGD Singapore Dollar

THB Thai Baht

USD US Dollar

ZAR South African Rand

 

Symbol: Enter the Currency Symbol that represents this currency.  Here are a couple of ways to enter the Currency Symbol if the symbol is not on your keyboard

 

1.  Go into Microsoft Word and select 'Insert' on the top toolbar.  In the dropdown list select ‘Symbol’.  You can now select the symbol and ‘Insert’ into the word document.  From there you can copy the symbol and paste it into this field

 

2.  Set your keyboard with ‘Numerics Lock’.  Using the enabled numbers due to the Numerics Lock being on (I.e. NOT the numbers 0 to 6 on the top row of the keyboard) you should place the cursor where the symbol is to appear and then - holding down the ‘Alt’ key - enter

 

0128 for the Euro (€)

0163 for the Pound (£)

0165 for the Yen (¥)

 

Description: Enter a short description of the Currency.  No checks are carried out on this entry.

 

Foreign Purchase Receipts: From the drop-down list select the Cost Centre that will be used for the Purchase Receipt Cost for the above Currency.

 

Foreign Debtors Control: From the drop-down list select the Cost Centre that will be used for the Debtors Control Account for the above Currency. 

 

Foreign Debtors Exchange: From the drop-down list select the Cost Centre that will be used for the Exchange Account in MYOB for the above Currency.

 

Foreign Unapplied Deposits: From the drop-down list select the Cost Centre that will be used for the Unapplied Deposits for the above Currency. 

 

Foreign Unapplied Payments: From the drop-down list select the Cost Centre that will be used for the Unapplied Payments for the above Currency. 

 

Foreign Discounts Given: From the drop-down list select the Cost Centre that will be used for Discounts Given for the above Currency. 

 

Foreign Payment Rounding: From the drop-down list select the Cost Centre that will be used for Payment Rounding for the above Currency. 

 

Exchange Gain or Loss: From the drop-down list select the Cost Centre that will be used for Exchange Rate Gain or Loss for the above Currency. 

 

Foreign Payment Charge: From the drop-down list select the Cost Centre that will be used for additional Finance Charges for the above Currency. 

 

Multi-Site Cost Centres (Button): If you click on this button you will be taken to a separate screen for entry of Cost Centre Codes covering Multi-Currency by Site using the above Transaction Types

 

Notes: Extended Notes held against this record as entered in the ‘Detail’ screen

 

 

Buttons

 

Close: This will close the Currency Code screen.  If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

 

Add: This will bring up a blank ‘Detail’ screen for entry of a Currency Code.

 

Save: This will save the current data without exiting the screen

 

Cancel: Any changes made since the screen was opened or the last time the ‘Save’ Button was pressed will be lost.

 

Delete: Not active in this view

 

Related: This will bring up a list of functions that are related to the Currency Code.  You may open and maintain information in those screens whilst still remaining in the Currency Code screen.

 

Reports: This will bring up a list of Reports that are related to the Currency Code.  You can immediately run the report whilst still remaining in the Currency Code screen.

 

 

Rates Tab

 

Entry and Display fields

 

Rate Type: From the drop-down list select the Rate Type.  The options are:

 

Fixed Term: The Exchange Rate will be effective within the date range.  A Fixed Term Rate always takes preference over a Floating Rate.

Floating: The Exchange Rate will be effective from the ‘Effective From’ date and will supercede a ‘Floating’ Rate containing a prior ‘Effective From’ date

 

Effective From: From the drop-down calendar select the effective start date when this exchange rate becomes effective

 

Effective To: This is only active for ‘Fixed Term’ Rate Types.  From the drop-down calendar select the effective start date when this exchange rate becomes effective

 

Exchange Rate: Enter the Exchange Rate that will convert from your home currency to the foreign currency.  For example, if this currency was AUD and your home currency was NZD and the exchange rate was 1 NZD = 0.8 AUD then you should enter 0.8

 

Buttons

 

Close: This will close the Currency Code screen.  If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

 

Add: This will send the cursor to a new line for entry of a new Rate

 

Save: This will save the current data without exiting the screen

 

Cancel: Any changes made since the screen was opened or the last time the ‘Save’ Button was pressed will be lost.

 

Delete: This removes the current highlighted Currency Rate record

 

Related: This will bring up a list of functions that are related to the Currency Code.  You may open and maintain information in those screens whilst still remaining in the Currency Code screen.

 

Reports: This will bring up a list of Reports that are related to the Currency Code.  You can immediately run the report whilst still remaining in the Currency Code screen.