警惕id比较大小存在bug
看到一段代码用id大小比较两条记录的创建时间，结果出现了一些bug。 本意是筛掉38这个情况，但是因为字符串在js中比较大小并不是比较其数字的大小，而是逐字符比较数字的编码大小。 这种情况应该parseInt转换成numeric的类型再比较大小
Print Icon WILL Trigger User Event!
Never thought clicking Print icon on a record to get the pdf WILL fire record’s user event. This is very new to me In this example, when print the record where the user event script like above is deployed to will fire the function getAmountChinese and the field custbody_total_amount_text will become available for the Advanced... » read more
error.SuiteScriptError:MODULE_DOES_NOT_EXIST 模块不存在：/NLRecordScripting.scriptInit$sys.js
Scenario form.clientScriptFilePath is used in User Event for loading a client script under record view event. The error occurs when view event is fired. Steps to Locate the Bug the file path is correct, which is proven by referencing the client script file in define[] without a problem set the file path to a wrong... » read more
Error Code 406 When Request an OAuth2 Token from External 请求外部的OAuth2令牌得到代码406
In my case, I put Accept type into the request Header and it does work. Code snippet with pseudo data: Welcome to share your situation and solution. For more info about Header https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/Accept 我在http请求的Header中添加了Accept的类型，一切就正常了。 含有瞎编信息的代码如下： 如果你有其它解决方案也可以分享。 关于Header的帮助主题 https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/Accept
VALID_LINE_ITEM_REQD when transform from Sales Order to Item Fulfillment
You must have at least one valid line item for this transaction error will stop us from creating an item fulfillment from a sales order at the stage of record.transform() if we did not specify an inventoryLocation in the defaultValue parameter. Here is a working suitelet code which creates an item fulfillment via record.transform(). You... » read more
SSS_INVALID_SRCH_OPERATOR But Search Is Not Stopped 报SSS_INVALID_SRCH_OPERATOR但是搜索没有被终止
In some scenarios, you may find a search does throw an Invalid Search Operator error but NetSuite executes the search and returns the result. You may just want to let it go as long as it works, but we can make it work flawlessly. 有时候视图会返回一个nlobjSearchFilter包含无效操作者，或语法不正确错误，但是视图还是正常返回了结果。你可能觉得能用就行，但是我们还是可以做更好一点。 It’s very likely that an anyof operator is used but... » read more
SuiteScriptError, name: LINKED_ITEMS_DONT_MATCH, message: Linked items don’t match
Eng This error pops up when you are creating an item receipt record from a purchase order and trying to set different item id to a item sublist line. Let me explain it with an example: Purchase order JNPO#0001 has been created as below line item ID quantity rate 0 1000 10 $5.00 1 1001... » read more
MODULE_DOES_NOT_EXIST for Custom SuiteScript Lib
The error could be caused by many problems and I think I just found a niche one. Scope The finding is just for non-AMD situations, where @NAmdConfig is not used and only the routes to the library files are referenced in the define([]) #1 Did you miss .js in the file name? Credit to this... » read more
Customer Payment记录类型UNDEPOSITED FUNDS字段的bug
当用SuiteScript操作customer payment记录的时候，选择isDynamic=true，此时如果输入了科目(account)字段的值，UNDEPOSITED FUNDS就会被取消，然后科目旁边的radio button会被选中。但是当某些逻辑需要反转选项，把account设置为空，UNDEPOSITED FUNDS这个radio button却不会被选中。 这种情况下尝试rec.setValue({fieldId: "undepfunds", value: true})是无效的，会提示You have entered an Invalid Field Value true for the following field: undepfunds 正确的方法是！ 这个bug很明显来自SuiteScript不能很好兼容radio button
Saved Search多个formula结果字段产生bug及应对
之前做过几个项目都有saved search中使用formula搜索结果列的情况，个人感觉当同一个类型的formula结果列出现多次但formula的内容不一样的情况下很容易产生bug。 今日的例子中，在对于invoice的搜索中我使用了如下的searchColumn，对应结果中的formulacurrency和formulacurrency_1 搜索结果反馈是正常的。之后我添加了两个搜索列，对应结果中的formulacurrency_2和formulacurrency_3 问题来了：用于显示结果的suitelet上，4个列返回的数字是一样的，返回的都是133.14，明显不正确；但log显示的结果是正确的，如下： 这种情况下因为上面代码中formulacurrency_2和formulacurrency_3公式比较简单，可以直接使用字段进行搜索，避免formulacurrency的使用，即可避免问题 此时返回结果是正确的 问题得以解决。 如果更复杂的情况确实需要多个formula的情况呢，这种情况可以考虑把searchResult当作JSON进行处理，直接用Object[key]的方式取值。不过这种情况需要考虑未来SuiteScript更改返回结果结构的情况，方案可能随时失效。 暂时没有用过N/query处理过类似情况，如果有人做过也可以来说说。