My Oracle Support Banner

R12: AP: Automatic Offset Paid Invoice Listed Twice in Trial Balance, on Different Liability Accounts (Doc ID 2789101.1)

Last updated on AUGUST 27, 2021

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Fully paid invoice, created using Automatic Offsets option,  listed in Trial Balance (APTB) twice, with 2 Liability Accounts, with the same sum, once positive, and once negative, but "Total for Party" is zero.

Customer is using Custom Subledger Accounting Method (SLAM).

Steps:


a. Navigate to Payables -> Invoices and create an invoice, using Automatic Offsets option and a custom SLAM

b. Pay the invoice and fully account both invoice and payment

c. Check APTB and notice the invoice still listed, but on 2 accounts.

 

Example:

Account Payables Trial Balance (APTB) shows next:

 

Account: 0000-XXXX-0000-00000-000000-0000-0000

Transaction Type    Transaction Number   Payment Status   Remaining Amount
AP Invoices                 1111                        Fully Paid             0.01

Total for Account 0.01

 

Account: 0000-YYYY-0000-00000-000000-0000-0000

Transaction Type     Transaction Number   Payment Status Remaining Amount
AP Invoices                 1111                         Fully Paid             -0.01

Total for Account -0.01

 

Total for Party 0.00

 

APTB shows 0.01 Remaining Amount on the account XXXX on the transaction 1111 and -0.01 Remaining Amount on the account YYYY, on the same transaction 1111.


GL_LEDGERS.SLA_ACCOUNTING_METHOD_TYPE = 'C' for the Ledger.

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


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