Transaction Vendor Bill question: I need to update...
# general
h
Transaction Vendor Bill question: I need to update a bunch of records that pulled in from our bill.com integration into Netsuite but set the location incorrectly (Found the issue and resolved for the future) I've attempted to export all of the effected bills, update the location to null and import it back in thinking this would clear the location out but it's not. I checked and you can't do it via mass update, you can't edit the saved search to do it through there. Anyone have any suggestions to get this to work?
r
Check the box below on the second screen and it should work via CSV import. Note: I'd recommend having only a two column import file with the Internal ID as the first column and Location as the second. That box is all or nothing so if you have other fields mapped in your source file, it might blank those out also.
h
Ahh thank you! I'm going to check and try that now, also appreciate the FYI on mapped fields being blank with it.
n
Hi @Hunter, we are trying to implement bill.com in our company. Could you please share if you have a vendor mapping template with me? I appreciate your help on this. Thanks.