Ivy Lopez-Oracle · SCM Guru · Red Diamond

Hi @Martha Hakes, Per the documentation in SuiteAnswers 70249: After you save the Global Inventory Relationship record, you can change which locations are listed here. Changes will affect only future sales orders you enter. About your other question on customers and subsidiaries, I found this documentation in SuiteAnswers…

Hi @User_6YD5L, 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, can you clarify if you are pertaining to WMS Mobile or NetSuite Mobile App? If any other members have any thoughts, insights, or…

Hi @ONO4, 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_J6WYT, 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, can you try using the Internal ID of the vendor instead of the name? If any other members have any thoughts, insights, or…

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.