EAR9.1+: One or More Items Exceed the Maximum Operator Write Off Amount Limits on this Worksheet. (6050, 115) When Attempting to Write Off Low Dollar Interest Amount in a Maintenance Worksheet. (Doc ID 1612133.1)

Last updated on SEPTEMBER 26, 2023

Applies to:

Symptoms

On : 9.1 version, Maintenance Worksheet

When attempting to write off low dollar interest amount in a Maintenance Worksheet the following error occurs.

ERROR
-----------------------
One or more items exceed the Maximum operator write off amount limits on this worksheet. (6050, 115)

REQUIRED SETUP
-----------------------

1. Navigate to Set Up Financials/Supply Chain > Common Definitions > User Preferences > Define User Preferences > Receivables Data Entry 2 and define Max Write Off (15000) and Max WO Percent (100) for Maintenance Worksheet.
2. Navigate to Set Up Financials/Supply Chain > Product Related > Receivables > Payments > Automatic Entry Type and open System Function ID MT-03. Make sure Require Reason is checked. Enter Maximum Write-Off Amount (5000), Currency (USD) and Maximum Write-Off Percent (100).
3. Navigate to Set Up Financials/Supply Chain > Product Related > Receivables > Credit/Collections > Overdue Charging and open Overdue Charge ID. Make sure to check 'Create Overdue Charge Document', 'Create A Group To Post Charges' and 'Create Charge by Item Line'.
4. Navigate to Set Up Financials/Supply Chain > Business Unit Related > Receivables > Receivables Options and link Overdue Charge ID to Receivables Options. Also define Maximum Write-Off Amount (10000) and Maximum Write-Off Percent (100).
5. Navigate to Customers > Customer Information > General Information and open customer USA13. Go to 'Bill To Options' and define Maximum Write-Off Amount (999999999) and Maximum Write-Off Percent (100).

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create and post a new item for business unit US007 and customer USA13. Accounting date is 23-AUG-2013 and terms of payment is NET30.
2. Run overdue charge process for business unit US007 and customer USA13 using As of Date 30-SEP-2013. Overdue charge is generated for 0.23 USD.
3. Run ARUPDATE.
4. Run overdue charge process for business unit US007 and customer USA13 using As of Date 31-OCT-2013. Overdue charge is generated for 0.90 USD.
5. Run ARUPDATE.
6. Navigate to Accounts Receivable > Receivables Maintenance > Maintenance Worksheet > Create Worksheet and add a new Maintenance Worksheet for business unit US007 and customer USA13.
7. Build worksheet. Select overdue charge (sequence 2, amoun7 1.13 USD), enter type and reason and perform Write-off A Debit.
8. Save worksheet and the following error pops up: One or more items exceed the Maximum operator write off amount limits on this worksheet. (6050, 115)
9. When trying to write-off the original item (sequence 1, amount 71 USD) it's working fine.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot write-off low interest amount in Maintenance Worksheet.

Cause

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