Linha Microsiga Protheus - Inglês

Páginas filhas
  • Saving Pattern For Transfers In Foreign Currency

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

Information

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.



    IMPORTANT!

    For the system to interpret these transfers correctly in reports, queries and cancellation operations, it is mandatory to respect the saving pattern for fields E5_MOEDA, E5_VALOR, and E5_VLMOED2.


    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.