We are trying to setup auto job complete and closing processes. In trying to make sure everything is where finance wants it, we seem to be having some confusion.
Finance requirements, allowable tolerance +/- 10% and $2000 max. Current parameters in testing are setup like this and I’ve also tested with 10 in all of the qty boxes.
Finance is making the assumption that the EstJobCost is ProdQty*StdCost so for one of our example jobs that it completed, they calculated the following: The EstJobCost would be $40,344.60. Our -$6,089.18 variance is 15.1% of the estimated cost.
I’ve put tickets into support without much luck. Any suggestions?
Couple of things to check. First, was the closing code assigned to the Product Group of that Job. Second, I believe a 0 means it will not check that field. Try changing the Under to 1 or something else and see what happens.
Thank you for the suggestion. I reversed the jobs that were flagged as completed from running it the last time and this time through it did not flag anything for complete.
I have the parameters applied to all product groups.
Like if you make more than the job called for or less than the job called for, but you did so correctly, like used the proper proportion of labor, material, etc. for the underproduction or over production, job closing still compares your total costs to the estimated costs for the job at the quantity you released it for… not what the costs would be using standard cost at the actual quantity produced.
This isn’t what is happening in your case, right @lindsayc?
The job was for 1500 and 1600 is what was actually reported. It was a batch job so that is it’s own confusion but it was not expecting it to complete or close.
Like even if Epicor just made a setting where it did this action for you, you know? Like, “set expected qty to actual quantity,” that way they could still keep the job completion and closing process coded the same.
This process is cutting down larger 4 ft x 8 ft panels into 8 in x 10 in panels. We are using shop grade material so there’s an estimated amount of material pulled off the shelf to cut down and in some cases the shop grade has more scrap and others less. So this time there was less scrap. Instead of returning the material back, they typically process whatever was pulled. There isn’t a good way to estimate how much material you actually need since where the imperfections are that create shop grade very full sheet to sheet.
Makes sense. But you could put a scrap factor on the material equal to what the average scrap is. So if you calculate average scrap to be 1%, you would issue enough to make 1515. Then if you get more, bonus! If you get less, you issue more material.
If you typically make more/less production quantity on these jobs, you can look into Production Yield Recalculation process. We use it in our fab areas - if we scrap at the first operation we can’t “catch up” more parts. By running production yield recalculation, it automatically resets the production quantity. This helps us by MRP picking up that we need more as well as completing the final operation automatically flags the job as a candidate for completion.
Jenn
In our experience, Auto job close created a lot of confusion and it never worked properly. We ended up creating a BAQ with all possible combinations and then use an external BOT to trigger a series of job close operations. It’s been working beautifully for over a year now.
