The Overview

TZL Marketing was using a VB .Net–based desktop application that suffered from several core issues affecting its operations. The system did not support financial year closing, forcing manual interventions and increasing the risk of errors. Stock reports detailing quantity in cartons and units were completely absent, making inventory monitoring difficult. Closing stock costing, especially using average cost methods, often differed from actual figures due to frequent large purchases, creating discrepancies in financial reporting. Being a desktop-based application, it could not run live or support multi-user real-time access, limiting operational efficiency. Along with many other gaps, these issues hindered accurate decision-making, slowed workflows, and increased dependency on manual processes for critical financial and inventory management tasks.

The Solution

To resolve these challenges, the application was designed with a carefully restructured data model that aligned new profile requirements with the updated database schema. Stock management logic was rebuilt to handle dual-unit tracking, allowing quantities to be calculated accurately in both cartons and individual units. Closing stock costing issues were addressed by implementing clear valuation rules with automated reconciliation between average costing and actual stock movement. A dedicated post-dated cheque (PDC) management workflow was introduced to track due dates, settlements, and clearances in a controlled, error-free manner. Together, these improvements delivered a reliable, transparent, and easy-to-operate system for day-to-day trading operations.

• Enhanced Security
  Implemented role-based access, approval controls for financial actions, and audit trails for stock and cheque transactions to protect sensitive trading data.
• Seamless Migration
  Migrated existing profiles, stock balances, and PDC records through validated scripts and parallel checks, ensuring accuracy while keeping business operations uninterrupted.