Sunday, September 16, 2018

You do not have permissions to set a value for element tranid due to one of the following reasons

The user gets a CSV Response "You do not have permissions to set a value for element tranid due to one of the following reasons:
1) The field is read-only;
2) An associated feature is disabled;
3) The field is available either when a record is created or updated, but not in both cases.

User is importing new sales orders (or any transaction). When creating new sales order in the UI the Order # field has "To Be Generated" value. User uses a Saved CSV Import.

To resolve the problem we need to set the Ignore Read-Only Fields box to Yes.

1. Setup > Import/Export > Import CSV Records (or Saved CSV Imports if you have already a saved import).

2. Import Type = Transaction.

3. Record Type = Sales Order (or any other transaction).

4. Select the csv file.  Below is a sample CSV File:
              Order #,Customer,Item,Qty,Rate
              1,1019236 Angelina Jolie,widget,30

5. Click Next.

6. Data Handling = Add.

7. In the Advanced Options > make sure to place a check mark on Ignore Read-Only Fields checkbox (if this is not checked, you will receive the error).

8. Click Next.

9. Map the necessary fields including the Order # to the Order # field in NetSuite fields (if this is a Sales Order import).

10. Click Next.

11. Click Run.

No comments:

Post a Comment