EAP: PO Voucher with Freight errors -- Data being added conflicts with existing data (18,2) (Doc ID 1621974.1)

Last updated on JANUARY 30, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

A multi-line PO with a fixed Asset is created with the Miscellaneous Charges for Freight. The Miscellaneous Charges are allocated to specific PO lines. A Quick Invoice is created by copying the PO onto the Quick Invoice, and the Freight amount is changed. Voucher Build creates the Voucher in a Postable Status. When the PO Voucher is displayed and re-saved, an error occurs.

ERROR
Data being added conflicts with existing data (18,2)

STEPS
1. Misc Charge/Landed Cost Defn page setup:

Miscellaneous Charge = FRGTPR (Freight Prorated)
Prorate is checked

2. Procurement Control > Non-Merch Charges page setup

Unit = US001
Freight Charge = FRGTPR

3. Create a 4 line PO as follows:

PO Business Unit = US001
PO Number = CRAW_GRP
Line 1 PO Qty = 2, Price = 800.00
Line 2 PO Qty = 1, Price = 900.00
Line 3 PO Qty = 2, Price = 700.00
Line 4 PO Qty = 2, Price = 600.00

4. For PO Line 1:

Distribution Line 1 = Qty 1
Distribution Line 2 = Qty 1

Both Distribution Lines are associated to a AM Unit, Profile ID and have the box for Capitalize un-checked.

5. For PO Line 4:

Distribution Line 1 = Qty 1
Distribution Line 2 = Qty 1

6. On the Header - Miscellaneous Charges page:

Miscellaneous Charge = FRGTPR
Amount = 250.00

Freight is allocated to Line 1 and Line 3

7. Dispatch the PO
8. Create a Quick Invoice from the PO

Quick Invoice Entry > Add a New Value page

Business Unit = US001
Quick Invoice Template = Complete
PO Business Unit = US001
PO Number = CRAW_GRP

9. On the Quick Invoice page, click the Miscellaneous Charges hyperlink
10. Change the Misc Charge Amount from 250.000 to 200.000
11. On the Quick Invoice page:

Change the Freight amount from 250.00 to 200.00
Change the Total from 5350.00 to 5300.00
Save the Quick Invoice Entry page

12. Run Voucher Build for the Voucher ID
13. Display the PO Voucher
14. On the Voucher > Summary page, Entry Status = Postable
15. Access the Voucher > Invoice Information page
16. Click Save
17. The above error occurs

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