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
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.
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156