Table Procedures
On this page:
The Warehouse Inventory System uses the following tables to reference locations and stock item information in your inventory records:
Shipping Code Table | Identifies locations for delivering stock items from your main storage sites. |
Stock Number Table | Sets and maintains pricing, ordering, and physical inventory levels. |
Warehouse Code Table | Identifies locations for receiving and storing stock items. |
Menu Path: Warehouse Inventory > Reference Tables select a table option
Searching for and listing table records
Select Warehouse Inventory > Reference Tables.
Select a table option to display the table's page.
In the Search section, enter criteria identifying the records to list, and then click Find. To run an advanced search, use the Advanced button. For details on advanced searches, refer to Inventory Transactions Page.
The records found in your search display in the List section.
Adding table records
Select Warehouse Inventory > Reference Tables.
Select a table option to display the table's page.
Click Add New.
In the Detail section, enter a unique code in the Code field, and then complete the remaining fields.
To save the record, click OK.
If the Continuous checkbox is selected, you return to the detail section's Code field. To add another record, repeat Steps 4-5. When you finish adding records, click Back.
If the Continuous checkbox is not selected, you return to the Search section.
Updating table records
Select Warehouse Inventory > Reference Tables.
Select a table option to display the table's page.
In the Search section, enter criteria identifying the records to list, and then click Find. To run an advanced search, use the Advanced button.
In the List section, select the record to update, and then click OK.
In the Detail section, change the desired fields. You cannot change the Code field, since this field identifies the record.
To save the record, click OK.
Deleting table records
Select Warehouse Inventory > Reference Tables.
Select a table option to display the table's page.
In the Search section, enter criteria identifying the records to list, and then click Find. To run an advanced search, use the Advanced button.
In the List section, select the record to delete.
Click Delete.
In the Confirmation dialog, click Yes.
Printing table records
Select Warehouse Inventory > Reference Tables.
Select a table option to display the table's page.
In the Search section, enter criteria identifying the records to list, and then click Find. To run an advanced search, use the Advanced button.
Click Print.
In the Print window, specify how you want to generate the report, and then click OK.
Note
The Stock Number table displays an additional window when you click Print. For details, refer to Stock Number Table.