01. OVERVIEW

The saving pattern for transfers in foreign currency generated by routines and processes from the financial module is semantically divided in two saving types: Saving defined by the bank currency and saving defined by the bill currency.

-In routines and processes that use a bank directly or indirectly, the transfer saving is defined by the bank currency. When it is not necessary to select a bank for performing an operation from these routines and processes, the transfer saving is made in the current currency.

-In routines and processes that do not use a bank, the transfer saving is defined by the currency of each bill involved in the operation. This means that every transfer generated from a bill will use as transfer currency the same currency of the bill.

-Among the routines and processes that use a bank directly or indirectly, there is an exception for saving the E5_VLMOED2 field in the petty cash replenishment, addition and deletion of investments and loans, and investment redemption. For these processes, this field's value will always be saved in the current currency.

02. SAVING PATTERN FOR THE FIELDS: E5_MOEDA, E5_VALOR, AND E5_VLMOED2

The same saving patterns apply to the fields:
FK1_MOEDA, FK1_VALOR, FK1_VLMOE2, FK1_TXMOED
FK2_MOEDA, FK2_VALOR, FK2_VLMOE2, FK2_TXMOED
FK5_MOEDA, FK5_VALOR, FK5_VLMOE2, FK5_TXMOED

Restructuring of the SE5 table in the FKx table family


  • E5_MOEDA - Saves the bank currency
  • E5_VALOR - Saves the transfer value in the bank currency
  • E5_VLMOED2 - Saves the transfer value in the bill currency
  • E5_TXMOEDA - Saves the transfer rate used for effecting a process. This rate can be the one pre-fixed to the bill, the one from the currency registration or a rate entered when a process is being performed.
  • E5_MOEDA - Saves the billing currency
  • E5_VALOR - Saves the transfer value in the billing currency
  • E5_VLMOED2 - Saves the transfer value conversion (E5_VALOR) to the current currency when the bill is in a foreign currency, or the conversion to the currency of the process when the bill is in the current currency
  • E5_TXMOEDA - Saves the transfer rate used for effecting a process. This rate can be the one pre-fixed to the bill, the one from the currency registration, or a rate entered when a process is being performed.




03. SAVING EXAMPLES

-Advance Payment Addition (PA) / Receipt (RA) in a foreign currency bank

PA is added in bank foreign currency Dollar.





-Bill post in current or foreign currency made in a foreign currency bank

Bill added in current currency Real.


Bill added in foreign currency Dollar






-Petty cash replenishment



-Settlement

Bill added in current currency Real.


Bill added in foreign currency Dollar


Bill added in foreign currency Euro


Settlement currency Dollar





-Payment

PA added with current currency bank


Bill added in foreign currency Dollar.





<!-- esconder o menu --> 


<style>
div.theme-default .ia-splitter #main {
    margin-left: 0px;
}
.ia-fixed-sidebar, .ia-splitter-left {
    display: none;
}
#main {
    padding-left: 10px;
    padding-right: 10px;
    overflow-x: hidden;
}

.aui-header-primary .aui-nav,  .aui-page-panel {
    margin-left: 0px !important;
}
.aui-header-primary .aui-nav {
    margin-left: 0px !important;
}
</style>