Thai Public listed company, top five MLM company at the time of development.
Consulting, customization and implementation of ProLevel (our proprietary ERP solution).
Develop a system to handle the core operations of the business with a member section that allow a high level of interactivity to help them reach their year targets.
The customer uses a complex trinary system with roll-ups, matching bonus, sponsor bonus, funds, qualifies, coupons, strong-weak links and box limits for daily calculations based on member ranking that extends more than 100 levels deep.
The system had to allow:
- Registration of new members keeping tight control of the structure and the relation of each member (new members’ help promoting ranking of higher levels).
- Registration of invoices and credit notes that affect every higher level.
- All back office operations extending to Forma (accounting software)
Also, to help stimulate their members’ activity (around 140,000 people distributed all across Thailand) the system had to allow members to consult their team’s status, to manage their activities, in order to maximize everyone’s profits.
The system required fast commission calculation to allow updating the whole tree information every hour and will have the daily and monthly commission ready on time.
As a final challenge, the company was to acquire many competitors, so the commission rules had to be flexible to allow continuous change to keep the plans attractive.
The first step was to understand, document and improve the calculation process; we interact with their ERP provider to detect the existing information and to design the interfaces to retrieve and save new information.
Several web services were developed on both sides to integrate the systems.
Most of the logic for commission calculation was moved to the DB itself to accelerate the process.
A rich interface using AJAX was done to minimize the learning curve and to allow cashiers to work at the required speed.
Once the calculation logic was checked and approved, we set to make it more efficient; after data cleaning, structure and procedure optimization we were able to reduce the original 4 hours process to about 5 minutes process for daily transactions and 12 minutes for the monthly ones .
Many interface files for banks were made as well as a rich set of reports.
We also decided to extend our framework to provide excel downloading to every available listing.
Tools and Technologies:
- MSSQL 2000
- MSSQL stored procedures
- Multiple Win 2003 servers
- MSSQL data replication services
- Web services
- BB Framework 3.0
- BB security modules
- XLS binary maker
Our customer announced on public media (TV) the release of their new system and commission plan to promote their 1,000 million baht target per year.
As there was a delay in the delivery of the hardware (not handled by Blue BaLl), we made the system public in our own servers for a couple of weeks, receiving more than 5,000 per day.
The system was fully developed in time and we were able to release all the required optimizations before the deadline.
After the release of the system, many more phases have been added, acquired companies systems have been integrated, commission calculation has been changed 3 times and other modules such as inventory management /lending plans have been successfully.