Page Comparison

...

Auditing field inventory presents a number of challenges, not the least of which is accuracy and investment of time. We’ve found that in cases of counting localized inventories, as well as auditing warehouse assets, barcode scanning can be very useful. Try utilizing our free UDIdentify app to scan all of your inventory, create a spreadsheet, and send that data to yourself via email. You can then use that data to reconcile what is in ConnectSx. You’ll want to make sure that you have at least the following data points in your audit results spreadsheet: catalog number, lot, quantity. 

...

Next, you’ll want to copy your inventory data into a fresh tab in your audit results spreadsheet. In each tab (audit results and ConnectSx inventory), insert a column and concatenate your catalog number and lot number columns to create one identifying number for each catalog/lot combination – the formula should resemble something like this: =concatenate({catalog_number_column}, {lot_number_column}). This will allow us to perform a vlookup between the two tabs.  If you have UDI data, feel free to utilize the UDI instead of creating this concatenation. For more information on UDIs, check out this helpful link: https://www.fda.gov/medical-devices/unique-device-identification-system-udi-system/udi-basics

Next perform a vlookup to pull the quantities from your audit results tab over to your ConnectSx Inventory tab and clearly label the column as your audit results.(For more information on performing vlookups please reach out to us at value@connectsx.com.)

Now you can subtract these two quantities and see what changes in your inventory levels need to be made. 

In ConnectSx you have a couple of options for modifying your inventory quantities after an audit:

1. Create an Event to decrement inventory (event type: missing). Choose Event Type: “Other” and give a description of why you’re removing this inventory. This will create a record of what was decremented and why. (Please see the Knowledge Base article about Events[CR1] )

2. Deactivate your inventory in the inventory detail screen (Please see the Knowledge Base article about deactivating inventory).

3. Add new inventory via inventory import (Please see the Knowledge Base article about inventory imports).

4. Add new inventory manually (Please see the Knowledge Base article about adding new inventory).

It is key that you also update your inventory in your legacy systems if they are still in use (ex. an ERP or a financial reporting system such as Quickbooks) to ensure ConnectSx and your legacy systems stay in sync. For more information on integrating ConnectSx with your legacy systems, please reach out to us at value@connectsx.com.

Was this article helpful?

• Yes
• No

Still need help?

Feel free to reach out to us at value@connectsx.com with any questions!

Related articles

...