My Oracle Support Banner

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 DECEMBER 03, 2019

Applies to:

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


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?


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.