OliverK Blue Ribbon

Hi Shiela Thank you for your help. To clarify, would this show me whether or not it is the first transaction for that customer of the year? For example - Company X and Company Y Company X places 1 order in February and 1 order in March Company Y places 1 order in March only. When I use TO_Date({trandate}) with MINIMUM as…

Thank you Michelle, this is done. Have a nice evening.

Hi Jacob, ours is all working fine now. Have you raised a ticket with support? Are you getting this message still when you try to upgrade? "The solution provider manages upgrades to this SuiteBundle, so you may not update it directly. When an upgrade is available, the solution provider will install the new version in your…

Hi Moshe Go onto a record where you would expect to see it and press CTRL SHIFT R At the same time, this will force a browser refresh of the scripts which should pick up the new version. That's what I had to do, let me know if it works. Oliver

Looks like a fix is on the way We are writing to notify you that Defect 811321 has been assigned U2 urgency. The latest version 2.12.0 of the File Drag and Drop bundle 41309 is currently being deployed to all accounts. This process is estimated to take several more hours to complete. Our Product team is actively…

Thank you Michelle, at least we are not the only ones. I have raised a support case citing the issue number. Hopefully it will be a quick fix. Thank you.

Don't worry, I hadn't checked the 'Can be fulfilled' box on the service items themselves, once I did this they showed on the picking ticket. Thank you.

Hi sorry to open this back up again. I have the 'Always print kit components' on picking tickets enabled, however my components still do not display. Just to check, my components are 'Service items for resale' As they are not physical components could this be why they do not appear? Thank you Oliver

Thank you Lyka In the end I disabled the workflow and used a client event script instead which is working well. Thank you for looking into the matter. Have a good week. Oliver

Hi Lyka Thank you for letting me know, what a shame, never mind. kind regards Oliver

Hi Dominica Thank you for letting me know. That's a shame, but never mind. Take care Oliver

Sorry Niks, I've done it again! Okay, for anyone having the same problem then use getText instead of getValue However if you are doing this on a record being created then you have to reload the record within the script. Code below. var objRecord = record.load({ type: record.Type.ESTIMATE, id: recordId, isDynamic: true, });…

Thanks Niks, I have solved this one I created another variable with the myURL displayed as a link and this works var myURL = scheme + host + relativePath; var myLink = '<a href="'+myURL+'">Link to Quote</a>'; Thanks all

Thank you for your expansive answer, I appreciate you taking the time and this makes sense. In order to make this work for us I have written a little script that runs every 30 minutes and looks at the MAX expected receipt date for uncommitted items on the work order and copies it into the Date field on the work orders.…

Hi there. Do you mean the Ship Date on the Shipping tab or the line item Expected Ship Date Both were showing the same date which was the date the SO was created and the date in the Supply Required By Date. I did have a slight breakthrough, if I change the main date on the work order to the date of the expected supply on…

Thanks Lyka I will gather this information and come back to you

Just to pre-empt, My date settings are set to display DD/MM/YYYY and I have made sure that the field being populated on the actual item page is also in the format DD/MM/YYYY So I don't know why the format is being changed to the one in the screenshot.

Gaurav, this is incredible, it worked like a charm, thank you very much. Have a great afternoon. kind regards Oliver

This worked perfectly. Thank you very much for your help Ivy, incredible skills. Kind regards Oliver

Hi Ivy I hope you are well. Thank you for your help. I believe I did have a formula similar to this initially and I added the to_char in because in actual fact I need to use the Least function in a bigger formula to work out if today (-) these least of these dates is bigger than 60, if it is then I want to check a check…

Thank you Richard, fingers crossed

Hi Michelle Thank you for letting me know. I will head over there and vote this morning. Have a great day. KR Oliver

Hi Michelle Thank you for your help. Apologies I have not had a chance to try your solution. But just to check, can you still user inline editing on a summary search? Or can I still use the summary highlighting when the search is not a summary search? Thank you Oliver

Hi Leonard I can confirm this is 100% correct and resolves the problem. Amazing. Thank you very much for taking the time and for your skill and detail in answering. I am pleased that this answer will now be on the forums to help others with similar issues. Have a great weekend and thanks again. kind regards Oliver

Good morning Patrick Thank you so much, this is perfect. I suspected it would involve the dense rank parameter but until you have had it clearly articulated by someone with the knowledge it is difficult to make progress. I greatly appreciate your time. Have an amazing weekend. Kind regards Oliver

Hi Ivy Thank you for your time. I did try this, however the only issues is that I have a location filter on the search and the {quantityavailable} stays the same no matter which location is selected when I use that option. As a workaround I have created 2 columns 1 for the company available as a whole and the other which…

Thank you Kristoffer. At least I am not the only person who wants this functionality :-) I will take a look at the suiteideas page. Thanks for your time. Oliver

Thank you Richard. Just to clarify, I have tried using {quantityavailable} instead of {locationquantityavailable} and the problem persists. When I set this to SUM it results in a number many times larger than what is actually in stock. Cheers all.

Hi Niks and team This is semi resolved. I have simplified the date formula down to an absolute range as per the below and it is working in the required way. Thank you for your consideration. Of course if anyone has any advice on better ways to process these then I would be grateful. Thank you Kind regards Oliver Working…

thank you for the swift answer Ivy, that's great. I will go down the analytics route. Thank you very much kind regards Oliver