Richard Appleford OB Red Ribbon

Hi @Richard James Uri-Oracle This is the message we get, each time, we know that there maybe ZIP/Postal codes missing, so its frustrating having to select OK each time. It also slows NetSuite processing down, so we have to wait for it to cycle through.

Hi @Richard James Uri-Oracle , We dont use SOAP for transactions, so I do not know why this is displaying?

Hi @Jack Daryl Espiel-Oracle and @Mikko De La Fuente-Oracle , I have a similar issue, I am trying to extract the information between 2 spaces. The values look like (for example) this APP1022 Richard Appleford ZZZ9999 James E Smith 78 Brian L Gotham I need to extract the value between the first 2 spaces so above to return…

@Dext3r Thank you for this post and solution. We just came across the same problem. It is somewhat frustrating how there are a number error messages in NetSuite which do not specify what the error is!

Hi @3956128 and @roberth , I'm now getting the above error too, it would appear it is now not allowing me to save Customer records. Please can you let me know where I can turn it off?! Any help is much appreciated

Hi @Angelica Mae Segador-Oracle Our issue has now been passed to the NetSuite team who are trying to establish how to resolve. As your suggestion above, yes I cleared browser history, tried on other browsers and my colleague also got the same error on a different laptop/user account. It looks like it is a company wide…

specifically, we have 3 subsidiaries. Ltd (which is our main subsidiary) then Inc and GmbH. Inc and GmbH effectively buy from Ltd and sell to a customer. The above script was written before GmbH was created and it works for Inc/Ltd scenario but not GmbH/Ltd scenario which uses the same forms for SO and PO but just a…

Hi All, I am a complete novice in Suitescript, with no Java background, I am planning to learn but I have an issue which might be a quick fix for someone who knows suitescript. In our business we have 3 subsidiaries, though when a number of scripts were written we only had 2. I think the issue is is that the scripts needs…

Hi @Richard James Uri-Oracle , that one worked, thank you! I'll have a read of it, I have no experience of scripting and need to learn quite quickly, maybe starting off with some simple ones first, this looks quite complex! I also have an additional query to do with scripts but I will ask in a seperate thread. Best regards…

Hi All, I'm am getting this now. Raised a help request with NetSuite but nothing back yet. As @3950659 mentioned I'm having this issue on our main form we use in our company. I was making a number of changes all at once and now I'm unable to do anything other than Move Elements between subtabs. Not even able to create new…

Hi @Mikko De La Fuente-Oracle I'd be interested in this article but when I click on the link it just takes me to a standard NetSuite screen?

@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