web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Chad Anderson Profile Picture
    Chad Anderson 420 on at

     Did you try running checklinks against the Purchasing transaction table?

  • Charlotte Rich Profile Picture
    Charlotte Rich 210 on at

    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
    Not sure on that one.  You may need to contact support.
  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    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.

  • Charlotte Rich Profile Picture
    Charlotte Rich 210 on at

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

    Thanks,

    Charlotte

  • Charlotte Rich Profile Picture
    Charlotte Rich 210 on at

    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!

  • Anusone Saenphimmachak Profile Picture
    Anusone Saenphimmachak 5 on at

    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.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans