System Five Add-Ons & Integrations help simplify the way you do things.
Our catalog of services has topic-based, role-based, or technical plans that can help you maximize your software investment.
Copyright © 1984-present
Windward Software Systems Inc.
All Rights Reserved.
Privacy Policy
This is also known as a phone card import. It has some specific requirements and is designed to work on a receiving report.
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.
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.
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