[BenWang]

Hello,

I want to build a CSV template to import Expense Report. I have a primary file that includes employee, date etc. and I also have a secondary file to store the expense lines. I believed I followed all the requirements on the help center when building this template. But I keep getting this error “Ref No. must be unique” although I have this “Ref No.” field in the secondary file and i use incremental numbers start with “1”. I also tried removed this field from the template (hope NS can auto fill this field behind) but still get the same error.

Is there anyone know how this can be resolved?
This is a cached copy. Click here to see the original post.

[razad]

Hi Ben,

It could be the values you may have in the “Ref No” field -see the quote from suite answer below:

Ref No.

Ref No. is one of the key fields for the Expenses sublist. You can create a value for Ref No. when you create the expense report record. If you do not create a value, the system creates one.

If you create a value, note that it must be unique, and it must be an integer. If you attempt to populate the Ref No. field with an illegal value (such as an alphabetic value), the Import Assistant does not allow you to proceed past the mapping page.

Answer ID – 31844 also

https://netsuite.custhelp.com/app/an…ail/a_id/31839

[BenWang]

Hi Sam,

Thanks for your reply.

I did follow the guide you mentioned. However, I tried both leaving the field blank and create a integer value, I still get the same msg. Any thought on this? Can this be a NS bug?

Ben

[razad]

Refer to the following suite answer topic

https://netsuite.custhelp.com/app/an…ail/a_id/31843

[Author]

Posts