Enterprise resource planning (ERP) integrator system and method

Patent metadata

Field	Value
Publication number	US-10489758-B2
Application number	US-201113032722-A
Country	US
Kind code	B2
Filing date	Feb 23, 2011
Priority date	Feb 23, 2011
Publication date	Nov 26, 2019
Grant date	Nov 26, 2019

Abstract

The methods and systems described herein attempt to resolve the deficiencies of the conventional systems by using pre-loaded templates and extracting comprehensively populated payment files in an industry standard format for processing. In one embodiment, a computer-implemented method for generating a payment file comprises receiving, by a computer, a request for a payment to a beneficiary; receiving, by a computer, a selection of the beneficiary for payment; receiving, by a computer, a request to pay the beneficiary using a template; retrieving, by a computer, the template from a database, wherein the template has a plurality of business rules for completing a plurality of data fields; extracting, by a computer, information from a database to complete the data fields of the template; and generating, by a computer, a payment file by completing the data fields of the template according to the plurality of business rules.

First claim

What is claimed is:

1. A computer-implemented method for generating a payment file at a payor computing system containing a payment configuration computer and a network gateway, the payor computing system being remote from a payment facilitation computing system, the method comprising:
receiving, by the payment configuration computer, a request instructing the payment configuration computer to initiate for a payment to a beneficiary
using at least a template file within a plurality of template files previously received from the payment facilitation computing system;
responsive to receiving the request, automatically identifying, by the payment configuration computer, a single template file from the plurality of template files in a database that is associated with the beneficiary in the request, wherein the identified template file contains a plurality of data fields and logic instructions configured to cause the payment configuration computer to generate the payment file and to modify the plurality of data fields of the identified template file;
modifying, by the payment configuration computer, the identified template file based on determining which data fields to dynamically select based on the request for the payment, determining which information to extract for the included data fields, and formatting a data field based on the request for the payment according to the logic instructions;
executing, by the payment configuration computer, an executable file based on the logic instructions in the identified template file to:
scan and extract, by the payment configuration computer, information from the database to complete the data fields of the modified template file configured for the beneficiary; and
generate and transmit, by the payment configuration computer via the network gateway to a file exchange server of the payment facilitation computing system, the payment file by completing the data fields of the modified template file according to the logic instructions configured based on the request for the payment, whereby the file exchange server validates the payment file before dissemination.

2. The computer-implemented method according to claim 1 , wherein the payment file is in an ISO 20022 XML format.

3. The computer-implemented method according to claim 1 , further comprising providing the template file for installation in a database for use in generating the payment file.

4. The computer-implemented method according to claim 1 , wherein a first template file is used for generating a credit payment file and a second template file is used for generating a debit payment file.

5. The computer-implemented method according to claim 1 , further comprising:
extracting, by the payment configuration computer, information about the beneficiary for completing a first data field in the template file;
extracting, by the payment configuration computer, information about an invoice for the beneficiary for completing a second data field in the template file; and
extracting, by the payment configuration computer, information about a bank account for completing a third data field in the template file.

6. The computer-implemented method according to claim 1 , further comprising transmitting the payment file to the file exchange server of a bank for processing.

7. The computer-implemented method according to claim 1 , further comprising generating, by an enterprise resource planning system, a batch file of a plurality of payment requests for processing.

8. The computer-implemented method according to claim 1 , wherein a first data field of the template file comprises an amount to be paid to the beneficiary, and the payment file is generated by completing the first data field using a preferred currency of the beneficiary.

9. The computer-implemented method according to claim 1 , wherein a plurality of business rules determine which data fields are to be completed based upon the beneficiary.

10. The computer-implemented method according to claim 1 , further comprising generating a payment file for a beneficiary in a first country and generating a payment file for a second country using the same template file.

11. A enterprise resource planning (ERP) system for generating a payment file at a payor computing system containing a payment configuration computer and network gateway, the payor computing system being remote from a payment facilitation computing system having a file exchange server, the system comprising:
the payment configuration computer communicatively coupled to:
a first database for storing payment information about a beneficiary to be paid;
a second database for storing information about an invoice from the beneficiary;
a third database for storing information about a bank account for making payments to the beneficiary;
a fourth database for storing a plurality of template files previously received from the payment facilitation computing system, wherein the each template file contains a plurality of data fields and logic instructions configured to modify the plurality of data fields of the template file based on the beneficiary, and wherein the plurality of data fields of each template file are configured to receive data extracted from the first database, second database, and third database; and

the payment configuration computer further configured to:
execute a payment configuration component for automatically selecting a single template file from the plurality of template files based on the beneficiary upon receiving a request to pay the beneficiary,
modify the identified template file based on determining which data fields to dynamically select based on the request for the payment,
determine which information to extract for the data fields, and
format a data field according to the logic instructions of the modified template, and
generate the payment file using the modified template file of the fourth database by completing the data fields of the modified template file configured for the beneficiary, executing the logic instructions of the template file, and then sending the payment file to the network gateway of the payor computing system for transmission to the file exchange server for processing, whereby the file exchange server validates the payment file before dissemination.

12. The system according to claim 11 , wherein the fourth database stores a first template file for credit payments and a second template file for debit payments.

13. The system according to claim 11 , wherein the template file comprises instructions for the payment configuration component to complete the data fields.

14. The system according to claim 11 , wherein the template file is used by the payment configuration component to generate a payment file for a beneficiary in a first country and a beneficiary in a second country.

15. The system according to claim 11 , wherein a first data field of the template file comprises an amount to be paid to the beneficiary, and the payment file is generated by completing the first data field using a preferred currency of the beneficiary.

16. A computer-implemented method for generating a payment file at a payor computing system containing a payment configuration computer and a network gateway, the payor computing system being remote from a payment facilitation computing system, the method comprising:
selecting, by the payment configuration computer, a template file from a plurality of template files based on a particular beneficiary to receive the payment, wherein the plurality of template files are previously received from the payment facilitation computing syste

Assignees

• Jain Manish
• Citibank Na

Inventors

• Jain Manish

Classifications

• G06Q20/10 Primary

  specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems · CPC title