Required fields for importing Time Ticket Register

Summary

What are the requirements for importing a Time Ticket Register to Sage 50 Accounting?

Resolution

CAUTION: Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.

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

Required fields:

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.

Need more help?

Chat now

Solution Properties