Hi Ken Zhang-Oracle, Thank you for posting your email concern here! Let our gurus check and see what they can do to help! To other's who may have some insight, please feel free interact in this thread!

Hello Kedalene, Glad to have you with us today! Thanks for posting your concern here. Kindly allow our gurus some time to check this one for you and we will get back to you with our findings. To our members, please feel free to share your thoughts on the thread.

Hi Meherin, Try this one below instead: This is the formula: sum(case when {accounttype} = 'Income' then {amount} else 0 end - case when {accounttype} = 'Cost of Goods Sold' then {amount} else 0 end) / NULLIF(sum(case when {accounttype} = 'Income' then {amount} end),0)

Hi @Sharon Hirsc, Kindly check @JohnCirocco 's comment and let me know if it helps. @JohnCirocco thank you for sharing your insight regarding this matter!

Hi Miki M-Oracle, Can you please provide screenshot on how the web query does not work? Please make sure to redact any sensitive information.

Hi Miki M-Oracle, As per SuiteAnswers ID 7843, the est gross profit is computed as: Read-only field that equals the revenue amount minus the Est. Cost. At the header level, it equals the gross profit of all lines, factoring in transaction-level discounts and markups.

Hi Meherin, I think I found what was causing the issue, there were hidden characters in the formulas in the SuiteAnswers article. There were U+200C characters after the first { of the field ids. It is unclear what caused this but I would suggest leaving a feedback in the SuiteAnswers article so that this can be corrected.…

Hello Hendrik Kotze, Glad to have you with us today! Thank you for creating this thread. Kindly allow us to review your concern and we'll provide updates in this thread. To our other members, please feel free to share your thoughts regarding this should you have any.

Hello Mark Derrick, Thank you for creating this thread! Allow our gurus to check on this one and we'll get back to you with updates or if we need additional information. To other users who may have insights regarding this topic, feel free to add your comments by replying to this thread.

Hi tech work. I think this thread is a duplicate of the one below. My colleague is already working on you other thread. It is better that you wait for her testing results. Thanks!

Hi FazeprooF, As per checking my resources, I did not see any documentation that would achieve this functionality. As there is no standard feature to achieve this, you may reach out to your Account Manager as this may be consulted for customization with the Professional Services team/Advanced Customer Support team. I hope…

Hello PaulFleetwood, Glad to have you with us today! Thanks for posting your concern here. Kindly allow our gurus some time to check this one for you and we will get back to you with our findings. To our members, please feel free to share your thoughts on the thread.

Hi Mathias_Netsuite, Thank you for posting your email concern here! Let our gurus check and see what they can do to help! To other's who may have some insight, please feel free interact in this thread!

Hello Mathias_Netsuite, Glad to have you with us today! Thank you for creating this thread. Kindly allow us to review your concern and we'll provide updates in this thread. To our other members, please feel free to share your thoughts regarding this should you have any.

Hello Dext3r, Thank you for creating this thread! Allow our gurus to check on this one and we'll get back to you with updates or if we need additional information. To other users who may have insights regarding this topic, feel free to add your comments by replying to this thread.

Hello User_KDHIR, Thank you for creating this thread! The ability to only show/automatically populate the preferred bin on Sales Orders is not yet available in the standard NetSuite account. This is currently an enhancement request logged on Enhancement # 166522: Setup > Customization > Transaction Forms > Custom Sales…

Hello User_IJB6M, Glad to have you with us today! Thanks for posting your concern here. Kindly allow our gurus some time to check this one for you and we will get back to you with our findings. To our members, please feel free to share your thoughts on the thread.

Hello Edwards_05, Glad to have you with us today! Thanks for posting your concern here. Kindly allow our gurus some time to check this one for you and we will get back to you with our findings. To our members, please feel free to share your thoughts on the thread.

Hello Pradeep Kumar., Glad to have you with us today! Thanks for posting your concern here. Kindly allow our gurus some time to check this one for you and we will get back to you with our findings. To our members, please feel free to share your thoughts on the thread.

Hello Meherin, Can you try this instead? ---Formula (Percentage) | Sum | Round | Formula = SUM((CASE WHEN {accounttype} = 'Income' THEN {amount} ELSE 0 END)-(CASE WHEN {accounttype} = 'Cost of Goods Sold' THEN {amount} ELSE 0 END) / NULLIF(SUM({netamountnotax}),0)

Hi Lea Celosa Columna, I further consulted this to SuitePeople HR managers, they said they don't also have a documentation for this. They advise for you to reach out to your account manager instead.

Hi fonsoposada, That's unfortunate, may I know why it does not work on your concern? As per checking, my resources those articles are usually what users use as an alternative to Inventory Activity Detail Report.

Hello Meherin, Glad to have you with us today! Thank you for creating this thread. Kindly allow us to review your concern and we'll provide updates in this thread. To our other members, please feel free to share your thoughts regarding this should you have any.

Hello User_LUL5V, Thank you for creating this thread! Allow our gurus to check on this one and we'll get back to you with updates or if we need additional information. Meanwhile can you check @GauravAgrawal 's comment? To other users who may have insights regarding this topic, feel free to add your comments by replying to…

Hello Benjamin Paul - USA, Glad to have you with us today! Thanks for posting your concern here. Kindly allow our gurus some time to check this one for you and we will get back to you with our findings. To our members, please feel free to share your thoughts on the thread.

¡Se acabó el tiempo! ✨ La respuesta correcta y su explicación figuran a continuación: Respuesta correcta: C Explicación: Cuando los detalles del depósito en una Orden de Venta no se completan, no afecta la ubicación física ni el depósito físico. Dado que la Orden de venta es una transacción que no se contabiliza o que no…

Time's up, everyone! ✨ Kindly see details below for the correct answer and its explanation: Correct Answer: C Explanation: When Bin details on a Sales Order is not filled out it neither affects the location on hand nor the bin on hand. Since Sales Order is a non-posting or a non-inventory affecting transaction when it is…

Hello Rhys Gottwald, The purpose of the Bin Empty button is that if your warehouse uses bins and the bin has no items, you tap Bin Empty. From there you can process another pick task, or select the same one and pick from another bin. No other process/processes triggered by the button as per checking.

Hello Stephen N, Glad to have you with us today! Thanks for posting your concern here. Kindly allow our gurus some time to check this one for you and we will get back to you with our findings. To our members, please feel free to share your thoughts on the thread.

Hi User_OAY9I, Thank you for posting your email concern here! Let our gurus check and see what they can do to help! To other's who may have some insight, please feel free interact in this thread!