REPAY Payables: Version 290
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:
|
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.