System, method, and computer program for dynamically reconciling a distributor invoice with a retailer receiving invoice for products sold under multiple UPCs and in multiple quantity units
US10134093B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Jan 22, 2016 |
| Grant date | Nov 20, 2018 |
| Priority date | — |
| Expiry date | Oct 15, 2036 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06K7/1413
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
The present disclosure describes a system, method, and computer program for dynamically reconciling a retailer receiving invoice with a distributor invoice for products sold and invoiced under multiple UPC codes and in multiple units of quantity. A retailer receiving invoice is matched to to a distributor invoice. For each line item in both invoices, the UPC, quantity, and unit-price are normalized. Invoiced UPCs are normalized to a hierarchy level in a product family a master product database. Also, invoiced unit prices are compared to upper and lower price limits for invoiced UPCs to determine whether an invoiced UPC correlates to an invoiced unit price. Quantity and unit-price are normalized by converting price-correlated units to base-level units in a product hierarchy. Normalized UPCs, quantities, and unit price are compared to match line items across invoices and discover any discrepancies. Credits are matched to discrepancies.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.