E1: 45: Ship And Debit Quantity Applied (QYAP) Wrong with Credit Order From History (Doc ID 1982823.1)

Last updated on OCTOBER 22, 2015

Applies to:

JD Edwards EnterpriseOne Advanced Pricing - Sales - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Advanced Pricing
Credit Order from History (P4210)
Assign, Recalculate and Reassign Agreements (R45100)
Tools Release

The Quantity Applied (QYAP) field in Ship and Debit History (F4575) is incorrectly calculated by Assign, Recalculate and Reassign Agreements (R45100) for a Credit Order From History when the pricing UOM is different from primary, but the order quantity is in the primary UOM. For example the quantity ordered is -1 CA in the credit order from history, but there are 24 PK per CA, the Quantity Applied (QYAP) field in Ship and Debit History (F4575) is populated with -1 (based on Pricing UOM) when it should be -24.

Assign, Recalculate and Reassign Agreements (R45100)  should calculate Quantity Applied (QYAP) of -24 on the Credit Order if 1 CA = 24 PK.


The issue can be reproduced at will with the following steps:
1. Setup an item (P4101) with Primary UOM of PK and Pricing UOM of CA with UOM Conversion (P41002) of 1 CA = 24 PK.
2. Add the Item as a Ship and Debit (P4513) item.
3. Create the Ship and Debit Adjustment populating the Based On Cost field with 0.4754, Basis Code = 5, and the lock cost checkbox checked. Populate minimum and maximum quantities.
4. Setup a version of Sales Order Entry (P4210) for Ship and Debit Processing. Processing option #11 (Ship and Debit Processing) on the process tab of the Sales Order Entry (P4210) version, is set to a value of 2 to call Assign, Recalculate and Reassign Agreements (R45100) in batch mode.
5. Make sure Defaults Tab Option #8 (Default Transaction Unit of Measure) is set to 1 (Pricing UOM).
6. Using Powerforms Sales Order Entry (P42101) create the Sales Order line for Quantity 1 and UOM CA is defaulted. Create a second line for Quantity 24 and override the UOM to PK.
7. Verify Assign, Recalculate and Reassign Agreements (R45100) is launched by Sales Order Entry (P4210).
8. From Manage Existing Order (P42101) take the Row Exit to Ship and Debit.
9. Verify Quantity Applied (QYAP) is 24 in Ship and Debit History (P4575) because 1 CA = 24 PK (primary UOM).
10. Process the order through Sales Update (R42800)
11. Make sure Credit Order Document Type has Ship and Debit Processing Checkbox checked in Document Type Revisions (P40040).
12. Create a Credit Order From History Version. Do not call Assign, Recalculate and Reassign Agreements (R45100) this will be done as a separate job.
13. Create a Credit Order from History (P4210) pulling in the first line from the sales ledger record. Credit order was created for -1 CA.
14. Now run Assign, Recalculate and Reassign Agreements (R45100) as a separate job.
15. Row Exit from Credit Order to Ship and Debit. Quantity Applied (QYAP) is -1 in Ship and Debit History (P4575) when it should be -24.

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