HertsChris Blue Ribbon

Yes that did it thank you. Superstar. Chris

Ok Thanks Dominica. Frustrating but I can live with it. There aren't that many scenarios where we will have multiple locations on a PO. Thank you for your help. Chris

Well that's a releif. Unfortunately that is not the behavior in my system. Is this a setting somewhere? See below -

Some of the stuff that is sitting in Enhancements is really shocking. this seems like such low hanging fruit. Lets get this kind of stuff ironed out before adding any more bells and whistles. Thanks for your help Chris

HI Michelle, Yes I am talking about the sublist found at Opportunity record > Sales > Estimates. I want to change the view of this sublist (the columns). Chris

This is a simple workflow that uses a saved search to indicate when a renewal opportunity needs to be created (based off contract end date). The Workflow is just one action - Create Record. Subsidiary is not one of the available fields as far as I can tell which means the system is regularly creating the opportunities in…

@JoshPNW what did you end up doing to get around this? We are facing the same issue. Our Delivery charge is a Non Inventory Item that goes straight to billing but the items to purchase are Inventory Items to be received and fulfilled. We are left with loads of delivery charges sitting in orders to invoice waiting for their…

HI Kristoffer, I appreciate your patience here! Yes that works. The only problem is, the replace function no longer works ${snumber?replace("<br />" " ")} So I am back to having one long column of data instead of several columns. Am I able to have this working at the same time?

This still doesn't work unfortunately. The packing slip is being printed from the Item Fulfillment. does that change anything? The list details above look like they are pulling from the sales order. Chris

Hi Kristoffer, thanks again for your help. I have tried this but it hasnt worked unfortunately. Below is my code - Maybe this isn't possible for serial numbers in the same way it is for one long description. Did you manage to get this to work for serial numbers?

That does work. That's great thank you. Now is there a way to prevent this - The serial numbers are cut off and don't continue on the next page. is there a way to continue these on the next page and not have them fall of the bottom? Chris

Yes I just want a tidier way of presenting the packing slip when the re are hundreds of serials. Interested to see what other people are doing. I have had to block out pretty much all the information but below is what it currently looks like like.

Thanks Kristoffer. If you are seeing the issue as well I am surprised no one else has complained about this. I will raise a ticket now. Thanks

Thanks John. I don't know how I missed that list of transaction types. My mistake. Very annoying it doesn't cover all transaction types though. Seems like a miss from NetSuite

Hi John, Yes it is checked. They need to be able to amend Sales Order numbers but have a problem with sometimes generating duplicates. We want to be able to allow them to override but block duplicates. I assumed this Warn and Block setting would do it.

Hi Michelle, Yes that all makes sense now thanks for your help. Chris

Hi Michelle, I was about to say - it can't be that easy can it!? Unfortunately our Inventory items are used across all Subsidiaries but locations need to be fixed to a specific Subsidiary. we therefore get the following error when trying to set a location on the item record. So what I'm seeing is that it is not possible to…

Thats fine. thanks Joahnna, I suspected it wouldn't be possible sadly. rather than script it it I may try to pick and move the scheduled email workflows to the quote record. This may do the job. Thanks for your help. Chris

Hi Joahnna No thats not my need. I want an additional field to hold the PDF version of the quote. My end result is I want the PDF version of the quote attached to the email. Because the email is going from the opportunity record instead of the quote i created the above fields to pull information from the quote. But I am an…

Thanks Joahnna, So this is basically the email (I have amended this for privacy) - This email goes out from the Renewal Opportunity and is part of a bigger campaign it is not until this point in the email campaign though that the Quote needs to be attached or referenced. custbody32 and custbody33 are both custom fields on…

You can create an inline html field as a hyperlink. Would that be sufficient? Create a transaction body field. In type select Inline HTML Under Validation and Defaulting, Default Value - '<a href="' || 'https://your link..' || '">Your Text</a>'

Hi guys, I have done this. and it works. thanks a bunch @JohnCirocco and @Kristoffer Viray-Oracle Chris

Thanks John, I have requested a call from them now. Initially it seemed as though a lot of the integrations I was seeing was from a buyers perspective but we need to use it as a seller. I see now that they offer both. Since we only have one customer requesting it I was hoping there was some NetSuite solution but it seems…

Thanks @JohnCirocco . @Kristoffer Viray-Oracle I don't really understand how I would approach this could you show me the test you did? Would I still keep the first field populating via the saved search? And then how would the workflow look? sorry if it is obvious! Chris

Great. thank you for that. Will follow that advice

Hi Kristoffer. The solution doesn't really meet the need unfortunately. It does 'work' in that it will pull the value from the original field but only when the the record is edited and saved. we need it to be a live field that we can report off rather than needing to edit and save every record to get a value there. The…

Hi Katerina, yes we reconciled it way back. I'm not sure why but the company were reluctant to reconcile from statements two years ago but the amounts match and it doesn't affect any subsequent reconciliations so we are all good. Thank you

So lets try a different approach then, How would you store a value from a field that is populated by a saved search. I understand I cant store that value so my workflow was meant to populate a new field with the value from the first field so I can store it. Since I cant get that to work how would you advise I store the…

Hi @Kristoffer Viray-Oracle , Yes that does work but only if I edit and save the Sales Order.

Kristoffer this is driving me crazy!!! I have changed the workflow to just populate with the word test rather than feed off the first field. The only difference between the first and second screenshot is that in the first one the Store Value is ticked on the field. I have tried this in Edge and Chrome and get the same…