Using DMT to make labor entries


(Yelena Tuzikova) #1

Hello,
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.

image


(Mark Wonsil) #2

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. :slight_smile:

Mark W.


(Tanner Post) #3

Here is a list of the fields we use to populate labor records via DMT using “TE Labor Combined” if it helps:
Plant
Company
ClockInDate
EmployeeNum
LaborHedSeq
PayrollDate
LaborDtl#ClockInDate
LaborDtl#Company
LaborDtl#EmployeeNum
LaborDtl#LaborDtlSeq
LaborDtl#LaborTypePseudo
LaborDtl#JobNum
LaborDtl#AssemblySeq
LaborDtl#OprSeq
LaborDtl#OpCode
LaborDtl#JCDept
LaborDtl#LaborHrs
LaborDtl#LaborQty
LaborDtl#LaborNote
LaborDtl#ExpenseCode
LaborDtl#OpComplete
LaborDtl#FSComplete
LaborDtl#ResourceGrpID
LaborDtl#ResourceID
LaborDtl#TimeStatus
LaborDtl#OkToChangeResourceGrpID


(Yelena Tuzikova) #4

Thank you both!
I was able to get it to work almost exactly like I wanted.

Now I am trying to figure out how to get the pay hours to be correct. It will not let me include payhours as a column in the upload. Below shows the BAQ results of the new records I created today.