Vendor Export

Rather than managing account vendor information in your Accounts Payable system, it may be maintained in Circulation and then interfaced using this option. The Business Rule— To which system should vendor information be interfaced? (Account Setup section), determines the format of the export.

To export vendor information:

1. Select Vendor Export from the AP/Direct Deposit menu.

   
2. Select Add, and complete the following fields:

   Field	Type	What to enter
   Company	setup	Select the company for which vendor information should be exported.
   Bill Source	setup	Select the bill source to filter vendor records.
   From Date	date	Enter the date from which vendor records should be included in the export.
   Report Only	checkbox	Select this field to generate a report only. When selected, no export file is created and the Use File Map option is disabled.
   Use File Map	checkbox	Select this field to generate the export using a File Map. When selected, the file structure is controlled by the File Map configuration.
   File Format	setup	Select the File Map to be used for the export. This field is enabled only when Use File Map is selected.
   File Name	open	Displays the default file name from the selected File Map. You can modify this value if required.

3. Select OK, and then select Continue to run the export. Vendor information for new accounts will be appended to the vendorexport.d file in /dti/exchange/cm/secure.

   

   

File Map

Use a File Map to control the structure and format of the export file.

• When Use File Map is selected, the export file structure is determined by the selected File Map. The layout, field order, and included Data Elements are defined in the File Map configuration.

• When Use File Map is not selected, the export uses the default format.

• Business Rules

  • Business Rule—To which system should vendor information be interfaced? (Account Setup Section) determines the export format (for example, DTI Standard, DTI Standard 2, Lawson, or PeopleSoft II).

  • Business Rule—At what level of detail should DTI Standard vendor file be exported? (Account Setup Section) applies only when the interface is set to:

    • DTI Standard

    • DTI Standard 2

    When applicable, this Business Rule determines the field-level detail in the export.

• When a File Map is used, the file structure is defined by the File Map, while the data values continue to be populated based on the Business Rules.

File Map Fields

The following fields are available when configuring File Map–based export:

1. Use File Map: Enables File Map–based export.

   • When selected, File Format and File Name fields are enabled.

   • When Report Only is selected, this field is disabled.

2. File Format

   • Lists File Maps configured for Vendor Export.

   • Select a File Map to define the export structure.

3. File Name

   • Displays the default file name defined in the selected File Map.

   • Enter a custom file name if required.

   • File name tokens can be used to include dynamic values such as date or sequence.