Expensify.org/hunger SNAP campaign status
We’re no longer accepting new participants as our focus is on reimbursing existing claims. While we’re unable to provide a specific timeline on when your report will be reimbursed, we’re doing our best to drive donations and keep reimbursements moving forward. If you know anyone who can donate to this campaign please encourage them to enable Personal or Corporate Karma on their Expensify account.

Issues with Expensify syncing to NetSuite

DougJohnsonDougJohnson Expensify Customer Posts: 1
in Integrations and API

Hi all,

Was wondering if someone could help me with some issues my team has been facing with syncing data between Expensify and NetSuite. Given the amount of people who have got to be using both NetSuite and Expensify, I was wondering if anyone had run into any of these issues before and could let me know how you solved any of these problems? We've got 3 main challenges:

  1. When one of our employees creates an Expensify account, there is no field for them to enter in an address - NetSuite then automatically syncs with Expensify and creates a new vendor, but without an address field. This occasionally causes issues when payments are issued to vendors without addresses - these payments are then kicked back and create more work on our end.
  2. When an employee creates their Expensify account (and this gets synced with NetSuite), a new vendor is created in NetSuite using the employee's email address as the name field - is it possible for the vendor to be created using the first and last name fields (and for an external vendor ID to be generated)?
  3. Sometimes, employees who are already in our NetSuite system as vendors create an Expensify account, which, once synced, creates a duplicate vendor record in our system. Given that the email address in their initial vendor profile and in their new Expensify account are the same, is a way to avoid this duplicate vendor record creation?

Thanks everyone, appreciate the help from the community!

Flag · Accept Answer Off Topic Insightful Vote Up Awesome

Answers

  • Greg SchroederGreg Schroeder Expensify Team Posts: 49 Expensify Team

    Hi @DougJohnson, happy to help here.

    1. Expensify doesn't currently have the concept of an address field, so there wouldn't be a way to generate this upon export. The vendor record address would have to be added on NetSuite's end.
    2. The NetSuite integration requires that the name field has a matching email address with the submitter's Expensify account in order to work properly. You won't be able to adjust this at this time.
    3. Hmm - I would expect that an existing vendor record with the same email would trigger an error upon export when the new vendor creation is attempted. Typically we prevent new vendor creation for this reason exactly (to avoid duplicates). 🤔 Perhaps you could write into [email protected] and we can look into that more deeply.
    Flag · Accept Answer Off Topic Insightful Vote Up Awesome
Sign In or Register to comment.