List Types

<< Click to Display Table of Contents >>

You are here:  Sage Intacct Paperless Administration > Global Settings >

List Types

Administrators have the ability to make custom lists of items that can be selected as index values.

 

1.From My Paperless, click Global Settings.

2.In the Global Settings navigation bar, click List Types.
 
The List Types page displays:
 
ListTypesGrid
 

 

Adding a List Type

 

When you click Add+button-mh, the List Type General Properties dialog box displays with the GENERAL tab active:
 
NewListTypeProperties
 

 

1.In the Name field, enter a list name. This is a required field.

2.The Active check box should be systematically checked. If this list should not be active, remove the check box.

3.Click SaveButtonDefault .

4.Click the LIST DATA tab.
 
The following page displays:
 
ListDataGrid
 
This is where you can add rows and add columns. When you import rows, these are "CSV Importer" style where column headers from the first line of the CSV file are read; where comma delimiter and double quotes are the defaults.

 

5.Click AddColumnButton.
Important: You must have at least one column before adding rows.
 
The following Add Column dialog box displays:
 
ListAddColumn
 

6.In the Name field, enter the column heading.

7.In the Field Length field, keep the default (which is 50), lengthen (or shorten) the field length as appropriate.

8.Select the Allow Unique Values Only check box if two rows in the column cannot have the same value. This is important when building a backfill for a custom list.

9.Click Addbuttonplain-mh.

10. Continue adding columns if additional data is warranted.

 

 

Manually Adding Rows

 

1.Click AddRowButton.
 
AddRowGrid
 

2.Type the entry in the appropriate column(s).

3.Click Save, AddRowSaveicon-mh.

4.Then click AddRowButton again.

5.Continue the process to add entries to your list.
 
The final list should resemble the following:
 
ListGridComplete
 

Note:  You can change the row order by clicking on the Row Ordericon that displays at the beginning of each row and dragging the row to the order you want it.
 

 

Importing Rows

 

You can import rows of list data from a source CSV file.

 

1.Click ImportButton.
 
The Import List Data dialog box displays:
 
ImportListData
 

2.Click SelectFileButton to access your associated CSV folder similar to the following:
 
SelectFileDialog
 

3.Highlight the file to select it.

4.Click Open.
 
A completed Import List Data dialog box redisplays:
 
ImportListDataComplete
 

5.Use the Delimit Columns With text field dropdown to select the appropriate delimiter. Comma is the default.

6.Use the Delimit Text With text field dropdown to select the appropriate quote marks. None is the default.

7.Verify that the Read column headers from first line of CSV file check box is selected. This is the default.

8.Click StartImportButton.
 
The LIST DATA page redisplays. Note the additional column headings and entries as a result of the CSV file you imported.