Cloud Red Ribbon

Hi Al3xicon, Erm No, can't remember how to do it, is it CONCAT(TO CHAR({isonline},' ',{isinactive})) Will that work? so will I need to keep doing concat(concat(concat(concat X amount of times to add those 20 different Matrix Options. Thanks Even this is failing for me :(…

Just one more thing, I ran this successfully. I ran another search and update a bulk of records in a flash, however when I go to run the Mass Update again it keeps saying --- "our session has timed out. Please re-enter your information and try again." I tried to edit the search and then perform the update but I get the…

Just want to say Farrago & BrettKnights - I Love you guys!! thanks for helping me out :)

Well, my criteria works fine, type of sales order, and there is a purchase order fields where I have selected Date & Status. like I said, this is the only way for all three numbers to load up on one search.

Hi, Because I need to see Sales Order Number, Name of customer and amount. this is the only way I can think of doing it that will bring me SO number, CS number & PO number.. unless you know of another way? Thanks

bump...anyone? Please --------------- Also, If I edit the KIT sales order, I can edit the site category and it will get display correctly on Reports.

Sorry Guys, I havent replied. My MD has given me a impossible task to do, she told me to revisit this late, I appreciate all the help. Thank You

Update - I got the formula working with two dates. Thanks Evan..:D if anyone wants to know why ..here you go sum(Case when {account} = '1100 Sales' and ({today} - {trandate}) BETWEEN 0 AND 7 then decode({type}, 'Return Authorisation', nvl({quantity},'0'),0) + decode({type}, 'Currency Revaluationt', nvl({quantity},'0'),0)…

Its failing on the second half . I added another column into the search and used the second half of the formula : sum(Case when {account} = '1100 Sales' and ({today} - {trandate}) BETWEEN 0 and 7 then decode({type}, 'Sales Order' , nvl({quantity},'0'),0) + decode({type}, 'Currency Revaluationt', nvl({quantity},'0'),0) else…

Evan, Please rephrase 'Because no sale is going to be both between 0 and 7 days ago and 0 and 14 and 21 days ago.' I am trying to look at Returns (RA) in this week and dividing by Sales Order from the 3rd Week. the Formula field is using a sum summary so yes.

JCirocco, we have not yet installed Beta Pivot Function, We have loads of customization to our Netsuite, and I'm worried, it may mess things up?

Hi Evan, Sorry, still can't get it working.. please advise sum(Case when {account} = '1100 Sales' and ({today} - {trandate}) BETWEEN 0 AND 7 then decode({type}, 'Sales Order' , nvl({quantity},'0'),0) + decode({type}, 'Return Authorisation', nvl({quantity},'0'),0) else 0 end * 100) / sum(NULLIF(Case when ({today} -…

anyone? Please...

Evan, thanks, I can't believe I missed that.. but it still does work. It doesnt show Invalid :D but its Blank and the Grand Total at bottom shows 0.

Thanks Evan, I've Tried that too, still invalid... Case when {account} = '1100 Sales' and ({today} - {trandate}) BETWEEN 0 AND 7 then decode({type}, 'Sales Order' , nvl({quantity},'0'),0) + decode({type}, 'Return Authorisation', nvl({quantity},'0'),0) else 0 end * 100 / NULLIF(case WHEN {trandate} BETWEEN 14 AND 21 then…

Case when {account} = '1100 Sales' and ({today} - {trandate}) BETWEEN 0 AND 7 then decode({type}, 'Sales Order' , nvl({quantity},'0'),0) + decode({type}, 'Return Authorisation', nvl({quantity},'0'),0) else 0 end * 100) / case WHEN {trandate} BETWEEN 14 AND 21 then decode({type}, 'Sales Order' , nvl({quantity},'0'),0) +…

Thanks, I have set Main line to be false.. works great.. but another issue - The notes are appearing multiple times because some sales orders have more then 1 lines. I can see the item name and code but then I only want the user note to show once.. I do not want to group this. otherwise I will lose one or the other..

Morning Peter, Thanks for the reply, but my directors wants to see every item we are currently selling and comparing it to last year. They want to be able to export this in a CSV. wouldn't a KPI only show one Item? I haven't created a KPI but I dont think there is a way to see Price, Margin, stock available. sorry if I…

Hi George, Please can you help me with this formula? I tried doing WHERE CONTAINS({number}, 'RA') but that didnt work, so then I tried your 'Like' statment - but still doesnt work... Case when {account} = '1100 Sales' and {number} LIKE 'RA%' and ({today} - {trandate}) BETWEEN 0 AND 7 then count({number}) else 0 end I am…

Hi Evan, Thanks for the reply. However I want to be able to group the customer questions or remove them. when searching for a item we do not want to go through 30 questions to find the item. I know we can type cu: or but most of the time we can find the customers easily. I am talking about Items where we do not have to…

Thanks Evan & JMUnderwood, I think you are right, if there isn't another way then it will have to do :) Thanks again Mayur

yep i got it working. without having to open the run the saved search. Thanks again :) Have a Great Weekend

lol you're right. I havent made that button our NS support team have, As I do not know Coding or Js I cannot edit or move things around. Is there another way, to call a script? or something similar. we've had problems in the past when employees forgetting to inform the various depts and the item gets sent out. Thanks Cloud

i Disabled all the audiences in the search 'test pre order test' thinking it may revert back to the original update form.... however it now shows this error when trying to update matrix. Normal items and Kit work fine.. : Notice (SuiteScript) That search or mass update does not exist (internal id=385)

Ok I tried your amended .Js file and when I click on G&H cancel order button, nothing happens. I clicked on Edit and as soon as I click on the uncheck box to reopen the sales order I get this message : An unexpected error occurred in a script running on this page. FieldChanged (fieldChange) customform JS_EXCEPTION…

Just to let you know. I've sorted it. the culprit was a Workflow I had created for a Item to search Pre-Order Items but for some reason I did not how I set it up lol. So deleted it and tried a Matrix and Voila :) Mass update completed on 4 items.. checked and it works...

Hi, I don't know if that's the right ID for that button. I am going to check :) fingers crossed it works :) Thanks Khultquist. Also, if you don't mind - please could you advice, I am creating this in my custom sales order 'transcation form' and using Field Changed Function : Fieldchanged, all others are empty. is this…

Never mind, I just got a email :) lol..

ok I have created a search but emails not working...sigh. il try again.. thanks Khulquist. just realized, it will email only one person, is there a way to send email just to the person who closed it? Thanks

Great Richard, Thanks!! cant wait to try this.. but I've ran into another problem.. I had to edit the Phone Call entry form instead of the Event form and I have set it up how I want it. But I dont want to reserve time, or have anyone attend it, have it so it doesnt appear on my dashboard as a reminder and remove from…