Salesperson

<< Click to Display Table of Contents >>

Navigation:  System Manager > Data Import > Import Parameters >

Salesperson

Previous pageReturn to chapter overviewNext page

 

To successfully import Salesperson records, take note of the following general conditions when creating your import source file:

 

There can be any number of entries in the source file, one following immediately after the other.

 

The first line in the source file is not imported. Be sure to enter the first entry after the first line.

 

You must enter the data field's name in the first line as a column heading. The data import is case-sensitive so be sure that each column name is spelled correctly and that it matches with the actual data field's name.

 

Each line in your source file after the first line will be treated as a separate record.

 

There are certain validations that the data import feature performs which differs depending on the import function selected. Validation checks are in place to ensure that data to be entered into the system are acceptable. Below are the data-specific requirements you need to successfully import salesperson records:

 

Required Module: Sales Order (SO) or Accounts Receivable (AR)

 

Required Import Field(s):

SalespersonCode

CountryCode

RevenueCode

 

notes_c

Note: You can also view all the data fields available for importing Salesperson records by downloading from this link the sample import file.

 

 

 

 

Illustration:

 

The following example shows you how to format the source file properly to successfully import Salesperson records. The sample import template below shows you the following:

 

It is for importing four (3) different salesperson records.

It includes the required fields SalespersonCode, CountryCode and RevenueCode, respectively.

It also contains values for the selected data fields to be included in the data import. You have the option to include all data fields in your source file or to select only a few fields. For those non-required fields that you opt not to include in the source file, the system will auto-populate it with the default values.

 

SalespersonCode

FullName

Title

Street

City

State

Zip

CountryCode

Phone

RevenueCode

Email

Status

JOHN

John Adams

Regional Sales Supervisor

4453 River Valley

San Francisco

CA

94113

US

954-258-4552

SERVICE

johnadams@yahoo.com

1

ANNIE

Annie Howards

VP Sales

9552 Fourth Estate

New York

NY

10001

US

9521-541-2582

CONTRACT

anniehowards@gmail.com

0

SAMUEL

Samuel Lee

Sales Representative

54 Garnet Road

Brisbane

CA

94221

US

510-357-3483

CONTRACT

 

1

 

 

 

 

 

© 2023 AccountMate Software Corporation