User Tools

Site Tools


faq:how_to_data_load_serial_numbers_on_a_purchase_order_or_phone_card_import

How to data load serial numbers to a purchase order

This is also known as a phone card import. It has some specific requirements and is designed to work on a receiving report.

Requirements

  • The part must be on the PO already.
  • The item field which contains the supplier part number, or another number you type in must match the Part Number field on the import. This would normally be the suppliers part number, but will be the part number in most cases where the supplier part number is blank.
  • The order tab shows after you do the import, this will not show the To Receive number, so you will want to change to the On Order tab to see the newly added serials.

Preparing your import file

The import file usually starts as an excel worksheet. It is recommended that you build and work on the import in excel and then as a last step before importing you will save the file as a .CSV file (comma seperated value file). There are 4 fields in this file, but the 4th field was able to be ignored in tests I performed. The examples will assume the 4 column format even though it works the same.

  • See file format below:
    1. The fist line is not imported and is used to show the header columns
    2. The following lines contain the data you need to import
SupplierPartNo,Serial,Description,Qty
abc,cm-0001,abc Description,1
123,cm-0002,abc Description,1

Depending on special characters you may see double quotes added to the file like this. The description field shows what you would see if you had a description like abc 1“ Description.

SupplierPartNo,Serial,Description,Qty
abc,cm-0001,"abc 1"" Description",1
123,cm-0002,"abc 2"" Description",1

You have probably noticed that the example don't look much like excel. The examples show what the file would look like if you saved the file as a .CSV file and opened it in a text editor like notepad. Once you have saved a file in this format you can go on to importing it into a Purchase Order in System Five.

Importing Into a Purchase Order

The recommended procedure is to import the serials to a sent purchase order or a receiving report. Please review the requirements section for information on the requirements of the import. This is really important because the phone card doesn't provide information on numbers that it fails to load. The only information that ever displays is if the serial number already exists and that is the reason the import is prevented. If the supplier part number is typed a little differently or the import file has a part number instead of the supplier part number you will not be informed that the serial number was not loaded. You need to manually review the file afterwards in order to make sure that all the serials were loaded.

Note: Add video here after it is finished being VShared-cm

faq/how_to_data_load_serial_numbers_on_a_purchase_order_or_phone_card_import.txt · Last modified: 2010/11/23 15:39 (14 years ago) by cliff