EFT Processing AR FAQ
To implement 2-step approval, set the in EFT Options to Entered.
Refer to Approving changes of EFT Vendor/Customer/Employee details
You can create a single receipt per invoice, or group all outstanding invoices in a single receipt per customer:
Select Yes if you want separate receipts per outstanding invoice,
Select No to include all invoices in a single receipt per customer.
You can use EFT Processing to email advices for AR Miscellaneous Receipts as well as AR Receipts. This means you don't need one process in AR to email customers a remittance advice for Miscellaneous Receipts, and a second process in EFT to email customers remittance advices for Direct Debits.
-
Use an EFT File format for Miscellaneous Receipts configured to work without having to enter EFT details for the AR Customer.
-
Enter and post the AR Receipt Batch
-
Create the EFT File (but you don't upload the AR Receipts EFT File to the bank)
-
Email the Customer a Remittance Advice using the Print Advices screen.
File Sequence No
The FSN field on the EFT Bank is next sequence number (the one that is going to be used for the next EFT Run).
If the file name is set to "File Sequence Number", this number is updated when you
Tip: If you need to reexport a file, set the file sequence number back by 1 to generate the file with the same number.
You can use the "Update Invoice Due Date" feature if the due date needs to be amended for selection in the Create Receipt Batch run.
It is also useful if you need to correct the Due Date on an invoice for your AR Aged Trial Balance because the original document was posted with the incorrect Due Date.
When any document's Due Date is amended, the date, time, user, original due date and amended due date are logged in the Updated Invoice Due Date Audit log.
Note: You are only able to use this screen if the security group "Update Invoice Due Date" has been assigned to your Sage 300 Security profile.
The File Type field is optional. If this option is enabled, you have a Finder to select the EFT Customer, and another to select the EFT File Type. You can then select a file type to record different bank account details for the Customer according to the file type.
If you leave this field blank, then EFT will use the file type that has been assigned in EFT Options > Primary Bank Setup to label the fields and enable EFT Customer extra fields.
Note: The File Type field is only available if you select "Allow multiple Customer bank account details one per EFT file type in EFT Setup > Options > AR Tab. Change the option and restart the screen if you don't see the field.
Detailed example of setting up EFT Vendor is available: Setup EFT Vendor with multiple file types
This report lists the selection criteria and customer/document exclusions that were set at time of running the Create Receipt Batch process in EFT Processing.
If this field is populated with an email address, it will be used if you choose delivery method as “Vendor/Customer” in EFT Reports > Print Advices.
The Email-To field is 250 character long.
For A/R Refunds
-
ELREF01 – payment date is based on the date when the EFT File was created/generated.
-
ELREF02 - payment date is based on the refund entry date.
For A/R Receipts
-
ELREC01 – payment date is based on the date when the EFT File was created/generated.
-
ELREC02 - payment date is based on the receipt entry date.
This form lets you create A/R Receipt or Refund batches from A/R invoices and other documents according to the configuration in the EFT Processing Receipt Selection Code setup.
Create Receipt batch can create three types of batches:
A/R Receipt batches, Zero value A/R Receipt batches to apply documents and A/R Refund batches.
When creating A/R Refund batches, the process only includes Credit Notes and Unapplied Cash and Prepayments, in line with how Refund batches work in Sage 300.
