Hormese Paul · Lead Solution Architect · Bronze Trophy

Hi @Mikko De La Fuente-Oracle , Thank you for your confirmation on the script. Regarding the custom list, it would be good to know if I am missing any setup or if it is a standard limitation.

Hi @Joahnna Given Uy-Oracle , Thank you for your reply. I have created different fields with a different formula as suggested.

Hi @Joahnna Given Uy-Oracle , Sorry for the delayed response. I got caught up in month-end closing. The formula NVL(CASE WHEN {type} = 'invtrnfr' THEN {tranid} ELSE NULL END, CASE WHEN {type} = 'salesord' THEN {tranid} ELSE NULL END) is working fine in both sales order and in Inventory transfer. But when I changed the…

Hi @Micah Timbol-Oracle , Thank you for the Mention. Its been a great honour to E-meet you guys in this community. I am a functional consultant working for the India based company-Jobin and Jismi IT service LLP. My motivation to work is that Netsuite does keep me pretty much interesting with new releases and features every…

Hi @Dominica Sevilla-Oracle , Thank you for your reply

Hi @Ivy Lopez-Oracle , Thank you for your reply.

Hi @Michelle Jabanes-Oracle , Thank you for your reply

Hi @Michelle Jabanes-Oracle , We have tried changing the Email message template of custom forms from Default Email Template to a custom form but NetSuite not picking that custom email template for automated emails. Then we inactivated all forms except the prefered form. And selected a custom template in that prefered form.…

Hi @Patrick Fresnosa-Oracle , Thank you for your time. I'm sorry as this was due to a script that came with a bundle. It was the script that makes the full tax amount appear in the invoice. I undeployed the same and now it is working fine.

Hi @Patrick Fresnosa-Oracle We are not using Advanced taxes. Zipcode: CA 95240

Hi @Emilia Ironov-Oracle , Thank you for your reply.

Hi @Joy Noreen Magoling-Oracle , Thank you for your reply.

Hi @Ivy Lopez-Oracle , Thank you for your reply.

Thank you. I will look into these details.

Hi @Ivy Lopez-Oracle , My question is actually based on packing orders. For bulk order picking, I am not using cartons to pick items, instead, I use a trolley to pick items Also, I am collecting items for different customers. My aim is to collect items in one go for different sales orders. So I have picked the items using…

Hi @Joy Noreen Magoling-Oracle , Thank you for your advice. It worked. I deleted the rule and set that again. When I check the WMS system rules in the list the 'use carton for single order picking' having an 'active' value as No. But When I opened the rule in edit mode the value set there was 'Y'. I have corrected it to N…

Hi @Joy Noreen Magoling-Oracle , @Arnold Willems , Thank you for your replies. I will try to do the solutions you have suggested. The item name/creation happens through integration which is why it is a mess. Need to clean that up. I'm grateful for your time.

Hi @Pauline Joy Cac-Oracle , Thank you for your reply. I will try to use saved search

Hi @Michelle Jabanes-Oracle , Thank you for your quick reply. Little sad to hear that it is an enhancement. Let me see if there can be anything that can be done internally.

Hi @Pauline Joy Cac-Oracle , Thank you for your reply. I will try to see any workaround in the script.

Hi @Erick Dela Rosa-Oracle , Thank you for your reply. It was very clumsy of me as I recently started in scripts. Thank you for pointing out the issue. Much appreciated.

Hi @Mikko De La Fuente-Oracle , Thank you for your time. We are able to solve this issue by enabling the website feature in Netsuite. Now the scripts are working fine. Please see the below screenshot. @mikk

@Mikko De La Fuente-Oracle I have attached the screenshot and scripts above

/** * @NApiVersion 2.x * @NScriptType Suitelet * @NModuleScope SameAccount */ var PAGE_SIZE = 100; //var SEARCH_ID = 'customsearch_jj_stock_germany_fen25_aj84'; var CLIENT_SCRIPT_FILE_ID = 5393; define(['N/ui/serverWidget', 'N/search', 'N/redirect'], function (serverWidget, search, redirect) { function onRequest(context) {…

Hi @Mikko De La Fuente-Oracle , Please see my below replies What role are you using while executing the script? : Admin Could you provide a simple script that is similar to your concern? Yes attached below Is there any error in the script execution log? No errors Is the script working before for this account? No, it's a…

Hi @Emilia Ironov-Oracle , I was not able to get/keep the actual column of the report using the workbook. The budget data get populated but not sure how to bring the actual amount. Please advice.

Hi @Jack Daryl Espiel-Oracle , Thank you for your quick reply. I will try some other alternative methods and also try registering a suite idea. Have a nice day.

Hi @Mikko De La Fuente-Oracle , You are great....! This solution worked for me. Thanks for the help

Hi @Shamaine Chan-Oracle , Thank you for your reply. I have decided to go for approval routing for the vendor prepayment. This question can be closed thanks.

Hi @Emilia Ironov-Oracle , Thank you for your fast reply. The first solution is indeed a mind-blowing one. Thanks a million for your detailed solutions with alternative methods.