The Commodity Selection Database program provides all the tools necessary to maintain a database of commodity selection criteria. Commodity selection criteria is used for reporting purposes throughout the system and enables you to group commodity codes together. The program will automatically load all commodity selection criteria in the database and display the commodity selection name and description. Use your cursor keys to move through the list.
Commodity Selection Criteria Database Menu
|
Cancel |
Select Cancel to exit the commodity selection criteria database maintenance program. |
|
Add |
Select Add to add a new commodity selection criteria to the database. |
|
Modify |
Select Modify to modify any field related to the highlighted commodity selection criteria. |
|
Delete |
Select Delete to delete the highlighted commodity selection criteria. |
|
Inquire |
Select Inquire to display fields related to the highlighted commodity selection criteria. |
|
Report |
Select Report to print a commodity selection criteria report. The Commodity Selection Report can be created for a specific commodity selection name or all commodity selection criteria. All commodity selection criteria related fields will be reported. |
|
Copy |
Select Copy to create a new commodity selection criteria by copying an existing commodity selection criteria and changing the name. Commodity Selection Criteria Maintenance Screen. |
Name
-
Enter a unique name for the commodity selection criteria. The maximum length is 10 characters and entry of a blank name will terminate entry.
Description
-
Enter the description (maximum 30 characters) of the commodity selection criteria. Make the description specific so it is easy to locate and understand later.
-
Commodity selection criteria is entered in exactly the same manner as GL selection criteria. Each level in the commodity code format can be identified and reported separately. A maximum of 99 lines of commodity selection criteria may be entered.
Set
-
Enter the set number. The set number effectively groups commodity levels together. Criteria with the same set number will be processed together using 'And' logic (a commodity code must meet every condition in the set to be selected). Create multiple sets of criteria by using different set numbers to group the criteria together. These different groups will be processed using 'Or' logic (if a commodity code meets the criteria for any specific set it will be selected).
Level No
-
Enter the commodity code element (level) number to select. The commodity levels are defined in the Commodity Code Format program. The name of the commodity level will be displayed.
Start Code
-
Enter the starting value for the level.
End Code
Enter the ending value for the level. Commodity Selection Criteria Maintenance Menu.
|
Accept |
Select to save the commodity selection criteria entered. |
|
Cancel |
Select if you do not wish to save the commodity selection criteria. |
|
Modify |
Select to modify the criteria line currently highlighted by the cursor. |
|
Delete |
Select to soft delete the highlighted commodity code. |
|
Insert |
Select to insert a new line of criteria above the line highlighted by the cursor. |
|
Delete |
Select to delete the criteria line currently highlighted by the cursor. |
|
Name |
Select to change the name for the commodity selection criteria. |