1. Home
  2. /
  3. Setup Guides
  4. /
  5. Currency Conversion
  6. /
  7. Exchange rate gains and...
  8. /
  9. Realisation of exchange rate...
  10. /
  11. Update transactions

Update transactions

Related topics

The following describes how to run the routine in order to update the A/R and G/L. When you run the routine, the following steps will take place:

  1. An exchange rate document will be created and connected to the revalued open item.
  2. G/L postings that reflect the exchange rate document will be created.
  3. A listing will be printed to show the revaluation on document level.
  4. Listings that show the update of the G/L postings will be printed.

    5. Prerequisites
    A voucher type, valid for the REVO routine, in Work with voucher types. A document type with the Document number, Handling code and Data type fields set to 3 in Work with document types.

    Tip: Create a new document type for this purpose by copying the existing document type connected to the system document type EXR. In this case you can differentiate the exchange rate differences created through this routine from the normal exchange rate differences.

    Valid exchange rates must be set up in the Exchange rate table for all currencies to be included in the run. The following parameters apply:

    Time level
    Enter an asterisk (*).
    Medium
    Enter the valid exchange rate.
  1. Select the A/R realisation of exchange rate differences menu item.
  2. You access the A/R realisation of exchange rates panel where you make your selections. In order to run a proper update you have to decide your selection criteria as well as whether you are to revalue gains and/or losses. For further information regarding those fields, see Create a simulation of losses. In addition, you have to update the following fields:
    3. Simulation
    Set to NO since we are to update transactions.
    Accounting period
    Enter the period in which you want the realisation to take place. This will be the period in which the settlement, as well as the G/L postings, will be created.
    Note: The accounting period cannot be prior to the period you entered in the Select to period field. The system will check this for you in order to avoid that an exchange rate difference is created in a period prior to the one that the document to be revalued was entered in.
    Voucher type
    Enter a voucher type valid for the REVO routine. The voucher type controls the voucher numbering for the G/L postings.
    Voucher date
    The system defaults actual date. Enter the voucher date you want the settlement and the G/L postings to receive.
    Document type
    Enter the document type that you want the exchange rate documents to receive. The document type controls the account for the exchange rate posting.

    Click OK to start the update. When the realisation update has completed the following message will be sent: “Job REAL_EXR completed normally“.

Related topics