user10648298

Phillip, Unfortunately this is not currently possible. -John

in Searching for CustomRecords (child records) of a specific Item? Comment by user10648298 Jan 20, 2009 10:29PM

Also, we have a specific WSDK forum. https://usergroup.netsuite.com/users/forumdisplay.php?f=37 -John

in switching from NetSuite Standard Site to WSDK based site Comment by user10648298 Mar 16, 2009 11:09AM

What does the SOAP that is generated look like? -John

in Adding Multiple Addresses to customer addressbook in PHP Comment by user10648298 Feb 1, 2008 4:37PM

By default, scripts are not run. You can go to Setup->Import->CSV Import Preferences and change this. -John

in Suitescript not triggered upon CSV import any longer? Comment by user10648298 Sep 4, 2007 4:40PM

In terms of getting non-US excel files, one solution I've suggested before (since we don't support country specific character encodings), is to upload the file to Google Docs as Excel and then export as CSV. This has the downside of having to go through Google obviously. If you are only getting CSV files and they've…

in CSV Import needs major help Comment by user10648298 Apr 2, 2012 11:59AM

This was miscategorized. Integration processes don't send out emails, so the status of the enhancement has been changed to Defect. -John

in Support case import sends out notifications on old cases Comment by user10648298 Jan 25, 2012 1:30PM

Please create a case with support and reference issue 178823, that way our Support or QA team can verify it works in your account as well. Thanks, -John

in Journal Entry Import Name/Entity Field Comment by user10648298 Apr 17, 2010 6:30PM

In the import assistant under advanced options, do you have "overwrite sublists" checked?

in Item Import Error Comment by user10648298 Dec 3, 2009 11:02AM

Issue 169900 has been created to address this. -John

in Problem Importing Shipping Item in 2009 R2? Comment by user10648298 Sep 23, 2009 11:20AM

Is the second a custom field? To overwrite you need to use the advanced options and select "overwrite missing fields". Be careful with this option as it blanks out data when you don't have a value for it in your file. -John

in clear customers email field Comment by user10648298 Sep 30, 2009 11:28AM

Externalid is the user supplied unique identifier you are looking for

in Vendor Bills (transactions) Comment by user10648298 Dec 3, 2009 10:57AM

Do you have a One World account? If the available departments depend on subsidiary then you can't choose a default value. Go to Transactions->Setup Budgets and look at the values available in Department - those should be legal departments. Make sure you set the subsidiary first if you have a one world account. -John

in Budget Import Comment by user10648298 Sep 19, 2009 6:17PM

To simplify, import the parent matrix item first (the first line in your file only). Next go into the browser and go to the new item screen. The "subitem of" field in your csv should exactly match the "subitem of" field in the new item screen. I'm not sure why you are getting the display name error - is it a dropdown in…

in What is "Invalid parent reference key" error in import Comment by user10648298 Jun 1, 2009 11:08AM

Most likely these are unrelated. "Invalid Reference Key" is the standard error whenever a Foreign Key with a matching name can not be found. Sometimes it's due to form/sourcing errors, sometimes it's due to the quirky way in which the value must be matched. -John

in What is "Invalid parent reference key" error in import Comment by user10648298 Jun 3, 2009 11:13AM

If you don't have auto-generated numbering on, you can set the "Customer" field to the email address. Netsuite does insist on something besides email address, you may need to set either first/last name, company name or "Customer". -John

in Import Qualified Leads - email address only Comment by user10648298 Apr 6, 2009 11:19AM

You have to do two imports as Olivier suggested. First import the Customer - but set the externalId. ExternalId is meant to represent the key in a different system - so if your customer currently has a key "XYZ123" just set externalId to that (though it must be unique across all entities such as contact, customer, and…

in Importing Customers and Sales orders at the same time Comment by user10648298 Feb 17, 2009 12:08PM

Most likely these are unrelated. "Invalid Reference Key" is the standard error whenever a Foreign Key with a matching name can not be found. Sometimes it's due to form/sourcing errors, sometimes it's due to the quirky way in which the value must be matched. -John

in What is "Invalid parent reference key" error in import Comment by user10648298 Jun 3, 2009 11:13AM

Have you filed a case for this? It's pretty obviously an issue on the NetSuite side. -John

in No CSV import Maps saving???? Comment by user10648298 Feb 4, 2009 2:34PM

The online help is very useful... Account Setup : Data Management : Guidelines for CSV Import Files : Items Import : Importing Matrix Options for Items (you can just search for importing matrix options for items) I think you should be able to map all three Option Types for each child item. Thus the file would look a little…

in Importing Multiple Item Options via CSV Comment by user10648298 Nov 26, 2008 2:58AM

Can you file a case with support - give them the file and the mapping details. Also, are you getting stopped before you can run the import are are you getting errors in the response file? -John

in did something change since thursday??? Comment by user10648298 Feb 17, 2009 12:16PM

This should be doable - what errrors are you getting? -John

in Store Description / Detailed Description Move Comment by user10648298 Dec 5, 2008 11:24AM

Olivier's suggestion is the one I would make. I would work with support on this one - generally if a field is not displayed it is because the assistant can not find it on your preferred form or it is not settable on your preferred form. -John

in Custom field missing when doing an import/update Comment by user10648298 Oct 22, 2008 12:53PM

Double check that you are doing lookups by internalId (click the pencil and make sure "lookup type" is set to internalId). Then double check that the item you have mapped to is a child instance of the matrix ("sweater-red-large", not "sweater"). If both of those things are true, please file a case with support (including…

in CSV import does not work but rep says not a Defect Comment by user10648298 Nov 3, 2008 10:45AM

You would have to use the advanced option "overwrite sublists". Do an update with a file that has only internalId of the customer and the address information that you want. Warning : This will completely overwrite the existing addresses with the new ones. If you had 3 addresses and you update with 2, you will only have 2…

in Updating Address Label Comment by user10648298 Jul 9, 2009 1:29PM

Unfortunately, not yet. It's on the roadmap - please vote for enhancement 46541. As an alternative, you can still use SMBXML (I think there are services that will convert files for you). -John

in Can I upload New Cases? Comment by user10648298 Nov 24, 2008 8:07PM

One other thing to try is mapping a column in your file to one of the values on the sales team (eg sales rep) instead of defaulting in all the values. -John

in CSV gets overridden by SFA Rules Comment by user10648298 Nov 3, 2008 10:41AM

It's not an editable field. You can search/export it and you can modify it via WS, CSV and SSS. We don't show it in the UI because we think of it as a "backend" field - entirely meant for syncing external systems. A workaround is to write custom code that sets externalId to the SKU as a before submit SSS. Another is to…

in CSV import does not work but rep says not a Defect Comment by user10648298 Oct 16, 2008 5:15PM

Due to the item heirarchy "SKU1B" could mean "SKU1 : SKU1B" or "SKU2 : SKU1B", and there would be no way to know for sure which item was meant. The name match is designed such that what you see in the item dropdown on a transaction is the exact string value you need to submit. It's consistent and verifiable that way (if…

in CSV import does not work but rep says not a Defect Comment by user10648298 Oct 16, 2008 2:15AM

Yes, the key difficulty is matching the invoices. Unlike most fields in the Assistant, the "Invoices" field does an InternalId lookup and can't do a name lookup. Thus there are two strategies - 1) Export a list of invoice internalIds along with the amount you want to payoff using saved search. Add a repeating column for…

in Customer Payment Import Comment by user10648298 Oct 11, 2008 1:36PM

It's also not just a matter of trusting the user, but attempting to make sure corrupt data isn't entered. When we researched this feature the users we talked to were much more afraid of having to clean up bad data that got in vs having to take several tries to import. As Elham indicated, being able to specify custom form…

in CSV Import restricted to preferred form Comment by user10648298 Oct 3, 2008 12:14PM

user10648298 Newbie

Comments