The Remaining Amount Must Be Zero After Clicking the Credit Balance Button (Doc ID 2805055.1)

Last updated on MAY 20, 2024

Applies to:

Symptoms

The Credit Memo(CM) Include tax is calculated incorrectly and the APP-AR-11091 error occurs.

- Pattern 1:

1-1. Create a Transaction:
Line Qty  UnitPrice NetUnitPrice  Amount  NetAmount IncTaxRate  TaxAmount
1      1      29200        29200   29200      29200         0%         0
2      1     226070       226070  226070     226070         0%         0
3      1      30800        28000   30800      28000        10%      2800
4      1      17270        15700   17270      15700        10%      1570
5     21      39500        39500  829500     829500         0%         0

Total Amount:1132840 Line: 1128470 Tax: 4370

1-2. Create a Receipt: Amount 1084770 and apply above.

1-3. Create a CM 1
Line Qty   UnitPrice NetUnitPrice  Amount  NetAmount IncTaxRate TaxAmount
1    -.027     29200        29200    -794       -794         0%         0
2    -.027    226070       226070   -6146      -6146         0%         0
3    -.027     30800        28000    -838       -762        10%       -76
4    -.027     17270        15700    -469       -426        10%       -43
5    -.570     39500        39500  -22553     -22553         0%         0

Total Amount:-30800 Line: -30681 Tax: -119

1-4. Create a CM 2 using the Credit Balance button.

  Credit Memo           Credit Transaction  
            %  Amount   Original   Balance Due
 Line  1.5245  -17204    1128470             0
  Tax  1.5332     -67       4370            -1
Total  1.5246  -17271    1132840            -1

Error
APP-AR-11091: You cannot over apply this transaction error occurred.

Line Qty   UnitPrice NetUnitPrice  Amount  NetAmount IncTaxRate TaxAmount
1    -.015     29200        29200    -445       -445         0%         0
2    -.015    226070       226070   -3447      -3447         0%         0
3    -.015     30800        28000    -470       -427        10%       -43
4    -.015     17270        15700    -263       -263        10%       -24
5    -.320     39500        39500  -12646     -12646         0%         0

Total Amount:-17271 Line: -17204 Tax: -67
Tax amount should be -66, instead of -67.


- Pattern 2:

2-1. Create a Transaction:
Line Qty  UnitPrice NetUnitPrice  Amount  NetAmount IncTaxRate  TaxAmount
1      1      1,001          927   1,001        927   IncTax8%         74
2      1      2,009        1,827   2,009      1,827  IncTax10%        182
3      1      3,003        3,003   3,003      3,003  Taxexempt　        0
4      1      4,335        4,014   4,014      4,014   ExcTax8%        321
5      1      5,015        5,015   5,015      5,015  ExcTax10%        501

Total Amount:15,864 Line: 14,786 Tax: 1,078

2-2. Open the Credit Transaction form.
2-3. Create a new credit memo and click the Line button.
2-4. Close the Line form (No input line).
2-5. Click the Credit Balance button.
2-6. Save the Credit memo.
2-7. Complete Credit memo. Following error occurs.

Error
APP-AR-11091: You cannot over apply this transaction error occurred.

Changes

Cause

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