Difference between revisions of "Vendor EFT Settings Spreadsheet"
Jump to navigation
Jump to search
(One intermediate revision by the same user not shown) | |||
Line 29: | Line 29: | ||
|- | |- | ||
| '''Show only primary EFT bank account''' || Check this box to show only the primary EFT bank account. otherwise, leave it unchecked | | '''Show only primary EFT bank account''' || Check this box to show only the primary EFT bank account. otherwise, leave it unchecked | ||
+ | |} | ||
Line 34: | Line 35: | ||
− | When you have selected your parameters, click start. The system will generate the report and display a summary of the results. | + | When you have selected your parameters, click start. The system will generate the report and display a summary of the results and save the spreadsheet to the file location that was selected. |
[[Category: Accounts Payable Reports]] | [[Category: Accounts Payable Reports]] |
Latest revision as of 18:47, 15 July 2022
Overview of AP43
The Vendor EFT settings spreadsheet pulls vendors with fields included in AP04 Vendor Entry screens. To generate the report:
- From the DDI Connect main menu, double-click Accounts Payable
- Double-click Reports
- Double-click Vendor EFT Settings Spreadsheet. The parameters screen will launch:
You have the following options:
Field | Description |
---|---|
Spreadsheet filename | Choose the file path to save the spreadsheet by clicking the folder |
EFT Format | Select the EFT Format. The options are All, ACH and Bank Wire. |
Include inactive vendors checkbox | Check this box to include inactive vendors otherwise leave it unchecked |
Include vendors with no EFT settings | Check this box to include vendors with no EFT settings otherwise leave it unchecked |
Show only primary EFT bank account | Check this box to show only the primary EFT bank account. otherwise, leave it unchecked |
Print Options
After clicking the Print Options button you will see the following options. Choose the desired options and click OK to return to the report parameters screen.
Option | Description |
---|---|
Printer | Click the drop down arrow to select from a list of available printers. DDI Connect uses your default printer unless told otherwise |
Format | Click the drop down arrow to select from a list of available formats. Select paper size, number of columns, and number of rows for printing. Each report has built-in format defaults. Select “Use Defaults” to use the built-in report defaults. The number of rows and columns controls the print size and amount of information per page |
Memo | If you wish, you can add a memo to the output of the report. NOTE: It is recommended that Word documents be saved with the .docx extension |
View Report | This option generates a pdf file that is displayed on the screen when the report is generated |
Archive Report | If this option is selected, the system will archive the report in the DDI Connect report archives. For information on working with archived reports, please reference this page: Archived Report Viewer |
Print Report | If selected, the system will generate the report output to your default printer. NOTE: You will also receive a pdf version of the report, displayed on your screen |
Print via PDF | Prints directly to your printer. |
This option allows you to send a .pdf attachment of the report to the indicated users' email addresses. When OK is clicked, a dialog box will open requesting a recipient | |
Duplex/Top | Prints the report on both sides of the paper in landscape style. The printer must be capable of printing on both sides or an error will occur |
Duplex/Side | Prints the report on both sides of the paper in portrait style. The printer must be capable of printing on both sides or an error will occur |
Green bar | Adds shaded, horizontal bars to the report, making it easier to read across columns |
No dialog | Selecting this option means that no ‘Report Completed’ dialog will display after the report has been generated |
Extra copies | If you want extra copies of the report generated, type the number in this field |
When you have selected your parameters, click start. The system will generate the report and display a summary of the results and save the spreadsheet to the file location that was selected.