Read Inventory Manual text version

Spare Parts Inventory Control System

Management Planning Systems

MPS Spare Parts Inventory Control System

© 2003, ACR ACR Publications 1298 Elm St. SW Albany, OR 97321 541-928-6199 www.acrp.com [email protected] 6/13/03

Contents

Description...................................................................................................................... 1 Installing the Inventory System.................................................................................... 2 Setup............................................................................................................................... 3 Support Tables................................................................................................................ 4 Table Layout........................................................................................................... 4 Spell Check Information ....................................................................................... 7 Vendor Data........................................................................................................... 8 Account Data....................................................................................................... 10 Departments........................................................................................................ 11 Issued To Data..................................................................................................... 11 Received By .......................................................................................................... 12 Units..................................................................................................................... 12 Spare Parts Data Entry................................................................................................ 13 About the Fields................................................................................................... 13 Initial Data Entry................................................................................................ 14 Navigation Button............................................................................................... 14 Issue Parts .................................................................................................................... 16 New Issue Slip...................................................................................................... 13 Print the Issue Slip.............................................................................................. 20 Receive Parts ................................................................................................................. 21 New Receipt Slip................................................................................................... 23 Print the Receipt Slip........................................................................................... 26 Reports.......................................................................................................................... 27 Spare Parts Screen.............................................................................................. 28 Spare Parts - Form View Reports............................................................ 28 Spare Parts - List View Reports ............................................................... 29 Parts Issued Screen............................................................................................. 30 Parts Issued - Form View Reports ........................................................... 30 Parts Issued - List View Reports............................................................... 31 Parts Received Screen.......................................................................................... 32 Parts Received - Form View Reports ........................................................ 32 Parts Received - List View Reports............................................................ 33 Report Menu........................................................................................................ 31 Find Function...................................................................................................... 35 Sort Function...................................................................................................... 38

How to Use the Spare Parts Inventory System

Description

Stand Alone System FileMaker Solution This Spare Parts Inventory Control System is a stand alone database system. This inventory control system is a shareware product produced using FileMaker Pro. Products developed with FileMaker Pro are called solutions. This solution was designed to provide a means of managing consumable inventory such as spare parts, chemicals, and general office supplies. The system was not designed to be used in a point of sale business. The Spare Parts Inventory Control System was developed by Management Planning Systems of Eugene, Oregon, who own the rights to the system. The files may be copied and used for up to 30 days on a trial basis demo to determine if you would like to purchase this system. However, the system may not be routinely used without the written permission of Management Planning Systems. The system is distributed and used in accord with the standard MPS Software License as shareware for $29.95. Management Planning Systems PO Box 1968 Eugene, OR 97440 541-484-1004

Function

Copyright

June 13, 2003

1

Installing the Inventory System

Be Familiar with FileMaker Install Files and Folders To be effective with the use of this data base the user should be familiar with functions of FileMaker Pro. The program is installed following the install procedure found in the How to Install.pdf document on the CD. The install places a folder on the computer titled mps. Inside this folder are four additional folders. The data files are placed inside of the data folder. A copy of this manual is placed in the Documentation folder.

Start the Program

The Inventory program may be opened from the Start Menu. Go to MPS Shareware. If Inventory is the only program installed the screen below will appear. If more than one shareware program has been installed the Launch Utility screen will appear, select Inventory and the screen below will appear.

June 13, 2003

2

Setup

Select Work Order Type After opening the file go to the Setup screen by clicking on the Setup button on the main menu. The screen below will appear.

Organization Info.

Start the setup by entering the organization (company) name, department, and location. Then define the issue and receipt numbers to be used by the system. Each time parts are issued a issue form is filled out and may be printed as verification for the parts withdrawn. Each issue is automatically assigned a number. You may define how this number appears, by assigning the prefix, fill, length of field and the next number to be issued. An example of the number is displayed on the right. Each time parts are placed into the inventory system a receipt is filled out. This receipt may be printed and attached to the invoice and/or packing slip as verification the parts were received. You may define how this number appears, by assigning the prefix, fill, length of field and the next number to be issued. An example of the number is displayed on the right.

Parts Issue Number

Parts Receipt Number

June 13, 2003

3

Support Tables

After initial setup the next step is the input of data into the support tables. The support tables hold data that appears in various pop-up lists and speed s information is always spelled the same way making later searches for data much more accurate. Six Tables There are six support tables, vendor, accounts, departments, issued to, received by, and units.

Table Layout

Buttons The layout of all of the tables is nearly identical. The row of buttons just under the title bar (Print List,, Toggle View, New Record, Delete Record, and Find Record and Find All) perform the functions described. There are two return buttons, Main Menu and Return to Support Table Menu.

June 13, 2003

4

Print Tables

Each table contains a print button. Clicking on this button will print the contents of the information shown on the screen.

New Records Change a Record

To obtain a new blank record click on the New Record button. The vendor data can be changed in either the form or list views. To change the data, place the cursor in the field and delete or type in the required data. For example; to change Basin Ref. to Basin Refrigeration.

Place the cursor after the period in Ref., backspace and type the remainder of the word.

Delete

To delete a record, select the record by placing the cursor into one of the fields of the record. Then click on the Delete button. A dialog box will appear asking for verification of the delete.

June 13, 2003

5

Delete All

Any selected set of data may be deleted by selecting Delete All from the Mode Menu.

Once selected a dialog box will appear asking for verification of the delete.

Find and Detail Sorts

A description of the find and sort functions built into FileMaker solutions is described at the back of this manual. Each of the support tables contains a Toggle View button located in the menu bar.

Toggle View

Clicking on this button will provide an additional view of the data. In this view, the title bar above each data field becomes a sort button. In addition, the actual name of the field is displayed in the title bar. This can be very helpful when attempting to import data as the name of the import filed must be identified.

Sort Buttons

The small square buttons just above the data are sort buttons. Clicking on any of these buttons will sort the data by the column under the button.

June 13, 2003

6

Spell Check Information

All Information can be Checked The data inputted into any of the tables or any other screens in this system, can be spell checked using the built-in spell checker. Select Spelling from the Edit menu. Then either select check record or check all.

Skip, Replace, Learn

Once selected a second spell checking dialog box will appear allowing the option of skipping the word, checking the word, or replacing the word. The learn button will only work after you establish a user defined dictionary.

User Dictionary

A user defined dictionary can be developed by selecting Spelling from the Edit menu and then selecting Select Dictionaries. A new dialog box will appear. Select New, set the location of the dictionary and give it a name. You can now enter special words into the dictionary.

June 13, 2003

7

Vendor Data Input

Select Vendors and a screen similar to the one below will appear.

View as List

View as List The vendor file appears in the View as List layout. The view as list layout provides a convenient way view the vendor records.

Sorting

In the View as List screen the data can be sorted by vendor or contact name by clicking on the small button located to the left of the field name.

Print List

From Menu Bar When Print List is selected from the menu bar a screen similar to the one below will appear. The data to be displayed and printed in this report can be selected and sorted using the find and sort functions described in the Find and Sort Functions section of this Users Manual.

Print the List

The list can be printed by clicking on the Continue button to the left of the screen.

Once selected a new dialog box will appear; select Print or Cancel to return to the view as list.

June 13, 2003

8

View as Form

Selecting a Record To view the record in the Form View click on the green button located to the far left of the record.

When the Form View is selected a screen similar to the one shown below will appear.

New Record

To add a new vendor record, click on the New Record button in the menu bar and a blank record will appear with a vendor number assigned and displayed in the upper right corner. The vendors file is designed to automatically provide a vendor number starting with 101. You can change the default assigned vendor number. Once a blank record is obtained the data can be entered. Start by placing the cursor into the Company field. Enter the appropriate data and press Tab to move to the next field. Shift/ Tab will move the cursor back one field at a time. In addition, the mouse can be used to place the cursor into any field. The comments and specialty fields are text fields. Any related information can be typed into these fields.

Enter Data Tab to Move

Comments and Specialty Fields

June 13, 2003

9

Cross Reference

The Inventory cross reference tab opens a screen displaying material purchased for any selected vendor.

Account Data

Select Accounts The account table is accessed by clicking on the Accounts button on the Support Table screen. When selected a screen similar to the one below will appear.

Need for Number

The account list contains only two vital pieces of information, the account ID and the account description. If an account name is entered without an ID number, the name will not reappear upon leaving and returning to this screen.

June 13, 2003

10

Departments

Select Departments The departments table is accessed by selecting the Departments button on the Support Table screen. When selected a screen similar to the one below will appear.

Issued To Data

Select The Issued To table is accessed by clicking on the Issued To button on the Support Table screen. When selected a screen similar to the one below will appear.

Two Sets of Data

When the New Record Button is clicked a blank record will appear that allows entry of a persons name in the Issued To column or a department, division, or etc. in the Department column. These two fields are used by different pop-up lists.

June 13, 2003

11

Received By

Select The Received By table is accessed by clicking on the Received By button on the Support Table screen. When selected a screen similar to the one below will appear.

Two Sets of Data

When the New Record Button is clicked a blank record will appear that allows entry of a persons name in the Issued To column and their department, division, or etc. in the Department column. Only the data in the Received By column is utilized. The data in the Department column allows for clarification when selecting the individual who received the material.

Units

Select The Units table is accessed by clicking on the Units button on the Support Table screen. When selected a screen similar to the one below will appear.

Data

When the New Record Button is clicked a blank record will appear that allows entry of a units of measure. This information is used in the receipt and issue screens.

June 13, 2003

12

Spare Parts Data Entry

After Vendor Table The spare parts file should be filled in after the Vendor table has been completed. The spare parts screen is reached by selecting Spare Parts from the main menu. This selection will provide a screen similar to the one below.

About The Fields

Required Fields The only field that is required is the Parts No. field. If this field is not filled in the remaining data will disappear once you leave the screen. In order for the reporting functions to work properly and provide needed data the Max and Min fields are critical. The fields for Qty Received, Qty Issued, Status and Value, are all gray indicating they are restricted for data entry. These fields are filled in by the program and cannot be accessed. The initial quantity on-hand is entered into the quantity on-hand field. In addition, this field can be used to adjust the quantity on-hand after a physical count. However, it is recommended, that once the initial quantity has been entered all other adjustments be made using either the issue or receipt process. Thus, this field is gray to indicate a restriction. The vendor information from the support file will appear as a pop-up list when the vendor ID field is selected.

Needed Fields

Restricted Fields

Initial Quantity

Pop-up List

June 13, 2003

13

Equipment & Comments

The equipment and comments fields are text fields and must be filled in by the user.

Initial Data Entry

New Record White Fields To obtain a blank screen in which to enter data click on the New Record button in the menu bar. To populate the database all of the white fields plus the Qty On-hand should be filled in. To obtain the vendor select the vendor ID field and a pop-up list will appear.

Identify the Vendor

To select a vendor, use the slide bar or up and down arrows along the right side to move through the vendor list or type the first letter of the vendor name and the first vendor starting with that letter will be selected. If this is not the correct vendor, use the slide bar or arrows to move through the list or type another letter. Once the correct vendor has been located in the list, press enter or double click on the name and it will be transferred to the Vendor ID and Vendor Name fields. Finish filling in the fields and click on New Record to add an additional record. Continue this process until all of the spare parts have been entered.

Select Vendor

Navigation Button

13 Buttons There are thirteen navigation buttons on the Spare Parts Data Entry screen.

Top Row

View as Form The main navigation buttons are in a row along the top. The View As Form button is depressed indicating you are on this screen

June 13, 2003

14

View as List

When the View as List button is selected a list of the parts is shown. This view will show only the parts that have been selected when in the Form View. To view all of the spare parts in the file, click on Find All from either the Form View or List View.

Return to Form View

Clicking on the View as Form button on the menu bar will take you back to the form view. In addition, clicking on the small green icon to the left of a specific record will return you to the Form View of that record.

Print Parts Info.

Clicking on this button will provide a report of all information shown in the Form View. More explanation of this function is described in the Reports section of this manual. This button takes you to the reports menu. The New Record, Delete Record, Find Record, and Find All buttons perform the designated function. Just to the right of the title are four navigation buttons. These take you back and forth through the data as well as to the first or last record.

Reports Other Back and Forth

June 13, 2003

15

Issue Parts

Purpose When parts are taken from the inventory they must be recorded in the Issue Parts screen. In this way the quantity issued, quantity on-hand, and value fields are updated. Selecting Issue Parts from the main menu will bring you to a screen similar to the one shown below. The screen will contain the first parts issued form.

Select

Navigation Buttons

The navigation buttons perform as is indicated.

June 13, 2003

16

List View

Selecting the List View will provide a list of selected issue slips. As with all of the screens the menu buttons along the top perform as indicated. In addition, the Issue No., Date, WO No., and Issued To fields can be sorted by clicking on the sort icon just above the column. Return to the Form View by selecting View as Form from the menu button or the small green icon to the left of the record.

New Issue Slip

New Record To obtain a blank issue form click on New Record and a blank screen will appear.

No. and Date

The issue slip number and the date of issue are entered automatically. Place the cursor in the WO No. field and enter the work order number, if appropriate, then press Tab to move to the next field.

June 13, 2003

17

The To Fields

When the cursor is placed in the To field a pop-up list will appear.

Select the person and press Enter or double click. The individual will be placed in the To field and the cursor will move on the Department field where a pop-up list will automatically appear. Department Field Select the desired department and press Enter or double click and the department information will be entered and the cursor will move to the account number field .

Account No.

When the cursor is in the Account number field a popup list of accounts will appear. Select the desired account and press Enter or double click and the account information will be transferred to the fields.

June 13, 2003

18

Notes & Parts No.

Once the account is selected the cursor will move to the Notes field. Either type in a note or press tab to move to the Part No. field and a pop-up list of all of the parts in the Spare Parts Inventory will appear.

Select Parts

Select the desired part. The list is automatically sorted by the parts description. A specific part may be found by using the scroll bar to the right, typing the first letter of the description, or clicking in the Part No. field to clear the pop-up list and typing in the part number. Once the part number is entered the other needed data will automatically appear. The cursor will move from the Part No. to the Quantity field. Enter in the quantity and the amount will automatically be calculated. After the quantity has been entered, pressing Tab will move the cursor to the Units field where a pop-up list of units will appear.

Enter Quantity

Units

Changing the Price

The price that appears in the Issue slip screen is the price shown in the Spare Parts Data Entry screen. This price can be changed in the issue screen. Making this change will not change the price shown in the Spare Parts Data Entry screen. However, the Amount field will change to reflect the changed price. Once a part has been selected and placed in the issue slip the Post Complete button at the top of the issue slip will change to a red button with the words Post Pending in the center.

Posting to Inventory

Post Parts

Once all of the parts have been selected the Post Pending button should be selected. This will update the On-hand inventory amount, the inventory value, and the quantity issued fields. In addition, the button will return to gray with the words Post Completed.

June 13, 2003

19

This completes this transaction. If additional parts are added to this issue slip the Post Completed button will once again change to red and must be selected to post the new parts to the inventory control.

Print the Issue Slip

Once all parts have been selected and posted it is time to print the issue slip. Select the Print Issue button in the menu bar and a screen similar to the one shown below will appear.

Total at Bottom Continue

The total for the issue slip is shown in the footer of the slip. Once the issue slip appears you can either print the slip or return to the issue slip screen. Just press the Continue button on the left.

When the print dialog box appears, select Print or Cancel. Cancel will take you back to the issue slip screen.

June 13, 2003

20

Receive Parts

Purpose When parts are received they must be recorded in the Parts Received screen. In this way the quantity received, quantity on-hand, and value fields are updated. Selecting Receive Parts from the main menu will bring you to a screen similar to the one shown below.

Select

Navigation Buttons

The navigation buttons perform as is indicated.

June 13, 2003

21

List View

Selecting the List View will provide a list of selected receipt slips. As with all of the screens the menu buttons along the top perform as indicated. In addition, the Receipt No., Date, PR/PO No., Account No, and Vendor fields can be sorted by clicking on the sort icon just above the column. Return to the Form View by selecting View as Form from the menu button or the small green icon to the left of the record.

June 13, 2003

22

New Receipt Slip

New Record To obtain a blank receipt form click on New Record and a blank screen will appear.

No. and Date

The receipt slip number and the date of issue are entered automatically. Place the cursor in the Received By field and a pop-up list will appear. Select the desired name and press Enter or double click. The name will appear in the field and the cursor will move on to the Vendor field

Received By

June 13, 2003

23

Vendor Field

When the cursor is placed in the Vendor field a pop-up list of vendors will appear. The scroll bar on the right can be used to move through the vendor list. The list is sorted by vendor name. Typing the first letter of a vendors name will move you through the list and select the first vendor whose name starts with that letter. Either select the vendor or use the scroll bar to continue to move through the file. The vendor list may be cleared from the screen by clicking a second time in the Vendor ID field. The vendor ID number can then be entered and the vendor name will be displayed automatically.

Select Vendor

Select the desired vendor and press Enter or double click and the vendor information will be entered and the cursor will move to the invoice number field . The invoice number, Purchase Order, or Purchase Request numbers should then be entered. The cursor will move from the invoice number field to the PR or PO No. field by pressing Tab. Once the PR or PO is entered press tab and the cursor will go to the Account No. field and a pop-up list of accounts will appear. When the cursor is in the Account number field a popup list of accounts will appear. Select the desired account and press Enter or double click and the account information will be transferred to the fields. The cursor will move to the Parts No. field and a pop-up list of parts will appear.

Invoice, PR/PO

Account No.

Select Parts

Select the desired part. The list is automatically sorted by the parts description. A specific part may be found by using the scroll bar to the right, typing the first letter of the description, or clicking in the Part No. field to clear the pop-up list and typing in the part number. Once the

June 13, 2003

24

part number is entered the other needed data will automatically appear. Enter Quantity The cursor will move from the Part No. to the Quantity field. Enter in the quantity and the amount will automatically be calculated. After the quantity has been entered, pressing Tab will move the cursor to the Units field where a pop-up list of units will appear.

Units

Changing the Price

The price that appears in the Receipt slip screen is the price shown in the Spare Parts Data Entry screen. This price can be changed in the Receipt screen to match the price shown on the invoice, PR or PO. However, making this change will not change the price shown in the Spare Parts Data Entry screen. If the price shown in the Spare Parts Data Entry screen is not the price you want to issue the part at, then it must be changed manually. Once a part has been selected and placed in the receipt slip the Post Complete button at the top of the receipt slip will change to a red button with the words Post Pending in the center.

New Price

Posting to Inventory

Post Parts

Once all of the parts have been selected the Post Pending button should be selected. This will update the On-hand inventory amount, the inventory value, and the quantity received fields. In addition, the button will return to gray with the words Post Completed.

This completes this transaction. If additional parts are added to this issue slip the Post Completed button will once again change to red and must be selected to post the new parts to the inventory control.

June 13, 2003

25

Print the Receipt Slip

Once all parts have been selected and posted it is time to print the receipt slip. Select the Print Receipt button in the menu bar and a screen similar to the one shown below will appear.

Total at Bottom Continue

The total for the issue slip is shown in the footer of the slip. Once the issue slip appears you can either print the slip or return to the issue slip screen. Just press the Continue button on the left.

When the print dialog box appears, select Print or Cancel. Cancel will take you back to the issue slip screen.

June 13, 2003

26

Reports

Two Types There are two types of reports. Those obtained from the Data Entry screens and those obtained from the Report Menu. Before selecting a report it is best to select and sort the data. The process used to find and sort data is described at the end of this manual. Once a report has been selected it will appear on the screen just as it will appear when printed. Along the left side of the screen are two key icons, a vertical book in the upper left corner and a Continue button. The vertical book is used to view individual pages of the report. The individual pages of the report may be viewed by clicking on the lower page of the book. This allows scrolling through the book. Or, the slide bar along the right side can be selected and moved down allowing fast scrolling to a specific page. The page number will appear in the lower right just below the book.

Selection and Sorting

Viewing Data

Vertical Book

Number of Pages?

The total number of pages in the report can be determined by moving the scroll bar to the bottom thus allowing the program to determine the total number of pages. In the example below there are 46 pages in the report.

June 13, 2003

27

Spare Parts Screen

Spare Parts ­ Form View Reports

Print Parts Info Selecting Print Parts Info. in the Form View of the Spare Parts Data Entry screen will provide a report showing all of the data seen in the Data Entry Screen as shown below. The report allows for a display of three parts records on each page.

Spare Parts Data Reports

Clicking on the Reports button while in the Spare Parts Data Entry Screen will bring up a dialog box asking you to select between a report of Activity or Status.

Select Status

If status is selected a second dialog box will appear asking if you want the report to show all spare parts with a balance over the maximum, under the minimum, or both.

If both are selected the report will appear similar to the one shown below with the status indicated.

June 13, 2003

28

Activity Report

If Activity is selected, a report similar to the one shown below will appear showing all receipts and issues for the selected parts.

Spare Parts ­ List View Reports

Print Parts List If the Print Parts List icon is selected while in the List View a report showing the selected parts, similar to the one below, will be produced.

Reports Button

If when in the List View the Reports button is selected the two reports, Status, and Activity, discussed above can be produced.

June 13, 2003

29

Parts Issued Screen

Parts Issued ­ Form View Reports

Select Reports If the Reports button in the menu bar is selected a dialog box will appearing providing two selections; print report of Detail or by sorted by Work Order. The report will be of all issue slips selected. (Use the find function to select specific slips, dates, or other data.)

Detail

A detail report provides a list of all parts received for the selected issue slips.

By Work Order

If the print by WO number is selected a report similar to the one shown below will appear.

June 13, 2003

30

Parts Issued ­ List View Reports

Print List If the Print Parts List icon is selected while in the List View a report showing the selected issue slips, similar to the one below, will be produced.

Reports Button

If when in the List View the Reports button is selected the two reports, Detail and by WO, discussed above can be produced.

June 13, 2003

31

Parts Received Screen

Parts Received ­ Form View Reports

Select Reports If the Reports button in the menu bar is selected a dialog box will appearing providing two selections; print report of detail or by sorted by Vendor. The report will be of all receipt slips selected. (Use the find function to select specific slips, dates, or other data.)

Detail

A detail report provides a list of all parts received on each selected receipt.

By Vendor

If By Vendor is selected a report showing all parts received from each vendor will be displayed.

June 13, 2003

32

Parts Received ­ List View Reports

Print List If the Print Parts List icon is selected while in the List View a report showing the selected issue slips, similar to the one below, will be produced.

Reports Button

If when in the List View the Reports button is selected the two reports, Detail, and by Vendor, discussed above can be produced.

June 13, 2003

33

Report Menu

Six Reports Selecting the Reports from the main menu provides the Report Menu screen with six report selections: · Parts Activity · Parts Status · Parts Issued by WO · Parts Received by Vendor · List - Receipts Detail · List - Issued Detail These are the same reports that can be selected from the form view of the individual screens and have all been discussed above.

June 13, 2003

34

Find Function

From the Button Bar

Select Find A find button is included in the button bar of most screens. To perform a find click on this button and all of the data fields will go blank allowing you to enter the find criteria.

Perform a Find

To perform a find, type the information you want to find into the field that contains the information and then press Continue, Return, or Enter. Notice all of the pop-up lists are available to assist in the find. It is not necessary to type in all of the information. For example, if you wanted to find a part name starting with a "C" you would only need to type the letter "C" in the description field and the program will find all of the parts that have a description starting with the letter "C." To clarify a find, you can type information into as many of the fields as is necessary to clarify the find. For example you can select the name of a crew, requested completion data, and equipment ID or name. There are times when you may want to find more than one item in the same field. For example it may be necessary to select two or more pieces of data from the same field. Type in the first piece of data, then either type Control-N or select New Request from the Mode menu and type in the next request. (The number of request that can be made at one time is limited only to a particle limit.) If the status bar is turned on (see below for how to turn on the status bar) you can look through each request to make sure they are as desired.

Words or Letters

Multiple Fields

Multiple Finds

June 13, 2003

35

When all of the requests are completed, press Return or Find in the Status bar. Omit Data To omit records with specific information from a find, click in the Omit box after setting up the find. The result will be all of the records not omitted. To view those omitted select the Find Omitted from the Select menu.

Turn On Status Bar

The status bar allows access to a variety of find and other functions. To turn on the status bar, click on the status bar icon located near the bottom left of the screen.

What will appear will look similar to the image below.

Omit

The selected data can be omitted from the find by clicking on the Omit box located in the status bar or from the menu as described above. Once the find function has been selected the status bar will open. Clicking on the small arrow next to the word Symbol will bring up an additional dialog box providing a number of symbols used to clarify finds.

Find Symbols

June 13, 2003

36

Two Most Common Symbols Range

Two of the most commonly used are the Range (...) and Exact Match (=). The range symbol can be used to select a set of work orders performed between any two dates. Type in the first date followed by three periods (...) or select the symbol and then the second date, then press the Continue button, return or enter keys. The exact match symbol is useful for finding parts where a specific field is blank. To find pats with no information in a specific field, type a = into a field or select = from the symbol menu. Then press the Continue button, return or enter keys.

Exact Match

Find From the Menus

The find function can be invoked from the Mode menu, from the keyboard by typing Control F, or from the Mode Pop-up list located at the bottom left of the screen.

June 13, 2003

37

Sort Function

Keyboard or Menu

The sort function can be obtained from the keyboard by typing Control S or selecting sort from the Mode menu. This procedure should only be used by those who have knowledge of FileMaker Pro.

Dialog Box

When the sort command is invoked a dialog box will appear allowing you to select which selection of fields and the arrangement of fields for a sort.

Select Fields

Select the field from the list on the left and then either double click or click Move to move the field to the right.

June 13, 2003

38

Rearrange Fields

Once the fields have been moved to the right they can be rearranged. Place the cursor on the double arrow to the left of the field and the cursor changes to two lines with arrows. When this occurs click, hold, and move the field to the new position. When completed press Sort.

June 13, 2003

39

Information

Inventory Manual

44 pages

Find more like this

Report File (DMCA)

Our content is added by our users. We aim to remove reported files within 1 working day. Please use this link to notify us:

Report this file as copyright or inappropriate

329345


You might also be interested in

BETA
Front
Inventory Manual
Maysteel.pdf