Several tables are included and must be populated by the end user in order to access some of the features of the Accounts Receivable and Work Orders program. The tables and their intended purposes are listed below:
accounts: An internal table that is the master table for keeping track of accounts. This table is populated directly from the main Accounts Receivable screen and should only be used as a backdoor for viewing the accounts data.
employees: For creating a list of employees.
inventory: Used for listing repair inventory part numbers, descriptions, counts, reorder (par) levels, costs, bin locations, count order (sequence) and vendor codes.
itemcatalog: For listing item descriptions, codes, and types. The type field joins to the type field found in the repairs table.
itemrepair: Used to join specific item codes to specific repair codes in order to allow repair lists to be limited based upon selected items. This table should be populated using the Link Items & Repairs menu option found in the Edit Tables screen menu.
repairs: For listing repair descriptions, codes, and the type of item the repair is for. The type field joins to the type field found in the itemcatalog table.
transactlog: An internal table used to track all transactions. This table is populated directly from the ledger tab of the main Accounts Receivable screen and should only be used for viewing the accounts transaction data.
vendors: This table is for creating a list of vendor descriptions, codes, and contact information. The vendor code is used to indicate the item vendor in the inventory table.
workorders: An internal table that is the master table for keeping track of work orders. This table is populated directly from the main Work Orders screen and should only be used as a backdoor for viewing the work order data.
workdetail: An internal table that is a detail table for keeping track of work orders. This table is populated directly from the main Work Orders screen and should only be used as a backdoor for viewing the work order detail data.
To access a table, click on the Table drop down menu and then
select the table that you wish to view or edit.
Place the cursor in each cell of the grid and populate the cells with the appropriate values.
Here are few guidelines for editing records within the Edit Tables screen:
Typically, master records such as the ones described here should not be deleted after the data have been used by the program. Instead, if a master record becomes obsolete, it should be inactivated in order to preserve the historical data.
One special menu option is for linking items to specific repair descriptions. This menu is accessed via the Link Items & Repairs selection under the Options menu.
Once the Repair Information screen opens, you may select the type of item to get a subset of items and repairs that have matching types. After an item is selected, the grid will be populated with repair details that have already been added for that item. Additional repair details can be added for the item by first selecting the repair description from the repair list and then populating the price and estimated hours edit boxes. Finally, click the add button to add the record or use the update and remove buttons to manipulate existing rows in the grid.