I am making a process that allows a person to type in the hours worked for a group of employees for a given week in an excel spreadsheet. Then once a week the new labor entries get pushed to Epicor using the DMT.
The issue I have run into is that I can’t successfully push any labor records into Epicor. If I only use the required fields that DMT recommends, it says that I am missing a field, screenshot below.
If I go through and add every one of the fields that it says I am missing, I get the “object reference not set to an instance of an object”. I suspect this has something to do with the laborhedseq and labordtlseq generation but that is just a hunch.
Some other details:
We are on Epicor 10.1.4 so we do not have access to the API yet. The customer for this wants this asap and is not willing to wait for the upgrade to get the API.
Ideally, you will be able to type into the excel sheet multiple days, multiple employees and which jobs their hours went to. All of this should happen from the same spreadsheet.
I have made updateable dashboard before but only being able to modify one record at a time, and not being able to add new records crosses off this option as a solution.
For indirect time, I think you need to add LbrHours. In Time and Expense Entry, the required fields are variable depending on what labor type you’re using. For Indirect(I), you need the Code and Hours; for projects(J) you need project, phase, and operation, and for production§ you need job, assmb, and operation. The required fields are required but other fields are required base on the labor type.
Here is a list of the fields we use to populate labor records via DMT using “TE Labor Combined” if it helps:
try this list of fields … made to use with project jobs - but you can adjust
That got me a lot closer.
I used the suggested reprocess file which had changed the format ot the time on some fields
It also turned out I didn’t have an operation’ 10’ (I normally do but had to delete it on that particular job, duh!)
And my Expense code should have been the abbreviated ID not the description displaying in time and expense entry. Finally - VOILA!
Thank you so much
I have that field in my template with an A value,
but still is not updating those fields
since are not in list from the DMT template, i just want to make sure that is Ok to have those values empties. I asked Epicor but still no answer