Adding parts

Notes:

Caution! Always make a backup of your data before you add parts.

To add new parts:

  1. Open 9-6 Add Parts/Update Prices.
  2. Select Add New Parts.
  3. If you want to automatically assign part numbers to the imported parts, select Assign Part#.
  4. In the Start# text box, enter the starting number to assign to the new parts. This must be in numeric form only.
  5. Choose Select Source File, then browse to and select the database file you want to use for adding parts.
  6. The path name for the source file appears.
  7. The Source File Fields under Field Mapping appears.
  8. If the source file contains descriptive headers or labels as its first line, select First Line is Header.

    This line is ignored during the import function.

  9. Map which Destination Fields from the Sage 100 Contractor database correspond to the imported Source File Fields.

    Important! At minimum, you must select Part#, Description and Unit as Destination Fields to be mapped.

    1. On the left side of the window, under Field Mapping, select the Source File Fields row and the Destination Fields cell that you want to map.
    2. Under Destination Fields on the right side of the window, select the corresponding Sage 100 Contractor field by double-clicking the field. Alternately, select the Sage 100 Contractor field, and then select ENTER or the arrow key to map the field.
  10. Repeat step 9 until you have mapped all Source File Fields with corresponding Destination Fields for the parts you want to add to your Sage 100 Contractor parts database.
  11. Click Add/Update.
  12. If any failures occur during the process, review the error log that appears.

Note: You can remove field mapping for a specific row by selecting the Destination Field and using the arrow key to move it back to the Destination Fields list.

Tip: You can use your selections to save as a template for future use.