That is what I am using as well; except I opt to complete and close the jobs. Good to know that it does work for you at least.
You have the “QuantityContinue” column in the DMT, too? I know that was an obscure thing I had to find.
I think “Schedule Job” is the screwiest DMT I know of. There’s a magical column you have to know about called “OverRideHistDateSetting” and set it to 1 for every row. And “StartTime” is a text field, so in Excel I have it as '6:00 (with the apostrophe).
There are some interesting DMTs out there.
Have that column as well… In general I love DMT’s but they can be vexing… I usually try to go through the steps on the menu when laying out the fields. Still wondering about the “Backflush Processing” and the need for that.
I have given up on backflushing the unfulfilled mtl requirements and I have created a DMT to mass issue them. Not pretty, but it works. All my Ops and Mtls have now been satisfied.
Next problem: each job I try to close by DMT gives me the error: “Table: JobClosing Msg: A valid job number is required.” I can manually close the jobs using the exact same jobnumber. This is what my DMT template looks like:
JobNum,Company,JobComplete,JobClosed,QuantityContinue,ClosedDate,JobCOmpletionDate
I have been able to use this exact template in the past, which leads me to believe that something in the DMT or data is off.
Has anyone seen this before?
Paul
I’d think you need Plant in there.
It doesn’t show as part of the Job Complete/Closing template in my 4.0.57.00 version of DMT. I added it, and it passes the Validation. Unfortunately, it still gives me the valid job required error.
-Valid point though; I have seen in the past a similar error when I run updates on jobs from a plant, and it happens to be not the plant I last logged into. Many things related to jobs I run a separate DMT for each plant.
P.
Oh, are you logged into full Epicor into the plant/site that the DMT is for? It can matter. Not sure about Job closing specifically.
I found the error. Excel dropped a leading 0. Can’t believe I missed that. It lead to another error; A valid completion Date is required. I tried multiple variations of MMDDYYYY, but none sticks. Is there logic as to what makes a date valid or not? In Job closing there is no problem using today’s date as complete and close date…
You know, I don’t know if there’s like a guide to that, but I always just use “Short Date” in Excel (it’s my favorite date format anyway) and that’s always worked. I have always wondered if it mattered.
I doublechecked the job to make sure that previous runs didn’t already show it completed with a non-matching date, but that is not the case either. I wonder if there is anything else I am missing…
@psiebers I just use =today() in excel with the default date format. I have the same columns as you, but JobCompletionDate is before JobClosedDate and Company is last.
I’ll try that; I have reshuffled the order before; let me see if that makes a difference. I used this template before and it worked, but I realized that we recently updated DMT to the latest release. Something might have changed to stop my old template from working.
Still no joy…
@psiebers Its better to create Updatable BAQ for this purpose as few cases DMT is unpredictable with upgrades
Is there a way I can automatically process hundreds of jobs with an updatable BAQ? Not sure if there is. Epicor’s DMT is one of the pickiest I have worked with, I must agree.
You can actually process hundreds of jobs in the job closing screen. I use DMT for mine, but our operations person who closes uses paste insert in the list. For 500 jobs it takes about the same time to process them.
2 Likes
Greg; you are right, it does come with a list view… Didn’t think about that one. Let me try…
Wow, I never noticed that! No kidding. It is still nice for it to run in the background with DMT, though.
Greg; Looks like it works. It does halt on the Completed Qty<Planned Prod Qty error. DMT has a flag to continue. How do you get around that, or do your quantities always match? I tried to simply enable that field in a Customization, but the Qty Completed Continue field is set to Int in the grid, and I am not sure how to process a boolean. For now I will keep hitting the OK button to watch the process…
We only close when they match.