E1: 42: No Invoice Total on Sales Update PDF When Bypassing A/R (Doc ID 1986374.1)

Last updated on JANUARY 19, 2017

Applies to:

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

Symptoms

On : 9.0 version, Sales
Sales Update (R42800)
Tools Release 9.1

When Bypass Update to Accounts Receivable is set in Sales Update (R42800), the total line for each invoice on the Sales Update PDF will not display total amount printed for the Invoice because that amount is fetched from the Customer Ledger (F03B11) record which is not created.

The client expects the total line for each invoice on the Sales Update PDF to always display the total of all the lines even when the Bypass Update to Accounts Receivable is set in the processing options.

The issue can be reproduced at will with the following steps:
1. Create a multiline Sales Order for items that have plenty of inventory.
2. Setup Sales Update (R42800) Version XJDE0004 so the Update Tab Processing Option #2 (Bypass Update to Accounts Receivable) is set to 1 (Bypass Update to Accounts Receivable) .
3. On the Summarization Tab, all processing options are set to blank (no summarization)
4. Run the Sales Update Version. The Total For All Invoices line does not have a total amount printed for the Invoice because that amount is fetched from the Customer Ledger (F03B11) record which is not created. However there is a Journal Entry for Accounts Receivable which is the sum of all Sales lines.

This is a problem for this client for Internal Sales to Construction Jobs which Bypass creation of Accounts Receivable (F03B11) records at sales update. These Sales Update PDF files get emailed to the project manager of the construction job in lieu of an invoice and decisions are made and actions are sometimes taken depending upon the total sales amount. Additional work must be done by the local construction office to manually calculate these totals since they are not printed on the report.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms