The Part Number Database

The part number database consists of data used in creating an entry that is identified by a part number that is unique for an importer. The part number can be alphanumeric data of up to 24 characters.

The data can be entered as an independent function accessed from the database menu. It can also be added "on the fly" while doing an entry. The basic data consists of a part number, HTS number and a description. Additional data, such as unit quantities and values as well as OGA data can also be entered.

How to prepare an Entry Using the Part Number Database

To prepare an entry using the part number database:

  1. Start the file in the usual manner by entering the log data.
  2. Use F18 (shift F8) from the log screen to access the part number entry screen.
  3. Type the invoice number and press enter to create a new invoice. This is the invoice number that will show on the worksheet and 7501. It can be numbers or letters and is 12 characters max.
  4. Type the MID (or use F4 to look it up) and the currency code.
  5. When you enter a part number and press tab the appropriate units will be displayed.
  6. If all items are from the same country, you need enter the country only on the first line. Additional lines will replicate the country down the list. In a similar manner, if there are multiple entries of the same part number you can leave the part number blank (but fill in the value) and the part number will replicate.
  7. The screen will scroll to accomodate as many lines as are required.
  8. Press F1 to finish one invoice. You can then enter another invoice if required. When looking at previously entered data you can use F2 and F3 to scroll through the invoices.
  9. Use menu option 2 to go to the worksheet. Type in the file number AND PRESS F8 (NOT ENTER!!) to convert the part number data to the worksheet. If previous data had been entered you will be asked if you want to delete the old data.
  10. Any additional data can be entered on the worksheet at this point.
  11. You MUST at least look at each invoice and answer the Related? (Y/N) question (other things happen at this point as well that need to happen before calc).
  12. Calc and process in the normal way.