Olivier Gagnon NC Red Ribbon

Assinging an External ID to your POs is indeed a very good idea, but I was talking about referencing the Vendor by external id. The problem is NS is failing ti recognize which Vendor exactly you're talking about. Specifying the Vendor's external id (or internal id) in the field would be more effective

Most likely NS expect the full ID, including the name. Try putting the vendor's name as well and see if that works. Alternatively, if you're able to import using Internal ID or External ID, I would recommend that. Much simpler.

What is 508297? Is is the Netsuite sequential vendor ID, the internal id or the extenal id?

No. You can't violate Netsuite statuses. To mark the invoices as paid, you must either: a) import he invoices at value 0$ b) subsequantly import Customer Payments to pay them c) subsequantly import Journal Entries to pay them

It is not possible to Bill using CSV. To create a Bill containing only what's on a given Receipt, you must press the Bill button from the Item Receipt rather than the PO. There is no quick way to automate this unless you use a script.

It will affect Entity searching, but only for very large volumes. Are we talking about thousands or millions here? If you really want to delete them, you can using scripting. However, if you are importing them in NS just to send an email and then deleting them, I would re-examine your process. While NS could be used in…

Are the date filters at the bottom of the result screen correct? even if they are, try pressing Refresh

This can be achieved by coding a Suitelet in Netsuite. It's a custom project though, you won't find anything suitable out-of-the-box.

Zips are a bit easier because you can set beginnign zip and end zip on territories, making contiguous ranges easy. Postal Codes don't work that way. The only advantage is when you write to Santa Claus you can send them to postal code H0H 0H0.

Are you importing for those? If so, you must provide a value for every range you defined.

Yes, but you have to use the "replace all line items" option (i forget the exact name). This means you'll be wiping out all your line items. Hence, you must reimport the entire order's line items, not just the line you want to modify. The CSV assistant is less than adequate when you want to make edits on lines.

I do not believe there is any way to import anything into Sales Rules are the moment. You basically do need to create 1 territory per rep, defining all of the codes in the territory - unless you can define your territories with something else than Postal Codes (cities maybe). The only other option I see would be to use…

Hmm... are you using Quantity Pricing?

Hey Sara, All addresses have labels - this is the "name" of the address as it will appear in dropdowns. For example, a label could be "Main Address" or "Back entrance" or whatever. Customers never see this. It is only a value to help users differenciate addresses on entities.

When importing something with line items, you have 2 choices: append or overwrite. If you append, you're basically adding closed lines to your transaction, which is completely useless. If you overwrite, you erase ALL lines and stick in the ones you are importing. So in this scenario, your CSV file would need to contain…

The field where you're trying to import the value "Required for all employers" into doesn't like that value. What field are you trying to import that into? If you look at the field in Netsuite, is it a dropdown? If it is, you have to make sure the value exists as one of the choices, and the value has to be written exactly…

are the previous records commited? Yes Do the subsequent records get imported (as long as they are without error)? Yes Cheers

Just import it as an item, as normal. Make sure the "Print Items" box is unticked on the Group itself.

I don't think that's possible, no. You should be able to add Groups to SOs normally, but I don't see how you'd be able to edit it on the fly. If you know exactly what you want in the group, though, strictly speaking you don't have to import the group, really. Groups don't really have any added value other than saving you…

You have 7, but you need to specify Weight Unit (i.e. "lb"). This is another field.

The long way would be to first export Customers, then export them back with their internal ids, and then use an excel vlookup to merge it back with your Sales Order CSV, then upload your SO CSV. Otherwise, using custom records and scripting, you could build a record you can import into, and then have script create the…

Am I missing something simple like "you just seperate each option with | in the CSV" Bingo. Seperate each option the item takes with a pipe (|) Cheers

So, after fighting with the CSV Assistant for a while, I figured out that you must press the little pencil icon and then you can set the default to NULL. This makes Netsuite not try to import new items or update any of them. So there you go. Not the clearest of interface, but in the end it works :)

That was actually what I wanted to do first, but I calculated it would take 63 hours of non-stop script execution to correct the 32 000 invoices. So yeah, CSV is better in this case ;)

Are your fields visible and enabled on the Preferred Customer form currently in use?

Hi, Had this discussion before. Post 10 and onwards has Netsuite employee response.

Hi Jeremy, The alternative to everyday CSV import is, basically, integration. You would need to have developed or customized an existing integration system (i.e. Web Services), between the system that spits out the CSV and Netsuite. This would probably be a big project (integration always is), but if manual CSV import is a…

Err... you could set that up with multiple checkboxes? I don't really visualize what you mean though. Do you have a website example that uses this setup? I don't see why either multiple checkboxes or a multi-select list don't fit your need?

Internal ID Multi select field 123 brand 1|brand 2|brand 3|brand 4

The "Child Of" field in the CSV Assistance means "Parent", so you can use that.