Difference between revisions of "Exchange Rate"

(Changed categories.)
 
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 64: Line 79:
 
[[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:
  

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