Differences

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

--- faq:how_to_data_load_serial_numbers_on_a_purchase_order_or_phone_card_import [2010/11/23 15:24 (14 years ago)] – cliff
+++ faq:how_to_data_load_serial_numbers_on_a_purchase_order_or_phone_card_import [2010/11/23 15:39 (14 years ago)] (current) – 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 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 =====
@@ Line 17: / Line 18: @@
 </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>
 SupplierPartNo,Serial,Description,Qty
@@ Line 25: / Line 26: @@
 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.
@@ Line 30: / Line 32: @@
 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