E1: 40R: Shipped Quantity Calculation in F47032 (EDI ASN DEMAND SCHEDULING DETAIL) Incorrect if Exact Standard Pack Quantity is not Used on Shipment Running EDI Advanced Ship Notice Extraction (R47032) (Doc ID 2936745.1)

Last updated on JULY 03, 2023

Applies to:

Symptoms

The CUM Shipped (CUMS) in the F470372 is not calculated correctly for standard pack items if the items selected are not the full standard pack quantity. The CUM shipped values are properly updated to the F40R12 and the F4942 during ship confirm, but when the R47032 is ran, the last record for the CUM Shipped value is not being updated in the F470372.

STEPS
-----------------------

1. Setup a new standard pack item (P4101). Make sure a UPC code is defined in the Shipping/Storage in the Item Master.
2. Setup item standard pack as 40 EA per Box in P460131.
3. Setup 1 Box per Pallet in the P460132.
4. Using the P4114, adjust in inventory to 3 different lots, but for two of the lots, add a quantity less than the standard pack (ex: 40, 31 and 9).
5. Setup a customer in the Demand Rules (P40R20) for DSE processing.
6. Verify the current CUMS value in the P40R12 (ex: 440)
7. Add EDI data in the P47171 for the customer/item. On the EDI Demand Detail, populate the CUM Quantity Flag with a 1.
8. On the schedule (F47173), input a quantity of 520. As the CUM Quantity Flag is set to 1, this means demand will be created for a quantity of 80.
9. Run the R47171 to create demand detail records.
10. Run the Create Schedule UBE (R40R010) to generate a sales order for a quantity of 80.
11. Approve the shipment using the P4915.
12. Setup a version of the P4205 for pack confirm that does not relieve inventory. Split the quantity of 80 into the three lots created earlier for quantities of 40, 31 and 9.
13. Go to the P4615, find the shipment and take the row exit-->carton detail. This will generate F4620 records.
14. Go back to the shipment and confirm the shipment using the P49645/P4205.
15. Verify the CUMS value calculated in the F40R12 and F4942 is correct (520).
16. Run the R47032. Review the CUMS quantity in the F470372. It only shows 511. It is missing the quantity of 9 on the last line of the shipment and sales order.

 

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.