When you create a template to import Time & Expense on Epicor, normally you don’t care column’s position. But when import Time & Expense, be careful.
I tried to import it but with wrong position of the column, labor / burden hours are made round up. Sample 15.75 hours round to 18 hours. Don’t know the value 18 hours come from.
So to correct this, create a template with the column’s postion as when you create Time Expense manually
This is template:
Company LaborHedSeq LaborDtlSeq LaborTypePseudo JobNum AssemblySeq OprSeq PartNum PartDescription ClockInDate ClockInTime ClockOutTime EmployeeNum LaborQty LaborHrs BurdenHrs ResourceGrpID ResourceID LaborNote JCDept ExpenseCode OpComplete Complete TimeStatus
