Olivier Gagnon NC Red Ribbon

I would just double check that your items are properly extended to your new sub.

Well, typically Excel will deal with commas within cells well, as it wraps it with quotation marks. "ABC, Inc" is a valid CSV value. However, if you have cells with ", such as say the length of something being in inches, that would be bad.

Both points can only be handled by adding scripting to custom code these measures.

The legacy record primary keys should be imported into the External Id. If you aren't doing that, you have a serious problem. Once that's done, you can import relating record by referencing the external id during the import process.

Hmm, no, haven't seen anything like that. I've seen mismatches but they were due to explainable data errors in the files. Sorry, don't have anything to more to offer.

When you are mapping your CSV import, press on the little pencil icon next to the mapping line for this employee field, and select "Internal id" from the popup.

I don't believe so, but importing child records should not be terribly difficult, Just import the children as their own record type, referencing the parent's external id that you set when uploading them.

Did you give all related lines in your CSV the same Extyernal ID? What did you use to tie lines together?

Something must be setting the Discount % field directly. This is actually not allowed. You must select a Discount Item. So, try to figure out what's setting the Discount % (or value, same thing) and blank that out.

Set the External ID field of the Sales Order. All lines for the same SO should use the same External ID.

Provide a value for Parent. I recommend using internal id as reference.

1. External IDs do accept alphanumeric 2. Users don't need to know the last number. Just have them use a system where they use [year][month][day][sequential line number] 3. You can use the Item Name to import, yes. Be wary of parent-child relationship though, as the full name must be used

That does not exist.

All lines belonging to the same SO should be set to use the same External ID, yes. I do not understand your comment about "it" not letting you type anything. You should be typing the external IDs in Excel, in your CSV file, and mapping your column in Excel to the External ID field

Well, I guess it depends a lot. I don't know how they supply the file. Let's say they place the file on an FTP server - well, you could have a Web Services process monitor that FTP and as soon as the file is there, the WS process starts feeding it into NS. However, if there isn't a way for you to ping and check if the…

Well a scripted solution would have a 5 MB file size limit, so that doesn't look like a good avenue. Doing an integration using either Web Services or RESTlets might be an option, slowly eating up the file, but this requires development cooperation with the Vendor.

In a report - no. In a Saved Search - yeah, super easy. Literally pull these columns out.

Enhancements in general take years. That particular enhancement has been around for several years. I doubt it will ever be released due to its logical and programmatic complexity.

If you're talking about child accounts, then those can be pretty easily added. However, you may have in mind something more akin to Class and Departments, that is to say a layer of information attributed to GL hits which the need for physical accounts. Since this is Income, I'm tempted to think the latter would be more…

Difficult to answer. Simple for me? Sure. Simple for someone that doesn't know scripting like I do? Nope... Probably not a great answer but not sure how else to answer...

Not out-of-the-box, but if you want to go scripting you can custom-create a smart functionality that is able to do this.

My guess is you have Quantity Pricing on. If you do, you must provide pricing for ALL quantity steps for all the price levels you wish to make updates to.

How big (in Mb) is the file?

CSV imports sometimes get stuck. You can contact NS Support to have them take a look.

Oooh, I see. Well, NetSuite does not support what you are trying to do here, unfortunately. It could be done as a custom thing using Journal entries, but it would be SUPER messy and I really don't recommend it. Maybe a month-end process where you run a batch process, which at that point, it reclassifies all your income…

I'm not sure what you mean by "table mapping" and "mapping the new fields". It might be a concept that does not translate well into NetSuite paradigm. Can you expand on what you mean by this step?

If you contact Netsuite Support, they may be able to give you access to a Mass Deletion tool. At least, they used to do that, but I haven't heard about that in a while. Worth a shot, though.

Did you just forget to hit the little pencil icon and set the reference to be internal id?

I forget all the time too :)

Did your failing Journal include Bank accounts?