So i recently asked for help on creating a BAQ for just this question (Link). After a few trial and error attempts, Epicor support actually got me rolling. Only for me to run into a “Field cannot be null” error. Apparently i cannot change a jobs resource group through a Udashboard; or so the support person told me. Something to do with the update.exe(?) process? i wasn’t sure what he was talking about.
so i then tried to unrelease and unengineer most of the jobs through my Udashboard and then thought maybe a DMT change would do the trick now that all the jobs are open for editing…Nope! no changes yet again.
Does anyone know a way that i can MASS-change my Resource groups and Resources at the job level?
Can you show the BAQ source code and the table criteria in phrase builder? I was able to update fields at the resource level of all open jobs without issue previously. I know mine had to exclude any operations that had already started, but I didn’t have a null issue.
I need to clear out either the Resource group or Resource depending on which one i want to keep. We are having an issue with running the global scheduler and this is one known blocker, having both resource and resource group filled in. So when i upload my udashboard and edit the fields they come up red and say cannot be null
I have been able to manually schedule a job through the jobentry screen with only the resource ID filled in on multiple occasions. I just cannot get the global scheduler to work. Epicor sent me a GIANT list of possible fixes and one of them has been that the Capability, Resource group, and Resource must only have one filled in. Filling in more than one will cause the scheduler to freeze which is the problem we’ve been facing from the beginning. All of our jobs have 2 filled in. When i remove one of these, and schedule, everything works as planned.
As for the source of the BAQ, do you all mean then Query Phrase?
That was information I was looking for. If I remember correctly, you cannot edit operations that have already been started. I would suggest putting criteria on the JobOper fields where ActSetupHours = 0.00 and ActProdHours = 0.00 and try again from there.
We’ve always had our ResourceGroupID selected on every operation and the ResourceID selected only on particular parts/jobs and haven’t had an issue. From what I understand is that the Group needs to be selected for the Resource to come in as an option. Perhaps it can’t pull in the ResourceID without it and it’s throwing an error because the group field is blank?
That’s my understanding from the Udashboard. But the weird thing, and this happens alot in this software, is that i can do exactly what i need to do ( leave the resource group blank and have a resource) manually one by one on the job level. How come this cant be replicated automatically/through DMT?
for the record, when you do what i just mentioned and leave the resource group blank, the resource drop down contains ALL available resources. So i assume the group box is more of a filter
If it’s like some of the other uDashboards I’ve created is there are some BOs that end in Impl ie LaborImpl, (not exact) which is not accessible through any BPMs. I was attempting to allow time details to be updated and update the associated LaborHrs and BurdenHrs. Through the Time & Expense entry, you can change the time and it will automatically update those fields, but not through the uBAQ. Traceroute identified with the Impl. I’m not 100% sure that this is where you’re having the issue, but you might do a client trace to see which BO is being used on the Job Entry screen.
Went into my test database to find out and all of the changes appear to be ran through the BO “JobEntryImpl”. I don’t know why they put in Business Objects that can’t be called outside of entry screens. Unless someone else can chime in and tell us how
Joe,
I think I just tried this with DMT (Job Operation Import) and it seemed to work.
What Version of Epicor are you running? I tested this in a 10.0 version.
Have you tried using DMT?
Here is a screen shot of the fields I included in my load to get it to work:
To Demo this I found an Engineered & Released Job and made sure one of my operations had resources that had both the resource group and resource defined on the same record. Then I used a BAQ to pull out only Open, uncomplete, not started Operations where the resource group & resource are not blank. Then I sent that to Excel, cleared out the Resource Group column and loaded it with DMT and checked the Job to make sure the change applied.
As others have already said, if your operation has already started that might be blocking you, those you will need to do manually.
Have you tried enabling tracing when you manually perform the steps you are attempting to recreate programmatically and checked if there are some BO methods that you can call? I like to find the BO’s and add a pre-processing method directive on the method that spits out all the parameters and tables passed to it since the trace often will show different information for some reason.
