Difference between revisions of "Exchange Rate"

(Tag: 2017 source edit)
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<div style="text-align: center;">
 
<div style="text-align: center;">
[[Maintenance]] | [[Currency]] | [[Exchange Rate Aids]]
+
[[Maintenance]] | [[Currency]]
</div><br />
+
</div>
 
==Exchange Rate==
 
==Exchange Rate==
This maintenance screen allows the users to configure the exchange rate of the specific currency.
+
This maintenance screen allows the users to configure the exchange rate of the specific [[currency]].
 
=====Requirements before using Exchange Rate=====
 
=====Requirements before using Exchange Rate=====
  
 
*The user should setup the following [[Maintenance]] Module in order to proceed on using the [[Exchange Rate]]
 
*The user should setup the following [[Maintenance]] Module in order to proceed on using the [[Exchange Rate]]
 
*#[[Currency]]
 
*#[[Currency]]
*For detailed instructions on how to setup the needed [[Maintenance]] Module, the user may visit the following Job Aid pages:
 
*#[[Currency Aids]]
 
  
 
=====Exchange Rate Record List=====
 
=====Exchange Rate Record List=====
[[File:Exchange Rate Record List.png|center|thumb|Exchange Rate Record List]]
+
[[File:Maintenance - Exchange Rate - Record List.png|border|center|1500x1500px]]
 +
<br />
 +
=====Adding Exchange Rate=====
  
=====Adding Exchange Rate=====
+
#Click [[Exchange Rate]] under Maintenance Menu
[[File:Adding Exchange Rate.png|center|thumb|867x867px|Adding Exchange Rate]]
+
#Under [[Exchange Rate]] Screen, Click Add Exchange Rate
{| class="wikitable"
+
#Fill out the necessary fields then click '''Save. Note: Fields with * are require fields'''
 +
 
 +
[[File:Maintenance - Exchange Rate - Add.png|border|center|1500x1500px]]
 +
<br />
 +
{| class="wikitable" style="margin: auto;"
 
!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 42: Line 61:
 
*Currency must be on '''ACTIVE''' status in order to Add details on the Exchange Rate
 
*Currency must be on '''ACTIVE''' status in order to Add details on the Exchange Rate
 
**This can be seen in [[Currency]] Maintenance Module
 
**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.
+
*Exchange Rate set on the module can also be edited on the transactions in case there are updates in the conversion.<br />
*For Detailed instructions on how to add Exchange Rate, you can visit the Exchange Rate Job Aid which can be found [[Exchange Rate Aids|here]]<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=====
[[File:Editing Exchange Rate.png|center|thumb|868x868px|Editing Exchange Rate]]
+
 
{| class="wikitable"
+
#Go to Maintenance then click [[Exchange Rate]]
 +
#Select an Exchange that needs to update its details.. Click the drop-down arrow then click Edit.
 +
#Update the necessary fields then click '''Save. Note: Fields with * are require fields.'''
 +
 
 +
[[File:Maintenance - Exchange Rate - Edit.png|border|center|1500x1500px]]
 +
<br />
 +
{| 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 76: Line 123:
 
***[[Import Purchase Order]]
 
***[[Import Purchase Order]]
 
***[[Accounts Payable]]
 
***[[Accounts Payable]]
***[[Debit Memo]]
 
 
***[[Debit Voucher]]
 
***[[Debit Voucher]]
 
***[[Payment Voucher]]
 
***[[Payment Voucher]]
  
*For Detailed instructions on how to edit Exchange Rate, you can visit the Exchange Rate Job Aid which can be found [[Exchange Rate Aids|here]]
+
=====<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:
  
 +
*Using drop-down arrow of a record can be used in single record Activation
 +
 +
[[File:Maintenance - Exchange Rate - Activate1.png|border|center|1500x1500px]]
 +
<br />
 +
 +
*Using Activate Button for activating multiple record.
 +
 +
[[File:Maintenance - Exchange Rate - Activate2.png|border|center|1500x1500px]]
 +
<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>=====
 +
Exchange Rate can be deactivated in two ways:
 +
 +
*Using drop-down arrow of a record can be used in single record deactivation
 +
 +
[[File:Maintenance - Exchange Rate - Deactivate1.png|border|center|1500x1500px]]
 +
<br />
 +
 +
*Using Deactivate Button for deactivating multiple record
 +
 +
[[File:Maintenance - Exchange Rate - Deactivate2.png|border|center|1500x1500px]]
 +
<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>=====
 +
Exchange Rate can be deleted in two ways:
 +
 +
*Using drop-down arrow of a record can be used in single record deletion
 +
 +
[[File:Maintenance - Exchange Rate - Delete1.png|border|center|1500x1500px]]
 
<br />
 
<br />
=====Exchange Rate Record Option=====
 
[[File:Exchange Rate Record Option.png|center|thumb|Exchange Rate Record Option]]Notes:
 
  
*For Detailed instructions on how to View, Edit, Activate, Deactivate and Delete Exchange Rate, you can visit the Exchange Rate Job Aid which can be found [[Exchange Rate Aids|here]]
+
*Using Delete Button for deleting multiple record
  
 +
[[File:Maintenance - Exchange Rate - Delete2.png|border|center|1500x1500px]]
 
<br />
 
<br />
=====Exchange Rate View Record=====
+
=====Exchange Rate Record Option=====
[[File:Exchange Rate View Record.png|center|thumb|Exchange Rate View Record]]
+
{| class="wikitable" style="box-sizing: inherit; border-collapse: collapse; border-spacing: 0px; background-color: rgb(248, 249, 250); font-size: 14px; color: rgb(34, 34, 34); margin: auto; border: 1px solid rgb(162, 169, 177); font-family: &quot;Open Sans&quot;, Roboto, arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"
 +
|+ style="box-sizing: inherit; padding-top: 8px; padding-bottom: 8px; color: rgb(119, 119, 119); text-align: left; font-weight: bold;" |Actions Available base on Exchange Rate Record Status
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Status
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |View
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Edit
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Deactivate
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Activate
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Delete
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''ACTIVE'''
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''INACTIVE'''
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |
 +
|}
 
Notes:
 
Notes:
  
 
*The user is allowed to edit the details when viewing the record.
 
*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.<br />
  
*For Detailed instructions on how to View Exchange Rate, you can visit the Exchange Rate Job Aid which can be found [[Exchange Rate Aids|here]]
+
{| class="wikitable" style="margin: auto;"
 
 
<br />
 
{| class="wikitable"
 
 
|+Categories:
 
|+Categories:
 
! colspan="2" |'''Modules'''
 
! colspan="2" |'''Modules'''
Line 109: Line 207:
 
|-
 
|-
 
|Financials
 
|Financials
|[[Accounts Payable]]<nowiki> | </nowiki>[[Debit Memo]]<nowiki> | </nowiki>[[Debit Voucher]]<nowiki> | </nowiki>[[Payment Voucher]]
+
|[[Accounts Payable]]<nowiki> | </nowiki>[[Debit Voucher]]<nowiki> | </nowiki>[[Payment Voucher]]
|-
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
|-
 
|Maintenance Aids
 
|[[Currency Aids]]<nowiki> | </nowiki>[[Exchange Rate Aids]]
 
|-
 
|Purchase Aids
 
|[[Import Purchase Order Aid]]
 
|-
 
|Financials
 
|[[Accounts Payable Aids]]<nowiki> | </nowiki>[[Debit Memo Aids]]<nowiki> | </nowiki>[[Debit Voucher Aids]]<nowiki> | </nowiki>[[Payment Voucher Aids]]
 
 
|}
 
|}
 +
[[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