My Oracle Support Banner

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:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.2 and later
Information in this document applies to any platform.


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.

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).




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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