3942489 Green Ribbon

Ok, so we've been affected by this it seems. We updated via smbXML about 1500 existing customers, unsubscribing them. Now we realize that we'd like to have some of them re-subscribed. Is there anyway to do this other than manually? When we try smbXML we get a very specific error message indicating that we can't set the…

Weird that it's just the alpha data, not numeric. Any chance it's a unicode issue? -Stephan

Are you sure about that? When I look at Lists > Relationships > Customers and click to edit the view, 'Last Modified' and 'Is Individual' is available for criteria, results and filters. 'Home phone' appears to be available also, in the primary contact fields. Edit: oops, not sure about in enterprise reporting, but it's…

Thanks Evan, but what about in UPS label printing, not simply the transaction forms? -Stephan

I do not understand the comments about having to enter the serial number at the sales stage. This is inaccurate. Malin, Perhaps others can be more specific about what they see, but for our part, during our go-live a year and a half ago, when we mentioned serialized inventory and did a test item, our NetSuite rep…

Sadly, after paying for these features, we ran into exactly the same problems. The fact that serial number needed to be suppled early in the transaction was out of the question for our business model; there was no way our sales rep or shipping manager would know what serial number our warehouse would be picking later in…

Bump. Just as a note, HomeDepot.com mandates that UPS labels for their suppliers who drop-ship for them include their Home Depot's name and phone number on the return address portion (top left) of the UPS label. Without a way to adjust this on a per-customer basis, we won't be able to use NetSuite's integrated shipping…

We would definitely be interested in this as well as we have exactly the same needs. We're able to set the return address on UPS labels in Worldship, for instance, so that returns go to the proper warehouse/refurbishment center. (Complicating this, we have multi-location inventory too, with several UPS accounts and use 3rd…

All of the lines of any Item Fulfillment that matches you search will be returned by default, which is why you may be seeing so many more lines than you expect. You might want to try: Main Line is True Also, you might want to play around with Item on any line is "Your item name here" I'm not sure on the negative you refer…

It sounds like what you're looking for is a search option of "Contains any of" which doesn't exist, which could be interesting (though probably slow). Stringing multiple contains options as an expression may be the only way unless there's something else about these records that would uniquely identify them. (Date created,…

1) Interesting question. Since the >> menu button in the item machine doesn't seem to get focus, it doesn't seem likely that a keyboard shortcut or combination would work to bring up the search screen. Of course, if you know a partial item name, typing in a few letters and pressing tab to trigger a search may get you what…

I could be way off base here, but I think that '- New -' in a list implies that the role you are using has create rights for that type. If the role doesn't have those permissions, the '- New -' shouldn't appear. -Stephan

Yeah, that makes more sense. Still, the problem you're trying to solve sounds like it will be more complicated with custom records, than without. Let's face it, you know most holidays far in advance, so you could: 1) have static text on an intranet page that shows holidays. (Update it once a year? Quarterly?) 2) have a…

Why would one want to do this? What purpose does it serve? Are you attaching these records somehow to employee records? -Stephan

It's pretty basic, but I'll add that it can be useful too, to write the exception text (or a meaningful message of some sort) to the execution log, when you catch unexpected exceptions. // A snippet from a script I used to selectively delete some records: try { nlapiDeleteRecord(searchresults[i].getRecordType(),…

The first error (albeit somewhat cryptic) was thrown b/c nlobjSearchFilter only takes 2 arguments. Hmm, perhaps I'm missing something here. The ServerSuiteScript documentation states: function nlobjSearchFilter( name, join, operator, value, value2 ) { ; } which is the format I used and is shown in use like that in the…

Is it possible that you need a LF & CR? i.e. does \n\r make any difference? -Stephan

Hmm, after removing the filter I get Script: updateCustomForm Error: JS_EXCEPTION Code: SSS_INVALID_SRCH_FILTER Details: An nlobjSearchFilter contains invalid search criteria: customform. What are the rules for what fields are allowed for SearchFilter? -Stephan

We'd be pretty interested in this as well, as it's an enhancement request that's been around for god knows how long. (There were a bunch of threads on this topic in the old news group too, come to think of it.) -Stephan

Are you certain that searchresults actually returned your record? You might want to check that. Because if nlapiLoadRecord(searchresults[0].getRecordType(), searchresults[0].getId()) fails then nlapiSubmitRecord(record) seems likely to cause problems. -Stephan

Do you (or does anyone) know if there is a way we can turn on that feature now so that it will go back to all old invoices and put INV in front of the number? In other words I want INV in front of future invoices AND past invoices. We actually did exactly that last year; we added INV and SA prefixes to our transactions…

Yes, we've had our share of de-duping large imports due to import problems. If you don't need the customers, you can fairly quickly tag them as inactive, instead of merging or deleting them. Go to the Mass Updates feature (Lists -> Search -> Mass Updates) and try a criteria of Middle Name = 'null', with a mass update field…

However, do you have a mass update field of Inactive? I don't. It's third from the top on my screen when mass updating customers. (See screenshot from other thread.) Leads are customer records too, since it's just a 'customer status' really. If you're paranoid, you can filter the Mass Updates criteria based on the "status…

As you surmise, for anything that you expect to track in inventory, yes, the item will need to exist. If it's not an item you track (like, say, paper clips from an office supply store), then no -- you might be able to get away with simply using the expense tab, choosing the proper GL account and putting the item details in…

CC payment shows as processed and AR was credited with the payment as was the corresponding bank account. However, the payment did not show up on the Verisign report or on the bank account. (ie they never received payment). Mark We saw this a few times during initial training when employees forgot to check (or somehow…

Can you just inactivate them instead? Mass Update - Items - Inventory Items - Item Is Inactive checkbox -Stephan

That sounds like it would be fairly tricky to setup. Without having ever tried something like that, my first thought might be: 1. Custom checkbox on sales orders for 'shared/split order' 2. Custom integer field on sales order for 'number of parties splitting 3. Custom ClientSuiteScript that would trigger on save of sales…

Splitting between 2 invoices only works if there are multiple items. No, I believe what he's talking about is partial payments. You can have multiple partial payments on a single invoice; case in point we had one customer last year who paid us with two credit cards and a personal check...three payments on that invoice.…

Moreover, you should probably check out how your duplicates are being detected; this setting is configurable in Setup > Company > Setup Duplicate Detection. There, you can set which field(s) are checked against to flag the record as a duplicate. (This can help you figure out why records you think are dupes aren't flagged…

Here is our situation, if an inventory says "0" on hand the value should also say $0. Well, it doesn't. There are positive and negative dollar amounts all over the place and they are all wrong. This is scary. Just a suggestion, run a report to check your inventory values. You are probably having the same situation we are.…