E1: 42: Need Ability to Reverse an Incorrect Landed Cost without Reversing Entire Receipt (Doc ID 3067619.1)

Last updated on JANUARY 15, 2025

Applies to:

Symptoms

A purchase order receipt is created with multiple Landed Costs creating multiple OV Receipt Documents. After the voucher for the received item is created and paid, it is determined that one of the Landed Costs was incorrect and needs to be reversed. However it is not currently possible in EnterpriseOne to Reverse Landed Cost Receipt without reversing all the receipts (regular and landed cost) together.

Please refer to 2771210.1 - E1: 43: Enhancement Request to Allow Reverse or Delete the Landed Cost (LCR) Entry Without Reversing the Receipt

Steps to Duplicate:

In Landed Cost Revisions (P41291), Item 230LC in Branch 30 has two Landed Costs

•   a. Freight = 2% of cost/Supplier 8547
•   b. Brokerage Fees = 4% of cost/Supplier 310
•   c. Include in Cost = Y
•   d. Voucher Y/N = Y

Create a Purchase Order for 100 EA of Item 230 in Branch 30 from Supplier 594344.

• Unit Cost is 100.00
• Extended Cost is 10,000.00

Reinquire on PO and Row Exit to Landed Cost

Landed Cost Screen shows three costs from 3 different suppliers

• Item Extended Cost is 10,000.00 from Supplier 594344
• Freight Extended Cost is 200.00 from Supplier 8547
• Brokerage Fees Extended Cost is 400.00 from Supplier 310

Setup a Version of PO Receipts (P4312) that has Landed Cost Activated (Process Tab Option #6 = 1)

Enter the PO Receipt (P4312) for the Full Quantity of 100 EA.

Click green checkmark to Accept Landed Costs.

Post the Receipt Batch 98915 O. Post Report (R09801) shows the following G/L entries in two different OV Receipt Documents.

•   For Purchased Item OV Document 6359
  • Inventory Debit (1.1411) = +10,000.00
  • Received Not Vouchered Credit (30.4111) = -10,000.00
• For Landed Cost OV Document 6360
  • Freight Landed Cost Expense Debit (30.1420) = +200.00
  • Freight Landed Cost Payable Credit (30.4184) = -200.00
  • Brokerage Fees Landed Cost Expense Debit (30.1420) = +400.00
  • Brokerage Fees Landed Cost Payable Credit (30.4184) = -400.00

Perform a 3-Way Match Voucher to pay the Item Supplier’s (594344) Invoice for 10,000.00.

Post the Voucher (R09801).

Go to Receipt Reversal (P43214) and search on the Purchase Order (8799).

• You determine that the second Landed Cost of 400.00 was incorrect and you decide to reverse it.

Select the second line. Take Row Exit to Reversal>Reverse Receipt.

The Reversal Not Allowed (053O) Error message is returned:

• Cause. . . . . . . You cannot reverse a landed cost row.
• Resolution . . . . You must reverse the original receipt corresponding to the landed cost.

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.