My Oracle Support Banner

E1: 42: Understanding GL Date Cannot Vary and Invoice Date Cannot Vary Work Center Errors When Running Sales Update (R42800) (Doc ID 2668331.1)

Last updated on JUNE 07, 2021

Applies to:

JD Edwards EnterpriseOne Sales Order Processing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

The client has sales order detail lines where the ship date field values vary. Line 1.000 indicates ship date = 05/20/2020 while line 2.000 indicates ship date = 05/31/2020.

At the time these orders process through sales update, the client wants to use the ship date value to assign the invoice date and the GL date values in the Accounts Receivable Ledger (F03B11) and Account Ledger (F0911). The order detail lines have not run through invoice print. As a result, the RI (invoice) number has not been assigned. The RI document number is assigned at the time of sales update (R42800). The client is also summarizing AR and GL.

The R42800 job completes and produces a blank report.  The work center messages indicate the following:

Subject : Error: Invoice Date Cannot Vary
CAUSE . . . . The Invoice Date must be the same value for all lines or pay items within the same transaction.
RESOLUTION. . Enter the same Invoice Date in all lines or pay items in the transaction.

Subject : Error: G/L Date Cannot Vary
CAUSE . . . . The G/L Date must be the same value for all lines or pay items within the same transaction.
RESOLUTION. . Enter the same G/L Date in all lines or pay items in the transaction.

How can this issue be resolved?

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

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