Cloud Red Ribbon

hmmm, I have a saved search and it allows me to inline edit fields (not multi select) just simple drop down boxes and free form fields... (it has multiple criteria's including Supplier Name and in Results 5 Custom fields - 2 Free Form and 3 Drop Down and a formula field) However.... I have created another saved search from…

Hi, I got it to display the image :D however even if I untick the checkbox it still displays the image.?? CASE WHEN {custitem23}= 'F' THEN '' ELSE '<img src="http://www.gardensandhomesdirect.co.uk/ghd/assembly.jpg">' END quick update - I tried this with a free form text field. and it displays image, when 1 is there and if…

Hi, I have made a field as a Rich Text and have this formula : CASE WHEN {custitem_ass_select} = '1' THEN '<img src=<"http://www.gardensandhomesdirect.co.uk/ghd/assembly.jpg">' ELSE '' END and have it set as Inline and also tried disabled. I tried changing it to {custitem_ass_select} = 'T' & {custitem_ass_select} IS 'T'…

Hi Evan, I have added a field (customer telephone number) into our customized purchase order form. However, When I log into the Vendor Centre, I can't see the field. What am I doing wrong? The Vendor centre, shows only a few fields So even if I select Roles under P.O and select preferred for Vendor, I do not want to…

Thanks Evan :) Works now.. much appreciated

Hi! I have managed to get the customer telephone number on the PO however, on the Vendor Centre/Supplier Centre, I cannot get the custom field to show up.. I have checked a few of the fields that are brought in but can't get it to work...

Hi, Is there a way to add summary type? I want to mass update Qty Sold for every item but starting on a test item. The formula : Case when {transaction.account} = '1100 Sales' and ({today} - {transaction.trandate}) BETWEEN 0 AND 99999 then decode({transaction.type}, 'Sales Order' , nvl({transaction.quantity},'0'),0) else 0…

Hi, You can try -> Manage Roles -> Show differences? Maybe you missed something out? Other then that, you can go into your item record/custom field and add permissions? or Recreate the item fields/record. Hope it helps

+1, I thought this was a Accounting System too..But it seems you have to create everything... :h_a_w: Any help with the said scripting? I would like this too.. but know nothing of scripting... How does one go about it and insert it? Would you be kind enough to share the script :D Thanks

Hi Drew, Thank you. I have 2000 items which includes Matrixes and Child items, it is the total number of items. but yea the solution sounds like a pain and it's not worth messing up and splitting up history etc like you have mentioned Thanks anyway.

Knlounsbury, Hi. I see what you mean and you're right. Those items didn't have any transaction associated so therefore didn't show. God it's so annoying that we can't do stuff on NS when we pay HUGE Amounts to rent the Package! I've spoken with NS support (2nd time) and there is a enhancement 171262, but there's no point,…

Hi Deisouss, I'm using a Item Search and I've used Transaction Field and then Options this brings in Item options for some items but the items are repeated so many times like 3 or 4 times. You're right I can maybe Group the Items but the item options is not just the item Options it also the actual Matrix Option. For…

So I guess no-one has any idea about this field.

Anyone please? I've found that the item options is created from lists that are created under Transaction Item Options. I've tried adding Transaction Item Options under my Saved Search and it brings up but not for every line and also the number of lines i.e. items are repeated over so many times.

ditto. I have tried using Firefox, Opera, Safari, Chrome & IE. The shopping cart is empty. I cannot replicate your problem

Hi Mondray, I just used this on my Saved search and it works good however I just changed my Criteria to not show me Matrix Child items i.e. to hide them. However when running the search it's showing me 298 Duplicates for example. 123 - Black TV 123 - Black TV 456 - Red TV 456 - Red TV 678 - Green TV 678 - Green TV My…

Anyone?

Hi, I got it working :) The problem was the custitem_ebird_pre_order field is not a checkbox and has a value of 1 if true. so changed if(itemDetails[i].getValue('custitem_ebird_pre_order', 'item') == 'T') to if(itemDetails[i].getValue('custitem_ebird_pre_order', 'item') == '1') I'm an idiot Lol ;) Thanks Jwenzer & Jeff

Hi, I have tried removing like you said. else if(itemDetails[i].getValue('custitem_ebird_pre_order', 'item') == 'F') { // If the line item is not an Early Bird item, mark hasEarlyBird as false. hasEarlyBird = false; } that didn't work, so then I removed the bottom elseif too but doesn't flag the field :(

I agree Sean :) Thanks @Everyone else Another problem :( I changed this to release on Netsuite but it does not work. It works if it's in testing mode? strange! Also, we have a script written by our Netsuite solutions provider that Fulfill drop ship PO's - It's a BuildUi script which generatea a Page. I want to add the…

Hi Jeff, Like so? Apologies If haven't understood you correctly, I am still a script newbie. 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 nlobjSearchFilter('internalid',…

Hi vVinceth, Thank You :) I got it working now.. However, please can you also help me with the second issue? I am trying to get it to display on the Custom Page - It's a BuildUi script. Thanks

Hi Jwenzer, It's not a PHP code, I only used that PHP tag to isolate the code from the message. I do not know how to break the loop unfortunately.. still learning :) What about this? Just changed the bottom to Return True. function SetFieldValue(type, edit) { // The itemDetails search can be done in an after submit phase…

wow quick responses thanks to both of you :) Oliver, I want to deploy this on the sales Order, so that it can scan through the SO and create a cash sale.. "sagepaydirectpro" is a Magento custom field and we have NS Payment method as a Credit card. the "var itemDetails = nlapiSearchRecord('salesorder') " was part of this…

Do you mean like this? I'm assuming nothing else is wrong? I've changed the SetFieldValue to SetFieldText is that what you mean or the actual field name is the Internal ID? where would I get this from or find it? function pageInit() { var itemDetails = nlapiSearchRecord('salesorder', null, [ new…

Hi SRodriguez, My thread over at : http://usergroup.netsuite.com/users/showthread.php?t=30358 and this is the script, which I tried and failed lol function pageInit() { var itemDetails = nlapiSearchRecord('salesorder', null, new nlobjSearchFilter('internalid', null, 'is', nlapiGetRecordId()), [ new…

+1 I tried doing this, someone has mentioned using system notes.. but my script doesn't work :(

Hi Khultquist, Sorry been stacked with other work.. Thanks for the reply - I have tried the code in debugger but it gives me ... ticket is not defined. this is a screenshot of my system notes - Printed Picking Ticket is not a custom field just appears under the system notes. All I want is to display a pop up alert and…

Hi Lorne, No 'Printed Picking Ticket' is not a custom field, that appears under the system notes after printing the picking ticket.

Hi Evan, I have tried in Debugged, it runs fine..but nothing happens when I test this on a test order...