Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Purchase Order Issues
Microsoft Dynamics GP (Archived)

Purchase Order Issues

(0) ShareShare
ReportReport
Posted on by Charlotte Rich 210

Hello all,

 I am running Microsoft Dynamics Great Plains 10. A user from the purchasing department was inputting a new PO yesterday and in the middle of it the system started telling her she didn't have permissions to access the PO. This was specific to that PO only. I had her get out of it and I tried to cancel the PO and void the PO but nothing happens, it just sits there. If I select the PO in SQL Query Analyzer from the POP10100 table it has a status of 0. How can I cancel, void or delete this PO?

 Thank you,

CDR

*This post is locked for comments

  • Anusone Saenphimmachak Profile Picture
    Anusone Saenphimmachak 5 on at
    Re: Re: Purchase Order Issues

    The solution i used:

    1. Run Reconcile on the specific purchase Order

    2. Then as a Power User(because users won't have access to POTYPE: 0) --> Open up the Purchase  Order and enter the missing header (POP10100). Type, vendor ID, etc.. -> click "SAVE" users will now have access to it.

    The only way i was able to replicate this issue...

    1. Open up Purchase Order Entery --> which will auto generate the PO number --> the Purchase Order number is updated in POP10100 --> select Vendor ID, Buyer ID --> POP10100 still only contains the PONUMBER

    2. Enter Line Items --> this will populate POP10110

    3. If users don't click "SAVE" the POP10100 will not get updated with POTYPE, POSTATUS, STATGRP, VENDORNAME, VENDORID, etc.   --> So if there's a network issue or if users don't logoff  and the system is set to clear the activity table everynight...this issue will occur.

  • Charlotte Rich Profile Picture
    Charlotte Rich 210 on at
    Re: Re: Purchase Order Issues

    I used your approach of backing up and then replacing the missing data from within SSMS. Once I did that I was able to go into the PO as usual in GP and void the PO.

     Thank you!

  • Charlotte Rich Profile Picture
    Charlotte Rich 210 on at
    Re: Re: Purchase Order Issues

    Thank you so much for the advice. I will go ahead and try your suggestion. I'll post the results after.

    Thanks,

    Charlotte

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Purchase Order Issues

    Using MS SQL Management Studio, open the PO header table and examine the affected PO vs other POs.  You will find significant data missing in the damaged PO.  Since it is no good, enter via the management studio the missing data.  Once things like the vendor data, dates, etc are completed, then you should be able to go into GP and delete or cancel the PO.  You may also need to make some adjustments to PO line items.

    CAUTION, back up your database first.

  • Chad Anderson Profile Picture
    Chad Anderson 420 on at
    Re: Re: Re: Purchase Order Issues
    Not sure on that one.  You may need to contact support.
  • Charlotte Rich Profile Picture
    Charlotte Rich 210 on at
    Re: Re: Purchase Order Issues

    Thank you for your response. I did run checklinks for purchasing and it didn't resolve the issue. Should I run the reconcile utility?

  • Chad Anderson Profile Picture
    Chad Anderson 420 on at
    Re: Purchase Order Issues

     Did you try running checklinks against the Purchasing transaction table?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans