Distribution management
Pharmaceutical wholesale and agency distribution
ASP.NET MVC on SQL Server
Several principal suppliers, hundreds of product agencies, stock that has to be tracked by batch and expiry, and returns settled against credit notes months after the goods went out. A general accounting package with a stock module attached does not survive contact with this trade.
- Every movement carries a batch and an expiry date: purchase, sale, free issue, customer return and return to supplier alike. Stock takes set the baseline and the system carries it forward.
- Free-of-charge issues and market returns settle against credit notes quantity by quantity, and whatever remains outstanding against each supplier stays visible until it clears.
- Receipts are followed from the collector's form through banking to realisation, including returned cheques and re-settlement, with ageing against every customer.
- Reporting runs across the full transaction history rather than a trimmed window, and is tuned to return inside the limits of shared hosting.
- Excel import for invoices, goods received notes, bonus issues and returns, each file validated with its own error report.
180,000+ invoices, 530,000+ invoice lines, 3,100+ products and 111 product agencies, in its seventh year of production. Figures from the live customer database.