Jervin Nicholas Teopengco-Oracle · SuiteBuilder · Silver Crown

Hi @nir.levy, Good day! Would you be able to elaborate more on your question? Thanks!

Hi @User_ZI55R, Good day! Sending a follow up on this in case you haven't read my previous reply. Thanks!

Hi @Adam W, Good day! Sending a follow up on this in case you haven't read our previous reply. Thanks!

Hi @User_EPWHS, Thank you for clarifying. With that said, then yes. Your suggested workaround would be possible. However, you would need to create a Custom Script that runs on Purchase Orders that will execute whenever the transaction is saved then have the script set the values of the Custom Field found in the Item…

Greetings, everyone! We have a fellow member, @CDuf, who could use our assistance. Please don't hesitate to share your knowledge and best practices to help them out. Your input is highly valued and appreciated! __ In the meantime, in case you know someone who is new to NetSuite, we encourage you to direct them to our newly…

Greetings, everyone! We have a fellow member, @Vernita, who could use our assistance. Please don't hesitate to share your knowledge and best practices to help them out. Your input is highly valued and appreciated! __ In the meantime, in case you know someone who is new to NetSuite, we encourage you to direct them to our…

Hi @Adam W, My apologies for the late revert on this. I would like to confirm if your Workflow is running on the Assembly Builds as well? On my test account, I've tried adding the {id} in the of the body of the Send Email Action as seen below: Results: It fetched the Id of the Assemby Build transaction successfully upon…

Hi @User_FTSNP, Would you be able to check on the scheduled_bulk_inventory_update script? This can be found via Customization > Scripting > Scripts Once you've navigated to the script, would be able to share what's on Line 21 of the code? So that we could check what might be causing the error. Thanks!

Hi @User_ZI55R, Good day! Would you be able to send screenshots of the other States as well? So that we could check how the Next Approver field is being set. Thanks!

Hi @User_EPWHS, My apologies, I misunderstood that the Custom Field should be specifically for the Order Items page only which is why I've mentioned that Enhancement. But yes, you can use Custom Item Fields as additional filters on the Order Items page However, since the Custom Field (with Store Value checked) will be in…

Hi @User_FTSNP, Good day! We would like to confirm if the script you've mentioned is from any bundles? Thanks!

Hi @Adam W, You're welcome! Neat formula to have it rounded to two decimal places! 😁

Hi @CDuf, Good day! Sending a follow up on this in case you haven't read my previous reply. Thanks!

Greetings, everyone! We have a fellow member, @User_30DPK, who could use our assistance. Please don't hesitate to share your knowledge and best practices to help them out. Your input is highly valued and appreciated! _ In the meantime, in case you know someone who is new to NetSuite, we encourage you to direct them to our…

Hi @Adam W, Yes. It should do the math and display it on your Custom Field. Please do note: Make sure you don't have anything stored in the field before unchecking the Store Value as you may lose data. Also, would you be able confirm which record these fields are on? So that I could try to replicate this in our test…

Hi @Adam W, Good day! Upon further checking on your screenshot, the Store Value field is checked. Meaning, the formula in the Default Value field would not work. Unless, the record is newly created and the fields in the formula already has values before the record loads. With this, we recommend you to uncheck the Store…

Hi @CDuf, Good day! I would like to confirm if this is what you've wanted to achieve? SELECT * FROM systemnote sn JOIN CUSTOMRECORD339 cr ON sn.recordid = cr.recordid WHERE sn.recordtypeid = 339 AND sn.recordid = cr.recordid ORDER BY cr.recordid; Note: 339 is the internal ID of the Custom Record. Results: How it looks in…

こんにちは @Miyu。 残念ながら、フィールド・グループをデフォルトで縮小に設定することは、現在システム制限です。また、これに関連する機能改善は作成されておりません。 ですので、新しいSuiteIdeaとして提出することをお薦めします。 詳細は、次のリンクにアクセスしてください: https://suiteanswers.custhelp.com/app/answers/detail/a_id/10054/kw/10054] 本システムの制限についてご理解の程よろしくお願いいたします。

Hi @Adam W, Good day! Can this be done manually? If yes, would be able to provide the steps on how to? So that I could try if this would be possible via Workflow. Thanks!

Hi @Karanjot Singh, Good day! Sending a follow up on this in case you haven't read our previous reply. Thanks!

Greetings, everyone! We have a fellow member, @User_DU7YV, who could use our assistance. Please don't hesitate to share your knowledge and best practices to help them out. Your input is highly valued and appreciated! __ In the meantime, in case you know someone who is new to NetSuite, we encourage you to direct them to our…

Hi @Karanjot Singh, Good day! Yes this is possible via Workflow. Please see the Workflow Action below: Workflow Action: Type: Set field Display Type Trigger On: Before Record Load Body: Checked Field: Sales Rep Display Type: Inline Condition Section: Field: User Role Compare Type: Any of Selection: <Select your roles here>…

Hi @User_EPWHS, Good day! For the Custom Field on the Item sublist, I would like to confirm if you wanted to automatically display "Yes" when it's in the Pending Approval status then "No" when it's Approved already? As for adding Custom Fields in the Order Items page, this is a current system limitation. I was able to find…

Hi @Grace999991, You're welcome! Great workaround! Thank you for sharing your solution to the community😊

サポートコミュニティへの投稿ありがとうございます。専門の担当者と連携して回答いたします。進捗があり次第、こちらに投稿しますので、少々お待ちください。他のメンバーの皆様も、このスレッドにコメントし、知見を共有したり提案することができます。なお、日本対応チームは平日（月〜金）の午前8時から午後6時まで対応しております。よろしくお願いいたします。

Hi @Grace999991, No worries! Upon further checking, it seems like it's only returning boolean values. That said, I would like to confirm if creating a Custom Field for this would be feasible on your end? Here's what I've done on my end: Custom Entity Field: Type: Free-Form Text Store Value: Unchecked Validation &…

Hi @Honey Soe, Have you tried using the ${nsformat_currency()} method? Here's an example below: <td align="right" colspan="4">${nsformat_currency(item.quantity * item.rate)}</td> Results: The field was displayed in the currency format. I hope this helps! 😊 __ If you find this reply to your question as helpful, others with…

Hi @Grace999991, Good day! On my test account, I've created a User Event script with the following code below: const beforeLoad = (scriptContext) => { var custRec = scriptContext.newRecord var creditHoldField = custRec.getValue('creditholdoverride') log.debug('Hold field', creditHoldField) } With this, I was able to get…

Hi @User_ER7E1, Good day! Sending a follow up on this in case you haven't read my previous reply. Thanks!

Hi @User_XXTWN, Good day! Upon further checking, this is a current limitation and I was able to find a related enhancement for this. This is logged and being tracked under Enhancement 109779 Address: Ability to create custom column fields to Adressbook sublist You can vote for this enhancement on the SuiteIdeas page. At…