Symptoms

* Open Orders Report produced by Pacqjob -2 has unusually large number of entries
* If line item is received after Invoice has been Approved, it has appropriate status of Received Complete / Invoiced, but appears in Open Orders Report erroneously
* Line items received prior to being Invoiced do not show up on Open Orders Report

Defect Status

Issue 16384-22225 / VYG-4654 is resolved for Voyager 9.1.0 and higher.

Replication Steps

1. Create purchase order and add line item; Approve PO.
2. Create Invoice and add line item; Approve Invoice.
3. Receive item
4. Note that line_item_status in line_item_copy_history is 1 = Received Complete; line_item_status in line_item_copy_status is 6 = Invoiced
5. Run Pacqjob -2 (Open Orders Report)
6. Note that the line item, though it has been Received Complete and Invoiced, appears on Open Orders report (see SQL example #1 in Other Information section).
7. If item is received prior to invoicing, problem does not occur (see SQL example #2 in Other Information section).

Workaround

None

Additional Information

Example #1:
Item shows up on Open Orders report in error; item was received after invoice was approved.

SQL> select * from line_item_copy_history where copy_id in
2 (select copy_id from line_item_copy_status where line_item_id = 3092);

COPY_ID AUDIT_ID LINE_ITEM_STATUS STATUS_DATE INV_LINE_ITEM_ID
---------- ---------- ---------------- ------------------- ----------------
3402 6716 8 2013-06-04 17:27 16 0
3402 6717 5 2013-06-04 17:27 38 1191
3402 6718 6 2013-06-04 17:27 52 1191
3402 6720 1 2013-06-04 17:35 23 0


SQL> select * from line_item_copy_status where line_item_id = 3092;

LINE_ITEM_ID LOCATION_ID COPY_ID MFHD_ID LINE_ITEM_STATUS INVOICE_ITEM_STATUS STATUS_DATE ITEM_ID
------------ ----------- ---------- ---------- ---------------- ------------------- ------------------- ----------
3092 8 3402 25373 1 6 2013-06-04 17:35 23 0


Example #2:
Item does not show up on Open Orders report (correct behavior); item was received prior to approval of invoice.

SQL> select * from line_item_copy_history where copy_id in
2 (select copy_id from line_item_copy_status where line_item_id = 3096);

COPY_ID AUDIT_ID LINE_ITEM_STATUS STATUS_DATE INV_LINE_ITEM_ID
---------- ---------- ---------------- ------------------- ----------------
3406 6730 8 2013-06-05 09:14 27 0
3406 6731 1 2013-06-05 09:14 34 0
3406 6732 5 2013-06-05 09:14 38 1195
3406 6733 6 2013-06-05 09:14 46 1195


SQL> select * from line_item_copy_status where line_item_id = 3096;

LINE_ITEM_ID LOCATION_ID COPY_ID MFHD_ID LINE_ITEM_STATUS INVOICE_ITEM_STATUS STATUS_DATE ITEM_ID
------------ ----------- ---------- ---------- ---------------- ------------------- ------------------- ----------
3096 8 3406 60811 1 6 2013-06-05 09:14 34 0

• Article last edited: 10/15/2014