Back to results
US 10,540,655 B2Granted
Automatic reconciliation of data structures
AssigneeAriba, Inc.
InventorsChris Chase, Lingyan Zhang, Xiangqun Hu, Tanvi Shah, Vijay Chandramouli, Yuan Tung
Life of this patent
Estimating the term…
Abstract
In an example embodiment, a data structure is received and automatically reconciled with other data structures in a computer system by comparing fields such as dates, transaction amounts, and discount amounts. A user is alerted as to whether the matches or discrepancies occur by displaying a message in a user interface.
Claims20
A method of reconciling remittance advice data structures comprising:
- receiving a remittance advice data structure, the remittance advice data structure including an amount of a remittance and a date of the remittance, the receiving performed in response to an order management service having translated a requisition into a format associated with a particular supplier to which the requisition is destined and the forwarding of the requisition to the particular supplier;
- matching, using one or more hardware processors, the remittance advice data structure to a payment proposal data structure corresponding to an invoice;
- calculating, using the one or more hardware processors, a discount amount using the amount of the remittance and an amount specified in the invoice;
- comparing, using the one or more hardware processors, the discount amount to a discount specified in the payment proposal data structure to determine if the amount of the remittance matches the payment proposal data structure;
- comparing, using the one or more hardware processors, the date of the remittance to a date specified in the payment proposal data structure to determine if the date of the remittance matches the payment proposal data structure;
- causing an alert to be displayed on a graphical user interface to alert the particular supplier as to whether the amount of the remittance and the date of the remittance match the payment proposal data structure by displaying a message in the graphical user interface depicting remittance information from the remittance advice data structure;
- receiving a second remittance advice data structure, the second remittance advice data structure including an amount of a second remittance and a date of the second remittance;
- matching, using one or more hardware processors, the second remittance advice data structure to a second payment proposal data structure corresponding to a second invoice;
- calculating, using the one or more hardware processors, a second discount amount using the amount of the second remittance and an amount specified in the second invoice;
- comparing, using the one or more hardware processors, the second discount amount to a second discount specified in the second payment proposal data structure to determine if the amount of the second remittance matches the second payment proposal data structure;
- comparing, using the one or more hardware processors, the date of the second remittance to a second date specified in the second payment proposal data structure to determine if the date of the second remittance matches the second payment proposal data structure;
- in response to a determination that the amount of the second remittance matches the second payment proposal data structure and the date of the second remittance matches the second payment proposal data structure, automatically reconciling, using the one or more hardware processors, the second remittance advice data structure and the second payment proposal data structure;
- and
- displaying results of the automatic reconciliation to the particular supplier.
11 more elements
A system comprising:
- an order processing service comprising:
- one or more hardware processors;
- a catalog management service storing one or more catalogs of items offered by one or more suppliers;
- a payment proposal processor and discount management user interface configured to obtain discount amounts and terms offered by the one or more suppliers and to generate a payment proposal data structure corresponding to each discount;
- a remittance document processing component configured to receive a remittance advice from a buyer and create a remittance advice data structure corresponding to the remittance advice, the receiving performed in response to an order management service having translated a requisition into a format associated with a particular supplier to which the requisition is destined and the forwarding of the requisition to the particular supplier;
- and
- a reconciliation component executable by the one or more hardware processors and configured to:
- retrieve the remittance advice data structure, the remittance advice data structure including an amount of a remittance and a date of the remittance;
- match the remittance advice data structure to a payment proposal data structure corresponding to an invoice;
- calculate a discount amount using the amount of the remittance and an amount specified in the invoice;
- compare the discount amount to a discount specified in the payment proposal data structure to determine if the amount of the remittance matches the payment proposal data structure;
- compare the date of the remittance to a date specified in the payment proposal data structure to determine if the date of the remittance matches the payment proposal data structure;
- communicate the results of the comparing of the discount amount and the comparing of the date of the remittance to the payment proposal processor and discount management user interface;
- retrieve the remittance advice data structure;
- the remittance advice data structure including an amount of a remittance and a date of the remittance;
- match a second remittance advice data structure to a second payment proposal data structure corresponding to a second invoice;
- calculate a second discount amount using the amount of a second remittance in the second remittance advice data structure and an amount specified in the second invoice;
- compare the second discount amount to a second discount specified in the second payment proposal data structure to determine if the amount of the second remittance matches the second payment proposal data structure;
- compare the date of the second remittance in the second remittance advice data structure to a date specified in the second payment proposal data structure to determine if the date of the second remittance matches the second payment proposal data structure;
- in response to a determination that the amount of the second remittance matches the second payment proposal data structure and the date of the second remittance matches the second payment proposal data structure, automatically reconcile, by the one or more hardware processors, the second remittance advice data structure and the second payment proposal data structure;
- wherein the payment proposal processor and discount management user interface is further configured to alert the particular supplier as to whether the amount of the remittance and the date of the remittance match the payment proposal data structure by displaying a message in a graphical user interface depicting remittance information from the remittance advice data structure;
- and
- displaying results of the automatic reconciliation to the particular supplier.
20 more elements
A non-transitory machine-readable storage medium comprising instructions, which when implemented by one or more machines, cause the one or more machines to perform operations comprising:
- receiving a remittance advice data structure, the remittance advice data structure including an amount of a remittance and a date of the remittance, the receiving performed in response to an order management service having translated a requisition into a format associated with a particular supplier to which the requisition is destined and the forwarding of the requisition to the particular supplier;
- matching, using one or more hardware processors, the remittance advice data structure to a payment proposal data structure corresponding to an invoice;
- calculating, using the one or more hardware processors, a discount amount using the amount of the remittance and an amount specified in the invoice;
- comparing, using the one or more hardware processors, the discount amount to a discount specified in the payment proposal data structure to determine if the amount of the remittance matches the payment proposal data structure;
- comparing, using the one or more hardware processors, the date of the remittance to a date specified in the payment proposal data structure to determine if the date of the remittance matches the payment proposal data structure;
- causing an alert to be displayed on a graphical user interface to alert the particular supplier as to whether the amount of the remittance and the date of the remittance match the payment proposal data structure by displaying a message in the graphical user interface depicting remittance information from the remittance advice data structure;
- receiving a second remittance advice data structure, the second remittance advice data structure including an amount of a second remittance and a date of the second remittance;
- matching, using one or more hardware processors, the second remittance advice data structure to a second payment proposal data structure corresponding to a second invoice;
- calculating, using the one or more hardware processors, a second discount amount using the amount of the second remittance and an amount specified in the second invoice;
- comparing, using the one or more hardware processors, the second discount amount to a second discount specified in the second payment proposal data structure to determine if the amount of the second remittance matches the second payment proposal data structure;
- comparing, using the one or more hardware processors, the date of the second remittance to a second date specified in the second payment proposal data structure to determine if the date of the second remittance matches the second payment proposal data structure;
- in response to a determination that the amount of the second remittance matches the second payment proposal data structure and the date of the second remittance matches the second payment proposal data structure, automatically reconciling, using the one or more hardware processors, the second remittance advice data structure and the second payment proposal data structure;
- and
- displaying results of the automatic reconciliation to the particular supplier.
11 more elements
Dependencies are inferred from the claim text.