Labor Entry - Mass Submit?

Any way to enter labor entry hrs against different jobs and them highlight each entry and mass submit? Currently in E9, i use the labor entry to fix qty variance for jobs that are completed but some of their operations are missing. Meaning during labor reporting , some of the employees forgot to report qty against the job operation. In E9, i used to get all the variance between Run Qty and Completed Qty and mass upload them using template in labor entry. Once mass uploaded, highlight all entries and click Submit.
But in E10, i mass uploaded all the variances but when i highlight all and click Submit, only the 1st row is Submitted/Approved. How can i submit / approve everything i entered with 1 click. The Employee used to do these qty variance is a dummy employee id with no labor rates.

I am assuming the date range for the entries are more than a week? If they are not then perhaps you can use the weekly time view to submit.

1 Like

Thank you for quick reply and suggestion. Yes, the entries are all done in a single day, say for example every Friday, so the date range will be within 1 week. However, when i tried to create new weekly time, the option to do so is greyed out. Is there somewhere i need to check off to have access to enter weekly time?

Hi Al,

You need to create the “Payroll Header” first by selecting the Monday on the calendar and then do New Time. Once you do that, you can add Weekly or Daily time.

Mark W.

I believe that the weekly and expense tabs require an additional license.

Brad Boes
bradboes@boosterpconsulting.com
231-845-1090

Thanks Mark and Brad.
It looks like additional License may be required as Brad mentioned. i did create the Payroll Header but only option available was New Time Details which is only good for daily labor entry time. i have no problem entering daily times but issue with E10 was not able to submit everything i entered at once like i was able to in E9. In E10, even if i highlight all the rows i entered and click Submit, only the last Row is “Approved”. So, i have to do it line by line.

We’re a manufacturing Company and use hundreds of jobs which has multiple operations per job. So when our shop employees report time, sometimes not all the qty completed will match job operation qty. In order to remedy that, i used to take a variance between the Job Operation Run Qty and Qty completed (reported via timesheet) and use the labor entry module to mass upload(paste update) Job, Assembly, Operation and Qty (variance calculated) for jobs that are shipped or received to stock. There are hundreds of jobs that would need this correction, so submitting each line would be extremely time consuming…

For the variances you mention, I have seen companies put in BPM rules to
give operators error messages in those instances. This pushes most of the
variance resolution back to the shop floor.

Sorry I can’t offer more help on your issue.

Brad

Is an updatable BAQ out of the question? What about DMT? If you are using DMT you can submit them with the submit field.

If you can write a customization, just have something iterate through the unsubmitted labor details on the list and submit.

Thank Dan… updatable BAQ is NOT out of the question but i am un-familiar with using it. I have / am using BAQs extensively for querying custom data on the fly for our month end analysis. But i have never used it as Updatable BAQs. Is it created in the same manner? i did notice under the “update” tab of the BAQ it was all greyed out? Maybe because of security issues where my Systems Manager has to give clearance before i could access it?

1 Like

Make sure that your BAQ is checked Updatable on the general tab.

1 Like

Is Auto submit on save an option for you?

Yes, Auto Submit on save would be definitely helpful. Is there a way to turn that feature on somewhere in the system? Hoping i could save/sumbit in batches using that feature if possible.

System Setup>Company/Site Maintenance>Site Configuration Control.

Load up your plant.

Modules>Time and Expense tab>Time>Submit on Save checkbox.

2 Likes

Thanks Dan for the helping me with were to go. i didn’t had access to the Site Configuration but my boss was able to check the box for me (Submit on Save). Unfortunately, it’s not doing anything. I highlighted a few lines and clicked Save in labor entry after check the submit on save box. It did not do anything. If i hit “Submit” button it will Approve First and Last row and leave everything else Un-approved. The “Save” button did not do anything.

That’s what I was worried about. I haven’t attempted to use that since E9 and it didn’t seem to be working correctly back then either unless I just couldn’t figure out how to utilize it. I still think the easiest way would be a customization or UBAQ if you’ve got the skill set.

That SUBMIT ON SAVE checkbox really irks me. I tried manually and programmatically disabling it at the form level… if you can change it there, tell me your secret :wink:

So just to confirm your original process. You work out the difference and create new time entry records and paste insert into the grid?

You may want to look at the grid itself and make sure the show the submit on save checkbox and add that to the data to update. My thinking is that the insert is not taking the submit on save into account even though it is set in the system options. To prove this I would run a trace while you are inserting the records, then take a look at the data in the trace file.

And as much as I have been going on about this lately, log it with Epicor if you believe it is an issue, then it can get fixed.

The other thing too if you want it to be automatically approved then make sure you have the Time and Expense settings on the relevant employee record to make it so.

Chris,
Did you try resetting to base and retest, just with the system option turned off/on?

Simon,
Thank you so much for pointing me to the grip itself. I was finally able to do what i wanted based on your suggestion. Thank you all for your help. What a sigh of relief…

I went in to Time and Expense entry and under :
Tools > Personalization > Time > Daily TIme > Detail > List
Under Column Properties uncheck the “TimeAutoSubmit” box (un-hide).
I was able to add that field to my upload with “TimeAutoSubmit = True”. Once the upload started via paste insert, each row started to get approved one by one automatically. - Mission Accomplished… Thank you so much everyone for your inputs.

1 Like

Glad We could help. Don’t forget to mark the topic as solved. Check out the site FAQ if you can’t work it out.
Enjoy your weekend. :grinning:

Haha Hally, what you think I have access to any system settings? :smile: #BackdoorForEverything