Mike, thank you for your quick response. We are on an older version, and it looks like I will just have to use a subquery to do the calculation myself. Hopefully when we upgrade next year it will fix some of the issues.
We are looking at moving the Test DB to a different server. Having a script is also being looked at.
Thanks for the quick response. It is on the same server. I will send your I will SQL comment over to our I.T. person as she understands it better than me.
Based on your screen shots there are two approved revisions on this part. There is a check in the approved column for both lines. If you go to Part entry and look at the revision tab are there two different approved revisions.
Thank you, Josh. I will be doing some testing to see how much tripling the hourly standard effects costs.
What is strange on this was it was working for him. Now when he refreshes the date range it returns nothing. As soon as I created him with a different user I.D. with same security it works fine. I have actually had this happen to a couple other users over the years.
I believe this is the solution.Under the Actions list for the Fulfillment Workbench Menu there is an option to “Calculate fulfillment on search” This needs to be checked. Otherwise it will not calculate. Each user needs to check this.
Thanks for the input everyone. I think I found what I needed. It looks like it is the due date field on Job Assembly. What we are trying to due is back the schedule up based on the number of days on the receive time field. Since all of our jobs are single level assemblies it looks pretty straightforward.
We created a vendor named Amex and any MRO purchases made with a credit card we also require a purchase order to that vendor. When the parts arrive we receive the purchase order and use that to tie to the bill for the credit card when we get it. It is not perfect, but it does give accounting more info and traceability.
We backflush most material. So I believe in order to balance everything out we would need to reduce the original job by the amount scrapped and create a new job for the difference.
Thank you, Robert. I run a similar BAQ for production postings. I was hoping there would be a way to automatically increase the allocated material on the job to take into account the amount lost to scrap. In our environment we would increase the amount of parent ran to make up for the scrap. The issue is you do not see the additional components required until after they are consumed. The planner ends up getting a call that there is not enough of the component material to make up for the scrap.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.