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

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

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 distr...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Lopez, Mark Edward, Keren, Gilad, McKinstray, Kent Donavan, Heine, William Arthur
Format: Patent
Sprache:eng
Schlagworte:
CALCULATING
CHECKING-DEVICES
COIN-FREED OR LIKE APPARATUS
COMPUTING
COUNTING
DATA PROCESSING SYSTEMS OR METHODS, SPECIALLY ADAPTED FORADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORYOR FORECASTING PURPOSES
ELECTRIC DIGITAL DATA PROCESSING
HANDLING RECORD CARRIERS
PHYSICS
PRESENTATION OF DATA
RECOGNITION OF DATA
RECORD CARRIERS
SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE,COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORY OR FORECASTINGPURPOSES, NOT OTHERWISE PROVIDED FOR
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung: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.