One of the goals when using ConnectSx is to maintain an accurate record of your inventory data as a living, ever-changing database. This can be difficult when there are many moving pieces and, at times, inventory counts can become inaccurate. In these cases its good to do regular inventory audits or cycle counts to verify the inventory you have in the field or in your warehouse. These are the steps for processing a cycle count in ConnectSx and making sure it stays accurate with any other warehouse management system or ERP.
Create a Cycle Count Worksheet
Navigate to your inventory screen in the console.
Apply search filters for the inventory to be counted in this batch (by lot, custody, UDI, etc.)
Click the “Export Inventory” button and select “Stock export of Inventory in the current search query only”
When notified download the export document
Open the export document and add a column next to “Quantity” and title it “Quantity Counted” or “Actual Count” (Whatever terminology suits your needs). This empty column will be where the new count is recorded.
First - Cycle count tips:
Make sure you’re counting by Item Number and Lot Number, rather than just Item Number. This way you’ll know which Lots to add or remove from your inventory counts.
We recommend that you execute and process your cycle counts one location at a time to maintain the accuracy of your data and consistency of your updates.
Always good to double or triple check your counts for accuracy, especially when there are deviations from your previous inventory counts.
We recommend that you collect the data in a similar way to the data below. Noting the item number, lot number, old count, new count, and the difference between the two (New Counts minus Old Counts).
The Difference column will tell you how many of each Item Number/Lot combination need to be removed from the system.
If you are also manually maintaining another inventory management system, such as an ERP or an Excel spreadsheet, we recommend executing the quantity corrections in your other system in real time alongside ConnectSx to ensure the systems stay in-sync with each other.
Example: Warehouse #10291 Cycle Counts (12/19/19)
Item Number | Lot Number | Old Count | New Count | Difference | Custody |
100001 | 189283 | 20 | 19 | -1 | ORG WHSE |
100001 | 123984 | 100 | 100 | 0 | Sales Rep 1 |
100002 | 182123 | 74 | 77 | 3 | Sales Rep 2 |
200008 | 714512 | 348 | 340 | -8 | ORG WHSE |
Second - Adding to your Inventory
To increment a quantity of an item in ConnectSx, you can navigate to the Inventory Tab and click on “Add Inventory”.
Enter the relevant details for your inventory - required fields include: item number, manufacturer, description, product line, and quantity.
Make sure you’re entering the DIFFERENCE - this action will add exactly the number of items that you enter in the quantity field.
Once complete click “save” and your item(s) will be added to your inventory.
Alternatively, if you have many changes to make, you might prefer to enter your data into a spreadsheet and import it. In that case, please reference the section on importing inventory in the ConnectSx Knowledge Base.
Third - Removing Items from your Inventory
To remove items from your inventory the items will need to be deactivated and there are three possible ways to accomplish this:
Find the item using inventory search and enter its detail page. Click on the “Deactivate” button. The item will be made inactive and will be effectively removed from your inventory.
2. You may create a container with a title such as “Cycle Counts 12-19-19”, then add all of the items that you need to remove to this container. Then enter the container’s detail screen and click on the “Deactivate” button. The container and all of the items it holds will be made inactive and effectively removed from your inventory.
3. You may create an Event with a title such as “Cycle Counts 12-19-19”. Then mark all of the devices that you need to remove with a status of “missing”. When you close the event the items you have added will be made inactive and will be effectively removed from your inventory, but their records will continue to bear the “missing” status. For more information on how to move through the Events workflow, please see the section in the knowledge base.