Skip to content
Almonaseb
In production

Abu Khalif Group: one ERP for building-materials trading and a cement plant

Warehouses, weighbridge, cash custody and sales on one system, in daily use since 2018

Client
Abu Khalif Group
Sector
Building-materials trade & manufacturing
Location
Sohag, Egypt
Since
2018
Short answer

Abu Khalif Group has run its building-materials trade and cement plant on a single in-house ERP since 2018: warehouses and accounts held at cement factories, purchasing and sales, a truck weighbridge, and cash custody with per-user permissions. After years of data growth we tuned performance, and the stock dashboard went from 94 seconds to under one second when measured on operating data.

2018
in daily use since
94 → 0.66 s
stock dashboard load time after tuning
17
roles with fine-grained permissions
2
businesses on one core: trading and the plant

The challenge

  • !Cement, steel, gypsum and bricks traded across warehouses, branches and accounts held at cement factories, each with its own balance.
  • !Heavy daily truck traffic, with an empty and a loaded weight to record for every trip.
  • !Cash custody held by warehouse keepers needed clear accounting per user.
  • !After years of accumulated data, the stock dashboard took 94 seconds to open.

What we delivered

  • ✓An in-house ERP covering warehouses, purchasing, sales, expenses, custody and weighbridge movements.
  • ✓A warehouse can be a physical store or an account at a cement company, so every product shows its balance at every location.
  • ✓17 roles and 23 permissions: a warehouse keeper sees only their store and custody; management sees everything.
  • ✓The same core runs the cement plant, with manufacturing added: a recipe per product, raw materials deducted, finished goods added at cost.
  • ✓Performance tuning: 31 database indexes, and the stock dashboard cut from 744 queries to two.

The outcome

  • ★The current version has run since 2018 and the client relies on it for daily accounts.
  • ★Stock dashboard from 94 s to 0.66 s (measured on a test copy holding the same operating data).
  • ★Incoming, outgoing and balance figures matched the database 100% after the change.
  • ★Every client request is logged in a changelog with its date and status.

A business that off-the-shelf systems do not fit

A building-materials trader in Upper Egypt does not sell from one warehouse. Part of the stock sits in the company’s own stores; part is a balance held at cement factories and shipped straight to the customer. So a “warehouse” in the system covers both cases, and each product’s balance (incoming minus outgoing) appears per location on one dashboard.

The rest of the cycle is built around that: purchasing and sales, weighbridge movements for every truck, empty and loaded, and the cash custody each warehouse keeper is accountable for.

From trading to the plant

When the group needed a system for its cement plant, we did not start from scratch. The same core was extended with manufacturing: each product has a recipe listing its raw materials; producing it deducts those materials from stock and adds the finished product with its cost and date, ready to sell from the same system. Cashboxes, banks and the fleet come with it.

Maintenance you can measure

A system that has run for years needs someone to review it. In 2026 we added 31 database indexes, and the stock dashboard’s load time went from 94 seconds to 0.66 seconds in measurement. We then rewrote the dashboard queries (from 744 down to two), and the figures matched the database exactly.

In the plant system, one screen once showed a wrong total. We fixed the cause, then reviewed every screen for the same pattern to make sure it did not occur anywhere else.

Scope

  • Warehouses & stock
  • Purchasing & sales
  • Truck weighbridge
  • Cash custody
  • Manufacturing & raw materials
  • Cashboxes & banks
  • Roles & permissions
  • Support & documentation

FAQ

Is this an off-the-shelf product or built for the client?

It is built around how the client works: a warehouse can be an account at a cement factory, and the weighbridge and custody are part of the daily cycle. When the group needed a system for its cement plant, it was built on the same core with manufacturing added.

How was the speed improvement measured?

On a test copy loaded with the same operating data: the stock dashboard opened in 94 seconds before the indexes and 0.66 seconds after, and the figures shown were then checked directly against the database.

More stories

Ready to try it on your own data?

A trial instance within 48 hours, in Arabic, no commitment.