Hi @Mahdy Abdelaziz, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hi @User_WV14V, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. To fast track their investigation, can you share screenshots on how your custom field was set up? Is the Store Value checkbox marked? In the…

Hi @User_E15G4, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hi @NitinEOH, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hi @User_TCHAY, Per checking my resources, it seems that your requirement is not yet available in the system and is currently logged as: Enhancement # 230133 : Advanced Bin/Numbered Inventory Management: CSV Import > To be able to import/indicate serial/lot numbers (Inventory Detail) You can vote for this in the SuiteIdeas…

Hi @manuelsaomartinho, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, let me also tag our members @GauravAgrawal, @Tiru Chembeti, @Brian Stisser, @Tafara & @censys_sl as they might have thoughts,…

Hi @Dylan Moore, Try using {quantityshiprecv} instead of {quantityfulfilled}. I checked in my account and the correct field ID for Quantity Fulfilled is {quantityshiprecv}.

Thanks for providing your insights on this, @censys_sl!

Hi @User_T9O5X, Upon checking, the ability to hide the Custom Price Level and restrict Roles from using the Custom Price Level is currently a system limitation. Also, I have found related Enhancement 51388 User would like to restrict sales roles from using the custom price level that tracks this request. You can vote for…

Hi @FazeprooF, I have reached out internally regarding your concern and one of our Product Managers have confirmed that we cannot completely disable the Tally Scan in Smart Count. However, enabling the 'Allow Manual Count Entry' checkbox will allow the counter to enter the counts manually along with Tally Scan. Since…

Hi @Benjamin Paul - USA, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you. By the way, you…

Hi @User_BDDIP, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you. By the way, you might be…

Hi @User_T9O5X, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you. By the way, you might be…

Hi @User_TCHAY, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you. By the way, you might be…

Hi @Paul Salkeld, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you. By the way, you might…

Hi @Benjamin Paul - USA, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you. By the way, you…

Hi @Rhys Gottwald, Per checking, it seems like your requirement is currently logged as an enhancement: Enhancement # 594588 WMS Mobile > Generate Replenishment > Use Maximum Quantity set in Bins as Maximum Quantity Regardless of Number of Items Associated You can vote for this enhancement, or submit a new one, in the…

Hello @FazeprooF, Per checking my resources on this one, it seems that the WMS Replen Min Qty and WMS Replen Max Qty can be set on the Bin record, but not on the Location record. Per the Warehouse Management Guide: For warehouse locations that use bins, you can replenish inventory at the item level or at the bin level. If…

You're welcome! Glad I could help. 😊

Let's add a ROUND function that encloses the formula. It should look like this: ROUND(SUM(CASE WHEN {account} = '4000 Sales' THEN {amount} ELSE 0 END)/NULLIF(SUM((CASE WHEN {type} = 'Item Fulfillment' THEN {quantity} ELSE 0 END) * ({item.custitem_unitsinasp})),0),2)

Add a NULLIF statement to the divisor to resolve that error. Try this: SUM(CASE WHEN {account} = '4000 Sales' THEN {amount} ELSE 0 END)/NULLIF(SUM((CASE WHEN {type} = 'Item Fulfillment' THEN {quantity} ELSE 0 END) * ({item.custitem_unitsinasp})),0)

Try removing the last closing parenthesis. It's an extra one with no corresponding opening parenthesis. Looking back at this thread, it seems I may have copied and pasted {customfield1) in your previous comment and didn't notice the ) was used instead of }. 😅

Thanks for the update. Let me further check my resources on this and I'll keep you posted.

Hi @FazeprooF, Were you able to test this? Let us know if it worked for you or not, so we can proceed accordingly.

Try: (CASE WHEN {type} = 'Item Fulfillment' THEN {quantity} ELSE 0 END) * {customfield1) OR if you need the summed values: SUM(CASE WHEN {type} = 'Item Fulfillment' THEN {quantity} ELSE 0 END) * SUM({customfield1}) You can also try using MAX instead of SUM to check if that would give the expected result.

Hi @Tybrneryan, Can you try this logic? SUM(formula1here)/SUM(formula2here) Try setting the Summary Type to Maximum or Sum and check if either of these will give you your desired results.

Hi @User_75YL8, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hi @User_ZCWF3, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hi @ImeldaSanchez, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Jack Daryl Espiel-Oracle, @Joahnna Given Uy-Oracle and @Kristoffer Viray-Oracle to take a look at your question and check if it is possible to edit that custom field. Please allow them some time to investigate and get…

Hi @Rhys Gottwald, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.