Is there a report I can run that will provide me the last date of production on an order?
Check out Part Advisor and also Purchase Advisor.
Thanks, looking report which tells the last date of job has been in production, example If a job is still open when was the last time we worked on those jobs? kind of things.
If you know the job, then look at the Job tracker to see labor transactions (also material and subcontractor transactions). If you want everything, then run the Production Detail Report. Make sure to check the flags for things you want to include like operation transactions.
If you want to develop your own dashboard to show just the jobs or types of jobs you are interested in, then a BAQ can make quick work of this request. If you want last production date, and that means the last time someone logged labor as “production”, then join your Part table with the LaborDtl table to pull in the last labor transaction.
If you want to see more than one part at a time, this is likely your best option. I don’t think LaborDtl contains PartNum though. You could get there via the JobHead table. You could also consider using PartTran for the last Receipt and/or Ship Date depending on if you’re MTO or MTS. That might be easier to summarize and who doesn’t like a good PartTran query?
3 Likes