Importing Time and Expense Entry (Due to paper timecards required during E11 upgrade)

Kinetic ERP
1

We had to use paper timecards for our OT shift this past Saturday due to the Epicor outage to upgrade to E11. Is there an easy way to import Time and Expense transactions? I do not see a template available in the DMT.

Thank you,
Lisa

2

@lfilzen, I see the following in our version of DMT…

image

3

Assuming the fields haven’t changed much in E11 you will want to use “TE labor Combined” with the following fields.

“Company”,“EmployeeNum”,“LaborHedSeq”,“Shift”,“ClockInDate”,“PayrollDate”,“ClockInTime”,“ClockOutTime”,“PayHours”,“TranSet”,“LaborDtl#Company”,“LaborDtl#EmployeeNum”,“LaborDtl#LaborDtlSeq”,“LaborDtl#LaborTypePseudo”,“LaborDtl#ClockInDate”,“LaborDtl#ClockInTime”,“LaborDtl#ClockOutTime”,“LaborDtl#LaborHrs”,“LaborDtl#IndirectCode”,“LaborDtl#ExpenseCode”,“LaborDtl#ResourceGrpID”,“LaborDtl#JCDept”,“LaborDtl#TimeStatus”,“LaborDtl#OpCode”

4

LaborHedSeq and LaborDtl#LaborDtlSeq both need to be set to “0”