[nzaleski@usatcorp.com]

Is it possible to import on the expenses sub-tab of a Bill Credit? When I do a import mapping I can easily see how I could import on the Apply or Item sub-tab but not the Expenses. It is simply not there, not a mappable option.
This is a cached copy. Click here to see the original post.

[hbeltejar]

This can be achieved by using multiple files for the upload.

> Import the file using Multiple Files upload for Import Type = Transaction, Record Type = Vendor Bill

> Choose the primary file for “Primary File – Vendor Bill”

> Choose the secondary file for “Linked File (Optional) – Vendor Bill Expenses

[nzaleski@usatcorp.com]

Worked good, but I am getting an error “Multiple values found for a dropdown field that can only take one. for field “Customer” ”

Apparently there are 16 errors, however NetSuite was not kind enough to tell me which 16. The error file has a column error, but it is blank all the way down the file.

Since the list an export from NetSuite I am not sure why the customers names are not importing correctly.

Also, got it to work correct without the Customer name.

Any thoughts? Thanks.

[nzaleski@usatcorp.com]

So I figured out why 6 of them were throwing errors and I have a theory on the other 10.

For some reason the customers name did not flow through correctly to the item fulfillment correct. For instance if the customers id is ‘Nic’s Pizza’ on the fulfillment it flowed through as ‘Nics Pizza’ and removed the apostrophe. Shouldn’t it flow through exactly as it is on the sales order?

The other 10 errors I believe that it is because they have sub-customers associated with the record. Assuming that theory is correct is there any way to control that. I tried putting single quotes around the name.

Thanks for you help.

[Author]

Posts