Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Step 1 - Identify your source object in the mapping. For this example, we have created a custom object Timesheet to better illustrate the mapping setup. The Timesheet object will be the source object.

Note

These steps below are very important. Xero is very strict when it comes to Timesheets. And rightly so, it drives employees pay slips, and you do not want to get that wrong.

Salesforce Data

Xero

Description

Timesheet related data

Timesheet__c.Resource_Xero_Id__c

EmployeeId

This provides reference for the Xero employee in the timesheet. This recordId is available in Xero. When you have connected your salesforce org to Xero, the information can be retrieved from the Xero Setting tab.

Open the App Launcher, search for “Xero Setting List” tab, click the the “Employee List” Tab

Timesheet__c.Date_From__c

StartDate

Identifies the start date of the

payperiod

Pay period of the timesheet. This is defined in Xero.

Timesheet__c.Date_To__c

EndDate

Identifies the end date of the

payperiod

Pay period of the timesheet. This is defined in Xero.

Time Logs related data

Salesforce Data

Xero

Description

Time_Log__c.Earnings_Rate_Id__c

EarningRateID

Identifies the Earning Rate ID for the time log. This information is available in the Xero Settings. When you have connected your salesforce org to Xero, the information can be retrieved from the Xero Setting tab.

Info

Open the App Launcher, search for “Xero Setting List” tab, click the the “Earning Rates” Tab

Image Modified

Time_Log__c.Date__c

This is the date when the resource/employee log the number of hours.

This will not be sent to Xero, however, the date will be used for

aggregrating

aggregating the total hours for each dates.

Info

If there a missing dates in the time logs compared to the timesheet Start & End Dates, TwixRiva will ensure that '0' is sent to TwixRiva for processing

Time_Log__c.Hours_Worked__c

NumberOfUnits

The number of hours for the time log

Step 2 - When the mapping is ready, navigate to Setup - > Custom MetaData Types - > Managed Records Next to XeroAutoCreate TimeSheet Mapping.

...