E1: 47: Direct Ship EDI Receipt of 12 EA Increases Sales (SD) Quantity from 1 DZ to 12 DZ (Doc ID 2671157.1)

Last updated on NOVEMBER 04, 2022

Applies to:

Symptoms

When an EDI Receipt (R47071) is used to receive a Direct Ship (OD) purchase order in EA that was ordered in DZ (dozens) on the Sales Order (SD), the sales order is updated incorrectly.

•  The quantity ordered and quantity shipped on the sales order gets changed from 1 DZ to 12 DZ.
• The Extended Amount of the sales order is increased by a factor of 12.

The issue is illustrated in the screen prints below:

Create a Direct Ship Sales Order for 1 DZ of an item with Secondary UOM of EA. Price is 300.00 EA and Extended Amount of Sales Order is 3,600.00. Status of the Sales order is 520/560 on Line 1.000.

Direct Ship Purchase Order (OD) is for 1 DZ after sales order entry.

EDI Receipt Input Data sent from the Supplier is for a Receipt of 12 EA instead of 1 DZ.

Run EDI Receiving Advice Edit/Create (R47071). The report shows Quantity Received was 12 but it doesn’t say 12 EA or 12 DZ.

Review the Direct Ship Sales (SD) Order. While the order was originally for 1 DZ (12 EA) at a Price of 300.00 EA and Extended Amount of 3,600.00, the sales order was changed to 12 DZ (144 EA) at 300.00 EA and Extended Amount of 43,200.00.

Check the Direct Ship Purchase Order. Line 1.000 for 1 DZ is changed to 0 DZ and a second line, 1.001, is created for 12 EA at status 400/999.

Run Sales Invoice Print on the SD Order. The customer is invoiced for 43,200 instead of 3,600.00.

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.