Richard Appleford OB Red Ribbon

@Red Velasco-Oracle Thank you, I will try this solution.

Hi @Kristoffer Viray-Oracle Are you able to text align vertically on the pdf templates? I want to create a column which has a "____" so a user can manually write on the line on a Picking Slip and also a tick box for them to confirm. I've got the tick box to work but I can't align the text for the "____" to the bottom of…

Hi @Francesca Nicole Mendoza-Oracle They are both relatively simple custom Transaction Body (date) fields on the Sales order transaction.

Hi All @User_ZCWF3 , @Francesca Nicole Mendoza-Oracle @User_I4Z2V I have a similar issue. We have a date {custbody_ob_slotenddate} that we set which keeps changing, so we want to capture the original initial date in a second field {custbody_ob_orig_slotenddate} which then doesn't get overwritten. I thought "Store Value"…

Hi @Tris Mendoza-Oracle and all the oracle communities, Looking through the NetSuite manual guides it shows there isn't a standard functionality which creates the Work Order form an Opportunity. For our business application I am going to advise against it, as a Work Order should only really be created from a Sales Order as…

Thank you @Tris Mendoza-Oracle , I've managed to set up the workflow to create the Work Order, though need to figure out how to bring an Item line value into the Assembly field of the Work Order.

Hi @Able Wilson, @Michelle Jabanes-Oracle , @Grace Catabian-Oracle Sorry for such a delay in replying, please see below, The opportunity field on the Funding Record is as below, does this need to be a "Record is Parent" ticked? The issue is though, this is a custom field on the main form of the Funding Record, not the…

@Mel H I've used this for one of our forms. <#if item.custcol_wrm_reg_hid_trackwarranty=="T">${item.inventorydetail}</#if>

Hi @Elychelle Gulen-Oracle I think I've worked it out. I rebuilt the criteria and it seems to have worked. I also used #display in the field brackets and created a new formula field as a string.

Hi Johanvl, I've utilised the following formula though it is not perfect. round(max/* comment */({messagedate}) over (partition by {customer.entityid} order by {internalid} desc rows between 1 following and 1 following) - {messagedate})

Hi @JohanvL The emails come from customers directly, so I'd need to do the saved search off the Customer Record linking the messages associated with it. The message table doesn't (that I can see) have a field for an associated message. I probably need to write a query which, per row, returns the previous row which has the…

Hi All, Excuse me for jumping on this thread though I have a separate but related query which @Elychelle Gulen-Oracle your response may solve. If @JohanvL you've your solution I'd be very interested to know about it too. I'd like to be able to report (via saved search) the time between an incoming email and the subsequent…

Thank you for this! @User_HIG7E

@3955366 Hi, I'd be interested in an answer to this too. My issue is slightly different. We have a drop down then a sub drop, currently we have to create a list for the main drop down, then individual drop downs for the options based on the first choice. For example say if had a choice of shape, then colour, is there a way…

Thank you @Gregz-Oracle and @Veronica Steluta Mincior-Oracle It is a bit odd that Created Date isn't an available filter. If required at a later stage we may need to create the additional custom field, though best practice would be to keep additional fields to a minimum. As Gregz noted, we may need to run formula. Many…

Edited original comment/post, it should read - "we can't filter by Created Date"!

Hi @Tris Mendoza-Oracle For me it is status reference key 8. It was a status I set to inactive, though have since reactivated it. Is it showing the error because I still have entities with that status? I tried to replicate in Sandbox and didn't get the error. I've also made other statuses inactive without getting the same…

Hi @James Parkin and everyone, I too am a weary traveler! We made the mistake of creating too many entity statuses and have since started to set a number of them to inactive. Is the error message related to a workflow or just to the field in general, as in, is there other options to remove the message and still keep the…

@Michelle Jabanes-Oracle Hi Michelle, As attached, the Funding Record field on the Opportunity is set to Edit

Hi All, just seen there are 2 formula's depending on if it is from Client or Server. Have tried using + and it has worked!

Hi @Ivy Lopez-Oracle, Josh and All, I have been trying to attempt this too. I find that whether I use 'text' or field labels I can only get the first value to display via the workflow. What am I doing wrong? The example above I'm trying to pull a custom field which is before the Title field and a random word to add to it.…

Zoomed in on the Funding Record.

@Able Wilson @Michelle Jabanes-Oracle Hi Both, For example if you took a Customer Search you are able to select "Transaction:Transaction Number" which when run would display all the Related Records against that Customer. We do have a field on the Funding Record which is 'Opportunity' and this is auto populated when an…

Hi Michelle @Michelle Jabanes-Oracle The "Funding Record" is a Custom Record, though the Opportunity (and its Document Number field) is standard NetSuite Record. The Saved Search is against the Funding Record, where I'm trying to pull in the Opportunity Document Number from Opportunities rows within the Related Record tab…

Hi All Sorry to jump onto this post but I have a similar problem. @Michelle Jabanes-Oracle Michelle, We have a custom record (Funding Record) which has Related Records which include Opportunities, etc. You can view the Related Record but I can't see the "Transaction" fields available to select in the Results area for the…

UPDATE, please ignore. Found the help guide

@Michelle Jabanes-Oracle The trouble is we keep having to change the links, as it works for a while, then they get broken, it seems really unstable. Does Oracle run tests for users (companies) like us who use a secure link through like us for example Stratokey for encryption, before releasing new updates? Many thanks…

@Michelle Jabanes-Oracle Hi Michelle, Emails we are sending out to external people, the images are broken? If we send them to internal recipients they work fine? This only just started happening in the last few weeks? Has something happened? Please help, this is affecting everything in our business.

Is this happening again? @3955551?

Hi @Lewalsh11741 Have you got an example I could compare with ours. We lost the links, then tried to change them, they worked fine then failed again. We initially had to put all the images into our google drive and link them across to NetSuite, then they broke. So we then put them into our NetSuite and it worked, then they…