Vendor Change Report

The Vendor Export interfaces only vendor information for new accounts. If vendor information is modified for existing accounts, the information may need to be changed in the Accounts Payable system manually. This can be done using the Vendor Change Report, which lists all accounts that have had setup information modified on or after a cutoff date.

Note:

If any setup has been modified for an account, the account will be listed on the report, even if there was no change to vendor information. For example, if only the account’s contract date is modified, the account will still display on the report.

To run the report:

1. Select Vendor Change Report from the AP/Direct Deposit menu.

   
2. Select Add, and complete the required fields:

   Field	Type	What to enter
   From Date	date	Enter the date from which modified accounts should be included in the report.
   Exclude Billing Changes	checkbox	Select this field to exclude accounts where only billing-related changes have occurred. This field is available only when Business Rule—To which system should vendor information be interfaced? (Account Setup Section) is set to DTI Standard 2.
   Export Data	checkbox	Select this field to export the report data to a .CSV file.
   Use File Map	checkbox	Select this field to generate the export using a File Map. This field is enabled only when Export Data is selected.
   File Format	setup	Select the File Map to define the export structure. This field is enabled and required only when Use File Map is selected.
   File Name	text	Displays the default file name defined in the selected File Map. Enter a custom file name if required. This field is enabled and required only when Use File Map is selected. File name tokens can be used to include dynamic values such as date or sequence.

3. Select OK, and then select Continue to generate the report.

   

   

File Map

Use a File Map to control the structure and format of the exported file when Export Data is selected.

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

• 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.

• 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, PeopleSoft II, or None).

• 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.

Example—Vendor Change Report