Thanks again @"Chris Dobbins" I knew I had that as a last resort. Now I know there is not other solution to show the conversion rate. Edit: Our implementer added a custom script after submitting that adds the conversion rate column to the sales order.

Thanks @"Chris Dobbins" What if in the invoice the unit type chosen was not a case, but a pack for example. Is it possible to show the conversion rate of the currently chosen unit type in the invoice?

Any other suggestions?

Wow! I tried the code and it works , this is the first I've heard of the SendKeys on another application. However, just as you said, I will go the script and see if I can work it out. If I couldn't I'll use your UOM sheet and maybe make it loop, save and start new. Thanks @"Chris Dobbins" and@"Erick Dela Rosa-Oracle"

Hello @"Erick Dela Rosa-Oracle", By table I mean the excel table that has my UOM's that are due to be uploaded. Since manually entering several hundred UOM's would take a long time, I searched for an easier solution. My idea is that there is someway to make the script to read off the csv table that has my UOM's to add.…

Thanks a lot! This is what I was looking for. I tried it and it works. However I did not try to add a UOM, I have to see if that is possible. And also if this script will be able to take data from a table. Thanks again Eric.

Does this script still work in Netsuite? If yes, where does it get the list of UOM's to upload Thanks

Thank you for your reply However this is not what I meant. I was talking about adding an item in any Sales Transaction page by the UPC. The item field (attached screenshot) only accepts the item number or name. Thanks again