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:
...
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
...