E1: 43: Price PO Receipt Based on Secondary Units Received (Doc ID 1637582.1)

Last updated on NOVEMBER 12, 2015

Applies to:

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

Symptoms

On : 9.1 version, Procurement
PO Receipts Entry (P4312)
Tools Release 9.1

ACTUAL BEHAVIOR
---------------
PO Receipts (P4312) are being calculated with the wrong Extended Amount when the item is a Dual UOM item, the purchase price is based on Weight (LB) and the Weight (Secondary UOM) is different from the weight calculated by the item conversion.

For Example:
Transaction Units = 400 CA
Standard Conversion = 2,000 LB
Secondary Units Received = 2,037 LB
Cost Per Unit = 4.64 per LB
Extended Amount Calculated = 9,280 (Amount for 2,000 LB)

EXPECTED BEHAVIOR
-----------------------
The Extended Amount should be 2,037 x 4.64 = 9,451.68

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup a Dual UOM Item Primary UOM = CA, Secondary LB, Purchasing LB
2. Setup Conversion 1 CA = 5 LB
3. Create a PO for 400 CA, Secondary 2,000 LB Unit Price 4.64/LB = 9,280 is calculated
4. Perform a PO receipt for 400 CA Secondary 2,037 LB, Unit Price 4.64/LB = 9,280 is calculated. Extended Amount should be 2,037 x 4.64 = 9,451.68

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Client is live. Vendor invoices are not being paid because they not matching PO receipts.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms