3947833 Newbie

Thanks guys. After further investigation, I realised that there's a multi-select option when defining an entity field, and if you import a delimited list into that field, you end up with a multi-select listbox. I'd have preferred checkboxes, but the list is just fine. Again, the documentation is very much lacking in this…

By Crikey you're right. I mapped the two customer reference fields together then did the thing with the pencil icon - it's worked a treat. I hadn't figured out that last step at all. I did read the doco very thoroughly, trawled the forums, and I consider myself a bit of a gun at problem solving, so could I respectfully…

Thanks for responding. I'm trying to import child records for customers. For example, we've set up Customers to be called "Clients". I'm importing from a legacy MS Access system. Each client has a number of accounts, and also a number of related payment records. I need to import all the clients, then be able to import all…

John, this functionality is only in wsdl 2008.2, right? We haven't got that yet.

Thank you. I searched for: note, internalid list, internal id list, search parent id, array internal id, array internalid, matching value, related records, user note, child records, sql in statement. The concept of looking up a 'joined search' didn't occur to me. When I finally did stumble across the 'Returning associated…

John, yes, you're right. That works. Unfortunately, I think that we don't have the ability to reference saved searches yet.

Can I also retrieve a list of custom records the same way? I mean, with a joined search. The custom record is a child of Customer, and is actually used as another type of note. The trouble is, when I try to specify 'search.customerJoin', the customrecordsearch doesn't have that property.

Thanks Elham, but that wasn't my question - what has page size got to do with limiting the number of records returned from a search?

John, I thought that CustomerSearchAdvanced on a saved search was only going to be implemented in wsdl 2008.2, which we don't get until next week. In any case, we need to get records where either the Customer has been modified, or any of the customer's account records, so I think the best way is to get the customers (where…

Is there a quick way of retrieving a list of custom records associated with a built-in record? I'm wanting to get all Customer, and all their Account records (custom record), for Customers with dateLastModified after a specific date.

Thanks for the responses, guys. I reckon there'll be a lot of people out there using .Net who end up referencing the wrong method - like I did. You'll save yourselves quite a few support cases (and save them valuable time) if you figure out a way of removing it. Cheers

Thanks. Why are there two functions 'addListAsync' and 'asyncAddList'? Confusing, surely. No help for 'addListAsync' in the doco. I picked that one because it came up first in the intellisense list.

Solved. Apparently in our case, 'subsidiary' refers to 'location', so changing RecordType to 'RecordType.location' (instead of 'RecordType.subsidiary') and assigning that RecordRef object to the 'location' property of the refund (instead of the 'subsidiary' property) works.

I've now struck another problem. I can't submit the record/s without adding a subsidiary, Please enter value(s) for: Subsidiary but when I add a subsidiary, I get the error: You do not have permissions to set a value for element subsidiary due to one of the following reasons: 1) The field is read-only; 2) An associated…

Ok, I've captured the SOAP response, and the value returned there is 1969-12-31T20:05:00.000-08:00 When using the syntax DateTime time = ((DateCustomFieldRef)cust.customFieldList[k]).value; I get back a time component of 3:05 PM. Here in Oz we're +10 hours ahead - not yet on daylight saving. Adding +10 +8 hours to 20:05:00…

Trouble is, we use a different user id on our website than the one NetSuite uses, so we can't do it that way. Thanks for the suggestion, though :D

I've now created a custom field called "Password" which has been populated with our website passwords, and am iterating through the CustomFieldList of the returned customer until I find it. That gives me the value to authenticate the user.

I got it working ;) Found a thread here about searching custom records using parent Sales Order Id.

I just created one which works fine.

Not on mine. All you get is the type id, and internal id of the ListOrRecordRef object, which lets you look it up. The 'name' field contains 'null'. I think what we're after here is to get the actual value of the list item, rather than its internal id. Otherwise we have to go and get the list, then iterate through the list…

Netsuite employees? Any response would be appreciated.

Thanks John. You're right of course. It turns out there's a custom field for 'State'. That's limiting the choices. Sheesh....why don't we just stick with the standard address fields? Case closed.