Adjusting a Transaction Results in Wrong ACCTD_AMOUNT_DUE_REMAINING in AR_PAYMENT_SCHEDULES_ALL Table (Doc ID 2911304.1)

Last updated on MAY 20, 2024

Applies to:

Symptoms

When adjusting a transaction results in wrong acctd_amount_due_remaining in ar_payment_schedule_all table.

Responsibility: Receivables Manager
Navigation: Transactions > Transactions

Steps to reproduce (Example):

1 create an invoice (A) for USD 100.

2 create receipt for USD 100 and apply it to invoice (A). So Transaction A balance is 0

3 create a credit memo (B) for USD -100 and apply it to invoice (A).

4 create an adjustment for invoice (A) for USD -10. Transaction (A) balance is -110

5 Check the balances on ar_payment_schedules_all table and see the acctd_amount_due_remaining field is -100 which is incorrect

Cause

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