Vinstron IMS: Sales & Inventory System for an Auto Parts Distributor Category
For Vinstron Auto parts distributor · October 28, 2020
Problem / case
Vinstron distributes auto parts. Its catalog is large, and every item has a part number, a brand, packing in cases and pieces, and the vehicles it fits. Sales, stock and collections were tracked separately, so stock counts drifted between locations and invoices had to be prepared and checked by hand. It was also hard to answer everyday questions: what’s actually on the shelf, which customers are overdue, and how much each salesman sold this month. Month-end reporting meant pulling numbers together by hand.
Solution
I built Vinstron IMS, a Windows desktop system in VB.NET and MySQL. It handles the full sales and purchasing cycle in one place, and several networked workstations share one central database. &Inventory: a product master list with part numbers, brands, categories and vehicle applications. It covers stock receiving, transfers between locations, adjustments and bad-order tracking, and each product has a bin card showing every stock movement. &Sales: invoicing with BIR-compliant printed invoices, sales returns, credit memos, statements of account and delivery tracking. &Purchasing: purchase orders and returns to suppliers. &Accounts: customer receivables with aging, customer and supplier payments, cheque tracking and supplier payables. &Reporting: over 40 printable reports, including daily and monthly sales, sales by salesman and by SKU, gross profit, salesman commission, AR aging and stock received. *Control: user access rights, an admin passcode for sensitive actions such as voiding items, a user activity log, and built-in database backup and restore.
