Atrieve Finance

Commodity Code

Commodity Codes are used to effectively group together related stock items. 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  to search for some specific text. The default option on the horizontal menu bar will be the option chosen on the main 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 of field related to the commodity code currently highlighted.

Delete

Select Delete to soft delete the commodity code currently highlighted.

Inquire

Select Inquire to display fields related to the commodity code currently highlighted.

Report

Select Report to print a commodity code report. The commodity code report can be created for specific commodity or all commodities. All commodity related fields will be reported.


Commodity Code Database Maintenance Screen

Commodity

  • Enter a unique commodity code. (Maximum length defined in Commodity Code Format.)

  • Enter a blank commodity code to 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 (maximum 60 characters). 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. 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 BAS dictionary.

e.g., User Database              01 010 04 41 511

Commodity Database    %% %%% %% %% 524

New GL Account           01 010 04 41 524

  • To charge the user GL account for goods during issues enter a blank GL account.

PST Tax Code

  • Some warehouse commodities are purchased PST exempt; that is, the warehouse does not need to pay PST for the goods received. However, depending on usage, some users must pay PST for these same goods. If the commodity contains stock items matching the above criteria, you must enter a valid PST tax code to be used when issuing the goods. During issues, the stock issue price must be recalculated to include PST and a PST tax collectable invoice must be created to submit the PST amount to the government.