Advance ship notice format

When adding assets records to SACM by the advance ship notice method, the data must be in CSV format and match the structure displayed in the template.

Note The CSV format must use UTF-8 encoding to retain special characters such as language accents. For more information, see How to create a CSV file with UTF-8 encoding from an Excel file.

To obtain the advance ship notice template:

  1. From the main menu, select Build > Service Asset & Configuration.

  2. Click the Receive assets link in the upper right corner. The Receive assets dialog box is displayed.

  3. In the Method field, select Advance ship notice.

  4. Click the Download sample file link that is displayed.

File format:

  • The advance ship notice file must include the following fields, in order, as the header:

    • AssetTagPrefix

    • AssetType

    • SubType

    • AssetModel

    • WarrantyEndDate

    • UnitPrice

    • Currency

    • ExternalPONumber

    • Quantity

  • There must not be any blanks for the following fields:

    • AssetType

    • SubType

    • Quantity

  • You may not select any additional fields to include in the file.

Related topics