Complete Receipts Dialog Displays Multiple PO Lines

Symptom

STEPS:

1. Create a new work order 1002 and change the status to APPR.

2. Create PO 1106. The PO line contains only one line for a stocked item.
Do NOT enter a storeroom.
Enter work order 1002.

3. Approve the PO:





4. From the "Select Action" menu, revise the PO.
Enter rev 1 in the description:



5. Approve revision 1.

6. From the "Select Action" menu, revise the PO.
Revise revision 1, revision 2 got created.

7. Approve revision 2 and then revise revision 2.
Revision 3 will be created.

8. Go to the Receiving application.
Bring up PO 1106.
Two records come up, one in APPR status and one in PNDREV:



9. Select the PO that is in APPR status.
"Select Ordered Items" against the APPROVED PO.
Save the record.

10. Click on the arrow next to the PO number to hyper-link to the PO application.
From the "Select Action" menu, choose "Complete Receipts":



From the dialog box, there are multiple lines to be completed:




This is incorrect.

Expected: The complete receipt dialog should display only one line.
Actual: The complete receipt dialog displays 3 lines including all of the PO revisions.

Take a look at the log, it is running this query:

select * from poline
where
ponum= '1126'
and receiptscomplete = 0
and siteid = 'BEDFORD'

it returned 3 records

Those lines seem to be from PO revisions.
A where clause is necessary to narrow down the result set in the "Complete Receipt" dialog in the Purchase Orders application.