E1: 42: Invoice Print (R42565) Prints Cancelled Lines For Orders Outside The Status Range (Doc ID 2608680.1)

Last updated on APRIL 18, 2022

Applies to:

Symptoms

Invoice Print (R42565) is printing cancelled lines at status 980/999 from previous orders where the statuses are beyond the From and Through Status setting specified in the processing options.

As a result, invoices are being created and sent to customers with ONLY canceled lines on the invoice.

The client’s customers expect to receive invoices for products shipped to them that include canceled lines, but they do not want receive invoices that ONLY have canceled lines where nothing was shipped to them and no payments are due.

The issue was reproduced by Oracle Support using Oracle Demo Data following the steps below:

1. Using a new Customer with no previous orders, create 2 sales orders (P4210) with 2 stock lines each.
2. Re-inquire and cancel a line on each order.
3. Ship Confirm (P4205) the remaining line on the first order.
4. Check Customer Service Inquiry (P4210) to review the order statuses:
   1. First Order Line 1.000 Status 540/560 – already shipped, ready for invoicing
   2. First Order Line 2.000 Canceled (980/999) – want this line on the invoice
   3. Second Order Line 1.000 – not shipped yet, not ready for invoicing
   4. Second Order Line 2.000 - Canceled (980/999) – do NOT want this line on the invoice
5. Set up a version of Invoice Print (R42565) with processing options as follows:
   1. Defaults Tab From and To Status = 560, based on Next Status
   2. Print Tab Option #2 = 2 (Print canceled lines)
6. Run the Invoice Print Version with Data Selection on the new Customer Address ONLY.
7. An invoice is printed for the first order
   1. On Line 1.000 the customer is billed 3,000.00 for this item which was shipped to them
   2. On Line 2.000 the customer the amount due is zero because the line was cancelled
8. A second invoice is printed for the second order.
   1. Only Line 2.000 the canceled line is printed on this order.
   2. The amount due is zero because nothing was shipped and the line was cancelled.
   3. This Invoice should NOT have been printed and sent to the customer.

Cause

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