Supplier invoice reconciliation and payment using an event-driven platform

The event-driven platform automates supplier invoice reconciliation, addressing inefficiencies in traditional methods by streamlining the process and reducing errors, thereby enhancing payment processing efficiency and user experience.

JP7595600B2Active Publication Date: 2024-12-06AMERICAN EXPRESS TRAVEL RELATED SERVICES CO INC
View PDF 4 Cites 0 Cited by

Patent Information

Application Number
JP2021576657
Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
Priority Date
2019-06-28
Filing Date
2020-06-15
Publication Date
2024-12-06
Estimated Expiration
2040-06-15

AI Technical Summary

Technical Problem

Traditional invoice reconciliation methods are time-consuming, require significant user input, and are prone to errors due to their manual nature, with payment processing capacity limited by the efficiency of purchase order transmission and coordination between buyers, suppliers, and payers.

Method used

An event-driven platform that automates supplier invoice reconciliation by coordinating between purchase orders, invoices, and order confirmations, using an event-driven architecture to streamline the process and reduce manual intervention, enabling efficient and reliable payment processing.

Benefits of technology

The system significantly reduces processing time from months to days, minimizes redundant requests, and enhances user experience by simplifying message sorting and coordination, while reducing the demand on system resources and increasing network availability.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007595600000001
    Figure 0007595600000001
  • Figure 0007595600000002
    Figure 0007595600000002
  • Figure 0007595600000003
    Figure 0007595600000003
Patent Text Reader

Abstract

A system for automated supplier invoice reconciliation is disclosed. The system may receive an order confirmation associated with a purchase order (PO) from a supplier system. The system may receive the PO associated with the order confirmation from a buyer system. The system may receive a first invoice associated with the PO and the order confirmation from the supplier system. The system may reconcile between the PO, the first invoice, and the order confirmation to generate a second invoice. The system may pass the second invoice to the buyer system.
Need to check novelty before this filing date? Find Prior Art

Description

[Technical field]

[0001] CROSS-REFERENCE TO RELATED APPLICATIONS This application claims priority to, and the benefit of, co-pending U.S. patent application Ser. No. 16 / 456,203, filed Jun. 28, 2019, entitled “SUPPLIER INVOICE RECONCILIATION AND PAYMENT USING EVENT DRIVEN PLATFORM.”

[0002] The present disclosure relates generally to systems and methods for automated invoice reconciliation and payment. [Background technology]

[0003] Traditional methods for invoice reconciliation often rely on a series of purchase orders and invoices flowing between buyers and suppliers prior to payment. Technical issues exist in that payment processing capacity is limited by the efficiency of purchase order transmission between buyers, suppliers, and payers, the number of purchase orders, and the number of invoices. Furthermore, errors can be introduced due to the largely manual nature of the reconciliation process between systems. In this regard, traditional manual methods of supplier invoice analysis and reconciliation are typically time consuming, require a relatively large number of user inputs, and may not be tolerant of information errors. Summary of the Invention [Means for solving the problem]

[0004] In various embodiments, a system, method, and product (collectively, the "system") for automated supplier invoice reconciliation is disclosed. The system may receive an order confirmation associated with a purchase order (PO) from a supplier system. The system may receive a PO associated with the order confirmation from a buyer system. The system may receive a first invoice and an order confirmation associated with the PO from the supplier system. The system may reconcile between the PO, the first invoice, and the order confirmation. The system may generate a second invoice in response to the reconciliation. The system may pass the second invoice to the buyer system.

[0005] In various embodiments, the system may consume the order confirmation message and record the order confirmation in an order confirmation table. The system may post the order confirmation message to an order confirmation API of the buyer system and receive a buyer order confirmation response message. The system may update the status of the order confirmation based on the buyer order confirmation response message. The system may resend the order confirmation message to the order confirmation API in response to an error.

[0006] In various embodiments, the system compares the first invoice to the multiple invoices in the first invoice table to determine a new invoice. The system may write the first invoice to the invoice table in response to determining the new invoice. The system may fetch or receive a PO and an order confirmation. The system may match the invoice, the PO, and the order confirmation. In various embodiments, the system may read multiple line items from each of the first invoice, the PO, and the order confirmation. The system may determine a matched line item set that includes the same set of line items across each of the first invoice, the PO, and the order confirmation based on common attributes. The system may calculate a running total for the matched line item set based on item price and item quantity.

[0007] In various embodiments, the system may fetch the first invoice from the first invoice table. The system may generate a second invoice based on the PO, the first invoice, and the cumulative total. The system may pass the second invoice to an electronic invoicing API of the buyer system and receive a reply. The system may update the status of the second invoice recorded in the second invoice table based on the reply. In various embodiments, the system may generate a generate payment instruction file (PIF) message. In response to the generate PIF message, the system may generate a JSON PIF based on the first invoice and the PO. The system may pass the JSON PIF to a payment API of the system and in response may receive a payment confirmation ID. The system may associate at least one of the payment confirmation ID or the JSON PIF with the second invoice.

[0008] The foregoing features and elements may be combined in various combinations without exclusivity, unless expressly indicated otherwise herein. These features and elements and the operation of the embodiments of the present disclosure will become more apparent in view of the following description and accompanying drawings.

[0009] The subject matter of the present disclosure is particularly pointed out and distinctly claimed in the concluding portion of this specification, however, a more complete understanding of the present disclosure may be obtained by reference to the detailed description and claims when considered in conjunction with the drawings, in which like numerals refer to like elements and in which: [Brief description of the drawings]

[0010] [Figure 1] FIG. 1 is a block diagram illustrating various system components of a system for supplier invoice reconciliation, according to various embodiments.

[0011] [Diagram 2]FIG. 1 illustrates a process for order confirmation in a system for supplier invoice reconciliation, according to various embodiments.

[0012] [Diagram 3] FIG. 1 illustrates a method of invoice processing in a system for supplier invoice reconciliation, according to various embodiments.

[0013] [Figure 4] FIG. 1 illustrates a process of invoice matching in a system for supplier invoice reconciliation, according to various embodiments.

[0014] [Diagram 5] FIG. 2 illustrates an invoice generation process in a system for supplier invoice reconciliation, according to various embodiments.

[0015] [Figure 6] FIG. 1 illustrates a process for generating a payment information file in a system for supplier invoice reconciliation, according to various embodiments. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0016] The system provides a greater level of sophistication and control of the supplier invoice reconciliation process. The benefits of the present disclosure may be applied to any suitable application of invoicing and ordering systems. For example, the present disclosure may be applied in a consumer sales context, a B2B, or a logistics context. Although the present disclosure may refer to "supplier invoices," those skilled in the art will appreciate that the system may be applied to any type of invoice, bill, charge, or request.

[0017] As mentioned above, the prior art systems usually involve technical problems of payment and reconciliation time delays between buyers and suppliers, but the present system provides a technical solution by reconciling payments in the event platform. In this regard, the present system can increase the speed and efficiency of payment processing through automated reconciliation by the event platform. The present system can reduce the process time that the payment process is engaged in by the user. For example, the payment process can be reduced from a period of months or weeks to a period of days. The present system can also reduce redundant PO confirmation requests and invoices, thereby reducing the demand for system resources. The present system can enhance the user experience by simplifying message sorting, routing, and reconciliation processing and reducing the number of user interactions.

[0018] The process improves computer functionality. For example, the process increases the reliability and speed of supplier reconciliation by reducing the number of user inputs and / or by passing on several user input requirements for reconciling POs, invoices, PO confirmations, and generating payments. Similarly, the process increases the reliability and speed of data presentation by enabling automated reconciliation and invoice payment. The system may tend to increase reliability by passing on information to the system where the POs, invoices, and / or PO confirmations are reconciled. In this regard, system resources are not burdened with data that may be invalid, duplicated, or pending, thereby tending to reduce kick-out manual intervention, and / or the like. In various embodiments, the process described herein may increase network availability by reducing front-end and back-end process calls and / or network hops. The process may also save processing resources, including CPU time, memory resources, and network resources. For example, conventional systems may tend to configure separate punch-out catalogs for each legal entity, ERP, and / or marketplace to capture and reconcile POs, invoices, PO confirmations, or the like. In this regard, conventional systems tend to increase demands on processing and data resources. The process and system disclosed herein tend to enable a single punchout with a marketplace that can automatically reconcile POs, invoices, PO confirmations, and the like.

[0019] In various embodiments, and with reference to FIG. 1 , a system 100 for supplier invoice reconciliation and payment may include an event platform 102, a user device 104, a buyer system 106, a supplier system 108, and a financial institution system 110. Any of these components may be outsourced and / or may communicate with the event platform 102 via a network. The system 100 may be computer-based and may include a processor, tangible, non-transitory computer-readable memory, and / or network interfaces, along with other suitable system software and hardware components. Instructions stored in the tangible, non-transitory memory may enable the system 100 to perform various functions as described herein. In various embodiments, the event platform 102 may be configured as a central network element or hub for accessing the various systems, engines, and components of the system 100.

[0020] The system 100 may comprise an event-driven architecture, also known as a message-driven architecture, which is an architectural pattern that facilitates the production, detection, consumption, and reaction to events. An event may be defined as a significant change in state. The event-driven architecture may include event generators, event consumers, and event channels. An event generator may publish events in the form of messages and may be unaware of the consumed events. An event consumer may subscribe to the published events and be unaware of other event consumers. An event consumer may process the events in an asynchronous manner. An event channel may handle the subscription, storage, and delivery of events.

[0021] In various embodiments, the event-driven architecture may be a Kafka architecture including a consumer group including multiple event consumers and a producer group including multiple event generators. The Kafka architecture includes a Kafka cluster including multiple event brokers and a Zookeeper. The event broker may pass on messages pushed from the producer group in response to pulls from the consumer group. The Zookeeper may maintain event consumer group offsets, topic lists, leader election, and general state information. The Kafka cluster and / or the event broker may define multiple event topics, and the event generators may publish event messages to the event topics.

[0022] In various embodiments, the event platform 102 may comprise a network, computer-based system, and / or software components configured to provide access points across the buyer system 106, the supplier system 108, and the financial institution system 110 to the various systems, engines, and components of the system 100. The buyer system 106 may operate and / or electronically communicate with the user devices 104 and the event platform 102. In this regard, the event platform 102 may enable communication from the user devices 104 to the systems, engines, and components of the system 100. In various embodiments, any of the event platforms 102 may include one or more data centers, cloud storage, or the like, and may include software, e.g., APIs, configured to retrieve data from and write data to the various systems, engines, and components of the system 100.

[0023] In various embodiments, the user device 104 may comprise software and / or hardware that communicates with the buyer system 106 over a network that comprises hardware and / or software configured to enable trading account holders, users, and / or the like to access the mail event platform 102 and / or the supplier system 108. The user device 104 may comprise any suitable device configured to enable a user to communicate with the network and elements of the system 100. The user device 104 may include, for example, a personal computer, a personal digital assistant, a mobile phone, a kiosk, and / or the like, and may enable a user to send voice communications and / or electronic messages.

[0024] In various embodiments, the buyer system 106 may enable a buyer to interact with the system 100 to submit a purchase order request (i.e., a PO), view supplier quotes and financing products, complete a purchase, and / or the like. The buyer system 106 may comprise any suitable combination of hardware, software, and / or database components. For example, the buyer system 106 may comprise at least one computing device in the form of a computer or processor, or a set of computers / processors, although other types of computing units or systems may be used, such as, for example, a server, a web server, a pooled server, or the like. The buyer system 106 may also include one or more data centers, cloud storage, or the like, and may include software, e.g., an API, configured to retrieve and write data to the event platform 102. In various embodiments, the buyer system 106 may include one or more processors and / or one or more tangible, non-transitory memories and may be capable of implementing logic. The processor may be configured to perform various logical operations in response to execution of instructions, for example instructions stored on a non-transitory, tangible, computer-readable medium, as discussed further herein.

[0025] Although this disclosure refers to a buyer system 106, it should be understood that the principles of this disclosure may be applied to a supplier invoice reconciliation and payment system having any suitable number of supplier systems interconnected to the event platform 102.

[0026] In various embodiments, the supplier system 108 may enable sellers to interact with the system 100 to obtain and view purchase order requests, submit quotes, complete buyer orders, and / or the like. The supplier system 108 may comprise any suitable combination of hardware, software, and / or database components. For example, the supplier system 108 may comprise at least one computing device in the form of a computer or processor, or a set of computers / processors, although other types of computing units or systems, e.g., servers, web servers, pooled servers, or the like, may be used. The supplier system 108 may also include one or more data centers, cloud storage, or the like, and may include software, e.g., APIs, configured to obtain and write data to the blockchain. In various embodiments, the supplier system 108 may include one or more processors and / or one or more tangible, non-transitory memories and may have the capability of implementing logic. The processor may be configured to perform various logical operations in response to execution of instructions, e.g., instructions stored on a non-transitory, tangible, computer-readable medium, as discussed further herein. Supplier system 108 may also include any suitable number of back-end systems for performing item inventory, transaction processing, item shipping and / or delivery, and / or the like.

[0027] Although this disclosure refers to supplier system 108, it should be understood that the principles of this disclosure may be applied to a supplier invoice reconciliation and payment system having any suitable number of supplier systems interconnected to the event platform 102.

[0028] In various embodiments, the financial institution system 110 can interact with the system 100 to obtain and view POs, payment authorizations, invoices, supplier quotes, and / or the like, submit financing products, send payments to complete buyer orders, and / or the like. The financial institution system 110 can comprise any suitable combination of hardware, software, and / or database components. For example, it can comprise one or more network environments, servers, computer-based systems, processors, databases, and / or the like. The financial institution system 110 can comprise at least one computing device in the form of a computer or processor, or a set of computers / processors, although other types of computing units or systems, e.g., servers, web servers, pooled servers, or the like, can be used. The financial institution system 110 can also include one or more data centers, cloud storage, or the like, and can include software, e.g., APIs, configured to obtain and write data to the event platform 102. In various embodiments, financial institution system 110 may include one or more processors and / or one or more tangible, non-transitory memories and may be capable of implementing logic. The processors may be configured to perform various logical operations in response to execution of instructions, e.g., instructions stored on a non-transitory, tangible, computer-readable medium, as discussed further herein.

[0029] In various embodiments, the financial institution system 110 may include or interact with the event platform 102 to facilitate purchases and payments, authorize transactions, and / or settle transactions. For example, the financial institution system 110 may represent an existing proprietary network that currently accepts credit card, debit card, and / or other types of transaction accounts or transaction instruments. The financial institution system 110 may be a closed network that is protected from eavesdroppers. In various embodiments, the financial institution system 110 may include exemplary transaction networks such as AMERICAN EXPRESS®, VISANET®, MASTER CARD®, DISCOVER®, INTERAC®, Cartes Bancaires, JCB®, private networks (e.g., department store networks), and / or any other payment network. The financial institution system 110 may include systems and databases related to financial and / or transaction systems and processes, such as, for example, one or more approval engines, authentication engines and databases, settlement engines and databases, account receivable systems and databases, account payable systems and databases, and / or the like. For example, the financial institution system 110 may authorize and settle payment transactions, maintain a transaction account member database, an account receivable database, an account payable database, or the like. In various embodiments, the financial institution system 110 may include an issuer system, an acquirer system, a payment processor, and / or the like.

[0030] Although this disclosure refers to a financial institution system 110, it should be understood that the principles of this disclosure may be applied to a supplier invoice reconciliation and payment system having any suitable number of supplier systems interconnected to the event platform 102.

[0031] Referring to FIG. 2, a process 200 of order confirmation in a system for supplier invoice reconciliation and payment (e.g., in the system 100) is shown. The buyer system 106 may generate a purchase order (PO) 201 and pass the PO 201 to the supplier system 108 (step 202). Step 202 includes displaying a supplier catalog on the user device 104 via a buyer catalog punchout. Step 202 includes constructing the PO 201 via the buyer catalog punchout. For example, constructing the PO may include selecting multiple stock numbers from the buyer catalog punchout. In various embodiments, the buyer system 106 may pass the PO 201 to the supplier system 108 via a commerce extensible markup language (cXML) protocol. Those skilled in the art will appreciate that any suitable protocol may be used to pass data files between various modules of the system 100. In response to receiving the PO 201, the supplier system 108 may post a cXML PO confirmation to the order confirmation API 206 of the event platform 102 (step 204). In various embodiments, the cXML PO confirmation message may include or be associated with the PO 201. For example, the cXML PO confirmation message may be associated with the PO 201 via a PO number. In response to receiving the cXML PO confirmation message, the order confirmation API 206 may post the cXML PO confirmation message to the order confirmation topic 208 of the Kafka architecture (step 210).

[0032] The order confirmation consumer 212 may consume the cXML PO confirmation message from the order confirmation topic 208 (step 214). In response to consuming the cXML PO confirmation message, the order confirmation consumer 212 records the order confirmation in the order confirmation table 216 (step 218). In various embodiments, the event platform 102 may be configured to pass the order confirmation to the buyer system 106. The order confirmation consumer 212 may post the order confirmation message to the order confirmation post topic 220 (step 222). The order confirmation post API consumer 224 may read the order confirmation message from the order confirmation post topic 220 (step 226). The order confirmation post API consumer 224 may post the order confirmation message to the order confirmation API 228 of the buyer system 106 (step 230). The order confirmation post API consumer 224 may receive a buyer order confirmation response message from the order confirmation API 228 and, in response, may update the status of the order confirmation recorded in the order confirmation table 216 (step 232). For example, step 232 may include setting an order confirmation received flag in the order confirmation. The process 200 includes determining whether the order confirmation was successfully posted to the order confirmation API 228 of the buyer system 106, and if not, posting the order confirmation to the order confirmation topic 208 (step 234). In this regard, the process may recycle at step 214, thereby tending to resend the order confirmation to the buyer system 106 and ensure receipt of the order confirmation. For example, the system may resend an XML PO confirmation message to the order confirmation API 228 in response to a buyer order confirmation response message indicating an error.

[0033] In various embodiments, and with additional reference to FIG. 3, a process 300 of invoice processing in a system for supplier invoice reconciliation and payment is shown. In response to receiving the PO 201, the supplier system 108 may generate an invoice 301 (i.e., a first invoice) in a cXML protocol. In response to generating the invoice 301, the supplier system 108 may post a cXML invoice message including the invoice 301 to an invoice API 302 of the event platform 102 (step 304). The invoice API 302 may check whether the invoice 301 is a duplicate invoice by comparing the invoice 301 to invoices stored in an invoice table 306 (step 308). In response to determining that the invoice is not a duplicate invoice, the invoice API 302 posts the cXML invoice message to a new / reprocess invoice topic 310 (step 312). The process invoice consumer 314 receives the invoice 301 by consuming the cXML invoice message from the new / reprocess invoice topic 310 (step 316). In response to consuming the cXML invoice message, the process invoice consumer 314 writes the invoice 301 to the invoice table 306 (step 318). In other words, the system may determine that the invoice 301 is a new invoice and, in response, writes the invoice 301 to the invoice table 306. In various embodiments, the event platform 102 may be configured to fetch the purchase order 201 from the buyer system 106. The process invoice consumer 314 may invoke a get PO API 320 of the buyer system 106 and, in response, receive the PO 201 (step 322). The get PO API 320 may return a cXML or XML PO. The process invoice consumer 314 may, in response to receiving the PO 201, write the PO 201 to a purchase order table 324 (step 326).

[0034] The process invoice consumer 314 may verify that the invoice 301 is associated with the PO 201 and / or the order confirmation (step 328). Step 328 may include, for example, reading the order confirmation table 216 and matching the invoice 301 with the order confirmation based on the PO number and the invoice number. Step 328 may include matching the PO 201 with the invoice 301 based on the PO number and the invoice number. Step 328 may include determining the invoice as valid if the PO number, invoice number, and order confirmation number match. The PO number and associated ancillary fields correspond across the PO, the order confirmation, and the invoice. In this context, the PO number may match across all documents. Thus, the system may verify the invoice 301 by association with the PO 201 and the order confirmation. In response to determining the invoice 301 as a valid invoice, the process invoice consumer 314 may post an invoice to begin matching topic 330 to the invoice to begin matching message associated with the invoice 301 (step 332). In various embodiments, the process invoice consumer 314 may generate an error message and responsively update the invoice table 306 (step 334). Step 334 may include, for example, flagging the invoice 301 as invalid if none of the PO number, invoice number, and order confirmation number match. In various embodiments, the system may periodically and / or asynchronously republish an invoice message containing the invoice to the new / reprocess invoice topic 310 where the invoice has not been inserted into the invoice table 306 or is verified by association with a PO (step 336).

[0035] In various embodiments and with additional reference to FIG. 4, a process 400 of invoice matching in a system for supplier invoice reconciliation and payment is shown. An initiating matching consumer 402 subscribes to the topic initiating matching products 330 and consumes the initiating matching products message associated with an invoice 301 to trigger the matching process (step 404). The initiating matching consumer 402 fetches the invoice 301 from the invoice table 306 (step 406). The initiating matching consumer 402 fetches the associated order confirmation from the order confirmation table 216 (step 408). The initiating matching consumer 402 fetches the associated PO 201 from the purchase order table 324 (step 410). In various embodiments, the PO 201, invoice 301, and order confirmation each may include structured data, such as XML or cXML, that includes line items associated with the purchase. Each line item may include various attributes associated with the item, such as, for example, an item number, an item price, an item quantity, and / or the like. In various embodiments, a line item may be associated with a purchase by, for example, a stock number, a stock keeping unit (SKU), an item number, and / or the like. The initiating matching consumer 402 may pass each of the PO 201, the invoice 301, and the order confirmation to the matching module 412 of the event platform 102.

[0036] The matching module 412 of the event platform 102 may determine 414 a matched line item set that includes the same set of line items across each of the PO 201, the invoice 301, and the order confirmation. Step 414 may include the matching module 412 comparing each of the line items of the PO 201, the invoice 301, and the order confirmation to determine, for each line item, a match across the line items of the respective PO 201, the invoice 301, and the order confirmation. For example, the PO 201 may include a first line item associated with a first quantity and a first price. In various embodiments, the matching module 412 may align and / or match the line items in the respective PO 201, the invoice 301, and the order confirmation based on a common attribute, such as one of a SKU, an item number, and / or a stock number. Step 414 may include the matching module 412 searching through a number of line items of each invoice 301 and order confirmation to verify that each invoice 301 and order confirmation includes a line item having a first amount and a first price. Step 414 may include comparing respective attributes of each matched line item to verify that each PO 201, invoice 301, and order confirmation includes the same set of line items and associated attributes. In this regard, the system may reconcile between the PO 201, invoice 301, and order confirmation associated with the PO 201. In various embodiments, the matching module 412 may calculate a credit (e.g., a negative payment amount). For example, the matching module 412 may process a sign conversion (from positive to negative or vice versa) of the invoice and / or payment instruction, thereby processing both payments and credits. In various embodiments, the payment amount or credit may be calculated based on the invoice and the included invoice type lookup code.

[0037] For each matched line item, the system may calculate a running total for the matched line item based on item price and item quantity (step 416). In various embodiments, there may be a many-to-one relationship between invoices and POs and / or order confirmations. In this regard, a running total may be calculated by matching line items across multiple invoices. Step 416 includes inserting a running total for each matched line item into a running total table 418. In response to generating a matched line item set that includes the same set of line items across each PO 201, invoice 301, and order confirmation, the matching module 412 publishes the items for which an electronic invoice message is to be generated to an items for which an invoice topic is to be generated 420 (step 422). The matching module 412 may invoke exception handling 424 when a mismatch is determined between any of the line items of the PO 201, invoice 301, and order confirmation (step 426).

[0038] With further reference to FIG. 5, in various embodiments, a process 500 of invoice generation in a system for supplier invoice reconciliation and payment is shown. An electronic invoice generation consumer 502 subscribes to the product for which an invoice topic is to be generated 420 and consumes the product for which an electronic invoice message is to be generated to trigger the invoice generation process (step 504). The electronic invoice generation consumer 502 fetches the invoice 301 from the invoice table 306 (step 506). The electronic invoice generation consumer 502 fetches the associated PO 201 from the purchase order table 324 (step 508). The electronic invoice generation consumer 502 may pass the PO 201 and the invoice 301 to an invoice generation module 510 of the event platform 102. The invoice generation module 510 may generate a second invoice based on the PO 201 and the invoice 301 (step 512). Step 512 may include reading the running total table 418 and generating a second invoice based on the PO 201, the invoice 301, and the running total. In response to generating the second invoice, the invoice generation module 510 may send an item to post invoice message to an item to post invoice topic 514 (step 516).

[0039] The e-invoice post consumer 518 subscribes to the product to post invoice topic 514 and consumes the product to post invoice message to recover the second invoice (step 520). The e-invoice post consumer 518 may pass the second invoice to the e-invoice issuing API 522 of the buyer system 106 (step 524). The e-invoice post consumer 518 may receive a reply from the e-invoice issuing API 522 and, in response, may update the status of the second invoice recorded in the e-invoice table 526 (step 232). Step 232 may include recording the second invoice in the e-invoice table 526. In various embodiments, the reply from the e-invoice issuing API 522 may indicate a failure to pass the second invoice and the system may resend the product to post invoice message to the product to post invoice topic 514 (step 528). In this regard, process 500 may recycle at step 520 thereby tending to resend the second invoice to the buyer system 106 and ensure receipt of the second invoice.

[0040] With further reference to FIG. 6, a process 600 of payment instruction file (PIF) generation in a system for supplier invoice reconciliation and payment is shown in various embodiments. An asynchronous PIF publisher 602 may periodically generate a PIF generation message and post the PIF generation message to a product to be generated PIF topic 604 (step 601). A PIF generation initiation consumer 606 subscribes to the product to be generated PIF topic 604 and consumes the product to be generated PIF message to trigger the PIF generation process (step 608). The PIF generation consumer 606 fetches the invoice 301 from the invoice table 306 (step 610). The PIF generation consumer 606 fetches the associated PO 201 from the purchase order table 324 (step 612). The PIF generation consumer 606 may pass the PO 201 and the invoice 301 to a PIF generation module 614 of the event platform 102. The PIF generation module 614 generates a JSON PIF message (step 617) that includes the PIF based on the PO 201 and the invoice 301. The PIF generation module 614 sends the JSON PIF message to the product 616 to post the PIF topic (step 618).

[0041] The PIF post consumer 620 subscribes to the product 616 to be posted to the PIF topic and consumes the JSON PIF message to trigger the PIF post process (step 622). The PIF post consumer 620 may call a payment API 624 of the system 100 (e.g., the buyer system 106, the financial institution system 110, or the event platform 102) and receive a payment confirmation ID (step 626). Step 626 may include passing the PIF to the event platform 102 via the payment API 624 and receiving a reply in response that includes the payment confirmation ID. The PIF post consumer 620 updates the state of the PIF recorded in the e-invoice table 526 (step 628). Step 628 may include recording the PIF and the payment confirmation ID in the e-invoice table 526 and associating the PIF and the payment confirmation ID with the second invoice. In various embodiments, a reply from the payment API 624 may indicate a failure to pass the PIF and the system may resend the JSON PIF message to the item 616 to post the PIF topic (step 630). In this regard, the process 600 may recycle at step 622 thereby tending to resend the PIF and ensure receipt of the PIF and the payment confirmation ID. In various embodiments, the event platform 102 may pass the payment confirmation ID to the financial institution system 110.

[0042] The detailed description of the various embodiments herein refers to the accompanying drawings and pictures, which illustrate the various embodiments by way of illustration. Although these various embodiments are described in sufficient detail to enable those skilled in the art to practice the present disclosure, it should be understood that other embodiments may be realized and that logical and mechanical changes may be made without departing from the spirit and scope of the present disclosure. Thus, the detailed description herein is presented for purposes of illustration and not limitation. For example, any described steps of a method or process may be performed in any order and are not limited to the order presented. Furthermore, any of the functions or steps may be outsourced to or performed by one or more third parties. Modifications, additions, or omissions may be made to the systems, devices, and methods described herein without departing from the scope of the present disclosure. For example, components of the systems and devices may be integrated or separated. Furthermore, the operations of the systems and devices disclosed herein may be performed by more, fewer, or other components, and the methods described herein may include more, fewer, or other steps. In addition, steps may be performed in any suitable order. As used herein, "each" refers to each member of a set or each member of a subset of a set. Additionally, any reference to a singular form may include a plural embodiment, and any reference to a plural component may include a singular embodiment. Although certain advantages have been enumerated herein, various embodiments may include some, all, or none of the enumerated advantages.

[0043] Systems, methods and computer program products are provided. In the detailed description herein, references to "various embodiments," "one embodiment," "one embodiment," "exemplary embodiment," and the like indicate that the described embodiment may include a particular feature, structure, or characteristic, but not every embodiment necessarily includes that particular feature, structure, or characteristic. Moreover, such phrases do not necessarily refer to the same embodiment. Moreover, when a particular feature, structure, or characteristic is described with respect to one embodiment, it is believed to be within the knowledge of one skilled in the art that such feature, structure, or characteristic is affected with respect to other embodiments, whether or not explicitly stated. After reading this description, it will be apparent to one skilled in the art how to implement the present disclosure in alternative embodiments.

[0044] As used herein, "meets," "conforms," ​​"matches," "relate to," or similar expressions may include an exact match, a partial match, meeting certain criteria, matching a subset of data, a correlation, fulfilling certain criteria, a correspondence, an association, an algorithmic relationship, and / or the like. Similarly, as used herein, "authenticate" or similar terms may include exact authentication, partial authentication, authentication of a subset of data, a correspondence, fulfilling certain criteria, an association, an algorithmic relationship, and / or the like.

[0045] Terms and phrases similar to "associate" and / or "related" may include, for example, tagging, flagging, association, use of look-up tables, or any other method or system for indicating or creating a relationship between elements such as (i) transaction accounts and (ii) items (e.g., offers, rewards, discounts) and / or digital channels. Furthermore, association may occur at any point in response to any suitable action, event, or time period. Association may occur at predefined intervals, periodically, randomly, once, multiple times, or in response to a suitable request or action. Any information may be distributed and / or accessed via software-enabled links, which may be sent via email, text, post, social network entry, and / or any other method known in the art.

[0046] The term "non-transitory" should be understood to exclude from the claims only the conveying of the transitory signal itself, and does not disclaim any claim to all standard computer-readable media that do not merely convey the transitory signal itself.

[0047] Benefits, other advantages, and solutions to problems have been described herein with respect to specific embodiments. However, those benefits, advantages, solutions to problems, and any elements that may cause or make any benefit, advantage, or solution more pronounced should not be construed as critical, necessary, or essential features or elements of the disclosure. Thus, the scope of the disclosure should not be limited by anything other than the appended claims, and references to elements in the singular in the appended claims are not intended to mean "sole" unless so expressly stated, but rather "one or more." Furthermore, when "at least one of A, B, and C" or similar language such as "at least one of A, B, or C" is used in the claims or specification, it is intended to be interpreted to mean that A may be present alone in an embodiment, B may be present alone in an embodiment, C may be present alone in an embodiment, or any combination of elements A, B, and C may be present in a single embodiment, e.g., A and B, A and C, B and C, or A and B and C. It is contemplated that the present disclosure includes methods, which may be embodied as computer program instructions in a tangible computer readable carrier, e.g., a magnetic or optical memory or a magnetic or optical disk. Moreover, it is not necessary for a device or method to address each and every problem sought to be solved by the present disclosure in order to be encompassed by the present claims. Moreover, no element, component, or method step in the present disclosure is dedicated to the public, regardless of whether such element, component, or method step is expressly recited in the claims. As used herein, the terms "comprises," "comprising," or any other variations thereof, are intended to include a non-exclusive inclusion, such that a process, method, article, or apparatus that includes a list of elements does not include only those elements, but may include other elements not expressly listed or inherent to such process, method, article, or apparatus.

[0048] Computer programs (also referred to as computer control logic) are stored in the main memory and / or the secondary memory. Computer programs may also be received via a communications interface. Such computer programs, when executed, enable the computer system to perform the features as discussed herein. In particular, the computer programs, when executed, enable the processor to perform the features of the various embodiments. Thus, such computer programs represent the controller of the computer system.

[0049] These computer program instructions may be loaded into a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the instructions that execute on the computer or other programmable data processing apparatus produce means for performing the functions specified in one or more blocks of the flowchart. These computer program instructions may also be stored in a computer readable memory that can instruct the computer or other programmable data processing apparatus to function in a particular manner, such that the instructions that execute on the computer or other programmable data processing apparatus produce steps for performing the functions specified in one or more blocks of the flowchart. The computer program instructions may also be loaded into a computer or other programmable data processing apparatus to cause the computer or other programmable data processing apparatus to perform a series of operation steps to produce a computer implemented process, such that the instructions that execute on the computer or other programmable data processing apparatus produce steps for performing the functions specified in one or more blocks of the flowchart.

[0050] In various embodiments, the software can be stored in a computer program product and loaded into a computer system using a removable storage drive, a hard disk drive, or a communications interface. The control logic (software), when executed by a processor, causes the processor to perform the functions of the various embodiments as described herein. In various embodiments, the hardware components may take the form of application specific integrated circuits (ASICs). Implementations of hardware state machines to perform the functions described herein will be apparent to those skilled in the art.

[0051] Those skilled in the art will appreciate that the system may be implemented as an existing system, an add-on product, a processing device executing upgraded software, a standalone system, a distributed system, a method, a data processing system, a device for data processing, and / or a custom computer program product. Thus, any part of the system or modules may take the form of a processing device executing code, an internet-based embodiment, a fully hardware embodiment, or an embodiment combining internet, software, and hardware aspects. Furthermore, the system may take the form of a computer program product with a computer readable storage medium having computer readable program code means embodied in the storage medium. Any suitable computer readable storage medium may be used, including hard disks, CD-ROMs, BLU-RAY DISCs, optical storage devices, magnetic storage devices, and / or the like.

[0052] The present systems and methods may be described herein in terms of functional block components, screen shots, option selections, and various processing steps. It is to be understood that such functional blocks may be realized by any number of hardware and / or software components configured to perform the specified functions. For example, the present systems may use various integrated circuit components, such as memory elements, processing elements, logic elements, look-up tables, and the like, that may perform various functions under the control of one or more microprocessors or other control devices. Similarly, the software elements of the system may be implemented in any programming or scripting language, such as C, C++, C#, JAVA, JAVASCRIPT, JAVASCRIPT Object Notation (JSON), VBScript, Macromedia Cold Fusion, COBOL, MICROSOFT Active Server Pages, Assembly, PERL, PHP, Oak, PYTHON, Visual Basic, SQL stored procedures, PL / SQL, any UNIX shell script, and Extensible Markup Language (XML) with various algorithms implemented in any combination of data structures, objects, processes, routines, or other programming elements. Additionally, it is noted that the system may use any number of conventional techniques for data transmission, signaling, data processing, network control, and the like. Additionally, the system may be used to detect or prevent security issues in client-side scripting languages, such as JAVASCRIPT, VBScript, or the like.

[0053] The present systems and methods are described herein with reference to screen shots, block diagrams, and flow diagram illustrations of methods, apparatus, and computer program products according to various embodiments. It will be understood that each functional block of the block diagrams and flow diagram illustrations, and combinations of functional blocks in the block diagrams and flow diagram illustrations, respectively, can be implemented by computer program instructions.

[0054] Thus, the functional blocks of the block and flow diagram illustrations support combinations of means for performing the specified functions, combinations of steps for performing the specified functions, and program instruction means for performing the specified functions. It will also be understood that each functional block of the block and flow diagram illustrations, and combinations of functional blocks in the block and flow diagram illustrations, may be implemented by dedicated hardware-based computer systems that perform the specified functions or steps, or by appropriate combinations of dedicated hardware and computer instructions. Furthermore, the process illustrations and descriptions thereof may refer to user WINDOWS®, web pages, websites, web forms, prompts, and the like. Those skilled in the art will appreciate that the illustrated steps described herein may be included in any number of configurations, including the use of WINDOWS® applications, web pages, web forms, pop-up WINDOWS® applications, prompts, and the like. It will also be understood that the multiple steps as illustrated and described may be combined into a single web page and / or WINDOWS® application, but have been expanded for simplicity. In other cases, steps illustrated and described as steps of a single process may be separated into multiple web pages and / or WINDOWS® applications, but have been combined for simplicity.

[0055] In various embodiments, the software elements of the system may also be implemented using a JAVASCRIPT® runtime environment configured to execute JAVASCRIPT® code outside of a web browser. For example, the software elements of the system may also be implemented using a NODE.JS® component. The NODE.JS® program may implement several modules to handle various core functions. For example, a package management module, such as NPM®, may be implemented as an open source library to help organize the installation and management of third-party NODE.JS® programs. NODE.JS® may also implement a process manager, such as Parallel Multithreaded Machine ("PM2"), resource and performance monitoring tools, such as Node Application Metrics ("appmetrics"), library modules for building user interfaces, and / or any other suitable and / or desired modules.

[0056] Middleware may include any hardware and / or software suitably configured to facilitate communication and / or process transactions between different computing systems. Middleware components are commercially available and known in the art. Middleware may be implemented through commercially available hardware and / or software, through custom hardware and / or software components, or through a combination thereof. Middleware may exist in a variety of configurations, may exist as a stand-alone system, or may be a software component residing on an Internet server. Middleware may be configured to process transactions between various components of an application server and any number of internal or external systems for any of the purposes disclosed herein. WEBSPHERE® MQ™ (formerly MQ Series) by IBM®, Inc. (Armonk, NY) is one example of a commercially available middleware product. Enterprise Service Bus ("ESB") applications are another example of middleware.

[0057] The computers discussed herein may provide suitable web sites or other Internet-based graphical user interfaces accessible by users. In one embodiment, MICROSOFT Corporation's Internet Information Services (IIS), Microsoft Transaction Server (MTS) services, and SQL SERVER database are used in conjunction with the MICROSOFT operating system, WINDOWS NT web server software, SQL SERVER database, and MICROSOFT commerce server. In addition, components such as ACCESS software, SQL SERVER database, ORACLE software, SYBASE software, INFORMIX software, MYSQL software, INTERBASE software, and the like may be used to provide an Active Data Object (ADO)-enabled database management system. In one embodiment, the APACHE® web server is used in conjunction with the LINUX® operating system, a MYSQL® database, and the PERL®, PHP, RUBY, and / or PYTHON® programming languages.

[0058] For the sake of brevity, conventional data networking, application development, and other functional aspects of the present system (and components of the individual operating components of the present system) may not be described in detail herein. Moreover, the connecting lines shown in the various figures contained herein are intended to represent example functional relationships and / or physical couplings between the various elements. It should be noted that many alternative or additional functional relationships or physical connections may exist in an actual system.

[0059] In various embodiments, the methods described herein are performed using various specific machines described herein. Those skilled in the art will readily appreciate that the methods described herein may be implemented using the specific machines described below, and those developed below, in any suitable combination. Furthermore, as will be apparent from this disclosure, the methods described herein may result in various modifications of certain items.

[0060] The various system components discussed herein may include one or more of the following: a host server or other computing system including a processor for processing digital data, a memory coupled to the processor for storing digital data, an input digitizer coupled to the processor for inputting digital data, application programs stored in the memory and accessible by the processor to direct the processing of the digital data by the processor, a display device coupled to the processor and the memory for displaying information derived from the digital data processed by the processor, and a plurality of databases. As used herein, the various databases may include the following: customer data, merchant data, financial institution data, and / or similar data useful in the operation of the system. Those skilled in the art will appreciate that a user computer may include an operating system (e.g., WINDOWS, UNIX, LINUX, SOLARIS, MACOS, etc.), as well as various conventional support software and drivers typically associated with a computer.

[0061] The system, or any portion or function thereof, may be implemented using hardware, software, or a combination thereof, and may be implemented in one or more computer systems or other processing systems. However, operations performed by the embodiments have often been referred to in terms such as matching or selecting, which commonly relate to intellectual operations performed by a human operator. Such capabilities of a human operator are not required, and in most cases are undesirable, in any of the operations described herein. Instead, the operations may be machine operations, or any of the operations may be performed or enhanced by artificial intelligence (AI) or machine learning. Artificial intelligence may generally refer to the learning of agents (e.g., machines, computer-based systems, etc.) to perceive the world around them, make plans, and make decisions to achieve their goals. Fundamentals of AI include mathematics, logic, philosophy, probability theory, linguistics, neuroscience, and decision theory. Numerous fields fall under the umbrella of AI, e.g., computer vision, robotics, machine learning, and natural language processing. Useful machines for performing various embodiments include general purpose digital computers or similar devices.

[0062] In various embodiments, the embodiments are directed to one or more computer systems capable of performing the functions described herein. The computer system includes one or more processors. The processors are connected to a communications infrastructure (e.g., a communications bus, cross-over bar, or network). Various software embodiments are described in terms of this exemplary computer system. After reading this specification, it will become apparent to one of ordinary skill in the art how to implement various embodiments using other computer systems and / or architectures. The computer system may include a display interface that transfers graphics, text, and other data from the communications infrastructure (or from a frame buffer, not shown) for display on a display device.

[0063] The computer system also includes a main memory, e.g., random access memory (RAM), and may also include a secondary memory, which may include, for example, a hard disk drive, a solid state drive, and / or a removable storage drive, which reads from and / or writes to the removable storage device in well-known fashion. It will be understood that a removable storage device includes a computer usable storage medium having computer software and / or data stored thereon.

[0064] In various embodiments, secondary memory may include other similar devices for allowing computer programs or other instructions to be loaded into a computer system. Such devices may include, for example, removable storage devices and interfaces. Examples of such may include program cartridges and cartridge interfaces (e.g., those found in video game devices), removable memory chips (e.g., erasable programmable read-only memories (EPROMs), programmable read-only memories (PROMs), etc.) and associated sockets that allow software and data to be transferred from removable storage devices to a computer system, or other removable storage devices and interfaces.

[0065] The computer system may also include a communications interface. The communications interface allows software and data to be transferred between the computer system and external devices. Examples of communications interfaces may include a modem, a network interface (such as an Ethernet card), a communications port, and the like. The software and data transferred through the communications interface are in the form of signals, which may be electronic, electromagnetic, optical, or other signals that can be received by the communications interface. These signals are provided to the communications interface over a communications path (e.g., a channel). The channel carries the signals and may be implemented using wire, cable, optical fiber, telephone line, cellular link, radio frequency (RF) link, wireless, and other communications channels.

[0066] In various embodiments, the server may include an application server (e.g., WEBSPHERE®, WEBLOGIC®, JBOSS®, POSTGRES PLUS ADVANCED SERVER®, etc.). In various embodiments, the server may include a web server (e.g., APACHE, IIS, GOOGLE® Web Server, SUN JAVA® System Web Server, JAVA® Virtual Machine running on a LINUX® or WINDOWS® operating system).

[0067] A web client includes any device or software that communicates over any network, such as any device or software discussed herein. A web client may include Internet browsing software installed in a computing unit or system to perform online transactions and / or communications. These computing units or systems may take the form of a computer or set of computers, although other types of computing units or systems may be used, including personal computers, laptops, notebooks, tablets, smart phones, mobile phones, personal digital assistants, servers, pooled servers, mainframe computers, distributed computing clusters, kiosks, terminals, point of sale (POS) devices or terminals, televisions, or any other device capable of receiving data over a network. A web client may include an operating system (e.g., WINDOWS®, WINDOWS MOBILE® operating system, UNIX® operating system, LINUX® operating system, APPLE® OS® operating system, etc.), as well as various conventional support software and drivers typically associated with a computer. The web client may also run MICROSOFT® INTERNET EXPLORER® SOFTWARE, MOZILLA® FIREFOX® SOFTWARE, GOOGLE® CHROME® SOFTWARE, APPLE® SAFARI® SOFTWARE, or any other of the wide variety of software packages available for browsing the Internet.

[0068] Those skilled in the art will appreciate that a web client may or may not be in direct contact with a server (e.g., an application server, a web server, etc., as described herein). For example, a web client may access the services of a server through another server and / or hardware component, which may have a direct or indirect connection to an Internet server. For example, a web client may communicate with a server through a load balancer. In various embodiments, a web client accesses a network or the Internet through a commercially available web browser software package. In that regard, a web client may be in a residential or corporate environment with access to a network or the Internet. A web client may implement security protocols such as Secure Sockets Layer (SSL) and Transport Layer Security (TLS). A web client may implement several application layer protocols, including HTTP, HTTPS, FTP, and SFTP.

[0069] Any of the communication, input, storage, database, or display discussed herein may be facilitated through a website having a web page. The term "web page" as used herein is not intended to limit the types of documents and applications that may be used to interact with a user. For example, a typical website may include, in addition to standard HTML documents, various forms, JAVA® applets, JAVASCRIPT® programs, active server pages (ASP), common gateway interface scripts (CGI), extensible markup language (XML), dynamic HTML, cascading style sheets (CSS), Asynchronous JAVASCRIPT And XML (AJAX) programs, helper applications, plug-ins, and the like. The server may include a web service that receives a request from a web server, the request including the URL and IP address (192.168.1.1). The web server retrieves the appropriate web page and sends the web page data or application to the IP address. A web service is an application that has the ability to interact with other applications over a communication medium such as the Internet. Web services are usually based on standards or protocols such as XML, SOAP, AJAX, WSDL, and UDDI. Web service methods are well known in the art and are covered in many standard texts. For example, representational state transfer (REST), or RESTful, web services may provide one way to enable interoperability between applications.

[0070] The Web client computing unit may further comprise an Internet browser connected to the Internet or an intranet using standard dial-up, cable, DSL, or any other Internet protocol known in the art. Transactions initiated at the Web client may pass through a firewall to prevent unauthorized access from users of other networks. Additionally, additional firewalls may be deployed between various components of the CMS to further enhance security.

[0071] Encryption may be performed using any of the techniques currently available or that may become available in the art, such as Twofish, RSA, El Gamal, Schnorr signatures, DSA, PGP, PKI, GPG (GnuPG), HPE Format-Preserving Encryption (FPE), Voltage, Triple DES, Blowfish, AES, MD5, HMAC, IDEA, RC6, and symmetric and asymmetric cryptosystems. The systems and methods may also include SHA-series cryptography methods, Elliptic Curve Cryptography (e.g., ECC, ECDH, ECDSA, etc.), and / or other later quantum cryptography algorithms in development.

[0072] Any database discussed herein may include a relational, hierarchical, graphical, block chain, or object-oriented structure, and / or any other database organization. Any database may also include a flat file structure, in which data may be stored in a single file in rows and columns without indexing structure or structural relationships between records. For example, a flat file structure may include a delimited text file, a CSV (comma separated values) file, and / or any other suitable flat file structure. Common database products that may be used to implement the database include DB2® by IBM® (Armonk, NY), various database products available from ORACLE® Corporation (Redwood Shores, CA), MICROSOFT ACCESS® or MICROSOFT SQL SERVER® by MICROSOFT® Corporation (Redmond, WA), MYSQL® by MySQL AB (Uppsala, Sweden), MONGODB®, Redis, APACHE CASSANDRA®, HBASE® by APACHE®, MapR-DB by MAPR®, or any other suitable database product. Furthermore, the database may be organized in any suitable manner, such as, for example, as a data table or a lookup table. Each record may be a single file, a series of files, a linked series of data fields, or any other data structure.

[0073] Association of certain data may be accomplished via any desired data association technique, such as those known and practiced in the art. For example, association may be accomplished manually or automatically. Automatic association techniques may include, for example, database lookup, database join, GREP, AGREP, SQL, using key fields in tables to speed up searches, sequential search through all tables and files, sorting records in files according to a known order to simplify searches, and / or the like. The association step may be accomplished by a database join function, for example, using "key fields" in preselected databases or data sectors. Various database tuning steps are undertaken to optimize database performance. For example, frequently used files such as indexes may be placed in separate file systems to reduce input / output (In / Out, "I / O") bottlenecks.

[0074] More specifically, the "key fields" divide the database according to high-level classes of objects defined by the key fields. For example, a particular type of data may be designated as a key field in multiple related data tables, and the data tables may then be linked based on the type of data in the key field. It is preferred that the data corresponding to the key field in each linked data table is the same or of the same type. However, data tables having similar, but not identical, data in key fields may also be linked, for example, by using AGREP. According to an embodiment, any suitable data storage technique may be used to store the data without a standard format. For example, the data sets may be stored using any suitable technique, including storing individual files using the ISO / IEC 7816-4 file structure, implementing a domain where a dedicated file is selected that exposes one or more base files containing one or more data sets, using data sets stored in individual files using a hierarchical filing system, data sets stored as records in a single file (including compressed, hashed via one or more keys, numbers, alphabets, accessible SQL, etc. by first tuple), data stored as Binary Large Objects (BLOBs), data stored as ungrouped data elements encoded using ISO / IEC 7816-6 data elements, data stored as ungrouped data elements encoded using ISO / IEC Abstract Syntax Notation (ASN.1) such as in ISO / IEC 8824 and 8825, fractal compression methods, image compression methods, and other dedicated techniques which may include.

[0075] In various embodiments, the ability to store a wide variety of information in different formats is facilitated by storing the information as a BLOB. Thus, any binary information may be stored in a storage area associated with a data set. As previously described, the binary information may be stored in association with the system or externally but in conjunction with the system. The BLOB method may store the data set as ungrouped data elements formatted as a binary block via a fixed memory offset using either fixed storage allocation, circular queue techniques, or best practices for memory management (e.g., paged memory, least recently used, etc.). By using the BLOB method, the ability to store various data sets having different formats facilitates the storage of data in a database or associated with the system by multiple unrelated owners of the data sets. For example, a first data set that may be stored may be provided by a first party, a second data set that may be stored may be provided by an unrelated second party, and a third data set that may be stored may be provided by a third party unrelated to the first and second parties. Each of these three exemplary data sets may contain different information that is stored using different data storage formats and / or techniques. Additionally, each data set may contain a subset of data that may differ from the other subsets.

[0076] As previously mentioned, in various embodiments, data may be stored without regard to a common format. However, data sets (e.g., blobs) may be annotated in a standard manner when provided to manipulate the data in a database or system. The annotations may include a short header, trailer, or other suitable indicator for each data set configured to convey information useful for managing the various data sets. For example, the annotations may be referred to herein as "condition headers," "headers," "trailers," or "states," and may include an indication of the state of the data set, or may include an identifier that correlates to a particular publisher or owner of the data. In one example, the first three bytes of each data set blob may be configured or configurable to indicate the state of that particular data set: for example, loaded, initialized, ready, blocked, removable, or deleted. Subsequent bytes of data may be used to indicate, for example, an identification of the publisher, user, transaction / member account identifier, or the like. Each of these state annotations is discussed further herein.

[0077] Data set annotations may also be used for other types of status information as well as various other purposes. For example, a data set annotation may include security information that establishes access levels. The access levels may be configured, for example, to allow only certain individuals, levels of employees, companies, or other entities to access the data set, or to allow access to certain data sets based on transaction, merchant, issuer, user, or the like. Additionally, the security information may restrict / allow only certain actions, such as accessing, modifying, and / or deleting the data set. In one example, a data set annotation may indicate that only the owner or user of the data set is permitted to delete the data set, various specified users may be permitted to access the data set to read, and all others are precluded from accessing the data set. However, other access restriction parameters may also be used to allow various entities to access the data set with various permission levels, as desired.

[0078] The data, including the header or trailer, may be received by a stand-alone interaction device configured to add, delete, modify, or extend the data in accordance with the header or trailer. As such, in one embodiment, the header or trailer is not stored on the transaction device along with the associated issuer-proprietary data, but instead, appropriate action may be taken by providing a user at the stand-alone device with appropriate options for the action to be taken. The system may contemplate a data storage arrangement where the header or trailer of the data, or the header or trailer history, is stored in the system, device, or transaction vehicle with respect to the appropriate data.

[0079] Those skilled in the art will further appreciate that for security reasons, any database, system, device, server or other component of the system may be configured in a single location or in any combination thereof in multiple locations, and each database or system may include any of a variety of appropriate security features, such as, for example, firewalls, access codes, encryption, decryption, compression, decompression, and / or the like.

[0080] Practitioners will also appreciate that there are several ways to display data in a browser-based document. Data may be represented as standard text or in fixed lists, scrollable lists, drop-down lists, editable text fields, fixed text fields, pop-up windows, and the like. Additionally, there are several ways available to modify data in a web page, such as, for example, free text entry using the keyboard, selection of menu items, check boxes, option boxes, and the like.

[0081] The distributed computing cluster may be, for example, a HADOOP® software cluster configured to process and store big data sets with some of the nodes including a distributed storage system and some of the nodes including a distributed processing system. In that regard, the distributed computing cluster may be configured to support the HADOOP® software Distributed File System (HDFS) as specified by the Apache Software Foundation at www.hadoop.apache.org / docs.

[0082] As used herein, the term "network" includes any cloud, cloud computing system, or electronic communication system or method that encompasses hardware and / or software components. Communication between the parties may be accomplished via any suitable communication channel, such as a telephone network, an extranet, an intranet, the Internet, point-of-interaction devices (such as point-of-sale devices, personal digital assistants (e.g., IPHONE® devices, BLACKBERRY® devices), mobile phones, kiosks, etc.), online communications, satellite communications, offline communications, wireless communications, transponder communications, local area networks (LANs), wide area networks (WANs), virtual private networks (VPNs), networked or linked devices, keyboards, mice, and / or any suitable communication or data entry modalities. Additionally, although the system is often described herein as being implemented with TCP / IP communication protocols, the system may also be implemented using IPX, APPLETALK®, IP-6, NetBIOS, OSI, any tunneling protocol (e.g., IPsec, SSH, etc.), or any number of existing or future protocols. When a network is in the nature of a public network, e.g., the Internet, it may be advantageous to consider the network insecure and open to eavesdroppers. Specific information relating to protocols, standards, and application software used in connection with the Internet is generally known to those skilled in the art and, therefore, need not be detailed herein.

[0083] "Cloud" or "cloud computing" includes a model for enabling convenient, on-demand network access to a shared pool of configurable computing resources (e.g., networks, servers, storage, applications, and services) that can be rapidly provisioned and released with minimal administrative effort or service provider interaction. Cloud computing may include location-independent computing whereby shared servers provide resources, software, and data to computers and other devices on demand.

[0084] As used herein, "transmitting" may include sending electronic data from one system component to another over a network connection. Additionally, as used herein, "data" may include encompassing information, such as commands, queries, files, data for storage, and the like, in digital or any other form.

[0085] Expressions similar to "payment processor" may include a company (e.g., a third party) appointed (e.g., by a merchant) to handle a transaction. A payment processor may include an issuer, acquirer, approver, and / or any other system or entity involved in the transaction process. Payment processors may be classified into two types: front-end and back-end. A front-end payment processor has connections to various transaction accounts and provides authorization and settlement services to merchants at the merchant bank. A back-end payment processor accepts settlements from the front-end payment processor and, via the Federal Reserve Bank, transfers funds from the issuing bank to the merchant bank. In an operation that would normally take a few seconds, both payment processors check the details received by forwarding the details to the issuing bank or card association of the respective account for verification and may implement a series of anti-fraud measures on the transaction. Additional parameters, including the issuing country of the account and its previous payment history, may be used to assess the probability that the transaction will be approved. In response to the payment processor receiving confirmation that the transaction account details have been verified, the information may be relayed back to the merchant who may then complete the payment transaction. In response to verification being denied, the payment processor relays information to the merchant who may then decline the transaction.

[0086] A "payment gateway" or similar expressions may include application service provider services that accept payments for electronic businesses, online retailers, and / or traditional brick-and-mortar merchants. A gateway may be the equivalent of a physical point-of-sale terminal found in most retail stores. A payment gateway may protect transaction account details by encrypting sensitive information, such as transaction account numbers, to ensure that information passes securely between the customer and the merchant, and also between the merchant and the payment processor.

Claims

1. receiving, by the computer-based system, an order confirmation from a supplier system, the order confirmation relating to a purchase order (PO); receiving, by the computer-based system, the PO associated with the order confirmation from a buyer system; receiving, by the computer-based system, a first invoice associated with the PO and the order confirmation from the supplier system; reconciling, by the computer-based system, between the PO, the first invoice, and the order confirmation; The adjustment is verifying that the PO, the first invoice, and the order confirmation have the matched line item sets based at least in part on a comparison of respective attributes for each item in the matched line item sets; calculating a running total for the matched line itemsets based at least in part on item prices and item quantities; Including, generating, by the computer-based system, a second invoice based at least in part on the cumulative total of the matched line item sets and the validation of the matched line item sets; transmitting the second invoice to the buyer system by the computer-based system; A method comprising:

2. consuming an order confirmation message by said computer-based system and recording said order confirmation in an order confirmation table; posting said order confirmation message to an order confirmation API of said buyer system by said computer-based system and receiving a buyer order confirmation response message; updating, by said computer-based system, a status of said order confirmation based on said buyer order confirmation response message; resending, by the computer-based system, the order confirmation message to the order confirmation API in response to an error; The method of claim 1 further comprising:

3. comparing the first invoice with a plurality of invoices in a first invoice table by the computer-based system to determine a new invoice; writing, by the computer-based system, the first invoice to the first invoice table in response to determining the new invoice; fetching the PO and the order confirmation by the computer-based system; matching the first invoice, the PO, and the order confirmation by the computer-based system; The method of claim 2 further comprising:

4. The step of generating a second invoice includes: fetching, by the computer-based system, the first invoice from the first invoice table; passing the second invoice to an electronic invoicing API of the buyer system by the computer-based system and receiving a reply; updating, by the computer-based system, a status of the second invoice recorded in a second invoice table based on the reply; The method of claim 1 further comprising:

5. generating a generate payment instruction file (PIF) message by said computer-based system; generating, by the computer-based system, a PIF based on the first invoice and the PO in response to the generate PIF message; passing the PIF by the computer-based system to a payment API and receiving a payment confirmation ID in response; associating the second invoice with at least one of the payment confirmation ID or the PIF by the computer-based system; The method of claim 4 further comprising:

6. A processor; a tangible, non-transitory memory configured to communicate with the processor and responsive to execution by the processor to: receiving, by said processor, from a supplier system, an order confirmation relating to a purchase order (PO); receiving, by the processor, the PO associated with the order confirmation from a buyer system; receiving, by the processor, a first invoice associated with the PO and the order confirmation from the supplier system; reconciling, by the processor, between the PO, the first invoice, and the order confirmation; The adjustment is verifying that the PO, the first invoice, and the order confirmation have the matched line item sets based at least in part on a comparison of respective attributes for each item in the matched line item sets; calculating a running total for the matched set of line items based at least in part on item prices and item quantities; Equipped with generating, by the processor, a second invoice in response to the adjustment; and passing said second invoice to said buyer system by said processor. the tangible, non-transitory memory having instructions stored thereon that cause the processor to perform operations including: A system comprising:

7. consuming an order confirmation message by said processor and recording said order confirmation in an order confirmation table; posting, by said processor, said order confirmation message to an order confirmation API of said buyer system and receiving a buyer order confirmation response message; updating, by said processor, a status of said order confirmation based on said buyer order confirmation response message; retransmitting, by the processor, the order confirmation message to the order confirmation API in response to an error; The system of claim 6 further comprising:

8. comparing, by the processor, the first invoice to a plurality of invoices in a first invoice table to determine a new invoice; writing, by the processor, the first invoice to the first invoice table in response to determining the new invoice; fetching, by the processor, the PO and the order confirmation; matching the first invoice, the PO, and the order confirmation by the processor; The system of claim 7 further comprising:

9. reading, by the processor, a plurality of line items from each of the first invoice, the PO, and the order confirmation; determining, by the processor, matched line item sets that include the same set of line items across each of the first invoice, the PO, and the order confirmation based on common attributes; calculating, by said processor, a running total for said matched line item sets based on item prices and item quantities; The system of claim 8 further comprising:

10. Generating the second invoice includes: fetching, by the processor, the first invoice from the first invoice table; passing the second invoice by the processor to an electronic invoicing API of the buyer system and receiving a reply; updating, by the processor, a status of the second invoice recorded in a second invoice table based on the reply; The system of claim 9 further comprising:

11. generating, by said processor, a generate payment instruction file (PIF) message; in response to the generate PIF message, generating an IF by the processor; passing the PIF by the processor to a payment API and receiving a payment confirmation ID in response; associating, by the processor, at least one of the payment confirmation ID or the PIF with the second invoice; The system of claim 9 or 10, further comprising:

12. The system of any one of claims 6 to 11, further comprising a Kafka architecture.

13. receiving, by a computer-based system, an order confirmation associated with a purchase order (PO) from a supplier system; receiving, by the computer-based system, the PO associated with the order confirmation from a buyer system; receiving, by the computer-based system, a first invoice associated with the PO and the order confirmation from the supplier system; reconciling, by the computer-based system, between the PO, the first invoice, and the order confirmation; The adjustment is verifying that the PO, the first invoice, and the order confirmation have the matched line item sets based at least in part on a comparison of respective attributes for each item in the matched line item sets; calculating a running total for the matched set of line items based at least in part on item prices and item quantities; Including, generating, by the computer-based system, a second invoice based at least in part on the cumulative total of the matched line item sets and the validation of the matched line item sets; transmitting the second invoice to the buyer system via the computer-based system; a non-transitory, tangible, computer-readable storage medium having stored thereon instructions that, in response to execution by the computer-based system, cause the computer-based system to perform operations including:

14. consuming an order confirmation message by said computer-based system and recording said order confirmation in an order confirmation table; posting the order confirmation message to an order confirmation API of the buyer system by the computer-based system and receiving a buyer order confirmation response message; updating, by said computer-based system, a status of said order confirmation based on said buyer order confirmation response message; resending, by the computer-based system, the order confirmation message to the order confirmation API in response to the error; 14. The article of manufacture of claim 13 further comprising:

15. comparing the first invoice with a plurality of invoices in a first invoice table by the computer-based system to determine a new invoice; writing, by the computer-based system, the first invoice to the first invoice table in response to determining the new invoice; fetching the PO and the order confirmation by the computer-based system; matching the first invoice, the PO, and the order confirmation by the computer-based system; 15. The article of manufacture of claim 14 further comprising:

16. reading, by the computer-based system, a plurality of line items from each of the first invoice, the PO, and the order confirmation; determining, by the computer-based system, matched line item sets that include the same set of line items across each of the first invoice, the PO, and the order confirmation based on common attributes; calculating, by said computer-based system, a cumulative total for said matched line item sets based on item prices and item quantities; 16. The article of manufacture of claim 15 further comprising:

17. fetching, by the computer-based system, the first invoice from the first invoice table; generating, by the computer-based system, the second invoice based on the PO, the first invoice, and the cumulative total; passing the second invoice to an electronic invoicing API of the buyer system by the computer-based system and receiving a reply; updating, by the computer-based system, a status of the second invoice recorded in a second invoice table based on the reply; and 20. The article of manufacture of claim 16 further comprising:

18. generating a generate payment instruction file (PIF) message by said computer-based system; generating, by the computer-based system, a PIF based on the first invoice and the PO in response to the generate PIF message; passing the PIF by the computer-based system to a payment API and receiving a payment confirmation ID in response; associating the second invoice with at least one of the payment confirmation ID or the PIF by the computer-based system; 20. The article of manufacture of claim 17 further comprising:

19. 19. The article of manufacture of any one of claims 13 to 18, further comprising a Kafka architecture.

Citation Information

Patent Citations

  • Information processing system and data communicating method therefor

    JP1995013903A

  • Manage / track public resource consumption and bill payments

    JP2001525575A

  • Device and method for preparing invoice, recording medium, program, terminal and invoice preparation system

    JP2003085420A

  • Examination execution device, examination execution method, and examination execution program

    JP2020201729A