The XML=t is not a publicly documented API. I don't recommend using this output to build an integration system because it might change. The best solution is to use our Web Services APIs. However, you might want to use an existing partner solution for EDI integration. If you are interested in finding out more, you can…

Can be done via scripting. If you append "&xml=T" to any transaction, you will also see a raw XML view of it, so depending on what you want from your XML and what you intend by "export", this may also be useful.

Yes. I assume you are asking because the Import screen specifies that some sort of ID is mandatory. Just set a unique value to External ID and leave Tran Id blank. NS will auto-generate it then.

I checked this out - that record type is not exposed to scripting either, so no dice.

No, you're pretty much looking at a full blown migration effort. Some fields and even some record types cannot be imported, or can be but using scripting techniques or, worst case, manual re-entry. We've done several of these, and they require careful planning, careful execution, a lot of dedicated time and careful…

Import Data with Multiple files is used to import "sub-information" about a record type, like line items for a order, or addresses for a customer. The multiple files contain different data types. Parent-Child data is the same data type. A flat import will work fine. All you need to do is import the parent before the child,…

No - no reading of data on your computer. Ever. You need to pass along the entire file contents, either as actual data or through the file upload mechanism.

Yup. There are several new APIs that allow you to programatically fire off CSVs using scripting. Of most relevance to the original topic, you can now build a RESTlet or Suitelet which accepts a CSV data, stores it somewhere (temporarely, if desired) and schedules a CSV Import job to run against the file.

Oh no, that is going to be impossible. Huge security issue. Can you imagine if browsers had the ability to pick up any file from your computer and read it? You will need to code a Web Services app if that is truly what you want to do.

Make a CSV file with 2 columns. The first will be Internal ID, where you'll write the current internal ID of all your items. The second column will be "new name", where you'll enter the new item names. Make sure to map both columns, and that should be that.

Try doing an import using Multiple Files (so one file has your base Vendor reference, the other file has all the address information), and when you get to the screen where you select add/update/add or update, open up the Advanced Options section and select "Overwite Sublists" So, you're not so much removing a single…

Yeah, you can run a little Item Search with the added column "Internal ID". That should do the trick, you can even export your search to CSV directly to give you a starting base.

It sure is possible. Try using a Multiple File import, and tie your lines to the header line using an External ID you generate.

You're probably going to be looking at a Web Services based solution, but yes, it's possible.

Putting the field within quote should work. Try opening the file in notepad to make sure it's done right, sometimes it's hard to see what Excel is doing.

I recommend you read the help under Accounting-> General Accounting-> Working with the Chart of Accounts-> Making Changes to Accounts-> Merging Accounts This help explains the "losing transaction history" part, the exact scope of that (i.e. only Bank and Credit Card accounts), and how to avoid it.

A Mass Update or CSV import should do it. I tend to prefer CSV.

You will require a Web Service middleware to do this. We have done this quite often using this method (it's the only way, you can't email to an FTP and javascript does not have a protocol for uploading to FTP either).

Is this ongoing or one-time? If it is a one-time, I would not buy a 3rd party tool. There records can be imported by using a custom record + some scripting. It'll be cheaper to have that coded than to buy a long-term use tool.

Well... you can't make a 0$ payment anyway. Nor a 1$ one if that's what you're thinking - you would just apply 1$ to the invoice balance, which would of course not close it. As to the CSV route in general, you can CSV import Customer Payments and specify to which Invoice they apply. If you want to close a bunch of invoice,…

There's a wide variety of reason. Unexpected Error is a catchall error. Your best bet is usually to ask Support, yes.

It is no longer the case. The Item Number record is accessible by script now.

It is not possible. Custom fields on Item Numbers can only be updated manually. No scripitng, no import. They are effectively quite useless.

You can use the CSV Import tool to import in Cash Sales with Gift Certificates on them. We happen to have done this like 2 days ago for a customer. Worked real well.

Credit Memos?

Assuming you're importing groupons as gift certificates, then I'm answering both posts ;)

Mhmm. But then that is not a script problem, that is an implementation problem. I think NS does support fractional quantities though. Can you check if you didn't just set Minimum Quantity to 1 on the item record? You should be able to just blank that out. Are you using Inventory Items? Might not be advisable to use…

Keep in mind if you import "standalone" invoices (invoices without a created from), and those items contain Inventory Items (or Kits or assemblies, etc), the Invoice will cause the inventory to deduct. So if you already had a SO->fulfillment, you'll be double-deducting inventory. Also, your SO will remain Open.

You can never set the Create From, it has to be there due to a transformation. Try this trick - create a Custom record to hold the imported info from your Invoice. Place an afterSubmit script on this record that takes the data provided, does an nlapiTransformRecord() of the SO into an Invoice, then modifiy the record based…

Sure, assuming the other app can call an httpRequest, you can have it ping a Suitelet that outputs CSV results of a seaved search.