Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / PO showing status of O...
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Tom Cruse Profile Picture
    Tom Cruse 1,475 on at
    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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!!

  • Verified answer
    Tom Cruse Profile Picture
    Tom Cruse 1,475 on at
    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.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    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'

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans