PO status tracking

(0) Share

Report

Posted on by Community Member

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

All responses (3)

Answers (0)

Frank Hamelly | MVP... 46,527 Super User 2025 Season 1 on at

Like (0)

Report

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 25,195 on at

Like (0)

Report

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... 46,527 Super User 2025 Season 1 on at

Like (0)

Report

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.