User Tools

Site Tools


faq:how_to_data_load_serial_numbers_on_a_purchase_order_or_phone_card_import

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Last revisionBoth sides next revision
faq:how_to_data_load_serial_numbers_on_a_purchase_order_or_phone_card_import [2010/11/23 15:24 (14 years ago)] clifffaq:how_to_data_load_serial_numbers_on_a_purchase_order_or_phone_card_import [2010/11/23 15:26 (14 years ago)] cliff
Line 5: Line 5:
   * 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 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.   * 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 ===== ===== Preparing your import file =====
Line 17: Line 18:
 </code> </code>
  
-Depending on special characters you may see double quotes added to the file like this+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**.
 <code> <code>
 SupplierPartNo,Serial,Description,Qty SupplierPartNo,Serial,Description,Qty
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