Create a simulation of losses in A/P

Related topics

The simulation of losses is run based on open items in the Accounts Payable with printout of a control list. One of the main advantages with this is that you can check the result before update and control that all exchange rates exist. Note: If you do not run a simulation, and there are errors (missing exchange rates), then the update will not be performed, and you will get an error list.

  1. Select the Revalue A/P open items menu item.
  2. You access A/P open items revaluation. The following fields can be used for selections and control when you run a simulation:
    Supplier number
    These two fields offer you the ability to select individual suppliers or a range for your revaluation.
    Transaction currency
    Enter values for transaction currencies if you only want to revalue certain currencies.
    Balance period
    The system proposes the actual period as the balance period, (this will also be the accounting period for the G/L transactions). You can change to any other open period if you want to have a new base for your revaluation. All open items at the given balance period for the selected supplier(s) will then be part of the revaluation.
    Invoices
    Indicate if you want to include invoices in the revaluation. If YES, then documents with data type 1, 5 and 6 will be selected, i.e. invoices, redefinition documents and bill documents
    Payments
    Indicate if you want to include payments in the revaluation.
    Exchange rate period/level
    Enter the exchange rate period and level which will be used as comparison when calculating the gains and losses.
    Revalue gains
    Set to YES if you want to calculate gains. Set to NO if you want to calculate losses only, which applies here.
    Revalue losses
    Indicate if you want to calculate losses.
    Simulation
    Set to YES since you want to run a simulation before update.
    Summary level
    Indicate on which level you want the sum to be printed, e.g. per currency, or per currency and supplier level.

    The following levels exist:

    Level Totals
    1 Currency
    2 Currency and customer/supplier
    3 Currency and customer/supplier and document

    Click OK to start the simulation. You can check the result based on the A/P open item simulation list before you do the update. Exit the routine.

Related topics