Daily ERP Spreadsheet Imports: Separate New Receipts, Duplicates, Cancellations, and Corrections

If an ERP spreadsheet is moved into an operations system each day, what should happen when the same row appears in the next file? Should it create a new receipt? Should an earlier quantity simply be overwritten? Without a shared rule, a receipt can be counted twice or the reason for a cancellation or correction […]
