i am trying to do an add/update csv import for vendor bills but i am running into this error for some reason "Transaction type specified is incorrect."

AI generated answer (using internal Slack threads):

The error "Transaction type specified is incorrect" usually occurs when there is an existing External ID being used in the account. If Add or Update data handling is used, NetSuite will try to update that record instead. The External ID should be unique across different transaction types. To resolve this issue, you may consider using Add as Data Handling. Here are the steps: 1. Navigate to Setup > Import/Export > Import CSV Records (or if you are using Saved CSV Import, navigate to Setup > Import/Export > Saved CSV Imports > select the Saved Import) 2. Select the Import Type, Record Type and the CSV file 3. In the Import Options page, select Add for the Data Handling 4. Proceed with the import Also, ensure that there isn't already a transaction with your external id. If you are importing a csv with an external ID that already exists prior to the import and you choose the "Add" or "Add or Update" option, you will get that error. If it doesn't exist yet prior to the import then it shouldn't give you that error regardless of how many times the external id repeats(still considered 1 transaction). ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

i am trying to update an existing record though

Thank you for your feedback