web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / purchase order not sho...
Microsoft Dynamics GP (Archived)

purchase order not showing in list

(0) ShareShare
ReportReport
Posted on by Community Member

I have purchase order that was entered incorrectly and then deleted in PO Entry.  The PO items still show up in past due lists, etc.  But are not listed in PO Entry or Edit PO for the purchasing agent.  When I log in as sa, I can get to the PO in either even though it's not listed by typing in the number, but I can't seem to fix the problem. 

In POP10100, the POSTATUS, STATGRP, and POTYPE are 0.

Any ideas?

Jay

*This post is locked for comments

I have the same question (0)
  • Victoria Yudin Profile Picture
    Victoria Yudin 22,768 on at
    Re: purchase order not showing in list

    With all the types and statuses being 0 I would suspect that the PO didn't complete the process of being deleted.  Have you tried running check links on the purchasing series?  You might need to delete the PO out of the POP10100 table first, then run check links, but I hesitate to give advice like this without seeing the data, just in case there is something else going on.

  • Community Member Profile Picture
    Community Member on at
    Re: purchase order not showing in list

    We did run check links on the purchasing series - no errors.

  • Verified answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,768 on at
    Re: purchase order not showing in list

    Jay,

    One other thing to try may be to run Reconcile on the PO - have you already tried that as well?

    I have definitely seen situations in the past where POs get stuck.  Usually these will also have a blank vendor ID and 1/1/1900 for the dates in the POP10100 table.  In the past I have manually deleted the POs from POP10100 and POP10110, but as I said before, I am not too comfortable with telling someone to delete data without seeing it and knowing the environment (to make sure that this will not impact anything else).  

    Another option may be to fill in the missing data in the POP10100 table - doing that will allow you to open the PO in GP and try to delete it from there again.

  • Community Member Profile Picture
    Community Member on at
    Re: purchase order not showing in list

    Victoria,

    Running Reconile on the PO worked.  We were able to then cancel the PO in Edit POs.

    Thanks!

    Jay

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,768 on at
    Re: purchase order not showing in list

    Excellent!  I am always glad to find a solution without having to muck with the data on the server.  :-)

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans