E1: 42: Sales Update Not Summarizing Negative Lines In AR Invoices (R42800/F03B11/AR/A/R/Negative/Credit/Invoice) (Doc ID 2436915.1)

Last updated on APRIL 17, 2024

Applies to:

Symptoms

Sales Update (R42800)

If a Sales Order has one or more credit lines, and Sales Update (R42800) Summarization Tab processing option #1 (Summarize A/R entries by Invoice) is set to 1 (Summarize A/R entries by invoice), the credit line is not summarized by Sales Update (R42800) and is put on a separate pay item in the Customer Ledger (F03B11) records that are created.

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

1. Create a two-line sales order with one regular line and one discount line.
2. On the Sales Update (R42800) Version, Summarization Tab processing option #1 (Summarize A/R entries by Invoice) is set to 1 (Summarize A/R entries by invoice).
3. Process the order through Sales Update (R42800)
4. Check the Sales Update (R42800) PDF report.
5. Notice that there is one positive line (pay item 001) and one negative line (pay item 002) on the Sales Update Report
6. Check Customer Ledger (F03B11) and note that there is one positive line (pay item 001) and one negative line (pay item 002) in the table.

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.