Balancing Segment Replacement on Exchange_gain_loss Is Not Generating Correctly in Secondary Ledger For Receipts With Earned Discount (EDISC)
(Doc ID 3078117.1)
Last updated on MARCH 24, 2025
Applies to:
Oracle Receivables - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
Balancing segment replacement on exchange_gain_loss Is not generating correctly in secondary ledger for receipts with earned discount (EDISC).
When a receipt does not have EDISC, the balancing segment replacement is correct.
AR accounting is using balancing segment value of the primary ledger incorrectly when it should be using balancing segment value of the secondary.
EXAMPLE USE CASE
================
1) Ledgers: USD primary, INR secondary
Conversion rate type : corporate
Define exchange rate for USD to INR
2) Update exchange gain loss in system options to
Gain : 70-740-7830-0000-000
Loss : 70-740-7840-0000-000
3) Create an invoice in USD with
payment term :3/10,2/30,Net60
trx_date: 01-DEC-2016
gl_date : 01-DEC-2016
amount : 980.00
4) Apply to receipt in USD with
receipt_date : 06-DEC-2016
apply date : 06-DEC-2016
amount : 1000
This will generate a discount of 29.40
5) Run create accounting in DRAFT mode
| ACCOUNT | GL DATE | ACCOUNTING CLASS | LEDGER |
| 01-000-1110-0000-000 | 06-Dec-16 |
Cash |
INR secondary |
| 01-740-7825-0000-000 | 06-Dec-16 | Earned Discount | INR secondary |
| 01-740-7840-0000-000 | 06-Dec-16 | Exchange Gain or Loss | INR secondary |
| 70-740-7830-0000-000 | 06-Dec-16 | Exchange Gain or Loss | INR secondary |
| 01-000-1210-0000-000 | 06-Dec-16 | Receivable | INR secondary |
| 01-000-1240-0000-000 | 06-Dec-16 | Unapplied Cash | INR secondary |
| 01-000-1110-0000-000 | 06-Dec-16 | Cash | Vision Operations (USA) |
| 01-740-7825-0000-000 | 06-Dec-16 | Earned Discount | Vision Operations (USA) |
| 01-000-1210-0000-000 | 06-Dec-16 | Receivable | Vision Operations (USA) |
| 01-000-1240-0000-000 | 06-Dec-16 | Unapplied Cash | Vision Operations (USA) |
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |