brocha Red Ribbon

Just want to provide some of the code. Here is the itemtable code with the custcol2 field highlighted. Ive also tried: record.item.custcol2 item.custcol2 item.item.custcol2 When i try to preview i get the below error.

This does help. THank you!

Hi, this is how im importing price updates Im matching on item internal id and updating the price level field with a numeric value. Just want to know if this type of price update will retroactively update all existing documents like previously entered quotes. THanks!

It wasnt the ideal solution as much as it was a work around.

ok, thank you for the information.

Hello Michelle Jabanes, I will try your proposed solution and let you know if i require additional assistance. Thank you!

Thanks @User_ZCWF3, I removed the status criteria and the conversion percentage seems more realistic now. I changed my summary type to MINIMUM but it doesnt seem to affect the results. Why do you use MINIMUM vs SUM? Thanks!

Hi, I came across the link below and was able to fix my saved search. Basically i had to manually type in the formula instead of COPY/PASTE. There must be some hidden characters in the formula i copied from SuiteAnswers. This question can be closed. Thanks!

Hello, Just wanted to get an update on this question. Please let me know if any clarification is needed. Thanks!

Hi Joahnna, Just checking in on this ticket. Hope my previous post makes sense. THanks!

Thanks for the information! Below is the current code and highlighted are the column labels and check.apply section. THis looks like the voucher code you sent me. Do you mean i add your code at the very bottom of this screenshot, under the check.credit section that is commented out?

Hi Johanna, Just following up on this question. Let me know if you need anything else to assist. Thanks!

Hi Johanna, Please let me know if you need any additional info from me. I appreciate your help.

Sure, here you go!

Thanks for this, Shaik. After a couple more tweaks to the code it finally works for me. I appreciate it.

Thanks Shaik, I tried to enter the code you suggested. Below is what i have. But the code throws this error when i preview it.

Jack, I kept getting error The string "--" is not permitted within comments" so to get around this just removed the code that was commented out and saved it in case i need it later. So im all set here. Thanks for your help, once again.

Thanks Jack. I havent had a chance to test this, but will do tomorrow and get back to you.

Hmm, i tried that and still get an error I feel like its something minor im missing. I appreciate your help.

I appreciate it, Gaurav. Unfortunately my script skills leave something to be desired. Unless you can provide some details instructions ill probably just use the "copy" checkbox. Thanks!

Thanks Jack. We wont need the third piece of code you provided as all our business ids are either 1 or 2. Here is the code i put in place. But it generates the below error

Hi, I would like to revisit this question. I would like to simplify the code in my screenshot below so the following is achieved. all quotes with a record.cseg_appf_business.id = 1, use media image 606031 all quotes with a record.cseg_appf_business.id = 2, use media image 14502 Jack was a great help before. Thanks!

Thanks Gaurav, that makes sense. My other question is after the checkbox is checked for COPY, would it then be possible to somehow link the initial order to the copied order(s)? LIke a list of the copied orders? Thanks!

Thanks for the feedback. Are any addresses "searchable" in the Global Search field?

Here is the quote and ship to field.

ok, thanks for looking into it anyway.

Yes, it is custom. Hope this helps.

i havent tested this yet but my initial thought is it wont be ideal. We need the workflow to trigger instantly, not wait for 30 min. But i appreciate the suggestion!

Thanks. I will give that a shot.

Here you go. When the business field = installation, the workflow will set the two field values in the second screenshot. This works for new orders. Some orders are entered as new: Some quotes are converted into orders using the "sales order" button on the quote: Thanks!