There are a few ways to find out which NetSuite bins are in a business’ system, which need to be kept, and which can be deleted. Users can build saved searches to determine which bin with stock at a particular location should become the primary bin and which bin should be made inactive. This will display bin-level information where there may be multiple bins at the same location for the same item.

This information helps the warehouse or inventory managers to consistently review data and take necessary actions with regards to bin management.

Starting with an ITEM based saved search, within the criteria, add filters such as item is active, consider bins with on hand quantity greater than zero (this way zero stock bins do not show in this saved search, and if required, they can be added or provided as another saved search), and specify which location. To check for all locations, specify all of them.

Criteria for checking NetSuite bins

Item.Inactive is false

BinOnHand.OnHand is greater than zero

BinOnHand.Location is NYC,LASVEGAS

Analyzing the results

Name – Item number/name

BinOnhand.Binnumber

binONhand.location

binOnHand.available

binONHand.OnHand

Next, create a formula field that checks what needs to be done with the bin.

(case when (({binonhand.location} = ‘NYC’ OR {binonhand.location} = ‘LASVEGAS’) ) then

(case when (nvl(DENSE_RANK() OVER (PARTITION BY {internalid},{binonhand.location}

ORDER BY {binonhand.quantityonhand} desc, {binonhand.binnumber} desc) ,0) = 1 OR {binonhand.quantityonhand} > 0) THEN ‘RETAIN’ ELSE ‘EMPTY’ END) else ‘RETAIN’ END

)

Explaining the formula to check NetSuite bins

This formula checks if the location is NYC or LASVEGAS, but it can be adjusted to check for all locations. After this, the next condition uses itemInternalId and binOnHandLocation to find out whether the bins have stock, and if there is no stock, whether it should be kept or not.

The DENSE_RANK and PARTITION BY are similar to ORACLE functions and will help to determine the condition. There may be other conditions checked here, such as a condition to find out how many items are in the same Bin. This also could help some inventory managers determine whether or not to keep bin. Below is the formula for this condition.

(count/* comment */({internalid}) OVER(PARTITION BY {binonhand.binnumber}))

Additionally, some inventory managers may want to keep the bin as required even though there is no stock by identifying it as a preferred bin. The preferred bin is a Boolean value that is available within binNumber.

NetSuite support provided by Citrin Cooperman

Citrin Cooperman’s Digital Services Practice can help ensure that your business is getting the most out of its NetSuite investment. To learn more about how our team’s NetSuite support services can help increase your company’s efficiency and achieve its strategic objectives, reach out to your Citrin Cooperman advisor or sales@citrincooperman.com.