You are viewing an old version of this page. Return to the latest version.
Difference between revisions of "Exchange Rate"
(Tag: 2017 source edit) |
(Tag: Visual 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 | + | [[Maintenance]] | [[Currency]] |
− | </div | + | </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]] | ||
− | |||
− | |||
=====Exchange Rate Record List===== | =====Exchange Rate Record List===== | ||
− | [[File:Exchange Rate Record List.png|center| | + | [[File:Maintenance - Exchange Rate - Record List.png|border|center|1500x1500px]] |
+ | <br /> | ||
+ | =====Adding Exchange Rate===== | ||
− | + | #Click [[Exchange Rate]] under Maintenance Menu | |
− | [[File: | + | #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 | ||
− | ! | + | !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 /> |
− | + | ||
+ | =====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: | + | |
− | {| 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="{"style":"margin: auto;"}" | ||
!Field | !Field | ||
!Description | !Description | ||
− | ! | + | !Allowed Input |
+ | ! style="vertical-align:middle;text-align:center;" data-ve-attributes="{"style":"vertical-align:middle;text-align:center;"}" |Restricted Input | ||
+ | ! style="vertical-align:middle;text-align:center;" data-ve-attributes="{"style":"vertical-align:middle;text-align:center;"}" |Character Limit | ||
+ | ! style="vertical-align:middle;text-align:center;" data-ve-attributes="{"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;" data-ve-attributes="{"style":"vertical-align:middle;text-align:center;"}" |N/A | ||
+ | | style="vertical-align:middle;text-align:center;" data-ve-attributes="{"style":"vertical-align:middle;text-align:center;"}" |N/A | ||
+ | | style="vertical-align:middle;text-align:center;" data-ve-attributes="{"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;" data-ve-attributes="{"style":"vertical-align:middle;text-align:center;"}" |Any Inputs except numeric | ||
+ | | style="vertical-align:middle;text-align:center;" data-ve-attributes="{"style":"vertical-align:middle;text-align:center;"}" |20 | ||
+ | | style="vertical-align:middle;text-align:center;" data-ve-attributes="{"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;" data-ve-attributes="{"style":"vertical-align:middle;text-align:center;"}" |N/A | ||
+ | | style="vertical-align:middle;text-align:center;" data-ve-attributes="{"style":"vertical-align:middle;text-align:center;"}" |N/A | ||
+ | | style="vertical-align:middle;text-align:center;" data-ve-attributes="{"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;" data-ve-attributes="{"style":"vertical-align:middle;text-align:center;"}" |N/A | ||
+ | | style="vertical-align:middle;text-align:center;" data-ve-attributes="{"style":"vertical-align:middle;text-align:center;"}" |N/A | ||
+ | | style="vertical-align:middle;text-align:center;" data-ve-attributes="{"style":"vertical-align:middle;text-align:center;"}" |Yes | ||
|}Notes: | |}Notes: | ||
Line 76: | Line 123: | ||
***[[Import Purchase Order]] | ***[[Import Purchase Order]] | ||
***[[Accounts Payable]] | ***[[Accounts Payable]] | ||
− | |||
***[[Debit Voucher]] | ***[[Debit Voucher]] | ||
***[[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>===== | |
+ | 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 /> | ||
− | |||
− | |||
− | * | + | *Using Delete Button for deleting multiple record |
+ | [[File:Maintenance - Exchange Rate - Delete2.png|border|center|1500x1500px]] | ||
<br /> | <br /> | ||
− | =====Exchange Rate | + | =====Exchange Rate Record Option===== |
− | + | {| 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: "Open Sans", 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 /> | ||
− | + | {| class="wikitable" style="margin: auto;" | |
− | |||
− | |||
− | {| class="wikitable" | ||
|+Categories: | |+Categories: | ||
! colspan="2" |'''Modules''' | ! colspan="2" |'''Modules''' | ||
Line 109: | Line 207: | ||
|- | |- | ||
|Financials | |Financials | ||
− | |[[Accounts Payable | + | |[[Accounts Payable]]<nowiki> | </nowiki>[[Debit Voucher]]<nowiki> | </nowiki>[[Payment Voucher]] |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|} | |} | ||
+ | [[Category:Maintenance]] |
Latest revision as of 12:12, 12 April 2022
Contents
Exchange Rate
This maintenance screen allows the users to configure the exchange rate of the specific currency.
Requirements before using Exchange Rate
- The user should setup the following Maintenance Module in order to proceed on using the Exchange Rate
Exchange Rate Record List
Adding Exchange Rate
- Click Exchange Rate under Maintenance Menu
- Under Exchange Rate Screen, Click Add Exchange Rate
- Fill out the necessary fields then click Save. Note: Fields with * are require fields
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
- 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.
Editing Exchange Rate
- 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.
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.
- The following modules that can be applied by exchange rate are the following
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
- Using Activate Button for activating multiple record.
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
- Using Deactivate Button for deactivating multiple record
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
- Using Delete Button for deleting multiple record
Exchange Rate Record Option
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.
- Click the Yes in the confirmation to proceed on the action taken.
Modules | |
---|---|
Maintenance | Maintenance | Currency | Exchange Rate |
Purchase | Import Purchase Order |
Financials | Accounts Payable | Debit Voucher | Payment Voucher |