Loading...

How To Sync Existing Xero Records to Wisenet

After you have set up your Xero account with Wisenet, you may need to sync existing records. The article outlines the required steps to:

  • Sync Wisenet Learner records to Xero Contacts
    • This will create a new duplicate record if the Learner already existed in Xero
  • Merge the duplicate Keeping the Wisenet generated Contact
  • Once all the merging is completed the Xero Invoices can be Resync’d which will add them to Wisenet
Before you begin:

Required Knowledge: Xero Integration

Required Pre-Steps: Set Up Xero Integration

1

Ensure Wisenet Learners are in Xero Contacts

This step involves syncing the required Learner records from Wisenet to Xero. You can identify a Xero Contact that has been generated by Wisenet by finding the Learner RefInternal number against the Learner. If you do not see this number then it is the old Xero Contact record.

This process will create a new duplicate Xero Contact record if the Learner already existed in Xero. This is required so that you can then merge contacts and keep the Wisenet generated Xero Contact.

There are a number of ways to Sync a Learner to Wisenet.

2

Set the correct Wisenet generated Xero Contact

Once the Wisenet generated Xero Contacts are created you can then use the Xero Merge Contact process which will move the Invoice and other Financial details to the correct Xero Contact record.

  1. Navigate to Xero and go to your Contact list
  2. On the Left Menu, Choose All
  3. Make sure the list is ordered alphabetically
  4. Look in the list and go from page to page and see where there are duplicate contacts due to one having the Wisenet Student Number in it
  5. Tick the checkbox against the non-Wisenet contact, then choose Action and select Merge
  6. A popup will show to choose the record to merge this record into. Search for the required Wisenet contact
  7. You should now have one record remaining that is the Wisenet contact.

Click image to enlarge

If you merge a Learner in Wisenet it will change the name in Xero to have the new “Merged” name.

You will need to ensure that the correct Wisenet record is in Xero and then also merge the records there keeping to correct Wisenet record.

You may then need to resync Invoices.

3

Resync Invoices and/or Learner to Wisenet

Xero has a requirement that field ‘ContactName’ must be unique. Therefore to prevent integration issues, this is derived from ‘ContactFirstName’ ‘ContactLastName’ ‘RefInternal’. The only impact this may have is that the ‘ContactName’ is generally the default field used on Xero Invoices. Therefore to avoid having the ‘RefInternal’ field on the invoice you need to create (or modify) a custom invoice template to use the fields ‘ContactFirstName’ ‘ContactLastName’ instead of ‘ContactName’.

  1. Go to Settings and then Connected Apps
  2. Select Manage
  3. Please choose the correct option to resync to Wisenet
  4. Complete relevant date range.
    • Note: If this is the first time you are syncing invoices or connecting Wisenet to Xero please choose a date range 1 year prior to your Xero account.

Click image to enlarge

PLEASE WAIT…missing invoices

  • If you do not reconnect to the new Xero you will not see any invoices in Wisenet
  • When you resync due to strict Xero integration limits it may take up to 24hrs for all invoices to re-sync
  • Please let your staff know if they can’t see invoices this may be why
  • If after this period you still are unable to see some invoices please raise a support ticket

Was this Resource helpful?