Hi all, I'm trying to import Purchase Orders but a...
# generalj
Joe
06/24/2020, 6:30 PMHi all, I'm trying to import Purchase Orders but am getting an error that says
Transaction type specified is incorrects
Suitestallion
06/24/2020, 6:33 PMare you doing update or add/update?
j
Joe
06/24/2020, 6:34 PMAdd/update @Suitestallion
s
Suitestallion
06/24/2020, 6:34 PMThe error 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.
Suitestallion
06/24/2020, 6:34 PMSolution
To resolve, user may consider using Add as Data Handling.
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
Suitestallion
06/24/2020, 6:34 PMSA 19693
j
Joe
06/24/2020, 6:35 PMGot it, thanks! I'll try just Add
s
Suitestallion
06/24/2020, 6:36 PMI have had that happen before when I was trying to import purchase order but Item fulfillment had the same ID,
j
Joe
06/24/2020, 6:36 PMGot it, it worked! So strange why it wouldn't just add on the add/update selection
Joe
06/24/2020, 6:37 PMAppreciate your help @Suitestallion! Thanks!
👍 1
6 Views