3951005 Green Ribbon

Thats perfect - Thank you :)

Just to the sales rep assigned to that customer? Dont know of any way thats standard functionality - Can possibly be done with a script?

Not tested but you can try pulling it in as a formula:- <%=internalid%>

Can you not just SUM the column by ticking the "show totals" box?

Wizard that is a really good point!! Any ideas on a way around this, Does anyone know how to just include weekends? Thanks for all of your help so far!

Hi Evan, I have tried putting:- <%=to_date({custitem_weekavailable}*7-6,'DDD')%> and I get ERROR: Invalid Expression It pulls the week available date in okay....

hi, Thanks For your reply, I tried it without the "to_char" and am getting the same error :- ERROR: Invalid Expression

THANK YOU GUYS!!! Worked a treat! That is perfect. Dont suppose you guys have an idea of why it wont pull into the email? Is it because its a formula and not a stored value, (harcoded value)?

Hi, Thats excellent I have managed to get it to display the correct date on the item record! Although it wont pull into the email, it still shows "Error Invalid expression" I'm not too concerned with that for now to be honest. However When the "Week Available" Number is set to 0 (This is the default) It shows "ERROR:…

Any update on this defect?

Hey Wizard, I would love to implement this script, could you share the final version? If you could also give a pointer on where to implement it too? Are you using it as part of a workflow, or can you just deploy it to item records? Thanks,

Hi Olivier - That seems to have stopped us having the ability to save the sales order when we edit, or even save when creating a new order. The Save button just ceases to work. I have had to remove this addition in order to regain functionality. Any ideas what would cause that?

Thanks Olivier - That worked perfectly. - I wonder if you could help me further - at the moment - if both locations have stock - the location with the lowest ID wins and the order is allocated there. Is it easy to amend the logic to say - Location with Highest quantity available - wins? I had a play around, but could not…

Not quite what you mean by "didn't work". I've got code in production on over 25 Netsuite sites that uses the basic technique described to limit shipping methods. The code I sent back was based on your sample code and, as mentioned, wasn't installed in an account to ensure it ran. If you want more help on this I think you…

Hi Matt, Try setting the third element to an array. Example: ["GB","BT",["185","183"]], ... Thanks! Joel Unfortunately this didn't work. Onto option 2...... :) Thanks for your input guys...

We can use just Netsuite settings........ Trouble is we need to define some 'shipping items' to particular countries BUT only to certain postcodes. Thats where the trouble comes in. :(

Matt, Joel's suggestion would certainly work and is the "right" way to do this. However if a non-coder is maintaining that list you need to keep the syntax to a minimum. The following (non-tested) code uses your proposed syntax. Note the use of 'anyAllowedChecked' to make sure you don't uncheck a legal shipping method.…

Hi Mark, Long time no type! Was just reading through some old posts and noticed this one! 2 years on are you still of the same opinion? We're using the same process still only now we have 2 yrs of growth in volume... So now it's even more of a headache! Cheers, Matt

What is it you need to achieve? Most of us have developed a vast knowledge of Netsuite over the years, although it depends what you are look for as to wheather I can help...

We had a problem like this, we ended up having a script that run from a lookup table, and matched the postcode to a shipping method. A company called Bluebridgeone did the development and integration for us. Sounds like you could benefit from the same solution, and as its something they have already developed for us, it…

I would recommend setting the Voucher Tax code to be VAT-O (Out of scope), When you "Bill" the order it then posts to your Balance sheet as a Liability. When it is then redeemed, its removed from your balance sheet and is used as part payment against whatever the customer chooses to purchase. At that point the VAT is…

Hi Kamlesh, Bit late with the times here, But I would LOVE to try this please? Could you email me the details , I am Finance and trust me I cant moan enough about it! If we could install it and have a look that would be great. Thanks, Martyn

We also have approx. 10k needed to merge. NETSUITE, Have you ditched all plans with this? As previously said, this has been outstanding for 4 years now!?!

I may be sounding a bit thick here. But where would you put that code? If I go to customise dashboard and choose custom portlet and go to setup, there is NOTHING in the drop down menu, no options at all. I assume I have to add those options somewhere? Thanks

Netsuite are apparently working hard on Social Media/Mobile development at the moment, and it forms one of their many strategies going forward.... Am hoping something like this is on the cards soon :)

appears to be back up!

Create a customer search, On the results tab ensure State and ID are listed. and udner the summary type column choose group on the state line, and count on the ID line. That will then display a list of States and how many "ID's" (Unique Customer records) are listed with that state on the customer record. No need for manual…

Depending on how the saved search is setup and which type of transaction its looking for you may need to use:- {fulfillingtransaction.shipmethod} If that doesnt work, let us know the criteria you've got set for the saved search. -Matt

Hi there, ok, I thinkyou can resolve this quite easily. Go to Lists > Accounting > Shipping Items Find the Shipping method for your integrated UPS. If me theory is correct, you will see that the Description for that method is blank. Populate the description with whatever you like (ie "UPS Ground") Now test your email, it…

Did you manage to get this working in the end farrago?