Order-resource fulfillment and management system and approach

• US 7,693,791 B2
• Filed: 06/09/2005
• Issued: 04/06/2010
• Est. Priority Date: 06/09/2004
• Status: Expired due to Fees

• Current Assignee: Syncada LLC (US Bancorp)
• Original Assignee: Syncada LLC (US Bancorp)
• Inventors: Hahn-Carlson, Dean W., Suits, David A., Kanathur, Raghunandan N.
• Primary Examiner(s): CHEUNG, MARY DA ZHI WANG
• Application Number:
  US11/151,748
• Publication Number:
  US 20060015455A1
• Time in Patent Office: 1,762 Days
• Field of Search: 705/26, 705/29, 705 39- 40, 705/44, 707 1- 6, 725/1
• 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
• CPC Class Codes: G06Q 30/04 Billing or invoicing
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03
• CPC Class Codes: G06Q 40/12 Accounting

Abstract

Historical data is used to manage and authorize payment for merchant offerings for transactions among a plurality of transaction parties. According to an example embodiment of the present invention, invoiced item quantities are processed using historical fulfilled and billed quantities of each item. If invoiced item quantities involved items that have been fulfilled but not billed, payment for the invoiced items is authorized. If some or all of the invoiced items have not been fulfilled or have been previously billed, payment authorization is withheld for at least the portion of unfulfilled or previously billed (and paid) invoiced items. With this approach, historical information relative to order fulfillment and payment status is used to automatically process invoices (e.g., audit the invoices for payment).

Claims

1. A transaction-processing system for managing payment resources for a plurality of transactions involving merchant offerings among parties including buyers and sellers, different ones of the plurality of transactions involving different sets of buyer and seller parties, the system comprising:

a data storage arrangement configured, for each of the plurality of transactions, to store data characterizing historical fulfillment quantities and historical billed quantities of ordered items that have been received; and

a computer arrangement configured and programmed, for each ordered item listed on an invoice for each of the plurality of transactions, to

associate the invoice with one of the plurality of transactions,

in response to a difference between a quantity of ordered item for which payment is requested on the invoice and the historical data for the ordered item in the data storage arrangement,

using the difference as a basis to generate electronic pre-payment reconciliation data for each ordered item listed on the invoice, and thereby generating the reconciliation data based on the quantity of the ordered item listed on the invoice and the difference, and

update historical billed quantities for the ordered item as characterized in the data stored in the data storage arrangement as a function of the quantity of the ordered item in the invoice.

2. The system of claim 1, wherein

the computer arrangement is configured and programmed to, in response to the billed quantity of the ordered item on the invoice being more than the difference for the ordered item in the data storage arrangement as defined by at least one previously-received invoice specifying a billed quantity of the ordered item, identify the quantity of the particular ordered item on the invoice that exceeds the difference as over-billed.

3. The system of claim 2, wherein the computer arrangement is configured and programmed to generate electronic pre-payment reconciliation data for a quantity of the particular ordered item on the invoice that does not exceed the difference.

4. The system of claim 3, wherein the computer arrangement is configured and programmed to communicate a quantity of over-billed items on the invoice to the seller party to which over-billed items apply.

5. The system of claim 1, wherein the computer arrangement is configured and programmed to receive information confirming fulfillment of a particular item for an order and to automatically update the historical fulfillment quantity data in the data storage arrangement for the particular item to reflect the confirmed fulfillment information.

6. The system of claim 1, wherein the computer arrangement is configured and programmed to:

monitor changes made to selected data fields in the data storage arrangement; and

in response to a change in one of the selected data fields for a buyer-defined electronic document indicating a received quantity, update another related data field for a seller-defined electronic invoice by modifying a line item field in the invoice to reflect the change in the selected data field in the buyer-defined electronic document, thereby performing pre-payment reconciliation between data fields stored for each of a buyer and a seller involved in a transaction.

7. The system of claim 6, wherein the computer arrangement is configured and programmed to automatically link related accounting data fields for a particular transaction as a function of a transaction party to which the related data fields apply, and in response to a change in an accounting data field for one of a buyer and seller involved in a transaction, update a linked accounting data field for the other one of the buyer and the seller.

8. The system of claim 1, wherein the computer arrangement is configured and programmed to compare information in each invoice with profile information stored in the databank to match the invoice with historical fulfillment and billed quantities and to use the matched historical fulfillment and billed quantities when generating electronic pre-payment reconciliation data for each ordered item listed on the invoice.

9. The system of claim 1, wherein the data storage arrangement is configured to store transaction-profile attributes for each transaction, the transaction-profile attributes including information for identifying order information for the transaction and at least one of a buyer and a seller involved with the transaction, wherein the computer arrangement is configured and programmed to generate electronic pre-payment reconciliation data for each ordered item listed on the invoice as a function of the transaction-profile attributes.

10. The system of claim 9, wherein the computer arrangement is configured and programmed to monitor changes in a transaction-profile attribute that indicates the fulfillment status of an order and, in response to changes in the fulfillment status of a particular order, update other transaction-profile attributes that relate to the fulfillment status for the particular order.

11. The system of claim 10, wherein the computer arrangement is configured and programmed to update transaction-profile attributes including payment-related attributes in response to a particular order being fulfilled.

12. The system of claim 10, wherein the computer arrangement is configured and programmed to facilitate payment for the particular order in response to an update to payment-related attributes for the particular order indicating that payment is appropriate.

13. The system of claim 1, wherein the computer arrangement is configured and programmed to generate electronic pre-payment reconciliation data for each ordered item listed on the invoice as a function of a billed quantity of the ordered item on the invoice and the difference for the ordered item as indicated in the data stored in the data storage arrangement by comparing billed quantity information for the ordered item on the invoice with the historical fulfillment and billed quantity information for the ordered item as indicated in the data stored in the data storage arrangement.

14. The system of claim 13, wherein the data storage arrangement is configured, for each of the plurality of transactions, to store data characterizing a paid quantity for ordered items of the transaction and wherein the computer arrangement is configured and programmed, in response to pre-payment data being generated, to update the data characterizing the paid quantity for the ordered items in the data storage arrangement.

15. The system of claim 1, wherein the computer arrangement is configured and programmed to audit and validate the stored data characterizing historical fulfillment quantities as a function of receipt data, thereby validating that received quantity resources have been added to the historical fulfillment quantities.

16. The system of claim 1, wherein the data storage arrangement is configured to store data characterizing historical fulfillment and billed quantities for ordered items of the transaction on a line item by line item basis and wherein the computer arrangement is configured and programmed to generate pre-payment data therefor and update said historical billed quantities on a line item by line item basis.

17. The system of claim 1, wherein the computer arrangement is configured and programmed to update historical fulfillment data in the data storage arrangement as a function of the time of delivery of an ordered item.

18. The system of claim 1, wherein the computer arrangement is configured and programmed to update historical fulfillment data in the data storage arrangement as a function of the condition of the ordered item upon delivery thereof.

19. The system of claim 1, wherein

the sets of buyer and seller parties include, for a particular one of the transactions, a supplier seller that supplies goods to an intermediary seller that sells the supplied goods to a buyer, and

the computer arrangement is configured and programmed to generate data to authorize payment, from the intermediary seller to the supplier seller, for each ordered item listed on an invoice presented from the supplier seller to the intermediary seller as a function of monitored received-item data fields bearing data indicating ordered items that have been received by the buyer.

20. The system of claim 1, wherein the computer arrangement is configured and programmed to

use configuration data to define data elements of electronic documents to be used to automatically relate data fields in the documents to received-item fields that identify a number of received items for each buyer,

update the received-item data fields to modify a total number of received items based upon the related data field of the electronic documents, and

generate data to authorize payment for each ordered item based upon the total number of received ones of the ordered items as indicated in the received-item data fields.

21. The system of claim 1, wherein the computer arrangement is configured and programmed to

for each of a multitude of buyers, monitor changes in buyer-input data fields that respectively depict quantities of particular items that have been received by the buyer, and update received-item data fields to identify a number of each specific item that have been received for each buyer,

for each invoice depicting a quantity of a specific item ordered by a buyer and for which a seller is requesting payment,

retrieve stored data from the received-item data fields to identify a number of the specific items that the buyer has received,

retrieve stored data that identifies a number of the specific items for which the computer arrangement has generated data to authorize payment to the seller on behalf of the buyer,

subtract the number of the specific items that have been received from the number of the specific items for which the computer arrangement has generated data to authorize payment, to determine a number of unpaid items,

in response to the number of specific items depicted in the invoice being less than or equal to the determined number of unpaid items, generate data to authorize payment for all of the specific items depicted in the invoice, and

in response to the quantity of the specific item depicted in the invoice being greater than the determined number of unpaid items, generate data to authorize payment for the determined number of unpaid items.

22. The system of claim 1, wherein the computer arrangement is configured and programmed, for each of a multitude of buyers, to

monitor changes in buyer-input data fields that depict a received number for each of a plurality of different items,

in response to the monitored changes, update received-item data fields for each item to specify a total number of each item that has been received by the buyer,

store data depicting a number of the received items for which payment has been indicated as being authorized, and

for each ordered item listed on at least one invoice received during a billing cycle defined by stored business rules for the buyer, generate data to authorize payment for an ordered number of the items based upon a difference between the total number of the items received by the buyer and the number of items for which payment had been indicated as being authorized prior to the billing cycle.

23. A method for automatically managing payment resources for a plurality of transactions involving merchant offerings among parties including buyers and sellers, the method comprising:

operating a computer processor, for each of the plurality of transactions, to perform the steps of

associate invoice data with a particular one of the transactions as a function of data in the invoice and stored transaction-profile information; and

in response to a difference between a quantity of ordered item for which payment is requested on the invoice and the historical data for the ordered item in the data storage arrangement,

using the difference as a basis to generate electronic pre-payment reconciliation data for authorizing payment from a buyer to a seller for seller-invoiced item quantities based on

fulfilled quantity data indicating items that have been fulfilled by the seller for the transaction, and

historical data for the item, the historical data being indicative of a portion of the total item quantity that has been previously-billed.

24. The method of claim 23, further including generating pre-payment data for payment of at least a portion of the seller-invoiced item quantities that does not exceed the difference.

25. The method of claim 24, wherein generating electronic pre-payment reconciliation data includes generating data for authorizing payment for at least a portion of the fulfilled quantity of the seller-invoiced item quantities that does not exceed an order total quantity for the item.

26. The method of claim 23, further comprising:

in response to electronic payment authorization data for seller-invoiced item quantities, storing data indicating the quantity of the item for which payment was indicated as being authorized.

27. The method of claim 23, further comprising operating a computer processor for:

in response to receiving item quantity receipt data from a buyer for a particular transaction, associating the receipt data with a particular one of the transactions for seller-invoiced item quantities as a function of the transaction-profile information, and updating historical fulfillment data for the associated transaction indicating the quantity of the item indicated in the receipt data.

28. A method for managing payment resources for a plurality of transactions involving merchant offerings among parties including buyers and sellers, different ones of the plurality of transactions involving different sets of buyer and seller parties, the method comprising:

operating a computer processor to perform the steps of,

for each of the plurality of transactions, storing historical data characterizing historical fulfillment quantities and historical billed quantities of ordered items, the historical fulfillment quantities representing a quantity of the ordered items that have been received; and

for each of the ordered items listed on an invoice for each of the plurality of transactions,

associating the invoice with one of the plurality of transactions;

in response to a difference between a quantity of ordered item for which payment is requested on the invoice and the historical data for the ordered item,

using the difference as a basis to generate electronic pre-payment reconciliation data for each ordered item listed on the invoice, and thereby generating the reconciliation data based on the quantity of the ordered item listed on the invoice and the difference, and

updating historical billed quantities for the ordered item as characterized in the data stored in the data storage arrangement as a function of the quantity of the ordered item in the invoice.