Cloud Red Ribbon

Happy to help :)

Hi Joanne, Sorry I am not good with formulas, So I cannot help you however I just noticed : MM/DD')||'/'||to_char({today},'YYYY'),'MM/DD/YYYY') I don't know how you entity field is set up but maybe you set it up as DD/MM/YYYY and that is probably why it is not returning results?

Hi Joanne, Have you been in Customization -> Entity field? you should see the proper ID that is assigned to your Birth Field. I have included a screenshot : . Also, I have just realized If the field you are using is a Date field then you would need formula (date) if you use text then maybe that is why it won't find it. I…

Hi, We had a similar problem, We contacted our Netsuite Solutions Provider & Netsuite Support but no-one could offer us a search. But thanks to Izer_Kelly, in helping me out with the formula's, I managed to create a saved search to show me items that have sold and not sold in the last 12 Months. My director loves it. The…

Hi Jpacifics, http://usergroup.netsuite.com/users/showthread.php?t=14877&highlight=poor

Hi, Thanks for the above, I will try that. Will this also work with Multi Select List? I might have some more questions later, but can you help with this reply from Evan? Here's what I meant: Create a custom record called "Rating" with a single integer field, "Numeric Rating". Add 5 record of that custom record type, with…

Hi, I've created another template with the one I designed and added those radio buttons like <p align=left><b>What age group are you?</b> <NLCUSTRECORD_AGE_GROUP_SURVEY> <div class="age"> <ul> <li>18 - 24 <input type="radio" name="customlist_age_group" value="1"/></li>…

Hi JPacifics, I have added a Age Group field into the custom record type 'Survey' how do I add the options underneath the Age Group? are they to be added like the Age Group field? Or will I need to create a List? If it's going to be a list, I need the customers to select the options using a radio button instead of the drop…

Hi, Is is possible because I am sending this to all customers who have received their orders to automatically fill in the names, email and order references in this survey form? I realized that this could be passed around friends and family who have never been on site just to win £100. Any help appreciated Thanks

Hi, when I click on save - I get an error saying NLNAME is missing. so that is why I have to add it. If finished the form, however when I clicked submit it redirects to our website? I got an email to say a new record has been created with results. but how do I report on it? I want to see how many people thought our…

nope, doesnt work. still bringing in 10 regardless of checked or not.

anyone? :(

Thanks Brett, Really appreicate it. I have done the following on just these two tabs but it is not working.. Am I missing something? I want this flag to also pop up on Purchase Orders. Can I get it work on PO to say the Sales Order has another supplier? Thanks

Hi Felix, Thats a mistake, should be SetFieldValue. I am using Bretts Script. No changes - I added 'sales order' after line number but that doesnt work, even tried 'item'

Thanks Brett & Evan :) haven't test it yet, but do I just add this onto edit forms and click on custom code and add it there? ---> script file, and fill pageinit function - SetFieldValue(type, edit) ?? what happens, if I have another code that I want to add, but doing it this way will only allow one code per form? is there…

Sorry haven't replied back to you JCirocco, My MD gave me a High Priorty Job to finish off, so that took over this job. :) Hope your well. Answer to your question - We are send Purchase Orders through. Our Order Process through to Shipping - What happens 1) Order Comes Through 2) Send All Orders through onto Microsoft…

just tried to save a SO and I got this error : Account: 1111189 Environment: Production Date & Time: 4/18/2012 9:43 am Record Type: Sales Order Internal ID: 59773 Execution Time: 0.04s Script Usage: 10 Script: Flag Sales Order Type: User Event Function: SetFieldValue Error: UNEXPECTED_ERROR TypeError: Cannot call method…

Wow Thanks Felix :) The world of scripting is still in the dark, loads to learn. I will create the script like you have advised (will let you know the outcome) but will this script not work on PO? I want it to look at the sales order, flag and then also filter through to the PO. In our warehouse, we currently have a small…

If anyone would be kind enough to check this code and see if I am doing it right? Please Note : where I have 'so.getLineItem('Vendor', 'Drop Ship'); <--- the Vendor & Drop Ship are two seperate custom column fields. The Drop ship is hidden, because I do not need it to show on the sales orders. The Vendor is display for…

Evan, Thanks do you think I can achieve what I want to? Lets say a SO has 4 items, 2 of the items are Company 1. and the other other 2 and non drop ship. Could my formula tell me that there is more then 1 supplier/another order? Its mind bending... I can't think of a way to do this... and in turn we are sending out 2…

Sorry John, But doing that will cause our accounts to mess up. We can't use the same vendor for numerous reasons. Can it not be a simple case when formula and adding the line lvls?

Hi Felix/Brett I can't get the basic working. I have amended the script to the new verison - but it is not firing.. function SetFieldValue(type, edit) { // The itemDetails search can be done in an after submit phase when you are sure the order has an id. var itemDetails = nlapiSearchRecord('salesorder', null, new…

bump...Anyone? Please.

Thanks Evan, Atleast now I know, formula's or searches not gonna help. but now trying to do the impossible - Me trying to script lol.. But hopefully if the script works then Its going to create a flag next to the sales order or Line? Mayur

Please can anyone help me..i'm really desperate getting this to work :( I have tried a few different ways to get this to work, I've created a custbody field (store value) at first I had it appear on Sale & Purchases - Now removed from Sales - as it was not firing. I've amended the script to use the new field…

will let you know, cant wait to start testing :D Thanks Again Felix --- Quick Update : I got An nlobjSearchColumn contains an invalid column, or is not in proper syntax: linenumber. I've selected the script file, and in after submit used SetFieldValue. Under deployments selected Sales Order, deployed, testing.. am I doing…

bump anyone?

how do I do this? Dont forget its on Navision they get the orders, the only use Netsuite to fulfill. Also, We share the a warehouse with another supplier, so we have 2 stocks in there, one which is ours and the other which is the suppliers. Even if I was to use the same vendor, the other suppliers order will not be…

I tried enabling Line sequence number and thought If I could write a formula like this, it may add vendors up and add a flag. CASE WHEN {linesequencenumber} BETWEEN 1 AND 10 AND {custcol3}= 'Company 1' AND {isdropship}= 'FALSE' THEN 'ANOTHER ORDER' ELSE 'ONE ORDER' END but keep getting error field not found :( Anyone else…

never mind, figured it out.. :D just incase anyone else wants to know : In Criteria, select Type : Inventory Item