EFT Setup- Receipt/Refund Selection Codes - Field List

Use this screen to configure Receipt Selection Codes to create A/R Receipt or Refund batches based on the criteria configured for each Receipt Selection code.

The values entered in the EFT Setup > Receipt Selection Codes are used as Default Values when using the Create Receipt Batch function.

See Also Create Receipt/Refund Batch for details on how to use.

Select tab

If you are using EFT Processing to process A/R Receipt or Refund Batches, use this tab to specify details about the receipt batches to be created by EFT Processing.

Document Type: Select the type of batches you want to create: A/R Receipt, A/R Zero value receipt to apply documents or A/R Refund.

Batch Description: Description of the batch

Entry Description: Entry description on the generated entries

Bank ID: This field will populate the Bank code on the generated batch. This is the bank where the funds are deposited into.

Payment Code: Specify a payment code to identify the type of payment

Tip:

  • The payment type "CASH or CHECK" configured on the Payment Code in A/R Setup is used to determine the A/R Refund payment type.

  • All details in the refund use the same payment type.

  • If no payment code is selected, the Refund payment type is set to "Cash".

  • You can amend the payment types before posting the A/R Refund batch if you don't auto-post the batch.

Skip the customer and continue the export

Selecting this option enables a tick box on the EFT Create File screen which will allow you to determine whether an error is generated for each run.

EFT Create File ignore all transactions for A/R Customers which have not been defined in EFT Customers and produce a file for A/R Customers which have been defined in EFT Customers.

Display Error and Abort

Display an error and abort the export - when you select this option, EFT generates an error message for each A/R Customer which is not defined in EFT customers and abort the export. The EFT Customer can then be added and the file export resumed.

Include the Customer anyway

If you select this option, EFT Processing creates the EFT File including the A/R customer details, where the EFT customer details are blank.

Select “No” if you require one receipt per AR Customer

Select "Yes" if you want to create one receipt per National Account for those AR Customers assigned to an AR National Account

Select “Use EFT Customer Setting” if you want to control the number of receipts created for an AR National Account on a EFT Customer by EFT Customer basis. Depending on the selection “Process single receipt per National Account” on the EFT Customer, Create Receipt Batch will either create one receipt per AR Customer or one receipt per AR National Account (to which the AR Customers have been assigned).

Note: This option does not apply when creating A/R Refund in line with Sage's rules for A/R Refund.

Post Receipt Batch will Create the Receipt Batch AND Post the receipt batch after it has been created.

Select Yes if you want separate receipts per outstanding invoice,

Select No to include all invoices in a single receipt per customer.

You can set the default value in the Receipt Select Codes Setup screen and change it at runtime when you use the "Create Receipt/Refund" process.

Criteria tab

Use this Tab to select the Documents to include in the Receipt Batches.

The values setup on the specified receipt selection code appear as the default in the Create Receipt Batch form, but you can change the values before creating the batch.

You can:

  • Choose the method for selecting documents  

  • Select all documents meeting the criteria  

  • Set ranges of account sets, terms code, billing cycle, interest profile, payment code and customer price list, etc.

Customer: Select the customer range

Batch: Select the batch range

Invoice Date: Enter the Invoice date range

Due From: Enter the Due From date range

Customer Balance: Enter a range for the Customer's Balance (this is the total amount outstanding)

Tip: When creating A/R Refund, if you only want to refund customers with a net credit balance, set the From Customer Balance to the lowest negative number you want to select. Set the To Customer Balance to 0.

Invoice Balance: Enter a range for the Invoice Balance (optional)

: Specify the range of account sets that you want included in the A/R Receipt/Refund Batch, or leave the To field blank and specify ZZZZZZ in the To field to select from customers with any account sets.

: Specify the range of Customer terms code that you want included in the A/R Receipt/Refund Batch.

: Specify the range of Invoice terms code that you want included in the A/R Receipt Batch. This doesn't apply to A/R Refund batches

: Specify the Customer billing cycle range that you want included in the A/R Receipt/Refund Batch.

: Specify the Customer interest profile range that you want included in the A/R Receipt/Refund Batch.

: Specify the range of payment codes that you want included in the A/R Receipt/Refund Batch.

: Specify the customer price list range that you want included in the A/R Receipt/Refund Batch.

: Specify the Customer Group Code range that you want included in the A/R Receipt/Refund Batch.

This field appears if you use Sage 300 Optional Fields

You can use the Customer Optional Fields box to specify a customer  optional field as a criteria for selecting customers for a receipt batch. If you specify an optional field, you can then select which optional field values to include in the Receipt batch.

Tip: Select All to select All optional field values and Double click on the Yes field in the Selected column to remove the values to exclude from the batch.

This field appears if you use Sage 300 Optional Fields.

You can use the A/R Invoice Header Optional Fields box to specify an invoice optional field as a criteria for selecting documents for a receipt batch. If you specify an optional field, use the Information icon to select which Optional field values to include.

Tip: When creating A/R Refund, this criteria doesn't apply.

Documents Tab

Use this tab to configure the document types to include in the calculation of the receipt amount, and applied to the receipt created (AR Credit Notes, Prepayments, Unapplied Cash / Receipts, Debit Notes)

Select “Yes” if you want to include any open Credit Notes in the calculation of the document value.

Include Prepayments

Select “Yes” if you want to include any open Prepayments in the calculation of the document value.

Include Unapplied Cash / Receipts

Select “Yes” if you want to include any open Unapplied Cash or Receipt Transactions in the calculation of the document value.

Include Debit Notes

Select "Yes" if you want to include any open Debit Notes in the calculation of the document value.

Include Interest Invoices

Select "Yes" if you want to include any open Interest Invoices in the calculation of the document value.

Exclusions Tab

Use this tab to list the customer(s) which are to be excluded from the document selection process and/or the Customer(s) and Document(s) combinations to be excluded from the document selection process.

Note: If you enter a National Account Customer Number, then all child accounts are also excluded.
Note: When you create the AR Batch, excluded customers and documents are included in the Receipt Batch Audit Log. Refer to EFT Receipt Batch Audit Log

 

Related topics

Create Receipt Batch