Maintain Currency: Difference between revisions

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

Screenshot below is the Currency entry form.

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.

3. See below screenshot as example.

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

@@ Line 1: / Line 1: @@
 ''Menu: Tools | Maintain Currency...''
-=='''Introduction'''==
+==Introduction==
-* You can create and set the currency and the exchange rate.
+:1. Currency use to convert the foreign value into local value by multiplying with the defined exchange rate.
-* 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.
+:2. You can create and set the currency and the exchange rate.
-::[[File:Maintain Agent-BROWSE.jpg |440px]]
+: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 />
-=='''Create New Currency'''==
+==Create New Currency==
-Screenshot below is the Agent entry form.
+: Screenshot below is the Currency entry form.
-::[[File:Maintain Agent-NEW.jpg |440px]]
+::[[File:Maintain Currency-Entry Form.jpg |540px]]
-{| class="wikitable"
+::{| class="wikitable"
 |-
 ! Field Name !! Explanation & Properties
 |-
-| Code ||
+| Currency ||
-* Input the new agent code
+* Input the new currency code
 * Field type : Alphanumerical
-* Length : 10
+* Length : 6
+|-
+| Symbol ||
+* Input the ISO Currency code, eg MYR, SGD, USD, etc.
+* Field type : Alphanumerical
+* Length : 6
 |-
 | Description ||
-* Input the Agent Name.
+* Input the Currency description
 * Field type : Alphanumerical
-* Length : 80
+* 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
 |-
-| Active ||
+| Cash Purchase || 08/02/2013 || BuyingRate = 3.1550
-* Checked = Active
-* Unchecked = Inactive
 |}
 <br />