Edit the expense accounts in bulk and add the 1099-MISC category

 To accomplish this in NetSuite, perform the following steps: 

1.  Navigate to Lists > Accounting  > Accounts
2.  Click Export – CSV
3.  Select Open
4.  Delete the extra rows before the Header row
5.  On the CSV file, retain only the accounts with Type = Expense
6.  Retain the fields Internal ID, Number, Account and Currency
7.  Add the 1099-MISC Category field
8.  Enter the 1099- MISC Category field for all the Expense accounts
9.  Copy the 1099- MISC Category field from Lists > Accounting > Accounts > New > Type = Expense and paste on the CSV file
10. Save the CSV file
11. Navigate to Setup > Import/Export > Import CSV Records
12. Import Type = Accounting
13. Record Type = Chart of Accounts
14. CSV File = One File to Upload
15. Select CSV file
16. click Next > Update > Next
17. Check Field Mapping
18. Click Next
19. Enter Import Map Name
20. Save & Run
21. Navigate to Lists > Accounting > Accounts
22. Edit Expense account and save