MYOB Acumatica and TimeTrak Data Synchronisation from TimeTrak version 21.3 onwards

Timetrak for MYOB Acumatica - Data Mapping Framework



Two way synchronisation between both platforms

MYOB and Timetrak Sync
MYOB Acumatica Timetrak Comments
Customers Customers
Contacts Contacts
Projects Projects
Tasks Tasks

One way synchronisation from MYOB Acumatica to Timetrak

MYOB to Timetrak
MYOB Acumatica Timetrak Comments
Branches Branches
Stock Locations \ Warehouses Stock Locations We create a consolidated Warehouse\Location in Timetrak
Taxes Taxes
Countries & States Countries & States Currently moving from text address fields to lookup fields- will be two way
Suppliers Suppliers
Stock Items Stock Items
Non-Stock Items Stock Items Timetrak combines Stock and Non-stock Items, they are just two different types.
Cost Budgets Quote Lines
Cost Codes Cost Types
Earnings Types Roster Classes
Employees Resources – Users
Project Equipment Resource – Equipment User
Marketing Lists Marketing Classes
Contact Attributes Attributes
Extra Fields Custom Fields (if required)
GL Codes GL Codes If required

One way synchronisation from Timetrak to MYOB Acumatica

Timetrak to MYOB
Timetrak MYOB Acumatica Comments
Approved Time Entries Time Activities TimeTrak sends hours through to the Release Time Activities screen by default. Non-Billable and Non-Productive time can be synced for payroll.

Acumatica Payroll can import hours from the employee Time Cards screen. Note: Time Cards require to be generated for the period. Within the Time Card, users select ‘Correct’ for hours to display from Activities.
Stock Items used Inventory Issue
Non-stock Items used Project Transaction
Quote Lines created Revenue Budget
Cost Budget Used when quote is derived from Timetrak
Job and Task Attachments Files Documents and Image of certain types (categories) can be synchronised back to the relevant Project or Task.
Project Fields Extra Fields on Project Screen Ability to show Timetrak only fields in Acumatica (Job Status, Unposted Time and Unposted Disbursements)

Realtime API calls between Timetrak and MYOB Acumatica

API Call Comments
Sales Price Lookup Due to the multiple parameters and complexity with Sales price calculations, anytime a price is used in Timetrak (Quoting, Disbursements, Labour Rates) we do an API call to retrieve the current value from Acumatica.
Stock Levels Lookup As above Stock levels can change instantly or if you wish to see levels in another location it is important the info is real-time, therefore any stock level lookups while in Timetrak also do a live call to Acumatica.
Purchase Order creation From version 24.3 of Timetrak we will be moving Purchase Orders from a synchronisation routine to a real-time scenario. This has been required to integrate with the Approvals module of Acumatica. Therefore any POs created in either Platform will be immediately available in the other.
File Attachment – direct to Acumatica With the change to Purchase Orders above it may mean certain PO attachment would be directly attached to Acumatica from the Timetrak PO Screen.