Cycle Count in NetSuite

Receive Updates On LinkedIn

img

One of our US-based clients is a leading distributor and servicer of products used in the electrical and mechanical infrastructure applications. They deal with strut channel, cable trays, fittings, and related products. Their products find use in power plants, data centers, solar farms, and industrial construction.   

Their vast inventory includes hard-to-find items and finishes like hot-dipped galvanized, stainless steel, and aluminum. They offer competitive pricing along with a helpful and knowledgeable sales team.

 

 

Requirement

Our client has a lot of items in their inventory. They wanted to count only the backordered items. Stock levels of those goods have to fall to zero from the prior day’s sales orders. The client did not add items manually on the inventory count page which are under the above conditions.  

They wanted the system to automatically add those items to the inventory count page under the conditions mentioned above.   

 

 

Solution

In order to achieve the goal, our developers use an item search and determine the backorder count of the items through their location. If an item is back-ordered and the stock level falls to zero, those items are transported to the inventory count location 

In the inventory count record, under the item subtab, they have added a button labelled “add items.” The client has to click on the “Add items” button. Duplicate items are not added. The user has to manually select the other items.    

Risk

Our developers experienced certain hurdles. If the saved search results are higher in the list, the process will be slower. NetSuite will display a warning message if an item is already part of another inventory count record. And one cannot add it to the sub list.  

Result

Our developers attained the requirements successfully. They were able to create an inventory count and they added a button called “add items.” When you click the button, the add list displays the Items 

Transform your business with Jobin & Jismi’s top-of-the-line Netsuite Customization Services. Contact us at contactus@jobinandjismi.com to schedule a consultation.