The Asset Selection dialog box allows you to select criteria used by CMI Fixed Assets to determine which assets to print or display.
The left side of the dialog contains checkboxes for many of the asset input fields. If you check a field, you can then enter criteria to be used. For example, if you check Asset Number, you can enter a range of assets to be selected. If you enter 150-200, only assets 150 through 200 will be printed or displayed.
Asset selection criteria can be saved and retrieved. This feature is helpful if you find yourself repeatedly making selections using the same criteria.
For ranges, you can enter either individual values (such as 10,20,30) or minimum-maximum pairs (such as 100-200 which indicates the range of values from 100 through 200). Individual values and minimum-maximum pairs can be combined (for example 1-10,20,30). Some input fields allow hyphens (-) or commas (,) as part of the value. For example, account numbers may have hyphens in them; if you enter 100-200, you may be indicating the range of values from 100 through 200, or you may be indicating a single account number 100-200. To distinguish between the two situations, you can enclose the value in quotation marks (either ' or "). For example "100"-"200" means the range of account numbers 100 through 200, and "100-200" means the single account number 100-200.
You can leave out the upper or lower limit. For example -100 means all values up to and including 100. 5000- means all values above or equal to 5000. If you need to indicate a negative number, put it in quotation marks.
Wildcard characters are allowed when entering values for the asset description and user-definable fields. Enter a question mark (?) for a single character that can have any value, or an asterisk (*) for any group of characters that can have any value. For example to select all assets with a description that begins with Chevy, enter
in the description field. To select all assets with the word Chevy anywhere in the description, enter
If you want to select all Chevys with model years in the 1990s, you might try entering
in the description field. Finally, if you want to select an item that actually has one of the wildcard characters, enter a backslash (\) before entering the character. For example, enter
to select all assets that begin with an asterisk. (\* represents the asterisk, and then the second asterisk means any characters can follow.)
For more on entering Asset Selection criteria see the Manual under the Help menu in your CMI Fixed Asset software. Pages 66-68
As always if you have questions or comments concerning this blog post or anything else related to the CMI Fixed Asset software please contact us at 1-800-678-3658 or at email@example.com.
Have a GREAT week!