Release Date: August 8, 2023

This release fixes an issue where payment vouchers weren't available. 

It also includes prep work to support a new virtual card vendor, updates to customer configuration screens, and ongoing development work on REPAY ETL (Extract-Transform-Load), an internal data mapping tool for importing client data and mapping it to REPAY Payables. When complete, REPAY ETL will eliminate clients having to provide their data to REPAY in a specific format and allow REPAY to automate custom reconciliation reports.

Release Notes

Ticket	Type	Description
CPAY-3449	Feature	Internal upgrades to our third-party search library, which will result in faster search and display of payments and payment details.
CPAY-3721	Fix	Payments > Search Payments. Fixed an issue where payment vouchers could not be viewed or accessed.
CPAY-3734	Feature	Internal. User Maintenance > API Clients. The new Org Number field lets internal users and administrators switch organizations quickly and manage API clients across all organizations. External users can still manage API clients for their organizations.
CPAY-3912	Feature	Internal. Development work to support a new virtual card vendor.
Multiple	Feature	Internal. Ongoing work to support REPAY ETL, an internal tool used to define file mapping templates for importing and exporting data to and from REPAY Payables, in a client's preferred format. To learn more, see "About REPAY ETL," below.
Multiple	Feature	Internal. In Setup > Customer Setup, added a new Configure Workflows section and moved ERP and reconciliation settings to the Manage Accounting and Reconciliation tab: In Select Integration, added the Reynolds & Reynolds ERP option.  Moved the FTP User field below the Select Integration field. The Configure Reconciliation Files section includes options to create daily and monthly reconciliation files and receive them via FTP. In an upcoming release, you'll be able to select the file mapping templates from REPAY ETL to format the reconciliation files.  Moved the Remittance Email and Remittance Phone fields below a new heading, Remittance Configuration.

About REPAY ETL (Extract-Transform-Load)

REPAY ETL is an internal tool used to define file mapping templates for importing and exporting data to and from REPAY Payables. When released, it will allow:

• Clients to provide payment files that are exported from their ERP or DMS (dealer management system), without additional pre-formatting
• REPAY to generate custom reconciliation reports in the format preferred by clients

In the tool, the REPAY Payables data formats and the client's payment and desired reconciliation file formats are captured as file structures. Then, the fields in a payment file structure can be mapped to the REPAY Payables file structure. Likewise, the REPAY Payables file structure can be mapped to the client's desired reconciliation file structure.

The resulting file mapping template matches fields in an input source file to fields in an output destination file.

File mapping templates are client-specific and available to REPAY Payables administrators. In the REPAY Payables UI, payment and reconciliation files are set up as file types for the client. The file type includes the client's FTP hostname and connection info, the appropriate mapping template, and other details. 

REPAY Payables uses the file type to determine how it should handle a particular inbound or outbound file. Using the associated file mapping template, it converts payments files uploaded to the REPAY Payables FTP server and formats reconciliation files generated by REPAY Payables and posted to the FTP server for the client.