Available in: Agile | Aware | Analyzer | Multi-Outlet
Why It's Important
1) Inventory counts help you monitor your available stock and determine the total value of your inventory.
2) Counts indicate the cost of running your business over a specified date range.
3) Opening level + purchases – closing level = Actual Usage. This is determined by your counts.
When you receive products and enter an invoice, we update the On Hand quantity for that product. However, if the product is not assigned to a specific location, reciProfity cannot adjust it to zero when you conduct inventory counts. As a result, the On Hand quantity for that product will remain unchanged, which can lead to inaccuracies in your On Hand totals after the count.
How To Use It
Create Locations
Create templates for your counts
Assign Products to Locations
Take A Count
Edit and View Counts
Let's get started
1) Click on the hamburger menu in the top left corner
2) Expand the Manage Inventory menu
3) Click on Counts
Create Locations
1) From the main Counts screen, click on Locations.
2) On the following screen, click the New Location button.
3) Enter your location name and, if applicable, add sub-locations.
A sub-location can be something like Top Shelf, or any indication of where the product is in the location.
When you implement a physical count, you count everything in each sub-location.
After you enter a sub-location, press the green plus button to save the changes.
Create templates for your counts.
1) From the main Counts screen, click on Templates.
2) Click the green +New Template button.
3) Give it a name. In this example, it's called "All Locations." One template is all you need; however, you can create multiple templates to meet your needs.
Click each Location that you want to appear on your count sheet
4) You'll see each location that you click in the column called Count These Locations on This Template
5) When you are ready to begin counting, you will see a list of the available Templates. You can either choose a single template for All Locations or create specific templates for different locations. It is essential to have a Ghost Location in order to account for non-active products.
The purpose of using templates is to reuse the same one for every counting activity. There is no need to create a new template for each inventory count exercise.
Assign Products to Locations
1) From the main Counts screen, click on "Products"
2) Type in the product name OR item code in the "Filter Products" box.
3) Choose the location you want to add them to by selecting from the "Select Location" drop-down menu.
4) Click the button to add the product to the location.
Take A Count
1) From the main Counts screen, click on "Products."
2) On the following screen, you have a choice to Import or +New Count. Select +New Count.
3) Select a template from the drop-down menu. Enter the date. The "counted by" and "verified by" fields are optional, however, it's recommended to use them so there is an audit trail of who conducted the count.
Enter your counts for the packages and/or units for the items on the screen.
Use the arrows to scroll through your different locations and enter counts for each item.
When you are done, select "save and new" to start a new count or "save and close" to save and exit. You can hit "save" at any point while taking a count to save it while you are working. You can always go back and edit it later.
Edit and View Counts
A count sheet can be viewed and/or edited after it is saved.
1) Click on the Counts icon to open the Count Sheet Journal, displaying all previous Counts.
Column Headers:
Template: this is the template used.
Counted At: The count sheet effective date.
Locations: number of locations associated with the template.
Products: number of products associated with the template
3) Make changes to the date, the item count, or add it to a PO.
4) Click the button to keep your changes, or
to discard them.