Oops, I screwed up. The correct syntax for uuencoding is one single percent sign prefix, so the correct syntax should be: "AddressID,Name%0D%0AAddress1%0D%0AAddress2%0D%0ACity, State Zip" In Excel, you can use the CONCATENATE (A1,"%0D%0A",A2,"%0D%0A",A3) function to concatenate individual fields. For example the above…

Hi Cody. The AddressID is case sensitive. If you import an AddressID that already exists in NS, then it overwrites/updates the existing record in NS (and fields missing from the import file are handled according to your Overwrite Blank Fields setting). If the AddressID does NOT already exist in NS, the a new record is…

Also try ruling-out if this is just a bug with the display of the UI, and if the underlying database is actually correctly importing. You can see what's in the underlying database by running a Saved Search (Customer) and picking the various address fields. That will run a query against the Address table and display the…

The address records obviously are one-to-many with the Customer record (i.e, one customer record can have multiple addresses). The way NS differentiates which address record to impact, is with the Label field: If the Label exists already, then it UPDATES the existing record with the exact same label (case sensitive). If…

John I hope you can help with this. Our acct is on 2009.2 I am doing a combined Customers+Contacts import, and also a combined Prospects+Contacts import. I have 3 separate files for each import run: (1) Entity (Customer or Prospect), (2) Addresses, (3) Contacts. The common key is the EntityExternalID. Also each Contact has…

Amy, I only brought-up the initial page showing the 48 possibilities. I didn't actually try to merge any of them....sorry....you've found what I would call a bug if there is a hidden restriction of only being able to check 10 boxes or else it crashes....that's not documented as a limitation.

And you can do bulk dupe detection instead of one-at-a-time. But Amy's solution is what you are seeking.

I did Lists > Mass Update > Mass Duplicate Record Merge, and I got a screen showing 48 dupes...so I'm not sure where Amy's limitation of 10 came from? As for hundreds at-a-time, I think my method will show you the entire universe. But, each record still really needs human review to decide which record survives and which is…

Use the Mass List Edit capability on lists to mass delete all your errorenous records...and re-import them correctly.

You can't. If you need to use the internalID to achieve uniqueness, then you have to use smbXML (or else fix the non-unique names to force them to be unique, and then you can use CSV).

What do I use as the field separator when I concatenate the AddressText field to explicitly include it in the CSV file? I exported an smbXML Customer record to see what separator NS uses, and it looks like they just use a space as the field separator, but this doesn't seem to be correct programming because you can't…

There is a hyperlink on the status page which will open an XML file that will contain the detailed error message and the offending field. You may have to fiddle with your Windows file extensions mapping to get the XML file to open in a program you can view it with (try Notepad). Also NS will email to the NS administrator…

Yes, I have seen this bug in earlier versions--that NS does not accept the chr(34) quote marks on the import. They cause an invalid character error. This is true for the column headers as well as the data fields. It really causes a pain in the headers with custom fields because the "custom:" prefix that you use for the…

Tommy, one of the tricks you can do with XML, is submit a query and let NS give you back the result, and then you look at the result XML record and see how NS formatted it. Sometime you will find an undocumented field and then you just have to mirror the format of what NS returned to you in the query.

Our president doesn't even like them occurring on different days. Greg So then you need a good process where your staff makes sure to create the Invoices the same day as the Item Fulfillment. Are you using the built-in batch process to create the Invoices? You need your business process procedures to make sure employees…

The fundamental point here is that by design, the Item Fulfillment DB COGS and CR Inventory on the date of the Item Fulfillment record. The Invoice DB A/R and CR Revenue on the date of the Invoice. If these cross a month-end, then your COGS and your Revenue are in different months. Several solutions as detailed above. But…

Yes that's a training issue. "Shipped" means it has left the building (FOB Shipping Point). "Packed" means it's sitting in the warehouse waiting to leave the building. So the root cause here is your warehouse staff is changing it to "Shipped" status too soon, plus the option to update the date was off. Just make sure your…

Mike, with drop ship items, they do not flow through the Inventory Asset Account. Instead the revenue is recognized from the Invoice or Fullfillment (depending on your settings), and the expense is recognized when you enter the vendor's invoice. But you will not see COGS on the fullfillment record (as you found)...I'm not…

Do you have per-line departments activated? Or just the 1 single department in the header segment is applied to the entire order? Drop ships are done on each line, and each line links to a line on drop-ship PO. (It's not the entire order, but rather line-by-line, that's why you can have a mixture of drop ship lines,…

Susan, you want to add a filter for Mainline=False. The Mainline is the header. You don't want the header; you want the lines. But realize you cannot get the header and the lines into the same report, so you'll have to run them separately.

Next time don't use an Invoice. Instead use a Cash Sale which records the revenue item and the payment all in the same one transaction. You can just import a CSV of Cash Sales and it's done. For your situation, you could write a simple javascript to loop thru the Invoices one-at-a-time (from a saved search result) and then…

When you create custom transaction fields, you specify which transactions you want them to appear on. So make sure Journals is checked. Also if those fields are really using Class or Department, then you can turn-on Class and Department on Journals in the Company Settings.

That completely deletes EVERYTHING in your account, and puts you back to day 1 when you logged into NS for the first time.

No. But next time you order your check stock, order them from Costco (cheaper) or NEBS (official NS forms supplier) for QuickBooks-compatible checks, and they should come in the correct collation in the box so you can put them in your printer without reversing the order.

Have your administrator give you access to mass update. Or you could use the CSV import feature. Use Excel to create a spreadsheet of Invoice numbers. Save that as a CSV file. Then using the Import Wizard, pick that CSV file. Import transactions type. Map the invoice# to the document # field on the mapping screen. Then…

Here's an even easier solution: Go to: Transactions > Management > Print Checks & Forms > Invoices Check "Allow Reprinting" and that will show you all invoices, then you can check the ones you want to reprint.

Julian, the address records are one-to-many relationship. As such, NetSuite uses the "Label" field as the key to identify which records to update. You cannot change this field (because the InternalID of the address records has not yet been exposed in CSV import, although it has been exposed in WS), so for now you must use…

This is another case where we need the ability to convert a Cash Sale into an Invoice. There is an enhancement request out there for this function. Pls go vote for it. As a workaround, you could create an Discount Item that posts to the A/R account. Put the Discount Item on the Cash Sale to reduce the Cash Sale balance to…

Yes this sounds like a UI bug. Open a ticket with support. And the workaround I would think would be to uncheck "Charge Credit Card". (Or completely delete the CC# should stop it for sure)

In 2010.1 they are adding the InternalID to the address records via CSV, so after the upgrade you don't need to use "Label" anymore (although you still can use Label if you want) and you can now update "Label" on 1 record if you use the InternalID as the key.