Niks Blando-Oracle · Technical Support Engineer · Blue Diamond

Hi @valtir_SuiteGeek, As per checking, the ability to use SQL summary Expressions like SUM is not yet available in the standard NetSuite account. This is currently an enhancement request logged on Enhancement # 536459 SuiteAnalytics Workbook > New Formula field > Allow to use SQL summary Expressions like SUM, COUNT, MAX,…

@Hand Japan Mari Arao , 前のコメントを読まれましたか? まだサポートが必要な場合はお知らせください。 よろしくお願いいたします。

Hi @Rhys Gottwald, As per checking, unfortunately there is no documented alternative solution for this. Apologies for the inconvenience this limitation may be causing you but I hope this helps clarify your concern.

Hi @Toanne Termeer, Can you please share the steps to reproduce this? Also, if you have existing picking strategies kindly send screenshots too. Be reminded to redact any sensitive information before doing so. Thank you!

@Hand Japan Mari Arao, 手持ち在庫と在庫数量の数値を比較するレポートが必要という意味で合っていますか。

Hello, everyone! We invite you to join the conversation and share your valuable insights with us. -- In case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is specifically designed to offer them information and guidance and help them make the…

Hello, everyone! We invite you to join the conversation and share your valuable insights with us. -- In case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is specifically designed to offer them information and guidance and help them make the…

Hi @Bee Yook, Other members commented and left insightful suggestions, let us know if you need further help on this.

Hi @valtir_SuiteGeek, This is the separated thread I created on your behalf. Can you give more information as what you were trying to do in your formula?

Hi @Benjamin Paul - USA, As per checking, I was not able to find a standard NetSuite report that will replicate Demand Planning or a way to fully replicate it through saved search. Without Demand Planning enabled it limits the ability of the system to accurately forecast items' demand. For other users, kindly comment in…

Hello, everyone! We invite you to join the conversation and share your valuable insights with us. -- In case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is specifically designed to offer them information and guidance and help them make the…

Hello, everyone! We invite you to join the conversation and share your valuable insights with us. -- In case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is specifically designed to offer them information and guidance and help them make the…

Hello, everyone! We invite you to join the conversation and share your valuable insights with us. -- In case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is specifically designed to offer them information and guidance and help them make the…

Hello, everyone! We invite you to join the conversation and share your valuable insights with us. -- In case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is specifically designed to offer them information and guidance and help them make the…

Hi @valtir_SuiteGeek , Also for more information about Case When formula you can check below related SuiteAnswers article: SAID: 87164 Advanced Sample Formula Fields Hope this helps. @MTL_MIA, thank you for sharing your insight on this!

Hi @Benjamin Paul - USA, Thank you for explaining further, seems like Demand Planning could help with this use case. See below related comment for reference: https://community.oracle.com/netsuite/english/discussion/comment/16844017#Comment_16844017

Hello, everyone! We invite you to join the conversation and share your valuable insights with us. -- In case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is specifically designed to offer them information and guidance and help them make the…

Hello, everyone! We invite you to join the conversation and share your valuable insights with us. -- In case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is specifically designed to offer them information and guidance and help them make the…

Hi @User_2I30C, Have you seen my previous comment? Let us know if you need further help on this.

Hi @JK415, Have you seen my previous comment? Let us know if you need further help on this.

Hi @User_2I30C, Have you tried clearing cache and trying to reload the Item record again? If yes, and it still shows blank on Quantity On Hand but has a value in Quantity Available, this could be a possible defect, and would require opening a case to further investigate. If you need assistance with this process, please let…

Hello, everyone! We invite you to join the conversation and share your valuable insights with us. -- In case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is specifically designed to offer them information and guidance and help them make the…

Hello, everyone! We invite you to join the conversation and share your valuable insights with us. -- In case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is specifically designed to offer them information and guidance and help them make the…

Hi @JK415, These items that get directly shipped to customers from suppliers are called Drop Ship Items. In order to check how NetSuite treat these items you can check below related articles: SuiteAnswersID: 28180 Drop Ship Items SuiteAnswers ID: 28213 Selling a Drop Ship Item SuiteAnswers ID: 28188 Fulfill and Receive…

Hi @User283824, As per checking, it appears that these are not possible to do through standard features. However, I found the following related enhancement requests: Enhancement#194423 Allow the option to print automatically the picking ticket on the back ordered items when receiving them. Enhacement#131699 Transaction >…

Hi @User_2I30C, To ensure proper tracking, I’ve created a separate thread on your behalf. Please refer to the new thread for updates. https://community.oracle.com/netsuite/english/discussion/4504586/available-quantity-greater-than-on-hand-and-bin-on-hand-and-available

Hi @User_2I30C, This is a separate thread I created on your behalf from Create a search.

Hi @Benjamin Paul - USA, Following up on the above requested details. Thank you!

Hi @Fabss, Have you seen my previous comment? Let us know if you need further help on this. Thank you!

Hi @JK415, Thank you for sharing your feedback. We truly value your insights, as they play a key role in helping us enhance our sessions to better meet the needs of our participants. Rest assured, we’ll be carefully reviewing your suggestions.