My Oracle Support Banner

E1: 42: Sales Journal (R42810) Passes Order Date (TRDJ) to Vertex for use in Tax Retrieval Calculation Rather Than Invoice Date (IVD) When Invoice Date is Assigned (Doc ID 2750132.1)

Last updated on FEBRUARY 05, 2021

Applies to:

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


The Sales Journal (R42810) sends the Order Date (TRDJ) rather than the Invoice Date (IVD) into Vertex for use in tax rate retrieval. Invoice Print (R42565), Sales Update (R42800),  Online Invoice Inquiry (P42230), Display Before Accept (P42232), Print Pick Slips (R42520), and Bill of Lading (R42530) all use the invoice date, when assigned, to retrieve the Vertex Tax Rate.  Reconciling the Sales Journal to transactions is difficult when the order date and invoice date are in different months and a rate change occurs.

The issue can be reproduced at will with the following steps:

  1. Create a Vertex sales order with order date 01/01/2021
  2. Process the order through to invoice print with invoice date 02/02/2021. The tax rate changed on 2/1/2021
  3. Run the sales journal for the order. Note the tax amount is based on the order date rather than the invoice date.


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

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