I am testing the Job Closing DMT; there are options for “Backflush” and “Backflush Processing”. I can guess what the purpose of the first one is; to issue all unissued mtl. Not sure why the second one?
The strange thing is that I can’t get it to backflush at all. Worse; when I set either flag, DMT acts like it successfully closes the job, but when I check up on it with Job Closing I see that the job is still open and nothing backflushed.
If I take the backflush related flags out of the DMT script the job closes, but nothing backflushes.
Has anyone seen this before?
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).
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:
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?
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.
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’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.
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.