Pipe and fittings distributor

The business moved pipe and fittings out of two godowns, and every order started with a search for stock. Stock lived in a set of spreadsheets that a couple of people updated by hand, and the numbers on the screen rarely matched what was on the racks. Party credit was not written down anywhere. It lived in the owner’s head, who remembered roughly who owed what and who was allowed to buy on account. When the owner was out, the rest of the team had no way to check who owed what.

So dispatches went out to parties who were already past their limit, because nobody at the counter could see the outstanding at that moment. Goods left the yard against a party that should have been on hold, and the money came back late or not at all. The real stock was a guess until someone walked both godowns and counted, so orders got promised on material that was not there. Month-end turned into a scramble of matching spreadsheets, chasing figures, and arguments over what had been sent and what had been paid. The owner spent the day on the phone instead of running the business.

Now godown-wise stock and party-wise credit sit on one screen. As goods move in and out, the stock for each godown updates, so the number on the screen matches the racks. Every party shows its credit limit and its outstanding right next to the stock. When a party crosses its limit, the dispatch holds on its own, before anything leaves the yard. Nobody has to remember a limit or make a call to check.

The owner opens the day already knowing what is in each godown and who owes what, without walking the yard or ringing around. The counter can serve a party without waiting on the owner, because the limit and the outstanding are right in front of them. Goods stop going out to parties who are over their limit, so less money sits stuck as outstanding. Daily stock and outstanding are there to read any time, so month-end becomes a normal day instead of a scramble. The team spends its time on selling and dispatch, not on matching spreadsheets.