My Oracle Support Banner

E1: 43: Validate Negative Landed Cost Amounts While Receiving a Purchase Order (P4312) Prior to Calculating the Zero Balance Adjustment (Doc ID 3044005.1)

Last updated on AUGUST 27, 2024

Applies to:

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

Symptoms

When a negative line purchase order is received with Landed Costs in the P4312 and the inventory balance goes to zero quantity on hand, we are writing a cardex record for the Zero Balance Adjustment. This was part of a fix in Bug 23067716 - P4312: MAKE LANDED COST AND ZBA AT SAME TIME ONTO F4111. If the total of the transaction (item cost plus landed costs) is calculated, there would not be any inventory amount left and the zero balance adjustment would not happen, but due to how the transaction is processed, we look at the order amount first and compare this amount to the inventory balance. Since the original receipt contained both the item cost and landed costs, the appearance of an inventory balance remaining is calculated due to the remaining landed costs. The zero balance adjustment logic is then executed. This enhancement is to request that we change the logic of the PO Receipts (P4312) program to process both the negative item cost plus the negative landed costs before performing the calculation for the zero balance adjustment.

STEPS

1. Setup a new item with cost levels of 02 and 08.
2. Setup a landed cost rule to be used on the purchase order.
3. Using the P4310, enter a new purchase order for a qty of 43 on line 1.000 and -43 on line 2.000. Both will have the cost rule created above.
4. Receive the positive line and apply landed costs. The cardex an G/L are correct.
5. Receive the negative quantity line.
6. Review the cardex. There are two entries. One for the item cost and one for the landed costs, but if you click on the transaction details, it states it's for a zero balance adjustment.
7. The F0911 contains entries for the item cost, landed cost and zero balance adjustment.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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