Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    ACQ: Open Orders Report contains Received Complete / Invoiced items

    • Article Type: Known Issue
    • Product: Voyager
    • Product Version: 8.2.1
    • Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care

    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

    Category: Acquisitions

    Subject: Invoicing


    • Article last edited: 10/15/2014