Fdc Sales Mis -
“Yes sir, forty scripts. I saw them myself. She wrote them in front of me.”
Arjun did something unorthodox. He opened the raw SQL database behind the MIS—the tables the dashboards were built on. He wrote a query to join prescriber data with patient redemption data with stockist return data . Then he looked at the time stamps.
On days when the company ran high-intensity sales blitzes, primary sales spiked—but redemption data showed no corresponding increase . In fact, on those days, the system recorded a suspiciously high number of prescriptions written after 9 PM , which was impossible because most clinics closed by 7. Fdc Sales Mis
Arjun walked to the data entry cubicle. A young woman named Pooja was manually uploading scanned prescription forms from field force. He asked to see the originals for Dr. Iyengar’s forty scripts from week one.
Someone was entering fake prescriptions into the system to game the CRM. “Yes sir, forty scripts
“Rajesh gave me these,” she whispered. “He said, ‘Just enter them. The system will never know. The expiry dates are old anyway.’”
A pause. “Sir, she said the combination gave some patients palpitations. She switched to separate molecules.” He opened the raw SQL database behind the
“And week three?”
And in the MIS, that whisper would never appear.
But who? A rep desperate to meet target? A stockist colluding with a retailer? Or the MIS itself—not the software, but the people who controlled what data entered it.
“Primary sales are strong,” his boss had said in the morning review. “But secondary is dead. The product is leaving our warehouse but not moving off pharmacy shelves.”