"Invalid reference key" and "Error creating employee" errors when syncing Netsuite

Rehana

I am having two issues with a sync.

1. When I sync Expensify to Netsuite I am getting and "Invalid reference key 211 for subsidiary 3"
2. I am getting an "Error creating employee: This entity already exists." when I am trying to export a report to Netsuite

Both the errors look like are Netsuite issues but I am not sure if I need to change anything in Expensify or Netsuite?

Please help !

tylerzoll

@Rehana,

A couple of things- Have you been syncing reports successfully with NetSuite, then something broke or is this the first time syncing?

How are you exporting your reports? Vendor Bills, Expense Reports or Journal Entries? Is this specific report going out as an vendor bill?

Make sure that the corect subsidiary is selected on the NetSuite connection set up tab.

Try syncing your account with NetSuite in the connections tab. Does everything sync there? if not, it should give up the specific entity where there is a conflict.

Rehana

Yes you were right ! I checked the employee's subsidiary setup in Netsuite and check Expensify. They were different and hence it was bouncing off. I have fixed it now.

I am looking into the first error. I need to check which GL account is giving me the problem. Need to dig deeper. I will let you know once I resolve it

Thanks once again for you help Tyler

Sheena Trepanier

@Rehana - Thanks for posting and confirming Tyler's reply resolved issue 2. If you're still running into issue one after looking into that reference key, please let us know!

Rehana

I figured it out. The error meant Invalid key reference 211 was the Internal ID of the bank account for a particular subsidiary with internal ID 3 in our system. We recently changed out bank account. Expensify and Netsuite were in sync but when the Approver was approving the reports he was choosing old bank account. The money did come out of correct bank account (thank God). So for the errored out reports I manually approved it in Netsuite and informed the Approver to choose the right bank account.

Sheena Trepanier

Hey @Rehana - Thanks so much for circling back to this thread and providing a fantastic update to the issue you were having.