Brett, I gave this a try. I set it up as an Action Script - triggered by a Scheduled Workflow. Sadly it came back with this error: TypeError: Cannot find function getLineItemCount in object 72. (CloseTransaction.js#3) This was trying to close Return Authorisations.

Thanks Brett, that worked great! The Random generated number is something we've been trying to deal with for a while. It's actually generating the ItemID for Inventory Items (via an external script for all new items - this workflow is just dealing with "copying" items) - and we've done it this way for 5 years, and so have…

OK, so far so good. However, as I've had to change the script so that it returns free form text, it's now adding .0 to the end of the number. Here's the script. function SetBarcode() { var ranNum= Math.floor(Math.random()*899999+100000); return ranNum; } is adding .0 something that NS is doing?

I've done some tests using an action script, but it's not quite doing what I need. The random number is needed for a Create Record action, and this number will be the ItemID - so it's a required field. I've got a Workflow field set up to store the value created by the script, and the action script then runs in a state just…

I'm assuming this isn't possible then :(

Great, thanks for that. Do you know if there's a way to stop entry via the popup totally? We have a few workflows which basically need the customer to be created before the transaction. Thanks for your help.

Did you find that you needed to change permissions for the Customer Center role for this to bring back data? We're using a RESTlet and logging in with the customer details, but cannot get anything back from the customer record at all without seeing a permissions error. For security, we want to avoid opening up the Customer…

Whilst constructing our own line will work for Emailed Reports, it won't work for Task Assignment Alerts - unless I've missed something? We have been discussing speed performance with support for years - using system2 is the only way we're able to make NetSuite usable.

Just wondering if anyone had any ideas about a solution for this. It's actually got worse for us - we are now using tasks for several functions, and each email alert (to tell the employee that a task has been assigned to them) comes complete with a link to the task - and this again is using system.netsuite.com rather then…

Thanks for this, I'll give it a go and see how it works.

Thanks for this. The problem we have is that in the UK, system.netsuite.com is virtually unusable for us - and we therefore use system2.netsuite.com all the time - so any emailed reports need to use this hostname in it's links.

I've been looking at the options inside Website setup > Email > Digital Delivery Emails. However, again this seems to only affect Gift Certificates purchased through the webstore. All our transactions are either created through WS or the UI - so we desperately need a way to modify this.

Thanks for this. Is this preference also going to change the format of amounts on customer receipts (PDF, etc)?

OK, just found out that this is not possible at all! :(

Anyone from NetSuite want to comment on this? Right now, when a customer is redeeming a Gift Certificate (in our external website) we cannot find anyway to identify the currency the Gift Certificate was issued in.

This is now fixed.

I've been updated with the following data: Defect 215062 - expected fix 16th Feb

If anyone else would like this, please vote for Enhancement # - 216649

NetSuite? Can you answer this issue please? Seems to be a fairly fundamental issue that if you have the Gift Certificate number, you're totally unable to identify (via scripting) what currency the certificate has been issued is.

Yes, but if you only have the Gift Certificate number, you seemingly have also no way to know the creating transaction either - this means we cannot look up the original currency.

Thanks for the suggestion - sadly it still does't work. s this is not a script, but simple a Custom Field formula - I'm not sure whether these transaction IDs would be used - but it was worth a try!

I'm sure they could, but we're an online retail business - this business doesn't stop at weekends - we'd be facing a six digit financial loss for a three day total shutdown. I understand the size of the database can cause some delays in migration, but I cannot understand anything taking three days.

Thanks for your feedback. This appears to be an issue which is [a] no one has an answer for or [b] no one wants to give us the bad news! If there really is a three day downtime for a server upgrade, this is hardly a realistic business proposal - and it does make you wonder why it's so badly structured.

No, this is more related to the speed of reports, Credit Card billing, etc. We've been through a massive house-keeping exercise reducing scripts, and removing redundant data to improve things - and are now curious whether completing this by moving to a Dedicated Server would be a logical next move. Do you still access the…

The initial reply confirms the THREE DAY downtime, and says that our "account has been with us for a while and it has grown large on data size, it has a large move time estimate." Seriously though, THREE DAYS move time? Looking like we've reached the end of the road with NetSuite if this proves to be the case :(

Well, here's something that we were not expecting - just had our first contact from the dept looking after our upgrade, and we've been told that the upgrade will require our entire NetSuite account being offline for nearly THREE DAYS!!! Errrr, hello? Who can take their business offline for three days? Seriously though, has…

Netsuite makes extensive use of Javascript files, both server and client based. Javascript is very different to Java - despite the similar name.

Well, we've just ordered our Dedicated Server - so looking forward to the improvements. Anything we need to watch out for during/after the upgrade?

Well I am hoping that it's just a miscommunication issue - and the three days relates to something else - but we asked them to double check, and they still came back with the same answer. Now asking for clarification. I could build a whole server farm in three days!

So everything still goes in via the same normal access points, but is then simply routed to a dedicated server once inside?