E1: 42: SO Entry (P4210) Does Not Apply Detached Adjustment (Control Code 6) to Amount in Prepayment Transaction File (F004201) (Doc ID 2929128.1)

Last updated on MARCH 24, 2023

Applies to:

Symptoms

If a Print on Invoice – Detached' adjustment (Adjustment Control Code 6) is applied to a Prepaid Sales Order, the adjusted price is not updated in the Prepayment Transaction Table (F004201).

Steps to reproduce:

1. Customer Master (P03013) has the following setup:
   1. Payment Instrument is Credit Card
   2. Tax Explanation Code = V
   3. Tax Rate Area = QTP
2. In Tax Rate Area Setup (P4008) QTP has a combined rate of 14.975%
3. Set up a 'Print on Invoice – Detached' adjustment (Adjustment Control Code 6) (P4071) and create an Adjustment Detail (P4072) record for Basis Code 5 add on amount of 0.10 per unit.
4. SO Entry (P4210) version is set as follows:
   1. Process Tab Option #5 (Display before Accept Prompt) = 1
   2. Prepayment Tab Option #1 (Prepayment Files will be updated) = 1
5. Create a sales order for 5 EA of item. Price defaults as 2.4400 and Extended Price is 12.20.
6. Price History (P4074) shows Price Adjustment of 0.1000 per unit for 5 units for a total of 0.5000.
7. Return to Sales Order Revisions screen and click green checkmark.
8. On Enter Prepayment Information screen, enter Credit Card Number and click green checkmark.
9. The Order Acceptance screen appears as follows :
   1. Extended Price = 12.20
   2. Adjustment = 0.50
   3. Order Total = 12.70
   4. Taxable Amount = 12.20
   5. Taxes = 1.83
   6. INVOICE TOTAL = 14.53 (0.50 adjustment included)
10. After Order Acceptance, check Prepayment Transaction Table (F004201).
    1. Settle - Transaction Amount (STRM) = 14.0300
    2. The amount did not include the 0.50 price adjustment
    3. The amount should have been 14.53

Cause

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