Discussion

Difference between revisions of "Exchange Rate"

 
(3 intermediate revisions by the same user not shown)
Line 14: Line 14:
 
=====Adding Exchange Rate=====
 
=====Adding Exchange Rate=====
  
−
#Go to Maintenance then click [[Exchange Rate]]
+
#Click [[Exchange Rate]] under Maintenance Menu
−
#Click '''Add Exchange Rate''' Button
+
#Under [[Exchange Rate]] Screen, Click Add Exchange Rate
−
#Fill-up the necessary fields then click '''Save'''
+
#Fill out the necessary fields then click '''Save. Note: Fields with * are require fields'''
  
 
[[File:Maintenance - Exchange Rate - Add.png|border|center|1500x1500px]]
 
[[File:Maintenance - Exchange Rate - Add.png|border|center|1500x1500px]]
Line 23: Line 23:
 
!Field
 
!Field
 
!Description
 
!Description
−
!Expected Values
+
!Allowed Input
 +
! style="vertical-align:middle;text-align:center;" |Restricted Input
 +
! style="vertical-align:middle;text-align:center;" |Character Limit
 +
! style="vertical-align:middle;text-align:center;" |Required Field?
 
|-
 
|-
 
|1.Effectivity Rate
 
|1.Effectivity Rate
 
|•The date where the exchange rate changes will be applied
 
|•The date where the exchange rate changes will be applied
−
|•Date
+
|•Date picker provided by the system
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |Yes
 
|-
 
|-
 
|2.Exchange Rate
 
|2.Exchange Rate
 
|•The amount to be exchanged on the currency
 
|•The amount to be exchanged on the currency
 
|•Number
 
|•Number
 +
| style="vertical-align:middle;text-align:center;" |Any Inputs except numeric
 +
| style="vertical-align:middle;text-align:center;" |20
 +
| style="vertical-align:middle;text-align:center;" |Yes
 
|-
 
|-
 
|3.Base [[Currency]]
 
|3.Base [[Currency]]
 
|•The currency to be converted.
 
|•The currency to be converted.
 
|•Currency List provided by the Currency Maintenance Module
 
|•Currency List provided by the Currency Maintenance Module
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |Yes
 
|-
 
|-
 
|4.Expected [[Currency]]
 
|4.Expected [[Currency]]
 
|•The converted currency from base currency
 
|•The converted currency from base currency
 
|•Currency List provided by the Currency Maintenance Module
 
|•Currency List provided by the Currency Maintenance Module
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |Yes
 
|}
 
|}
  
Line 48: Line 63:
 
*Exchange Rate set on the module can also be edited on the transactions in case there are updates in the conversion.<br />
 
*Exchange Rate set on the module can also be edited on the transactions in case there are updates in the conversion.<br />
  
 +
=====Viewing Exchange Rate=====
 +
 +
#Go to Maintenance then click [[Exchange Rate]]
 +
#Select a Exchange record that needs to view its details. Click the drop-down arrow then click View.
 +
#The user has an option to edit the Exchange Rate record upon viewing it.
 +
 +
[[File:Maintenance - Exchange Rate - View.png|border|center|1500x1500px]]
 +
<br />
 
=====Editing Exchange Rate=====
 
=====Editing Exchange Rate=====
  
 
#Go to Maintenance then click [[Exchange Rate]]
 
#Go to Maintenance then click [[Exchange Rate]]
−
#Select an Exchange Rate that needs an update. Click the drop-down arrow then choose Edit.
+
#Select an Exchange that needs to update its details.. Click the drop-down arrow then click Edit.
−
#Update the fields then click '''Save.'''
+
#Update the necessary fields then click '''Save. Note: Fields with * are require fields.'''
  
 
[[File:Maintenance - Exchange Rate - Edit.png|border|center|1500x1500px]]
 
[[File:Maintenance - Exchange Rate - Edit.png|border|center|1500x1500px]]
 
<br />
 
<br />
−
{| class="wikitable" style="margin: auto;"
+
{| class="wikitable" style="margin: auto;" data-ve-attributes="{&quot;style&quot;:&quot;margin: auto;&quot;}"
 
!Field
 
!Field
 
!Description
 
!Description
−
!Expected Values
+
!Allowed Input
 +
! style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Restricted Input
 +
! style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Character Limit
 +
! style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Required Field?
 
|-
 
|-
 
|1.Effectivity Rate
 
|1.Effectivity Rate
 
|•The date where the exchange rate changes will be applied
 
|•The date where the exchange rate changes will be applied
−
|•Date
+
|•Date picker provided by the system
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 
|-
 
|-
 
|2.Exchange Rate
 
|2.Exchange Rate
 
|•The amount to be exchanged on the currency
 
|•The amount to be exchanged on the currency
 
|•Number
 
|•Number
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Any Inputs except numeric
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |20
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 
|-
 
|-
 
|3.Base [[Currency]]
 
|3.Base [[Currency]]
 
|•The currency to be converted.
 
|•The currency to be converted.
 
|•Currency List provided by the Currency Maintenance Module
 
|•Currency List provided by the Currency Maintenance Module
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 
|-
 
|-
 
|4.Expected [[Currency]]
 
|4.Expected [[Currency]]
 
|•The converted currency from base currency
 
|•The converted currency from base currency
 
|•Currency List provided by the Currency Maintenance Module
 
|•Currency List provided by the Currency Maintenance Module
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 
|}Notes:
 
|}Notes:
  
Line 88: Line 126:
 
***[[Payment Voucher]]
 
***[[Payment Voucher]]
  
−
===== <span class="mw-headline" id="Activating_Currency_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Customer_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Supplier_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Tax_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Item_Master_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Item_Class_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Item_Type_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Chart_of_Account_Record" style="box-sizing: inherit;">Activating Exchange Rate Record</span></span></span></span></span></span></span></span> =====
+
=====<span class="mw-headline" id="Activating_Currency_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Customer_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Supplier_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Tax_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Item_Master_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Item_Class_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Item_Type_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Chart_of_Account_Record" style="box-sizing: inherit;">Activating Exchange Rate Record</span></span></span></span></span></span></span></span>=====
 
Exchange Rate can be Activated in two ways:
 
Exchange Rate can be Activated in two ways:
  
−
* Using drop-down arrow of a record can be used in single record Activation
+
*Using drop-down arrow of a record can be used in single record Activation
  
 
[[File:Maintenance - Exchange Rate - Activate1.png|border|center|1500x1500px]]
 
[[File:Maintenance - Exchange Rate - Activate1.png|border|center|1500x1500px]]
 
<br />
 
<br />
  
−
* Using Activate Button for activating multiple record.
+
*Using Activate Button for activating multiple record.
  
 
[[File:Maintenance - Exchange Rate - Activate2.png|border|center|1500x1500px]]
 
[[File:Maintenance - Exchange Rate - Activate2.png|border|center|1500x1500px]]
 
<br />
 
<br />
  
−
===== <span class="mw-headline" id="Deactivating_Currency_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deactivating_Customer_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deactivating_Supplier_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deactivating_Tax_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deactivating_Item_Master_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deactivating_Item_Class_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deactivating_Item_Type_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deactivating_Chart_of_Account_Record" style="box-sizing: inherit;">Deactivating Exchange Rate Record</span></span></span></span></span></span></span></span> =====
+
=====<span class="mw-headline" id="Deactivating_Currency_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deactivating_Customer_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deactivating_Supplier_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deactivating_Tax_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deactivating_Item_Master_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deactivating_Item_Class_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deactivating_Item_Type_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deactivating_Chart_of_Account_Record" style="box-sizing: inherit;">Deactivating Exchange Rate Record</span></span></span></span></span></span></span></span>=====
 
Exchange Rate can be deactivated in two ways:
 
Exchange Rate can be deactivated in two ways:
  
−
* Using drop-down arrow of a record can be used in single record deactivation
+
*Using drop-down arrow of a record can be used in single record deactivation
  
 
[[File:Maintenance - Exchange Rate - Deactivate1.png|border|center|1500x1500px]]
 
[[File:Maintenance - Exchange Rate - Deactivate1.png|border|center|1500x1500px]]
 
<br />
 
<br />
  
−
* Using Deactivate Button for deactivating multiple record
+
*Using Deactivate Button for deactivating multiple record
  
 
[[File:Maintenance - Exchange Rate - Deactivate2.png|border|center|1500x1500px]]
 
[[File:Maintenance - Exchange Rate - Deactivate2.png|border|center|1500x1500px]]
 
<br />
 
<br />
  
−
===== <span class="mw-headline" id="Deleting_Currency_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_Customer_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_Supplier_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_Tax_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_Item_Master_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_Item_Class_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_Item_Type_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_Chart_of_Account_Record" style="box-sizing: inherit;">Deleting Exchange Rate Record</span></span></span></span></span></span></span></span> =====
+
=====<span class="mw-headline" id="Deleting_Currency_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_Customer_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_Supplier_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_Tax_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_Item_Master_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_Item_Class_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_Item_Type_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_Chart_of_Account_Record" style="box-sizing: inherit;">Deleting Exchange Rate Record</span></span></span></span></span></span></span></span>=====
 
Exchange Rate can be deleted in two ways:
 
Exchange Rate can be deleted in two ways:
  
−
* Using drop-down arrow of a record can be used in single record deletion
+
*Using drop-down arrow of a record can be used in single record deletion
  
 
[[File:Maintenance - Exchange Rate - Delete1.png|border|center|1500x1500px]]
 
[[File:Maintenance - Exchange Rate - Delete1.png|border|center|1500x1500px]]
 
<br />
 
<br />
  
−
* Using Delete Button for deleting multiple record
+
*Using Delete Button for deleting multiple record
  
 
[[File:Maintenance - Exchange Rate - Delete2.png|border|center|1500x1500px]]
 
[[File:Maintenance - Exchange Rate - Delete2.png|border|center|1500x1500px]]
Line 171: Line 209:
 
|[[Accounts Payable]]<nowiki> | </nowiki>[[Debit Voucher]]<nowiki> | </nowiki>[[Payment Voucher]]
 
|[[Accounts Payable]]<nowiki> | </nowiki>[[Debit Voucher]]<nowiki> | </nowiki>[[Payment Voucher]]
 
|}
 
|}
 +
[[Category:Maintenance]]

Latest revision as of 12:12, 12 April 2022

Exchange Rate

This maintenance screen allows the users to configure the exchange rate of the specific currency.

Requirements before using Exchange Rate
Exchange Rate Record List
Maintenance - Exchange Rate - Record List.png


Adding Exchange Rate
  1. Click Exchange Rate under Maintenance Menu
  2. Under Exchange Rate Screen, Click Add Exchange Rate
  3. Fill out the necessary fields then click Save. Note: Fields with * are require fields
Maintenance - Exchange Rate - Add.png


Field Description Allowed Input Restricted Input Character Limit Required Field?
1.Effectivity Rate •The date where the exchange rate changes will be applied •Date picker provided by the system N/A N/A Yes
2.Exchange Rate •The amount to be exchanged on the currency •Number Any Inputs except numeric 20 Yes
3.Base Currency •The currency to be converted. •Currency List provided by the Currency Maintenance Module N/A N/A Yes
4.Expected Currency •The converted currency from base currency •Currency List provided by the Currency Maintenance Module N/A N/A Yes

Notes:

  • Currency must be on ACTIVE status in order to Add details on the Exchange Rate
    • This can be seen in Currency Maintenance Module
  • Exchange Rate set on the module can also be edited on the transactions in case there are updates in the conversion.
Viewing Exchange Rate
  1. Go to Maintenance then click Exchange Rate
  2. Select a Exchange record that needs to view its details. Click the drop-down arrow then click View.
  3. The user has an option to edit the Exchange Rate record upon viewing it.
Maintenance - Exchange Rate - View.png


Editing Exchange Rate
  1. Go to Maintenance then click Exchange Rate
  2. Select an Exchange that needs to update its details.. Click the drop-down arrow then click Edit.
  3. Update the necessary fields then click Save. Note: Fields with * are require fields.
Maintenance - Exchange Rate - Edit.png


Field Description Allowed Input Restricted Input Character Limit Required Field?
1.Effectivity Rate •The date where the exchange rate changes will be applied •Date picker provided by the system N/A N/A Yes
2.Exchange Rate •The amount to be exchanged on the currency •Number Any Inputs except numeric 20 Yes
3.Base Currency •The currency to be converted. •Currency List provided by the Currency Maintenance Module N/A N/A Yes
4.Expected Currency •The converted currency from base currency •Currency List provided by the Currency Maintenance Module N/A N/A Yes

Notes:

  • Currency must be on ACTIVE status in order to Edit details on the Exchange Rate
  • Exchange Rate set on the module can also be edited on the transactions in case there are updates in the conversion.
  • The update the Exchange Rate, the user must edit it in the Maintenance Module instead on the transaction.
  • If the user updated the Maintenance module Exchange Rate, the user should also manually edit the exchange rate if the transactions exchange rate is need to be update.
Activating Exchange Rate Record

Exchange Rate can be Activated in two ways:

  • Using drop-down arrow of a record can be used in single record Activation
Maintenance - Exchange Rate - Activate1.png


  • Using Activate Button for activating multiple record.
Maintenance - Exchange Rate - Activate2.png


Deactivating Exchange Rate Record

Exchange Rate can be deactivated in two ways:

  • Using drop-down arrow of a record can be used in single record deactivation
Maintenance - Exchange Rate - Deactivate1.png


  • Using Deactivate Button for deactivating multiple record
Maintenance - Exchange Rate - Deactivate2.png


Deleting Exchange Rate Record

Exchange Rate can be deleted in two ways:

  • Using drop-down arrow of a record can be used in single record deletion
Maintenance - Exchange Rate - Delete1.png


  • Using Delete Button for deleting multiple record
Maintenance - Exchange Rate - Delete2.png


Exchange Rate Record Option
Actions Available base on Exchange Rate Record Status
Status View Edit Deactivate Activate Delete
ACTIVE ☑ ☑ ☑ ☑
INACTIVE ☑ ☑ ☑ ☑

Notes:

  • The user is allowed to edit the details when viewing the record.
  • Activating/Deactivating and Deleting of Records can be done in two ways.
    • For single records, the user may use the drop down arrow then the action that need to perform.
    • For multiple records, the user may tick the records then click the action button that need to perform
      • Click the Yes in the confirmation to proceed on the action taken.
Categories:
Modules
Maintenance Maintenance | Currency | Exchange Rate
Purchase Import Purchase Order
Financials Accounts Payable | Debit Voucher | Payment Voucher
Retrieved from "https://docs.oojeema.com/index.php?title=Exchange_Rate&oldid=6692"