my open purchase requests showing complete PO

(0) Share

Report

Posted on by Jennifer Kaufman

A user copied a purchase request and created a new one. It went through the approval workflow and was converted to a PO. However, the requistion still shows up in the filter when the user looks for "my open requests". In the ReqMgmtDocument table I see that the status of that requisition is set to 4. When I look at the corresponding entries in the ReqMgmtLines table I see that purchaseorderdocument field has the correct PO entry. How can I get the requisition out of the open requests filter? Is there a check links process I can run on the dynamics db?

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Re: my open purchase requests showing complete PO

Hi Jennifer,

I had the same issue recently for a requisition that was tranfered as a PO. Looks lilke this happens from time to time (glitch ?). I did change the status field value and the requisition did disappear from the list on the user's side. Make sure that the requisition was already copied to the history tables as well (and always take a backup of your tables/databases first).
Andy Sather on at

Like (0)

Report

Re: my open purchase requests showing complete PO

Hello Jennifer - Thank you for using Microsoft Communities. My name is Andy and I will be assisting you today.

I won't be able to provide scripts to fix this issue over a Forum post, but here are the status values for the Req tables:

ReqMgmtDocument.Status values:

Created = 1,

PendingFinalApproval = 2,

Rejected = 3,

PendingTransferToPO = 4,

TransferredToPO = 5,

Voided = 6

ReqMgmtLines.LineStatus values:

Created = 1,

FinalApproved = 2,

TransferedToPO = 3,

Voided = 4