Hi Tim, thanks for that, i had to rewrite slightly for the correct column: function validateEnteredLineItem() {if (nlapiGetCurrentLineItemValue('item', 'custcol_discontinued') == 'T' && nlapiGetCurrentLineItemValue('item', 'quantityavailable') == '0') {alert("This item is discontinued and out of stock. You cannot add it to…

Same here, we have over 3000 product lines, 80% being matrix items. How can we offer our customers gift sets combined with multiple items if this feature is not available. With the current situation we can only create kit items using 20% of our products lines.

Hi Krishna, not sure if you still using this and if you got this sorted out, but did you manage to find a way to bulk apply deposits/credits against open invoices? Thanks, Chris

How far did you guys get with this? We are looking to possibly take this on if its any good?

We have a couple of scripts, but none that have changed in the few years they have been running. Seems odd that it would start playing up now for no reason.

Im not really fussed about past transaction only future transactions. We have around 3000 SKUs, half of which are bought in foreign currencies, i didnt really want to go through and readd a new supplier to them :(

Anyone? It seems to only effect our backorders whereby the order was accepted but when the last goods come in the customer is overdue and wont allow fulfilment of the backorders. Because of this, the pick ticket shouldnt even print, it wastes our pickers time having to pick something only to be told by the system they cant…

Hi Evan, thanks for that but i was after something else, my fault, was a bit cryptic with my post and its about to get worse. Say for example you make a sales order, but you dont send it to the following day. There is a discrepency of sales vs cash. Im looking for that discrepency in terms of items and transactions. If say…

Thanks for your reply, i did see this option but thought i would ask before i go ahead, we are running the UK version as well so thats good. And yes, we will be collecting tax on sales in the US as well as VAT in the UK. I think i might get our account manager to turn this one just in case :)

Anyone have any help on this, please?

Hi People, this is one that we have wanted since we started using NetSuite, the ability to apply a credit memo to a sales order or cash sale. We do not deal with invoice customers, we take cash only for our orders. If we get a return for aproduct we issue a credit memo, so how are we supposed to do this. Short answer, you…

Speak to Amit, he created a bundle for us which calculates this on the sales order, it also works out for us based on our services which courier we should send the goods by depending on the total weight. Is a very good script, but has failed recently so Amit is working on fixing it.

Is there any further update on this as at the moment its far too much of a security risk, duplicate accounts are created, its just a whole big mess. Realistically a customer should be able to login to their account, visit their customer centre and update their details there in a form. I mean seriously, this was something…

Hi Kamlesh, can you confirm if the bundle will also update shipping item tax codes?

Well at least yours fired Mark, i just came in to find that the scripts never even ran this morning so now i have to wait for it to do it now which looks like its going to take an hour, thanks a lot NetSuite, thats three years in a row you have screwed us on the VAT changes.

We ended up creating 3 different shipping items for this, one for UK mainland, one for Northern Ireland and one for Highlands of Scotland. Each one has a different pricing structure, however its down to the customer to choose the correct shipping item at the checkout which some of them tend to ignore and choose the…

We just came across the purchase tax code problem, another fun flaw. The vat rate best not change again, i have been here 10 hours straight sorting out all the problems its brought with it. Trying to run the script during the day is so slow. I have 600 orders to bill today, and 80% of them are throwing errors as the sales…

Well apparantely there was an email asking customers to update their bundle as there was a bug when users scheduled it. Well considering that we were off over Christmas it would have been nice for someone to find this out before we all left for the year.

Hmm, thats strange, thought that would have worked, did you untick it on VAT:ES? If so, i would file a defect.

I believe this is selected when either creating or editing that tax code. On the top right of the screen there should be a checkbox which says EC Code. I believe you need to tick this on the VAT:ESSS-GB and untick it on the VAT:ES code.

Same here, failed after about 10 tries, with the timeout error :( Am running it again now to see if it works, i was playing with the old tax codes as it was doing it which probs caused my issue. Ive run it again and leaving NetSuite alone until it has either finished or crashed again. If it does im just going to update the…

Kamlesh, will the bundle update vat on shipping items?

Was just thinking the same thing. Dont you just love the British government!

15 days and counting...

Kamlesh, i have installed the bundle and set it up, but under the open sales order section i have this, "There is large volume of open orders. Please contact support on how to update these transactions." Does this mean we will have to manually update these orders?

I know this is an old thread, but are alot of NetSuite UK customers no longer using NetSuite for their ecommerce? Im looking at the websites listed on here and they are not NetSuite sites. Thanks, Chris.

Well hopefully you wont have to suffer then, it should be fixed by the end of today, but thats a good 300 orders lost for us :(

Hi robmccreedie, are you using 2009.2 yet? If so, are you authorising cards ok through it? We got upgraded over the weekend and can no longer authorise credit or debit cards. Its a lovely new defect. Chris

How about getting this then, the average frequency of all customers grouped into date by month. In essence, two columns, Date and Average customer frequency. Thanks.

Hi Bernadette, unfortunately this is not what we are after. We currently use case capture which works as it should. We are talking about if a NetSuite user goes into a customer account, clicks on new email under the messages tab and sends an email to the customer. On the customer reply, the reply goes straight into their…