Is It Possible to Use the Currency Rate on the Invoice Date to Calculate the Values of Records from the Tran_codes 20 and 87 in the TRAN_DATA Table?

(Doc ID 2406196.1)

Last updated on JUNE 04, 2018

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.

Goal

According to the RMS functionality, the entry of imports is based on the exchange rate of the Purchase Order (PO). However, in Chile, there is a government legal requirement, which requires the use of the official dollar of the Central Bank on the day of the invoice (observed dollar). As a PO can have several shipments and invoices, the income, in the TRAN_DATA table, needs to use the currency rates based on the dates of the different invoices.

Is it possible to use the currency rate on the invoice date to calculate the values of records in the TRAN_DATA table to the tran_codes 20 and 87?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms