We have several issues that we're hoping to resolve with this upgrade. [1] General NetSuite UI speed [2] Better speed between our 3rd Party website and NetSuite [3] Controlling our own upgrade timings. We assume though, that all communications with the dedicated server is still through the same frontend process that we…

Thanks. So, for anyone interested - if you have anything in the UPC field, it uses UPC barcode type, otherwise it uses Code 128.

Perfect! That did it! It was the fact that the 'formula' box automatically ticks itself each time an edit is made that I hadn't noticed. Thanks for your help.

With scripting, you need to have a new method of payment in your webstore called "Collect in Store' - you will also need to have a specific Delivery method called the same. Then, when the order comes in, no money will have been taken.

Already done that. I'm just confused by the fact that "Income Statements" is totally missing from the list of options. It goes from Income to Integration.

If you wish to change the tab layout on the NS user interface (rather than on the website) then you'll need to look at Custom Centers. You will need to create a Custom Center and assign it to the Role that you wish to see the different layout. I've not done this, so I can't give you 100% confirmation that it will do…

Found a much easier solution. A custom element containing {createdfrom.tranid} Works great!

Yes, this is the way we've been trying to do it. However, so far we've failed to find a formula which NS actually allows to work. Any recommendation? Thanks.

Actually, I'm now discussing this with support due to an error I'm getting when trying to save the custom sublist. Hoping to get this resolved shortly. Thanks for the initial tip. Mark.

Thanks for this, could you perhaps give a little more data about how this would be set up. Thanks.

Did you set Formula (Text) is T in the Formula Window? I can get the formula to be accepted, but the search fails with the following error; Your formula has an unrecognized field in it. Please go back and correct the formula and resubmit.

Support recommend checking the Forums :)

On a similar note, I've been looking to add a list of the only the items a customer has purchased, to the Task window - so a product can be specified within the task. (The same way a Transaction can currently be selected). Would this be best done with a Parent-Child field, or a sublist? Any suggestions for a neat solution?…

I did it the same way, except I didn't select Sublist View = T, and as it was only ever going to find Matrix Child items, I didn't use Matrix Child Item = T Currently looking at a scripting solution to hide the Tab when viewed on non relevant items. mark.

This can be done with a Custom Sublist added to the Inventory Item record. Mark.

You can actually get the business days by using CASE WHEN to_char({field_date_datatype},'D') in ('2','3','4','5','6') then 'Your desire result' ELSE 'Other Result' END ('2','3','4','5','6') pertains to Monday, Tue, Wed, Thu, Fri .... Assuming Sunday is the start day of the week in your NS account. Thanks, Raymond I've…

Just to follow up on this, I've just realised that this is actually a defect that I'd seen before (171746) The week ALWAYS starts on which ever day is 1st Jan - so this year it's always a Sunday! It's an S3 defect, so not expecting it fixed anytime soon.

It appears to be that way. This also means that if you use the "week of year" function in a saved search, the week will always start on the Sunday - ignoring whatever you have set in the preferences.

if you're referring to the Item name appearing as "Parent:Child" - you can use this formula: substr({name},instr(' : ' || {name},' : ',-1)) The field will be either Name or Item - depending on the type of search you're doing.

Wondering if anyone could help with a Formula for a Custom Field that I've been tearing my hear out over? Here's the outline. I have 6 Custom (CheckBox) fields, and I need to create a new field which gathers together the status of these checkboxes into a new single field. So, for example, if the checkboxes were like this:…

Is it possible, through formulas, to get the stock level of an item at a specific date? Thanks. Mark.

Is there a way to create a Custom Formula field which, when displayed on a Parent Matrix item, can show total available stock for the SubMatrix items? So, for example if we have a Matrix code which contains 6 different submatrix items - each one of which has 2 available - then we'd expect to get 12 displayed in the field.…

Gave up on trying to build it into a search, and resorted to using the "Physical Inventory Worksheet" instead Gives me the answer I need. And I can cope with doing an Excel merge ;)

Somehow I knew that was going to be the answer. I started doing it, but after taking into account Sales/POs/RAs/etc I was beginning to hope there was an easier way! :(

I take it this isn't possible then? :(

When this happens, have you tried running a traceroute to system.na2.netsuite.com to see if you can see where the issue is?

Seems to be back to normal for us now.

Here we go again :( Can't even open a support ticket - page just times out.

It's seriously becoming a liability for us - all functions for us are basically down - we cannot even ship out any goods today.

Status.netsuite.com states: 12:00 AM PDTA number of accounts experienced intermittent performance issues resulting from a problem in the caching layer. The problem was detected by internal monitoring and was resolved by NetSuite's on call staff. (Resolved 5:53 AM PDT) Not sure why they think it's resolved.