My Oracle Support Banner

E1: 37: Use Actual Ship Date (ADDJ) or Date Promised Shipment (PPDJ) if ADDJ is Blank to Populate Date Shipped on Certificate of Analysis (R37460) (Doc ID 2662581.1)

Last updated on NOVEMBER 13, 2020

Applies to:

JD Edwards EnterpriseOne Quality Management - Version 9.1 to 9.2 [Release 9.1 to 9.2]
Information in this document applies to any platform.

Symptoms

COA (R37460) should use Actual Ship Date ADDJ or Date Promised Shipment PPDJ (if ADDJ is blank) from F4211 to populate the field Date Shipped (PPDJ) on the pdf. Currently, it is using Promised Delivery RSDJ from F4211.  Both Actual Ship Date and Date Promised Shipment are populated during Ship Confirm, the same step when the test results are entered.

An item leaves a warehouse and takes four days to arrive. The date of the promised delivery (RSDJ) is 4 days later than the ship date (PPDJ). The COA will be printed with the Ship Date = RSDJ 4 days in the future.

The pallets and the documents are ready on Friday. On Sunday, the driver will load the truck and pick the docs (COA) on its own. The COA should show a date that makes sense.

The issue can be reproduced by the following steps:

  1. Create a SO (P4210) and ship confirm it (P4205) to enter the QA test results (P3711) from the row exit.
  2. Save the test results, but change ship = 0 in the P4205 line, so theshipment is not confirmed.

  3. In F4211 notice that ADDJ is blank and PPDJ should be use.
  4. Run R37900 over the SO and notice the PDF of R37460 has the field Date Shipped (PPDJ) populated from F4211 Promised Delivery RSDJ. This is not making much sense, as both Actual Ship Date and Date Promised Shipment are populated during Ship Confirm, the same step when the test results are entered.

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
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.