Required fields for importing Time Ticket Register

NOTE: When importing and if you get an error on Ticket Number and it’s formatted correctly. Double check to make sure no duplicates.

Employee / Vendor
Recorded by ID
Ticket Number
Ticket Date
Has Been Used in Sales / Invoicing
Invoice Number Used* (Leave blank if the value of Has Been Used in Sales / Invoicing is FALSE)
Activity Item ID
Customer / Job / Adm (Value of 1 for Customer ID, 2 for Job ID, 3 for Administrative task)
Completed for ID (Specify a valid ID based on the selection for Customer / Job / Adm field)
Has Been Used in Payroll
Manual / Timed Option
Start Time* (Leave blank if Manual / Timed Option value is 1)
End Time* (Leave blank if Manual Timed Option value is 1)
Break* (Leave blank if Manual / Timed Option value is 1)
Duration* (Leave blank if Manual / Timed Option value is 0)
Billing Type
Billing Status
Billing Amount

NOTE: While the import process doesn't require other fields, other journals could need them. If in doubt, include them in your import file.