Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

PO status tracking

Posted on by Microsoft Employee

We have production orders that we enter into Dynamics GP 2010 that have multiple purchase orders from multiple suppliers committed to them.  We need to be able to track the purchase orders status, so we know when each component has arrived/is expected to arrive.  

Basically what we are trying to accomplish is to be able to generate some sort of report/smart list that would list at minimum:

(Order#)  (PO#’s attached to that order)  (PO Status)  (Promised Ship date)   (Vendor name).

We have been able to do 4 out of 5 with a purchasing smart list but so far cannot tie in the Order number.  Any ideas?

*This post is locked for comments

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: PO status tracking

    Richard is correct (as usual). I was thinking the MOP/POP Link would give that to you.  It does, if the POs are for outsourced services.

    However, check out the Job Costing functionality, if you own it.  It's an optional part of the MFG suite and would give you the ability to tie MO's and PO's to each other via a Job Number.  This might be too much overhead for your needs but it might be worth a look.

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: PO status tracking

    It's a bit more than just a report or Smart List.  The issue is that, except for outside services, there is no place to link a PO to an MO.

    I would suggest adding an extender window to either the PO or the MO (I think PO would be better) and storing there the MO number for the materials.  It might even be better to link the Extender window to the PO Lines so each line could be for a different MO.  Make sure to add the eXtender fields to the appropriate SmartList and to create a view.

    You can then create a report or SmartList.

    Our book Extending MS Dynamics GP has lots of information on doing this.

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: PO status tracking

    SmartList Builder.  You're going to need a custom SmartList to tie the production order field back to the PO fields.  Either that or a custom SSRS report.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans