Since it's a parent/child relationship, you can't add child records until the parent is actually created. If you're trying to generate an inventory adjustment every time your custom record is created, you will most probably require a script for that.

I can only give you high-level code, but it would look something like this function afterSubmit(type){ //Create new Inventory Adjustment record var newInventoryAdjustment = nlapiCreateRecord('inventoryadjustment'); /*Retrieve values from your custom record's fields. You may need a two-dimensonal array * but I am keeping…

This thread might help: https://usergroup.netsuite.com/users/showthread.php?t=17624&highlight=nlid If you can't find the correct CRMSDK tag: - Try to use <NLinsertfieldID>, so if the field ID in NetSuite is "company", try <NLCOMPANY>. You can find the field ID by having "Show Internal IDs" turned on in Home > Set…

1) Create a Transaction Body Field of type List/Record and choose your Custom Record as the List/Record. Make sure to check the "Record is Parent" checkbox and assign the field to Inventory Adjustments. 2) Edit your Custom Record (Setup -> Customization -> Record Types) to add a subtab. Once the subtab is added, in the…

Did you want a fully functional Adjust Inventory subtab within your custom record or were you rather looking into sourcing data from existing Adjust Inventory records for information purposes? I think it would help if you would explain what you're trying to achieve with this custom record.

Hi DMC, I don't see any "Invitee" field when viewing an Event. Which field are you talking about in NetSuite?

Looks like the "invitee" param adds a contact to the Attendees list. On which record in NetSuite will your Inline HTML field be?

You can get something similar using an inline HTML field and some simple scripting. I know it's not exactly what you were looking for, but you could do something like: //Get the value of the checkbox var valueToCheck = nlapiGetFieldValue("custbody_fieldtocheck"); //If value is not checked if(valueToCheck != "T"){ //Print…

I believe the "Alt. Email" field is for Individual-type Customers only. If you're viewing a Company-type Customer, it won't be available.

NetSuite Support told me how you can get the 'addrtext' field to populate automatically by adding the following lines: record.setLineItemValue('addressbook','override',1,'T'); //set override record.setLineItemValue('addressbook','addrtext',1,null); //set addrtext to null or an empty string Hope that helps!

If anyone is still interested in this, there is an Enhancement Request related to this issue: Enhancement 128637 - :Ability to have a BCC when creating an email in the case. (also attached to the same Enhancement Request): Enhancement 128637 - ::Ability to have a BCC for internal employees when creating an email in the…

+case {custrecordwlevel} when 'Vice President' then 7.5 when 'C-level' then 10 when 'EVP/GM' then 10 when 'Director' then 5 when 'Manager' then 5 when 'Other' when 2.5 end Shouldn't the last "when" be a "then"? And you may be missing an "else" clause in there too.

As far as I can tell, there's currently no way to update lines of journal entries through CSV Import. If by luck your department is exactly the same everywhere on these 2000 journal entries, you can temporarily turn off per-line departments, update the body-level Department field through CSV or mass update, and then turn…

For the sake of anyone looking for an answer to this question, I'm assuming your answer was that Base Price is not a field, but part of the Pricing Sublist?

You can definitely import via webservices. Here's a SOAP request that would work (minus the login info): &lt;soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"&gt; &lt;soapenv:Header&gt; &lt;platformMsgs:passport xmlns:platformCore="urn:core_2010_1.platform.webservices.netsuite.com"…

I'm pretty sure you have to spell out the entire category string, from the root category all the way to the category you want to assign. Check out this thread for details: https://usergroup.netsuite.com/users/showthread.php?t=15948

I find that very hard to believe. I'm not saying you're incorrect, I'm just saying I have no issues doing CSV imports with a saved and closed file. No issues at all. I've been through this one thousands of times now, so I'll offer my personal insight. I can confirm that Excel will change your data in a CSV file if you…

I did a large import to the customer table/address book to fix the Attention field and 10k records took over 2 hours to do. Is that a standard time or is that my system load, customer record customization, etc...? I have over 400K addresses to re-upload; that would be 400k/25k at a time * 2+ hours = 16 hours of cvs…

I've never seen such an issue before... How many lines are in your 2mb CSV file? I believe NetSuite has a 25000 line limit per import.

It actually is in the documentation. If you search "Delimiters for Hierarchical and Multi-Select Fields" or "General CSV File Conventions" in the NetSuite Help Center, both specify the format as "grandparent : parent : child".

If the contacts are truly the people making the orders, getting shipped and billed to, then you should make them sub-customers. Generally, contacts are just that: a record that stores contact information. If you start doing transactions with them, the sub-customer approach makes more sense.

I have a list of custom entity fields which I would like to import into a different Netsuite account. How do I do that or can I? If you want to import the field definitions, you can use a SuiteBundle. If you want to import the field data, you can use a CSV Import.

Although it's technically supported to import both at the same time, I find that the simplest way is to do two imports: add "Prospects Only" first, then add "Contacts Only" with the proper Prospect in the Company field.

Just to be clear here, you're trying to move marketing campaign info from one NetSuite account to another? As Joel mentioned, the Campaign record is exposed to Web Services, but it's also exposed to SuiteScript. If this is a one-shot deal, it may be more efficient to use SuiteScript and Custom Records: 1) Create a new…

I just tested it just now using a Multiple File item import and I was able to update the Base Price and blank out a second Alternate Price in the process. I checked "Overwrite Missing Fields" before importing. Both items had a value in the Alternate Price before importing and it was blanked out after import.

Our NetSuite is down as well. I called NetSuite Support and they said they're aware of the situation and are working on it. Edit: Seems to be back, at least for our NetSuite account. Our website is still down though.

Internally, we use Aptana Studio 2 and have been using it for several years. I've been running version 3 for about a month now and I'm seriously thinking about switching back to the version 2 because of the following reasons: [LIST] [*]Code Completion works differently in the new version. Right-click on your project and…

We've also encountered this problem, at least since Friday the 26th. We can no longer create a search that shows all of a project's support cases. We also can no longer create searches that include both projects and customers, and this is breaking several searches for both time entry and sales reporting.

One of our clients is having a similar issue, but on Sales Orders. If a Customer had a credit card on file and that credit card is selected by default as Payment Method, if the user changes the Payment Method to Check, it is not clearing out the credit card fields and actually processing the Sales Order as a credit card…

Some of our clients have complained about this issue as well, with some of their old reports (over 2 years old) giving the "Table" error when exporting to Excel. Export to CSV is definitely a workaround, but another thing you can try to do is re-create the report from scratch. That may fix the issue since it doesn't seem…