The Commodity Code Database program provides you with all the tools necessary to maintain a database of valid commodity codes. Commodity codes are used to effectively group related stock items together. The program will automatically load all commodities in the database and display their commodity code and description. Use your cursor keys to move through the list . The default option on the horizontal menu bar will be the option chosen on the main menu.
Commodity Code Database Menu
|
Cancel |
Select Cancel to exit the commodity code database maintenance program. |
|
Add |
Select Add to add a new commodity code to the database. |
|
Modify |
Select Modify to modify any field related to the highlighted commodity code. |
|
Delete |
Select Delete to soft delete the highlighted commodity code. |
|
Inquire |
Select Inquire to display the fields related to the highlighted commodity code. |
|
Report |
Select Report to print a Commodity Code Report. The Commodity Code Report can be created for a specific commodity or all commodities. All commodity related fields will be reported. |
|
Criteria |
Select Criteria to add, modify or inquire on selection criteria. |
Commodity Code Database Maintenance Screen
-
The following screen will appear if Add, Modify or Inquire is selected.
Commodity
-
Enter a unique commodity code. The maximum length is defined in the Commodity Code Format and entry of a blank commodity code will terminate entry. The breakdown of the commodity code including the description of each level displays at the bottom of the screen.
Description
-
Enter the commodity description (60 character maximum length). The commodity table lookup will be sorted in order by commodity description.
GL Account
-
In certain cases you may wish to charge expenditure accounts other than the user GL account for certain commodities. In these cases you must enter a GL account with wildcard (%) characters. The wild card characters in the commodity GL account will be replaced with characters from the user GL account to create a new GL account during Warehouse Requisition Entry, Complete Requisition Entry, or Daily Stock Issue. The commodity GL account MUST contain wildcards but CANNOT be comprised of all wildcards. Each level is validated against the atrieveFinance dictionary.
eg. User Database 01 010 04 41 511
Commodity Database %% %%% %% %% 524
New GL Account 01 010 04 41 524
-
Enter a blank GL account to always charge the user GL account for goods during issues.
PST Tax Code
-
Most warehouse commodities are purchased with PST included in the cost price. However, some users can claim an exemption from the PST for certain commodities. Therefore when issuing goods to these users, the PST tax amount must be removed from the stock issue price and a PST tax collectible invoice must be created to recover the PST amount from the government. If it is possible for a user to claim a PST tax exemption for this commodity, enter the valid PST tax code related to the exemption.