Shin W Red Ribbon

Hi @Jervin Nicholas Teopengco-Oracle , @Richard James Uri-Oracle Thank you for taking your time for my inquiry. There is no worries as I have understood that a client script is not available onto Order Items form to deploy. I hoped that if there was another (unexposed) option available.

Hi @Jervin Nicholas Teopengco-Oracle , Many thanks for your response. I am looking forward to hearing a good news from you😊

@Niks Blando-Oracle Thank you for introducing me to everyone and for letting me know about New to NetSuite. I would like to wait for any possible solutions and advices from someone here. Or would it be better that I should ask the same question in New to NetStuite? thanks a lot!

Hello @Tigran Shahnazaryan Wow, it works! That's probably what I was looking for. Thank you so much for your great assistance👍

Hi @Tigran Shahnazaryan Much appreciate your kind response. OK, let's simply my question. When I made a Custom Item Field named 'QTY Available' with simple formula below only contains {locationquantityavailable} then applied the Custom Item Field to Reorder Point Items sublist in Purchase Order by [Customize] button. Then…

Thank you @Tigran Shahnazaryan for your rapid response. Are you trying to add quantities for "Available", "On Order," and "Preferred Stock Level" per Location and show the sum in a new field/column? Yes, that is kind of what I want to do but I cannot find their Field Ids. Thanks!

Hi @Tigran Shahnazaryan As advised I am trying with Custom Item Fields and it seems nearly working well but still struggling with Multi-Location Inventory. To calculate the number we need. I want to get Available (or On Hand), On Order and Preferred Stock Level per Location which are already shown on each line in Reorder…

Hi @Tigran Shahnazaryan Many thanks for your detailed advice! I am unsure if the Carton Quantity can be seen in saved searches so I will check it and I may want to try to create a custom field. I will post the result here later. Thanks again!

Hi @Tigran Shahnazaryan, Thank you for your advice! I looked it up, but unfortunately I could not find an item that corresponds to 'carton quantity'.