Method and system for processing transactions

• US 8,326,754 B2
• Filed: 12/30/2004
• Issued: 12/04/2012
• Est. Priority Date: 02/05/2001
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Bandych, David W., Marron, John T., Hoffmeyer, Mark, Barnes, Michael J., Dawson, Tim, Hanson, Paul
• Primary Examiner(s): OBEID, FAHD A
• Application Number:
  US11/028,489
• Publication Number:
  US 20050177507A1
• Time in Patent Office: 2,896 Days
• Field of Search: 705/30
• US Class Current: 705/40
• CPC Class Codes: G06Q 20/10 specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
• CPC Class Codes: G06Q 20/102 Bill distribution or payments

Abstract

A system and method are provided for processing transactions between at least one buying company and at least one selling company using a central datastore accessible to users from the buying company and selling company. Purchase order and invoice data are obtained and compared to identify a matched record having purchase order data and corresponding invoice data. A collaborative data set in the central datastore is created, based in part on the matched record and storing in the datastore detailed settlement data regarding settlement of the matched record of purchase order data and corresponding invoice data. A complete settlement transaction history is stored by providing for storage of additional settlement data in the central datastore, wherein credit memos, debit memos regarding the invoice, the purchase order of the matched record, and/or other documents related to the transaction are stored as part of the collaborative data set.

Claims

1. A method of processing transactions between at least one buying company and at least one selling company which results in creation of a new collaborative data set, the method comprising:

providing a central datastore accessible to a user from at least one buying company and a user from at least one selling company;

obtaining, via a computer network, purchase order data having at least one entry, the purchase order data including purchase order header information and purchase order detail information;

obtaining, via a computer network, invoice data having at least one entry, the invoice data including invoice header information and invoice detail information;

sorting the purchase order data corresponding to one or more purchase orders into a plurality of hierarchical logical groups using one or more user-defined parameters, each logical group having a subset of purchase order data;

sorting the invoice data corresponding to one or more invoices into the plurality of hierarchical logical groups using one or more user-defined parameters, each logical group having a subset of invoice data;

determining, via a computer, a matched record having corresponding purchase order data and invoice data based in part on the sorted purchase order data and the sorted invoice data using the plurality of hierarchical logical groups and a plurality of matching rules;

identifying a set of purchase orders corresponding to the determined purchase order data of the matched record;

identifying a set of invoices corresponding to the determined matched record invoice data;

creating a collaborative data set in the central datastore based in part on the matched record and storing detailed settlement data in the datastore regarding settlement of the matched record of purchase order data and corresponding invoice data;

providing for storage of additional settlement data in the central datastore, wherein credit memos and debit memos regarding one of the invoice and the purchase order of the matched record are stored as part of the collaborative data set;

receiving into the datastore an indication of a dispute regarding the purchase order data and the corresponding invoice data;

storing as part of the collaborative data set supporting images and documentation related to the dispute from one of the at least one buying company and at least one selling company, wherein the supporting images and documentation are accessible to the users from both the at least one buying company and the at least one selling company; and

reconciling in the datastore the transaction using the matched record.

2. The method of claim 1 wherein:

the transaction is reconciled using only data and documents captured and stored in the datastore as part of the collaborative data set.

3. The method of claim 1 wherein:

documents, memos, images, files, notes, and correspondence related to the financial settlement of a transaction are captured and linked together in the datastore.

4. The method of claim 1 wherein:

the datastore includes an original payment decision, original payment deduction, dispute requests, supporting documentation, and subsequent credits and debits entered until both at least one buying company and at least one selling company are satisfied with the final settlement.

5. The method of claim 1 wherein:

information brought into the datastore is then shared between both at least one buying company and at least one selling company for a single source of data for the transaction.

6. The method of claim 1, further comprising allowing the at least one buying company and the at least one selling company access to selected data in the datastore by providing a web page accessible by the at least one buying company and a web page accessible by the at least one selling company via a global computer network.

7. The method of claim 1, wherein the purchase order header information comprises a purchase order number, a client identification, a vendor identification, and a purchase order date.

8. The method of claim 7, wherein the purchase order detail information comprises the purchase order header information, a quantity ordered for each purchase order entry, an item identification for each purchase order entry, a unit price for each purchase order entry, and a charge code for each purchase order entry.

9. The method of claim 1, wherein the invoice header information comprises an invoice number, a client identification, a vendor identification, and an invoice date.

10. The method of claim 9, wherein the invoice detail information comprises the invoice header information;

a quantity shipped for each invoice entry;

an item identification for each invoice entry; and

an extended price for each invoice entry.

11. The method of claim 1, wherein the obtaining purchase order data comprises obtaining the purchase order data in electronic format.

12. The method of claim 11, wherein the obtaining purchase order data further comprises obtaining the purchase order data via a global computer network.

13. The method of claim 1, wherein the obtaining invoice data comprises obtaining the invoice data in electronic format.

14. The method of claim 13, wherein the obtaining invoice data further comprises obtaining the invoice data via a global computer network.

15. The method of claim 1, wherein the obtaining purchase order data comprises obtaining the purchase order data in paper format.

16. The method of claim 15, further comprising converting the purchase order data to electronic format.

17. The method of claim 1, wherein the obtaining invoice data comprises obtaining the invoice data in paper format.

18. The method of claim 17, further comprising converting the invoice data to electronic format.

19. The method of claim 18, wherein the obtaining invoice data is conducted by a party other than the buying company or the selling company.

20. The method of claim 1, wherein the determining the matched record is performed automatically using a computer.

21. The method of claim 1 wherein:

the transaction is reconciled using only data and documents captured and stored in the datastore as part of the collaborative data set.

22. The method of claim 1 further comprising:

users from the at least one buying company reviewing additional settlement data added by users from the at least one selling company;

users from the at least one selling company reviewing additional settlement data added by users from the at least one buying company; and

repeating the reviewing the additional settlement data added by users from the at least one buying company and users from the at least one selling company until a final settlement is reached.

23. The method of claim 1, wherein a single platform is provided for handling all transactions for trade settlement.

25. The method of claim 1 further comprising:

determining the matched record using a set of user-defined matching rules.

26. The method of claim 1 wherein the matched record is determined using an iterative analysis of the plurality of hierarchical logical groups.

24. A method of processing transactions between at least one buying company and at least one selling company which results in creation of a new collaborative data set, the method comprising:

providing a central datastore accessible to a user from the at least one buying company and a user from the at least one selling company;

obtaining, via a computer network, purchase order data having at least one entry, the purchase order data including purchase order header information and purchase order detail information;

obtaining, via a computer network, invoice data having at least one entry, the invoice data including invoice header information and invoice detail information;

sorting the purchase order data corresponding to one or more purchase orders into a plurality of hierarchical logical groups using one or more user-defined parameters, each logical group having a subset of purchase order data;

sorting the invoice data corresponding to one or more invoices into the plurality of hierarchical logical groups using one or more user-defined parameters, each logical group having a subset of invoice data;

determining, via a computer, a matched record having corresponding purchase order data and invoice data based in part on the sorted purchase order data and the sorted invoice data using the plurality of hierarchical logical groups;

identifying a set of purchase orders corresponding to the determined purchase order data of the matched record;

identifying a set of invoices corresponding to the determined matched record invoice data;

creating a collaborative data set in the central datastore based in part on the matched record;

receiving into the datastore an indication of a dispute regarding the purchase order data and the corresponding invoice data;

storing as part of the collaborative data set supporting images and documentation related to the dispute from one of the at least one buying company and at least one selling company, wherein the supporting images and documentation are accessible to the users from both the at least one buying company and the at least one selling company; and

reconciling the transaction using the matched record.