Direct Debit Collection Management

Menu Path: Accounts Receivable Images\bluerarw.gif Customer Payments Images\bluerarw.gif Direct Debit Collection Management

Purpose

Export direct debit collection files that can be sent to banks.

Overview

Use Direct Debit Collection Management to process customer invoices for customers who are using direct debit collection. For information on setting up direct debit collection, see Direct Debit Collection Processing.

Exporting Direct Debit Files

To export direct debit files:

  1. Verify the appropriate cash account for direct debits is entered in the Cash Account field.

  2. Select filter criteria for the invoices you want to select for direct debit collection.

  3. Click the Show Data button in the ribbon. The invoices that meet the criteria you selected in step 1 appear on the Results tab.

  4. Select the check box in the Select grid column for invoices for which you want to export direct debit collection files.

  5. If you want to change the amount a customer will pay via direct debit for an invoice, modify the amount in the Instructed Amount grid column.

  6. Click the Preview Direct Debits button in the ribbon. Direct Debit Payments Preview appears, and allows you to preview the direct debit payments.

  7. Click the Print Options tab to select output options for the direct debit collection files.

  8. Click the Extract button in the ribbon. The direct debit files are exported to the folder entered in the Output Directory field in the Direct Debit Collection Processing section on the Options tab in Bank Code Maintenance.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Direct Debit Collection Management window.

Show Data

Click this button to display direct debit invoices (invoices for paying customers with direct debit mandates) on the Results tab based on the selected filter criteria.

Select All

Click this button to select the check box in the Select grid column for all invoices. This button is only available if the Results tab is displayed.

Deselect All

Click this button to clear the check box in the Select grid column for all invoices. This button is only available if the Results tab is displayed.

Preview Direct Debits

Click this button to display Direct Debit Payments Preview, which allows you to preview direct debit payments for selected invoices. This button is only available if the Results tab is displayed.

Direct Debit Mandate

Click this button to display Direct Debit Mandate Maintenance, which allows you to view the direct debit mandate for the invoice highlighted in the grid. This button is only available if the Results tab is displayed.

Invoice Detail

Click this button to display Invoice Inquiry, which allows you to view detailed invoice information for the invoice highlighted in the grid. This button is only available if the Results tab is displayed.

Select Tab Fields and Buttons

Field or Button

Description

Cash Account

Enter the cash account for which to display direct debit invoices, or click the Lookup button to select a cash account.

Description

This field displays the description of the selected cash account.

All Reference #s

Select this check box to display direct debit invoices for all reference numbers. This check box is selected by default.

From (Reference Number)

Enter a reference number for which to display direct debit invoices, or click the Lookup button to select a reference number. Reference numbers are also called invoice reference numbers during general invoice creation. If you want to display invoices for a range of reference numbers, enter the first reference number in the range. This field is only enabled if you clear the All Reference #s check box.

To (Reference Number)

Enter the last reference number in a range of reference numbers for which to display direct debit invoices, or click the Lookup button to select a reference number. Reference numbers are also called invoice reference numbers during general invoice creation. If you only want to display a single invoice, you can leave this field blank. This field is only enabled if you clear the All Reference #s check box.

All Reference Dates

Select this check box to display direct debit invoices for all reference dates. This check box is selected by default.

From (Reference Date)

Enter a reference date for which to display direct debit invoices, or click the drop-down arrow to select a reference date. If you want to display invoices for a range of reference dates, enter the first reference date in the range. This field is only enabled if you clear the All Reference Dates check box.

To (Reference Date)

Enter the last reference date in a range of reference dates for which to display direct debit invoices, or click the drop-down arrow to select a reference date. If you only want to display direct debit invoices for a single reference date, you can leave this field blank. This field is only enabled if you clear the All Reference Dates check box.

All Due Dates

Select this check box to display direct debit invoices for all due dates. This check box is selected by default.

From (Due Date)

Enter a due date for which to display direct debit invoices, or click the drop-down arrow to select a due date. If you want to display invoices for a range of due dates, enter the first due date in the range. This field is only enabled if you clear the All Due Dates check box.

To (Due Date)

Enter the last due date in a range of due dates for which to display direct debit invoices, or click the drop-down arrow to select a due date. If you only want to display direct debit invoices for a single due date, you can leave this field blank. This field is only enabled if you clear the All Due Dates check box.

All Batches

Select this check box to display direct debit invoices for all batches used for creating invoices. This check box is selected by default.

From (Batch)

Enter a batch number for which to display direct debit invoices, or click the Lookup button to select a batch number. If you want to display direct debit invoices for a range of batches, enter the first batch in the range. In this context, the batch number is the invoice batch number used for creating invoices. This field is only enabled if you clear the All Batches check box.

To (Batch)

Enter the last batch number in a range of batch numbers for which to display direct debit invoices, or click the Lookup button to select a batch number. If you only want to display direct debit invoices for a single batch, you can leave this field blank. In this context, the batch number is the invoice batch number used for creating invoices. This field is only enabled if you clear the All Batches check box.

All Posting Periods

Select this check box to display direct debit invoices for all posting periods. This check box is selected by default.

From (Posting Period)

Click the Lookup buttons to select a posting period and year for which to display direct debit invoices. If you want to display direct debit invoices for a range of posting periods/years, select the first posting period and year in the range. These Lookup buttons are only enabled if you clear the All Posting Periods check box. For more information, see Posting Period and Year.

To (Posting Period)

Click the Lookup buttons to select the last posting period and year in a range of posting periods/years for which to display direct debit invoices. If you only want to display direct debit invoices for a single posting period and year, select the same posting period/year you selected for the From field to the left of this field. These Lookup buttons are only enabled if you clear the All Posting Periods check box. For more information, see Posting Period and Year.

All Customer Codes

Select this check box to display direct debit invoices for all customer codes. This check box is selected by default.

Note You cannot clear this check box and the All Customer Names check box.

From (Customer Code)

Enter a customer code for which to display direct debit invoices, or click the Lookup button to select a customer code. If you want to display direct debit invoices for a range of customer codes, enter the first customer code in the range. This field is only enabled if you clear the All Customer Codes check box.

To (Customer Code)

Enter the last customer code in a range of customer codes for which to display direct debit invoices, or click the Lookup button to select a customer code. If you only want to display direct debit invoices for a single customer code, you can leave this field blank. This field is only enabled if you clear the All Customer Codes check box.

All Customer Names

Select this check box to display direct debit invoices for all customer names. This check box is selected by default.

Note You cannot clear this check box and the All Customer Codes check box.

From (Customer Name)

Enter a customer name for which to display direct debit invoices, or click the Lookup button to select a customer name. If you want to display direct debit invoices for a range of customer names, enter the first customer name in the range. This field is only enabled if you clear the All Customer Names check box.

To (Customer Name)

Enter the last customer name in a range of customer names for which to display direct debit invoices, or click the Lookup button to select a customer name. If you only want to display direct debit invoices for a single customer name, you can leave this field blank. This field is only enabled if you clear the All Customer Names check box.

All Billing Customer Codes

Select this check box to display direct debit invoices for all billing customer codes. This check box is selected by default.

Note You cannot clear this check box and the All Billing Customer Names check box.

From (Billing Customer Code)

Enter a billing customer code for which to display direct debit invoices, or click the Lookup button to select a billing customer code. If you want to display direct debit invoices for a range of billing customer codes, enter the first billing customer code in the range. This field is only enabled if you clear the All Billing Customer Codes check box.

To (Billing Customer Code)

Enter the last billing customer code in a range of billing customer codes for which to display direct debit invoices, or click the Lookup button to select a billing customer code. If you only want to display direct debit invoices for a single billing customer code, you can leave this field blank. This field is only enabled if you clear the All Billing Customer Codes check box.

All Billing Customer Names

Select this check box to display direct debit invoices for all billing customer names. This check box is selected by default.

Note You cannot clear this check box and the All Billing Customer Codes check box.

From (Billing Customer Name)

Enter a billing customer name for which to display direct debit invoices, or click the Lookup button to select a billing customer name. If you want to display direct debit invoices for a range of billing customer names, enter the first billing customer name in the range. This field is only enabled if you clear the All Billing Customer Names check box.

To (Billing Customer Name)

Enter the last billing customer name in a range of billing customer names for which to display direct debit invoices, or click the Lookup button to select a billing customer name. If you only want to display direct debit invoices for a single billing customer name, you can leave this field blank. This field is only enabled if you clear the All Billing Customer Names check box.

All Paying Customer Code

Select this check box to display direct debit invoices for all paying customer codes. This check box is selected by default.

Note You cannot clear this check box and the All Paying Customer Name check box.

From (Paying Customer Code)

Enter a paying customer code for which to display direct debit invoices, or click the Lookup button to select a paying customer code. If you want to display direct debit invoices for a range of paying customer codes, enter the first paying customer code in the range. This field is only enabled if you clear the All Paying Customer Code check box.

To (Paying Customer Code)

Enter the last paying customer code in a range of paying customer codes for which to display direct debit invoices, or click the Lookup button to select a paying customer code. If you only want to display direct debit invoices for a single paying customer code, you can leave this field blank. This field is only enabled if you clear the All Paying Customer Code check box.

All Paying Customer Name

Select this check box to display direct debit invoices for all paying customer names. This check box is selected by default.

Note You cannot clear this check box and the All Paying Customer Code check box.

From (Paying Customer Name)

Enter a paying customer name for which to display direct debit invoices, or click the Lookup button to select a paying customer name. If you want to display direct debit invoices for a range of paying customer names, enter the first paying customer name in the range. This field is only enabled if you clear the All Paying Customer Name check box.

To (Paying Customer Name)

Enter the last paying customer name in a range of paying customer names for which to display direct debit invoices, or click the Lookup button to select a paying customer name. If you only want to display direct debit invoices for a single paying customer name, you can leave this field blank. This field is only enabled if you clear the All Paying Customer Name check box.

Posted

Select whether to display posted, unposted, or both posted and unposted direct debit invoices. The Yes radio button is selected by default.

Extracted

Select whether to display direct debit invoices for which direct debit collection files have already been exported, have not been exported, or both have and have not been exported. The No radio button is selected by default.

Display Currency

Click the Lookup button to select the currency for exported direct debit collection files. This defaults to the default general ledger currency.

Results Tab Fields and Buttons

Field or Button

Description

Invoices

This grid displays invoices based on the criteria selected on the Select tab after you click the Show Data button in the ribbon. Select the check box in the Select column for invoices for which you want to export direct debit collection files. You can change the amount for each invoice that will use direct debit collection in the Instructed Amount field.