Netsuite - Vendor Sync
Is it possible to get individual corporate card expenses to sync to netsuite with that specific vendor name (ie "Amazon" to the vendor "Amazon" and "Target" to "Target"). I know this is possible with the QBO integration, but from what I've found, transactions can only be synced to one overarching vendor record in Netsuite, such as "Amex".
@EByer, That is correct. To be honest, I'm not sure of a great solution to fix this. You can do a lookup based off of information that Expensify submits, but it will still be on the line item. If you sourced in your vendor name into all of the line items on all of your transactions then did a lookup for the vendor on each expense, you might be able to make a report or saved search work. It would probably work well for just a few vendors, but probably not getting all of your vendors to match.
The main issue is that Expensify wouldn't be able to create a new vendor based off of the expense, but in theory you could at least get a report for all of the vendors that you have in NetSuite.
Considering the limitations though, I like to keep my vendor list in NetSuite clean, so I really don't want it to be cluttered with every gas station in America.
Totally agree @tylerzoll, one of our clients likes to see information this we though. I appreciate the workaround you listed. Thanks for your help!
@EByer, if it is something that you end up wanting to do, we have a similar (although a bit different) script that you could use. If you wanted, I could get you in touch with the guy that wrote our script for us.
@tylerzoll If you could introduce us, that would be really great!
@tylerzoll @EByer hello! were you able to find a solution for syncing vendors between Expensify and netsuite?