Ivy Lopez-Oracle · SCM Guru · Red Diamond

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.

Hi @Erica 4apps, Thanks for reaching out to us in the NetSuite Support Community. Our gurus @Patrick Fresnosa-Oracle and @Clarisa De Torres-Oracle 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…

Hi @Gert Van Damme, 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_2D608, Can you check if the Enable Item Line Shipping checkbox is marked on the order form? Based on my tests, if this is marked, some fields under the Shipping tab are removed because the shipping address is to be set in the item lines:

Hi @FazeprooF, Can you check the WMS System Rule “Enable Tally Scan?" and set the Rule Value from Y to N. Rule Value: N Process Type: Smart Count Apply Rule To: CycleCount If you have setup this rule for multiple locations, you need to do it to all the Enable Tally Scan? rules.

Hi @Gab JS, Is there only 1 result when you run the search? If so, then make sure that the Show List When Only One Result preference is enabled on your account. You can check this under Home > Set Preferences > Analytics tab.

Hi @brocha, 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 check your question and they'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or…

Hi @User_XMFHV, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Patrick Fresnosa-Oracle and @Clarisa De Torres-Oracle to check your question and they'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage…

Hi @ssilveri777, 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 @Dext3r, You can check the Related Records tab to see the related Item Fulfillments or Item Receipts of the Transfer Order.

Hi @eleran, Using Reorder Multiple works when you create Purchase Orders via the Order Items page. Per checking, having Minimum Purchase Quantity is still an enhancement in the system and is logged as: Enhancement # 15463 : Item > To be able to set a minimum quantity for orders and for Vendors However, this might be…