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

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) / Requisition Order stuc...
Microsoft Dynamics GP (Archived)

Requisition Order stuck in the wrong status?

(0) ShareShare
ReportReport
Posted on by Renee Leung 6,775

It looks like the status for a requisition may be incorrect.  The requisition items have been transferred into a P.O., yet the status still reads "Ready to Transfer to PO". How do we get the status to change to "Transferred to PO"?

Would I need to look into the Item Purchasing Options?

I do not think GP allows you to manually change the status for a requisition - is this correct? 

*This post is locked for comments

I have the same question (0)
  • Derek Albaugh Profile Picture
    Derek Albaugh Microsoft Employee on at

    Hello,

    If the requisition has been successfully converted to a purchase order, do you see it in the ReqMgmtDocument table in the DYNAMICS database?

    If so, what is the Status for this requisition? If it was successfully converted to a PO, you should see it with a Status of 5.

    ReqMgmtDocument.Status values:

    Created = 1,

    PendingFinalApproval = 2,

    Rejected = 3,

    PendingTransferToPO = 4,

    TransferredToPO = 5,

    Voided = 6

    The POStatus table in the POP10100 of that company should show the purchase order as '1' (new).

    We don't recommend changing the status of requisitions through SQL, but in cases like this where you're sure that it has been converted to a PO, you could change the ReqMgmt tables to show a status of 5 (Transferred to PO) instead of 4 (Pending Transfer to PO).

    I'd also recommend looking at the ReqMgmtOpenTasks table in DYNAMICS to make sure this requisition isn't still listed there, as it should be removed from this table once it is final approved.

    Thanks

  • Renee Leung Profile Picture
    Renee Leung 6,775 on at

    Thank you Derek. That is what I intend on doing. I have put together a script that should hopefully do this.

    Is there anything else I can check on the GP/BP end before manually updating SQL? We ran the Reconcile Purchasing Documents several times with no luck.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February 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