Sample Inventory Reconciliation Agent

Pharmaceutical reps must account for every drug sample by lot, and gaps can trigger formal investigations. Each month this agent pulls shipments received, signed provider requests and returns, then calculates the expected on-hand quantity for each product and lot. It compares that with the rep's physical count and flags differences, missing signatures and expired lots. For each difference, it looks for a cause, such as a request logged against the wrong lot or a transfer between reps that was never recorded. After the rep corrects records, it checks again. Gaps that remain unexplained are not forced to match; they go to the rep for the company's official discrepancy process. The rep approves every correction and submits the count. Edge case: expired samples must be returned through the official process and are never counted as given out to providers.