If the Counterpoint default Physical Count Worksheet doesn’t show enough information for you to count your items, you can create a Quick Report from the Item Lookup and print it.
Creating and Filtering the Lookup
To get into the item lookup, select columns, and filter the report for specific items:
- Select Inventory → Physical Count → Physical Count Enter
- Click the Magnifying Glass next to Item number
- An Item Lookup window opens
- Right-click on one of the Column Headers and choose Column Designer from the drop-down menu
- Choose Columns to print on the report by moving those columns to the Visible columns area. Remove columns from the Visible Columns area that you don’t need to see on the report. Recommended columns include:
- Item Number
- Long Description – if primarily using the Long Description field
- Qty on Hand – if you want to see the Qty that Counterpoint think you have in stock
- Any additional information you require
- Once you have all the columns you require added to the Visible columns area, click OK
- Expand the size of the columns of the lookup to see all data in the columns
- Click the Options button, and choose Filter from the drop-down menu
- Use the Filter window to limit what data shows on the Quick Report. Recommended Filters include:
- Primary vendor is exactly XXX
- Item category is exactly XXX
- Click OK
Previewing and Printing the Quick Report
To verify the right data displays and then print the quick report:
- Click Options and choose Preview from the drop-down menu
- Review the information in the report
- (Optional) Close the preview and redo columns or filters if necessary
- Click Print
