PO showing status of Open in Inquiry, but is fully received and invoiced

(0) Share

Report

Posted on by Community Member

we have an issue where we are trying to inactivate vendors, but we get the "assigned to PO or unposted receipt" error mentioned in KB article: http://support.microsoft.com/kb/2601436. Unfortunately there are no unposted receipts, and the PO is showing as closed in the zoom window for the transaction, and when I try to edit PO status. however, if we find the vendor in Purchasing Documents Inquiry, it shows a status of Open. we have this issue with multiple vendors, apparently.

anyone have a fix?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Tom Cruse 1,477 on at

Like (0)

Report

RE: PO showing status of Open in Inquiry, but is fully received and invoiced

I completely agree, I was hesitant at first too :) Glad it worked.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: PO showing status of Open in Inquiry, but is fully received and invoiced

That worked! when I saw "Remove completed POs" I thought it would delete the transactions... that's a pretty poorly phrased routine!!

Was this reply helpful? Yes No
Verified answer

Tom Cruse 1,477 on at

Like (0)

Report

RE: PO showing status of Open in Inquiry, but is fully received and invoiced

Step 8 in the KB should do the trick.

I had the exact same problem last week and it required no back-end SQL scripting.

In GP goto Inquiry >> Purchasing >> Purchase Order Documents

- select your vendor and include Open Purchase Orders, and then hit refresh. If a PO shows up then Step 8 should fix it.

Tools >> Routines >> Purchasing >> Remove Completed POs

enter your PO in the range and then hit insert, then click on restrictions, here you can check and uncheck the POs to remove. Its sort of a validation check that the PO will in fact be moved.

If that works then click process. You should now be able to inactive the vendor.

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: PO showing status of Open in Inquiry, but is fully received and invoiced

Michael,

I am wondering if you have problems with PO Line Status not matching the overall PO Status.

Try running this query, replace the PO number in it, with any of the problem PO numbers

select POH.POSTATUS,POL.POLNESTA,* from POP10100 POH

left join POP10110 POL on POH.PONUMBER = POL.PONUMBER

where POH.POSTATUS <> POL.POLNESTA

and POH.PONUMBER = 'PO1002'

Was this reply helpful? Yes No