E1: 43: Advanced Pricing In Procurement is not Calculating the Adjustment Amounts Correctly in G/L During Voucher Match (P4314) Using Different Transaction Unit of Measure (Doc ID 2946786.1)

Last updated on JUNE 15, 2023

Applies to:

Symptoms

When a transaction unit of measure is used on a purchase order that is different than the pricing unit of measure with a pricing adjustment, the incorrect amount is being calculated at Voucher Match for the adjustment. The amount for the DMAAI 4371 account is taking the adjustment amount and multiplying it by the transaction quantity on the order and not the total quantity on the order.


STEPS
-----------------------
1. Setup a new item in the P4101 with primary and purchasing UOMs in EA and pricing UOM in CA.
2. Add a UOM conversion for 1 CA = 6 EA
3. Setup an Advanced Price adjustment to add 40% of the base cost to the item.
4. Setup a cost for the item at 38.63.
5. Attach the rate schedule to the Supplier Master (P04012)
6. Create a purchase order for the item using the P4310 for a quantity of 10 CA (override transaction UOM to CA).
7. Verify the adjustment added 15.4520 to the item (38.63x.4).
8. Receive the order in full using the P4312.
9. Voucher Match (P4314) the order.
10. Review the journal entries created for the voucher. The Advanced Price Adjustment (DMAAI 4371) entry is created for an amount of $154.52. This is the transaction quantity (10) x 15.4520. But the adjustment amount should have been calculated for the total quantity on the order (60) to equal $927.12 (60*15.4520).
 

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.