User_6YI1X Blue Ribbon

Hello! Here are the steps I took based on your recommendations. I first went to set up and changed the setting to "ignore commitment". I ran the build work order again and the same error happened. I went into the inventory items that were showing backordered and adjusted the inventory. I ran the build work order again and…

Thank you for your response. I have already tried that. It still shows multiple lines. In addition, we are trying to see each line of the invoice (main line= false)which I believe is conflicting with the request to see the related payment info. which of course would be main line=true.

Is there a different workaround we might be able to try? The info. in that column used to cut off at a certain point and then display "more..." but with one of the newest updates, it started showing several lines. If I created a new tab within the sales order to post that custom field per line is that possible to do and…

I tried adjusting display size but it's not adjusting the column size. It remained the same.

i did try adjusting the height however it didn’t do anything but I will adjust the width today and see if it works. Also, thank you for pointing out I had copied the wrong script. I will put the correct one in for reference

Perfect! This worked. Thank you for your help!

Added more screenshots to original post of the field itself

I need to give more detail because the reality is I can get 3 decimals however when adding this custom field to a report it's pulling it over with 2 decimals. See the screenshots attached.

No worries. Much appreciated!

I have done as instructed and removed everything except date, document number, main line name, item and amount and it is still providing the same results. I left the criteria as is.

So sorry!! I forgot to add those screenshots to the initial question. Here they are:

Works like a charm! Thank you!

disregard. I figured it out.

Disregard. I’ve figured it out. Thank you!

Amazing! Thank you!

One last question-I noticed that by making those lists custom records I can no longer use inline editing for those fields on my item list. Is there a work around for that so that I quickly assign the product category and sub-category without having to go into each individual item?

Amazing! Thank you!

All of the items on the SO are either committed and need to be fulfilled OR they are fulfilled (previously before the enable line shipping was turned on). Yes all of them are set up for the same location BUT when we enable line shipping does that "location" have to be on the line instead of just in the Primary Information…

Thank you!!!

I'm sorry I stated the wrong thing. Our saved search is based on type=work order and have tried the created from: ship via and applied to transaction: ship via and it will not pull. Does that change things?

Some additional detail on the issue we are having. We have several saved searches created based on "type" sales order and "ship via". When enable item line shipping is checked off I understand that the ship via from the sales order goes away as it is then reflected on the line of each item of the sales order. We have…

What I'm really trying to access is the ship via per line not from the shipping tab. See picture. Sorry for the confusion.

I was looking to see how to add an external URL link such as a google sheet URL to a netsuite dashboard. Is that possible? For example, a link like the one below:…

I just noticed there were comma's in the check amounts. I reformatted that and attempted the upload again and got the same error.

Yes it worked ! Thank you so much for providing the work around!

The script in the suite answer works perfectly. Thank you for directing me there. I do have an additional question now that I have deployed and tested the script. With the script as is it now will not allow an edit of that particular field on the work order. We can hit edit on the work order make changes on the field and…

amazing thank you!

Ahhh I figured out why. There were several spaces between *MISC: . 21025 4-LEAF DOUBLE EYE HD 20" SPRING and LED Lights Complete Trailer. Stainless Steel Hardware. Once I removed the extra spaces it worked. Is there something I can add to the formula that would still pull over all of the information in that section…

One more question in regards to the formula provided. It is working however I have found that sometimes it is omitting some of the information. For example, in the following text: **MISC: . 21025 4-LEAF DOUBLE EYE HD 20" SPRING LED Lights Complete Trailer. Stainless Steel Hardware. **TONGUE: 3x4x72" tongue. 1200lb Single…

YES!!! Thank you soooooo much!!! ?