On this form, you create a bank feed that is connected to Plaid or MX or that loads bank transactions from a file. In addition to accessing this form through a search or a workspace, you can open it by clicking Add New Record on the form toolbar of the Retrieve Bank Feed Transactions (CA507500) form.
This form appears in the system if the Bank Feed Integration feature is enabled on the Enable/Disable Features (CS100000) form.
The form toolbar and More menu include the buttons and commands described below.
By using this dialog box, you can specify the settings for loading transactions in test mode. This gives you the ability to ensure that your bank is able to send transactions through MX or Plaid in a suitable format without mapping bank accounts to Acumatica ERP cash accounts and activating the bank feed. This dialog box opens if you click Load Transactions in Test Mode on the More menu.The following table shows the UI elements of this dialog box if MX or Plaid is selected in the Bank Feed ID box of the Summary area.
By using this dialog box, you can specify the settings for loading transactions in test mode, thus ensuring correct setup of the mapping between source file fields and the setting in Acumatica ERP. This dialog box opens if you click Load Transactions in Test Mode on the More menu. The following table shows the UI elements of this dialog box if File is selected in the Bank Feed ID box of the Summary area.
This dialog box is displayed when you click Load File Manually on the More menu. You use this dialog box to reload the file with transactions that has already been loaded or to load a new file.
In this area, you can specify the settings for a new bank feed connection or select an existing bank feed connection to view and possibly modify its settings. The elements of this area are summarized below.
This tab is used for mapping bank accounts to cash accounts and for reviewing the linked bank accounts.
The list of bank accounts shown on this tab is updated automatically by the system. The tab shows the accounts that you have selected in Plaid on the hosted form, which opens when you click Update Credentials on the form toolbar.
The table toolbar has only standard buttons.
This tab appears on the form if File is selected in the Bank Feed Type box of the Summary area. You use this tab to specify the connection settings, create a data provider, and set up the mapping rules between the file fields and the target fields in Acumatica ERP.
You use the UI elements in this section to specify the connection setting and test the connection to the SFTP folder with source files.
You use the UI elements in this section to create a data provider and specify the format of amounts in the source files.
You use this section to define the mapping rules between the fields of a source file and the settings of the cash transactions that will be created in the system. The table on this tab appears after you click Set Up Data Provider in the Source File section and the data provider has been successfully created. If the Bank Feed BAI2 data provider has been specified, the system automatically fills in this table with the mapping rules for required fields, which cannot be edited. However, you can set up mapping for optional fields.The table toolbar has only standard buttons.
On this tab, you can set up optional mapping between the bank feed fields and the bank transaction fields by specifying the source and target fields, respectively, and using formulas in the source field. By default, the table on this tab is empty.
If mapping is defined in the table for a target field and the Active check box is selected, the custom mapping rule will have a priority over the core program mapping, if it exists for this field. The specified rules will affect all bank transactions that will be created for all cash accounts from the current bank feed.
If File is selected in the Bank Feed Type box of the Summary area, this tab does not appear on the form.
The table toolbar includes the buttons described below.
The columns of this tab are described below.
On this tab, you can define whether expense receipts should be created and for which employee and corporate card they should be created, based on the transaction account and optional conditions that you can specify.
This tab appears on the form if the Expense Management feature is enabled on the Enable/Disable Features (CS100000) form and the Create Expense Receipts check box is selected in the Summary area of the current form.
On this tab, you can define expense items for expense receipts based on the transaction category or name. This tab appears on the form if the Expense Management feature is enabled on the Enable/Disable Features (CS100000) form and the Create Expense Receipts check box is selected in the Summary area of the current form.