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

Show Requisition Number for PO?

(0) ShareShare
ReportReport
Posted on by Michael Dougherty 315

In requisition management, once you generate a requisition into a PO, it goes into GP 2010.  I am able to pull up the PO just fine, but it gives no information on what requisition number it is from.  How do I find out this information?   Our purchasing department is going to have Requisition Numbers on hand, not PO numbers, so how are they able to search for the requisition after it is turned into a PO?

Thanks!

*This post is locked for comments

I have the same question (0)
  • Rob Bernhardt Profile Picture
    Rob Bernhardt Microsoft Employee on at

    Michael,

    It appears that the requisition number is not persisted on the purchase order.  The reverse occurs however.  You can look at the requisition in Business Portal and see the PO number once it's been generated.  In SQL, you can see this in the DYNAMICS..ReqMgmtLines table.  You could theoretically run a trigger whenever a PO is created that queries that table and updates the PO with the req number.

    Thanks

    Rob

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi Michael,

    The requisition does actually enter in the PO, but on the line item detail only... not on the header level. I created for our purchasing departement a smartlist in GP to help them track the PO's by buyer-id and show also the requisition number from the BP. This makes their life much easier. As the smartlist is based on a SQL view, let me know if you're interested to get the view and how to create the smartlist (you need to have the SL builder of course). You could also create a dynamic report in Excel based on the view, thus you don't need the SL builder in GP, but it would be more natural to have the information in GP all the way.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi Rob,

    Yes the PO number is written back to the requisition management tables (DYNAMICS..ReqMgmtLines), but unfortunately it goes updated only in the work table and not the history, which actually makes no sense to me (at least in BP 4.0). Over the time if you want to clean up the work tables, because users complain about the requisition that are stacking up, you have to copy the missing PO number over to the historical tables before you delete entries...

    I don't know if this has improved or been fixed in BP 5.1.

  • Michael Dougherty Profile Picture
    Michael Dougherty 315 on at

    I would like to see how you were able to achieve this so I can see if it will work for us.

    Thanks

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi Michael,

    Sorry for my late reply, I was in Houston at Convergence 2012 last week :-)... What would you like to see, the smartlist or the rollup of the PO number in the history tables for the requisitions ?

  • Michael Dougherty Profile Picture
    Michael Dougherty 315 on at

    Not a problem, hope it went well.  I guess the smartlist would be best for the end user, correct?

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    No problem, but in order to have  a smartlist linked to the requisition module table, you need to have SL builder... do you own a license for this product ? it could be part of your BRL subscription...

  • Michael Dougherty Profile Picture
    Michael Dougherty 315 on at

    I thought we did, but I just looked through our licenses and we do not have SL builder.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi Michael,

    I actually created a user view on the SQL server side in order to gather the information from the various tables (ReqMgmtDocuments, ReqMgtmLines & GL00105 (optionnal)). This way it could be used anywhere (SL, SSRS, Excel, Crystal). If you're interested, drop me an e-mail and I'll gladly send you the query from the view to create in the DYNAMICS DB.

  • c4c4571f00c7433e8415e0e1141719d2 Profile Picture
    c4c4571f00c7433e841... 1,110 on at

    hi, please send me too this sql view...........im waiting......

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

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