Order Guides must be created to do Department Inventories. See Create Procurement Order Guide and/or Create Inventory Order Guide User guides.
Go to Reports Module
Go to Reports Module
1. Go to “Reports” on the menu bar, then select “Inventory”
Open Count Sheet
Open Count Sheet
1. On the left hand side, click on “Order Tools”, then select “Order Guide Count Sheets”
2. Click on “Show Parameters”
3. Select the Order Guide to count. You can also add a second Order Guide to combine into 1 count sheet. This is helpful when you have a Procurement Order Guide and an Inventory Order Guide.
4. Use Order Guide Only - this is a Yes or No question
- Yes - This will only show you the Items that are currently on the Order Guide.
- No - This will show all the Items on the Order Guide but will also add in any Items that were bought into the Department that the Order Guide is set up to.
5. Price Origin - 3 options
- Invoice Pricing Only - Will bring up the cost of the Last Invoice Price. If there is no Invoice in the system yet, it will pick up Last Purchase Document.
- Last Purchase Document - Will bring up the cost of the Last Purchase Document. If there is no Purchasing Document in the system yet, $1.00 will be the price.
- Inventory Item Cost - Will bring up the cost in the Inventory. If the item is not in the Inventory, it will look for Last Invoice Price, then Last Purchase Document.
6. Additional Items Date - if you selected NO on Use Order Guide Only, this Date will tell the system how far back to look for additional item that were bought into the Department that is on the Order Guide.
7. Sort - 2 options
- Line Number - This will sort the Item by Line Number within the Order Guide.
- Location - This will sort the Item by the Area Location that was set up within the Order Guide.
8. Click “Run Report”
Export to Excel
Export to Excel
1. Click on “Select a Format” and choose “Excel”
2. Click “Export”
3. Open the document in Excel
Enter Counts on to the Excel sheet
Enter Counts on to the Excel sheet
1. When in Excel, enter in your counts in the correct Units of Measure. These UOMs are based off the Units with in the Item Master. If the Item is missing a Unit, it will need to be fixed in the Item Master
2. Once all the counts are keying in, use column Y to paste the below formula in. The Formula will need to be added to all the rows that have Inventoried Items.
- =SUM((H13*L13)+(M13*O13)+(P13*R13)+(S13*U13))
3. Then you will want to sum all of column Y to get the overall Inventory amount.
4. Save the Excel Sheet.