How to Use the screen
The screen includes AR Payments that have been entered, approved and completed through the standard Sage Intacct processes, for customers where the EFT File Format is set on the Orchid EFT Tab.
To create a new EFT File
By default, the screen shows Posted AR Payments for customers configured for EFT that are not in any EFT File.
Select the Posted AR Payments you want to include in an EFT File.
In the bottom right corner of the screen, you can view the number of records and the running total of the selected records to assist in validating the records selected against control total.
You can then GENERATE the EFT file. Refer to Generate EFT files
To view AR payments in a file
To view the Posted AR Payments already included in a file, refer to EFT AR Payment Request - View Payments in an EFT File
Step 1. Add Records to Generate an EFT File
Select Records
Select not in any EFT File to view Posted AR Payments available.
Use the tick box next to Customer ID to select/deselect all records.
You can also select Posted AR Payments individually.
Note: If the Format is crossed out, it generally means that the bank is not configured for the selected format. Hover over the field for a description of the issue.
Note: If you can't see completed Posted AR Payments, check that the Customer is configured on the Orchid EFT Tab.
Filtering records with a filter string
You can type a filter criteria, using =, >=, > or < for most fields.
Example: To filter by amount, enter >500 only, do not include the currency
Select Records from the list
Click in one of the fields in the first row to display a box with the values you can select.
In the EFT Payment Request screen, to filter by Payment Method, click in the Payment method field. This displays all values and you can select the values required, for example "Printed Checks"
You can also filter by typing text in the box. If you don't want to view Printed Check, you can filter them out using !=Printed Check in the Payment Method
Filtering on the EFT AR Payment Request screen - Customer name example
Sorting Records
You can sort most columns by the column heading, by clicking on the column heading.
When you hover over the heading in a list, the cursor changes to a pointing finger and you know you can sort. This is consistent with the standard Sage Intacct screens.
Drilldown to AR details
Drill down to view AR Customer details by clicking on the .
Drill down to view the AR Payment Details by clicking on the field.
Step 2. Generate EFT files
Use the Generate button to create EFT Files for the selected payment records. EFT Processing creates one file per bank and per EFT File Format for the selected records.
EFT Processing displays a message with the number of files generated.
Note: If there are any validation errors, review the message, update the required data and try generating the file again.
Step 3. Next Steps - EFT File List
You can then view the files created in the EFT File List. Refer to EFT File List - AR Customer Payments for details.
Step 4. View AR transactions in an EFT File
To view AR transactions included in a file, refer to EFT AR Payment Request - View Payments in an EFT File.
Troubleshooting
Permission Error
When you click “Generate” you may get the following error message:
Error: You do not have permission for API operation READ_BY_QUERY on objects of type company
If the format file uses any Company fields (e.g. Company.Name, Company.Address1 etc), then you must Generate the EFT File from the Top Level to have access to the Company object. Or the format file needs to be amended to put the Company fields on the appropriate entity object that you do have access to.
