Mark Derrick Red Ribbon

As we're only doing authentication with it, the slow speed might not be affecting us as badly as it is people who are using WS to move large amounts of data.

All our customers are authenticated through WS - so it's not great. It started at about 2pm yesterday - but luckily it seems to have been intermittent.

Over 2 hours since the S1 defect, and sadly still giving us trouble. Could anyone from NetSuite update us with an ETA?

Yeah - we need a way to just turn off the expiry for accounts not belonging to specific users, like the one we use for our non-Netsuite services to access our ReSTlets and WebServices. When our WebServices username has its password expire, one of our vital systems goes offline and we can't do business. So I set up a…

Would be nice if the same exclusions could be applied for regular password resets too.

Good question- I've had to turn off the password expiry routine because it was triggering on accounts I have set up only for use by RESTlets - so it would be very good to have this confirmed before everything suddenly stops working!

Hey Mark, sorry to thread hack, but can you tell me how you shut off the expiry routine for your RESTlet access? I've been banging my head about that for a while now! Sadly, we have had to disable the entire password reset routine, and now manually trigger employee resets by using a CSV import which sets the "change…

I had already wondered if that might be the only option. Although I find it hard to believe that there's not an option for allowing uninterrupted WS connectivity. Could this be somehow handled via SSO?

What we're seeing is that randomly it will return an empty response.

Is there an ETA for this defect fix? Does this also affect RESTlets? Thanks.

Did you manage to get any further with this? We're looking to do something very similar.

Is it still the case that reports cannot be accessed via WebServices??

Yes, I've looked at that - along with also trying to use the built-in Budget numbers. Unfortunately, I also need to include other data in the final report - number of days in month, days remaining, target, amount remaining to target, etc. These only seem to be possible to do in a Saved Search - but as the Saved Search is…

Same issue here - this is a shared bundle (not public) so each account has to be authorised to allow it to install it - however I've actually spoken to Birst about it, and they have no idea about what they need to do :( Right now they just appear to be using it as a hook to get you to talk to them about the full package.

Pretty much the same experience - initially the feedback we got was "It's already installed - go ahead and use it" After explaining about the need to get access to the bundle and that they needed to authorise us - it now seems that there's nobody there who has any idea about this at all - makes you wonder who even wrote…

Shame really, what we saw looked really good - but if it's this hard to get a working version, who knows how hard it would be to get real support later.

I have both required options, but the Install button isn't appearing for the bundle :(

Use https://system.netsuite.com/app/common/search/savedsearches.nl?whence= and look at "Last Run On" column - this will give you this data.

What improvements are you looking for?

Ah, sorry - realised I'd not Summarised the field in the results that I was relying on!

Thanks. I've actually moved to using Regexp instead - the following seems to work fine. REGEXP_INSTR({billzipcode},'L[0-9]') This then gives be the flexibility to have as many characters as I wish befpre the number.

Here's what I thought would work... CASE WHEN {billzipcode} LIKE 'L[0-9]%' THEN {internalID} END Guessing NS SQL doesn't like [0-9]

Well, as alway happens - as soon as you submit a question, you suddenly get a flash of inspiration. Although I haven't finished testing it fully yet - and I'm sure it's a bit rough - I've come up with the following formula to use in the results: CASE WHEN {trandate} < ({customer.firstsaledate}+365) THEN {amount} END…

In order to display sales for a specific previous week, I use this formula. decode(concat(to_char({trandate},'IW'), to_char({trandate},'IY')), concat(to_char({today},'IW')-4, to_char({today},'IY')), {netamount}, 0) This uses week numbers, in order to avoid having to determine the start of the week etc (thus avoiding issues…

You could simply list the Item Fulfilments which have shipped today, but then grab the value by using "Created From : Amount (Net)" That should work fine

Anyone know if this is possible? I need to update all customers with a range of available currencies, and a CSV export/import seems to be the only option??

Can anyone confirm the permissions required for users to access Pivot Reports. I've added both Search Pivot Field & Search Pivot Layout in the Custom Field permission. But, I'm still getting the following error: Permission Violation: You need a higher permission for custom record type Search Pivot Layout to access this…

Just done some more testing, and it doesn't appear to be a Role issue. If I assign the same role to myself, then it works fine, but someone else on this role, cannot see it at all. Is there a script ownership issue perhaps? Why is it that I can see it, but other people on the same role cannot?

In the Criteria, use "Type = Inventory Item" Mark.

I'm suspecting that the issue is that you're limiting the range of Accounts in your criteria - and thus cannot pull back the COGS account in the results.