(Created page with "''Menu: Tools | Maintain Currency...'' =='''Introduction'''== * You can create and set the currency and the exchange rate. * Default currency (----) is your based currency. :...") |
No edit summary |
||
(12 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
''Menu: Tools | Maintain Currency...'' | ''Menu: Tools | Maintain Currency...'' | ||
== | ==Introduction== | ||
:1. Currency use to convert the foreign value into local value by multiplying with the defined exchange rate. | |||
:2. You can create and set the currency and the exchange rate. | |||
::[[File:Maintain | :3. Default currency (----) is your based home currency. For example, your Financial Reports currency is SGD, then you should rename the default currency's description and symbol to "SINGAPORE DOLLAR" and "SGD" respectively. | ||
::[[File:Maintain Currency-Browse.jpg |540px]] | |||
<br /> | <br /> | ||
== | ==Create New Currency== | ||
Screenshot below is the | : Screenshot below is the Currency entry form. | ||
::[[File:Maintain | ::[[File:Maintain Currency-Entry Form.jpg |540px]] | ||
{| class="wikitable" | ::{| class="wikitable" | ||
|- | |- | ||
! Field Name !! Explanation & Properties | ! Field Name !! Explanation & Properties | ||
|- | |- | ||
| | | Currency || | ||
* Input the new | * Input the new currency code | ||
* Field type : Alphanumerical | * Field type : Alphanumerical | ||
* Length : | * Length : 6 | ||
|- | |||
| Symbol || | |||
* Input the ISO Currency code, eg MYR, SGD, USD, etc. | |||
* Field type : Alphanumerical | |||
* Length : 6 | |||
|- | |- | ||
| Description || | | Description || | ||
* Input the | * Input the Currency description | ||
* Field type : Alphanumerical | * Field type : Alphanumerical | ||
* Length : | * Length : 30 | ||
|- | |||
| We BUY at rate || | |||
* Exchange rate relate to PURCHASE module | |||
* Field type : Numeric | |||
|- | |||
| We SELL at rate || | |||
* Exchange rate relate to SALES module | |||
* Field type : Numeric | |||
|} | |||
<br /> | |||
==Create Periodic Exchange Rate Table== | |||
:1. You can define periodic exchange rate from date to date. | |||
:2. Click on the (+) sign to insert or (-) sign to remove. See below screenshot. | |||
::[[File:Maintain Currency-Entry Form-Periodic Currency2.jpg |540px]] | |||
<br /> | |||
:3. See below screenshot as example. | |||
::[[File:Maintain Currency-Entry Form-Periodic Currency.jpg |540px]] | |||
::{| class="wikitable" | |||
|- | |||
! Doc Type !! Doc Date !! Exchange Rate | |||
|- | |||
| Sales Invoice || 02/01/2013 || SellingRate = 3.2055 | |||
|- | |||
| Cash Sales || 15/02/2013 || SellingRate = 3.1890 | |||
|- | |||
| Purchase Invoice || 15/01/2013 || BuyingRate = 3.2112 | |||
|- | |- | ||
| | | Cash Purchase || 08/02/2013 || BuyingRate = 3.1550 | ||
|} | |} | ||
<br /> | <br /> |
Latest revision as of 07:33, 19 January 2016
Menu: Tools | Maintain Currency...
Introduction
- 1. Currency use to convert the foreign value into local value by multiplying with the defined exchange rate.
- 2. You can create and set the currency and the exchange rate.
- 3. Default currency (----) is your based home currency. For example, your Financial Reports currency is SGD, then you should rename the default currency's description and symbol to "SINGAPORE DOLLAR" and "SGD" respectively.
Create New Currency
Field Name Explanation & Properties Currency - Input the new currency code
- Field type : Alphanumerical
- Length : 6
Symbol - Input the ISO Currency code, eg MYR, SGD, USD, etc.
- Field type : Alphanumerical
- Length : 6
Description - Input the Currency description
- Field type : Alphanumerical
- Length : 30
We BUY at rate - Exchange rate relate to PURCHASE module
- Field type : Numeric
We SELL at rate - Exchange rate relate to SALES module
- Field type : Numeric
Create Periodic Exchange Rate Table
- 1. You can define periodic exchange rate from date to date.
- 2. Click on the (+) sign to insert or (-) sign to remove. See below screenshot.
Doc Type Doc Date Exchange Rate Sales Invoice 02/01/2013 SellingRate = 3.2055 Cash Sales 15/02/2013 SellingRate = 3.1890 Purchase Invoice 15/01/2013 BuyingRate = 3.2112 Cash Purchase 08/02/2013 BuyingRate = 3.1550