megaphone
SuiteWorld 2026の登録が開始されました。今なら300ドル節約できます。 今すぐ登録しましょう

プロフィール
Avatar
ロック解除可能なバッジを表示 ロック解除可能なバッジを表示
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.

Bee Yook Blue Ribbon

コメント

  • Hi, @Mikko De La Fuente-Oracle, Thanks for your advise. I know how to use trim() in saved search but how to apply it in script ? I not understand the statement in the script.. where to put the trim in .. Is it under variable like below ? var poNum = checkStr(nlapiGetFieldValue(trim('otherrefnum'))); Or…
    で Script with PO reference number with space Bee Yookによるコメント Jun 27, 2022 12:58AM
  • Hi @Joy Noreen Magoling - Oracle-Oracle, Thank you very much for your explaination. Yes, you are right! I have raised a case and they attached my case to the same defect number. Once again, thanks. Best Regards, Bee Yook.
    で Trend Graph (daily) in dashboard Bee Yookによるコメント Mar 28, 2022 12:39AM
  • @ Kristoffer Viray-Oracle , Thank you to you too . I just noticed after 3pm (malaysia time), Pacific time is 12am, the trend graph show the figure for 24 Mar 2022 (today), i guess this is time zone issue.. is anyone know where i can set for this time zone for trend graph ? currently, we set our time zone as (GMT+0:00)…
    で Trend Graph (daily) in dashboard Bee Yookによるコメント Mar 24, 2022 7:36AM
  • Dear Mikko, Thanks for your valuable advice. Yes, i tried below command but it's still didnt shown malaysia time. TO_CHAR(TO_TIMESTAMP_TZ(TO_CHAR({createddate},'MM/DD/YYYY HH24:MI:SS'), 'MM/DD/YYYY HH24:MI:SS TZH'), 'MM/DD/YYYY HH24:MI:SS TZH:TZM') Could you please advise what will be the correct formula for this…
    で AE:How to convert GMT to Malaysia time zone Bee Yookによるコメント Dec 7, 2021 7:06AM
  • Dear Ivy, Thank you so much for your hints. Yes, you are right, found there are records with WSA-20210326A20210327 instead of WSA-20210326-20210327.. that cause the error.. Once again, thank you very much.. it really helped. Kind regards, Bee Yook
    で Convert String to date in saved search Bee Yookによるコメント Nov 10, 2021 5:37AM
  • Dear Ivy, Thank you for your quick replied. For Formula(Text), it working fine. However Formula(date), it shown the following error or as attached: "An unexpected error has occurred. Please click here to notify support and provide your contact information." Yes, you are right, the actual fieldname is "inventorynumber".…
    で Convert String to date in saved search Bee Yookによるコメント Nov 10, 2021 2:23AM