Hi @"MSStoke", May I ask what enhancement have you found? I found an enhancement ( Enhancement # 116311 - Permissions > Would like the Department, Class, and Location restriction fields on the Role to also restrict Cases like they do for transactional records ) related to your concern. The suggested workaround is to use…

Hi @"Mr Rob", May I know if there was an error you received? If yes, what was it? It seems that the reason why the second code snippet does not work is because you are throwing 4 parameters(url,headers,body,credentials) for the https.post function. Based on the document(https.post(option)) it only has 3…

Hi @"ssilveri777", May I ask what saved search are you using? One reason that you are receiving this kind of error is because the name 'internalid' used is not the internal Id for number. See sample below for Internal Id vs Internal Id(Number) of Customer Saved Search: Internal ID Internal Id(Number) I suggest to change…

Hi @"PaulFleetwood", This has been reported before and it will be considered as a candidate for Future major release. This is the information related to your concern: Defect # 309705 - Name field's last name box is misaligned or falling off and not within the same row or line of First and Middle Name box. If you want to be…

Hi @"gmihaylov", The ability to update the external id to null is not yet supported by the system. There is an enhancement field regarding this functionality (Enhancement # 160343 - WS | CSV | SS - Ability to update external ID to blank/null). What we could suggest is to log a support case to add an additional vote for the…

Hi @"4014555", Please be reminded that Schema Browser is used for "SuiteTalk/Web Services" and not for ODBC. Connect Browser is the one used for ODBC. After checking the Connect Browser, it seems that the field Consolidated Overdue Balance is not yet exposed. What I could suggest for you is to create a case to support so…

Hi @"GKC", Search.Type cannot be an array since as per documentation, the parameter type requires a "String" data type and not an array. You could see it in the SuiteAnswers Article search.create(options) (id: 44081). -Mikko @"Mikko De La Fuente-Oracle"

Hi New_44789, There is actually an enhancement related to your concern. This is the information "Enhancement # 280716 - List>Relationships>Project Templates: Project template should have Standard fields the same as a regular Project Record". The alternate solution suggested was to "Copy existing Project". You could cast a…

Hi @"plantscan", Have you tried using "to_number" for your conversion? This function is an alternative way to convert data type instead of using CONVERT or CAST function. You may refer to SuiteAnswers Article SQL Compliance Id( 36406) for additional information. -Mikko @"Mikko De La Fuente-Oracle"

No worries, Zoran. I do understand you, sometimes SuiteAnswers are a little bit tricky and need some tweaking but we are here to help you figure it out. I am glad that it helped you with your concern. -Mikko @"Mikko De La Fuente-Oracle"

Here is a sample script: (I have tested this on my test account and using scheduled script) /** * @NApiVersion 2.x * @NScriptType ScheduledScript */ define(['N/xml','N/file'], function(xml,file) { function execute(scriptContext) { //If the XML is completely empty, the file may not be loaded properly, //you may still create…

Hi @"Marc Gipple", The functionality of adding invoice status on the column in the income statement details report is not yet available in the system. There is a related enhancement with regards to this. Enhancement # 165316 Reports > Financial > Income Statement > click an account to View Detail Report > On the Income…

Hi New_44789, Employee Center is almost out of the box NetSuite center, however, you could customize it in a limited extent. You could follow this SuiteAnswers Article Employee Center Dashboard Publishing (Id: 70197) on how you could customize it. On the other hand, adding custom portlet is still an enhancement (257643…

Hi @"Marlene Leivers", Could you provide a sample screenshot of the field you have mentioned? Also, could you check if the "Same row as previous" is checked for that field? One factor that a field cannot be moved is because the option "Same row as previous" is checked. Please take note also that standard and custom fields…

Hi @"Rob Leij", Have you tried contacting Celigo(they are the bundle owner) about the bundle you want to install? It seems that this is a dependent bundle and they are the ones who know the bundle well. -Mikko @"Mikko De La Fuente-Oracle"

Hi @"Lincecum_41340", May I ask the following questions to better understand your concern: * What record/s is/are affected? * Have you tried pulling the data via Saved Search and what is the result? * Are there any scripts/workflows running on the affected record/s? * Is the column/field standard or custom? A sample…

Hi @"Jyothi R", May I ask the following questions for better understanding on your concern: * What are you trying to accomplish? (E.g adding Expense Report to NetSuite via Integration(Expensify)) Could you elaborate more the use case? * What integration method are you using? (E.g Web Services/RESTlet)? Possible factor for…

Hi @"DONALD FERNANDES", May I ask what is the criteria you are talking about or what will be needed before the purchase order automatically close? -Mikko @"Mikko De La Fuente-Oracle"

Hi @"eleran", It seems that your concern is related to the Enhancement # 58714 - Please provide the ability to have our Fulfillment screen directly link to a UPS scale to determine more exact weight. What I could suggest to you is to create a case to add an additional vote for the enhancement or you could visit the…

Hi @"Zoran Roncevic", The information you provided is for appending a node after the last child node of a specific element node. If you want to create an XML document, I suggest to start by creating a file with XMLDOC type. You could refer to the SuiteAnswers Article file.create(options) (Id: 43525). Please note that in…

Hi @"Dejero", Unfortunately, it is not yet available to print MICR line on blank check stock using native NetSuite functionality. However, we advise you to use the check that has this readily available. You could take a look on the available forms, here is the link https://www.netsuiteforms.com/checks. -Mikko @"Mikko De La…

Hi @"lilywu", If you are familiar with scripting, I suggest you could create a User Event Script and use the context "Edit" so that the script will only execute after the record was created and saved / in edit mode only. Use the Field Method "updateDisplayType" to change the field from normal to disabled/inline or what you…

Hi @"3968939", May I ask the following questions: * What saved search are you using? * What type of formula? (E.g text,numeric,etc) I tried your syntax on formula(text) type but different fields and I did not receive the error. Trying the same syntax on a formula(numeric), I received the error "ERROR: Invalid Expression".…

Hi @"rprice", Could you try the following query and check if the results are what you are looking for: * SELECT * FROM OA_COLUMNS WHERE COLUMN_NAME = 'record_type_id' The SuiteAnswers Articles below may help you find the answer to your question: * Get the Meta Data of ODBC fields to verify the field type and field lengths…

Hi @"isweeney", Upon checking on our end, I found a related enhancement regarding your concern. The enhancement is all about adding the ability to display field for Last Run On or when was the saved search last executed. You could vote for the enhancement # 267919 List > Search > Saved Searches > New > Select Saved Search…

Try this one: /** * @NApiVersion 2.x * @NScriptType Portlet */ define(['N/search'], function(search) { function render(params) { var portlet = params.portlet; portlet.title = "MicroFab Select Inventory List"; portlet.addColumn({ id: 'Part Number', type: 'text', label: 'Part Number', align: 'LEFT' }); portlet.addColumn({…

Hi @"John Griffin", Upon checking your script, the "return" is inside the function "render", try placing the "return" outside the render function. I tested this on my test account and it works. I have successfully uploaded your script. Let me know if this helps. -Mikko @"Mikko De La Fuente-Oracle"

I think there is no similar function like getValue(column) on n/query module. What I can suggest to you is to manipulate the result from the ResultSet of the n/query module. E.g you could create a loop function for the results so that you could catch the specific column that you needed. I hope this helps. -Mikko @"Mikko De…

Hi @"3968939", Have you tried exploring the idea provided in this SuiteAnswers Article: * Add Border Lines on the Sides of the Table in Advanced PDF/HTML Template (Id: 74420) I hope this helps. -Mikko @"Mikko De La Fuente-Oracle"

Hi @"KeyAcumen", It seems that there is limited documentation regarding existing API that uses SIC/NAIC to add code/industry to a static field in NetSuite's CRM. On the other hand, is creating Custom Field will suffice your concern? If you are not familiar with creating Custom Field, you could follow this SuiteAnswers…