E1: 04: Standard Voucher Entry (P0411) Doubles or Adds to the Open Amount (AAP) when Revising an Unposted, Existing Voucher With and Without Taxes (Doc ID 2817377.1)

Last updated on DECEMBER 01, 2022

Applies to:

Symptoms

Using Standard Voucher Entry (P0411) to re-inquire on a just-entered and unposted voucher, there are three scenarios under which the Open Amount (AAP) value doubles or is added onto:

1. Scenario 1: the voucher does not have tax: when re-inquiring on it, the Tax Explanation Code field is updated with a valid value, e.g. V, but the Tax Rate/Area field is left blank. When tabbing out of the grid record to the next one, P0411 sets an error, “Tax Area Required”. After going back into the grid record with the error and updating the Tax Rate/Area field with a valid value and saving the changes, notice that the Open Amount field (AAP) has doubled.
   
   
2. Scenario 2: the voucher does have tax: the Tax Rate/Area field is changed to a different value. When the Taxable and Tax Amount fields are not blanked out at this point and the user tabs to the next grid record, P0411 sets error 2106: “Tax Amount Invalid”.
   The user then goes back to the first record and blanks out the Taxable and Tax Amount fields to let the system recalculate their values. When tabbing out of the grid record again, notice that the Open Amount field (AAP) has doubled.
   
   
3. Scenario 3: the voucher does have tax: when re-inquiring on the voucher and changing the gross amount for the 2^nd time during the same session, the values of the second change are added to the original gross amount value.

The only way to correct any of these scenarios is to use a database utility, such as SQL, because the system won’t allow a delete or void of the vouchers.

STEPS TO REPRODUCE

Scenario 1

1. Open P0411 and click on Add.
2. Create a voucher without taxes and save it.
3. Re-inquire on the voucher and click in the Tax Explanation field in the grid.
4. Add a valid value, e.g. V.
5. Leave the Tax Rate/Area field blank and tab to the next grid record.
6. P0411 sets error “Tax Area Required”.
7. Go back to the first grid record, the one with the error, and put a valid value in the Tax Rate/Area field.
8. Tab to the next grid record and notice that the Open Amount field (AAP) value has doubled.
9. Click on the green checkmark to save the changes: P0411 does not set any errors on the doubled amount.

Note: if you repeat Steps 3 thru 9, the Open Amount will double each time.

Scenario 2

1. P0411: create a voucher with taxes and save it.
2. Re-inquire on the voucher and click in the Tax Rate/Area field in the grid.
3. Change it to another valid value.
4. Tab to the next grid record: P0411 sets error 2106: ‘Tax Amount Invalid’.
5. Go back to the first grid record and blank out the Taxable and Tax Amount fields.
6. Tab to the next grid record again and notice that the Open Amount field (AAP) value has doubled.
7. Click on the green checkmark to save the changes: P0411 does not set any errors on the doubled amount.

Note: if you repeat Steps 2 thru 6, the Open Amount will double each time.

Scenario 3

1. P0411: create a voucher with the Tax Explanation Code and Tax Rate/Area fields populated, e.g. set the Tax Expl Code to E and the Tax Rate/Area to CO.
   Do NOT post the voucher.
2. P0411: inquire on the voucher and drill down into it.
3. Change the Gross Amount (AG) in the grid to a different value.
4. Click with the mouse into the second grid row. Note the value of the Open Amount (AAP) field: it has not changed at this point.
5. Go back to the first grid row and change the Gross Amount again.
6. Click with the mouse into the second grid row.
7. Note that the value of the Open Amount (AAP) field has changed: it has added the value of the new amount to the original value.

Note: if you repeat Steps 5 and 6, the Open Amount will be added to each time.

Cause

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