The Challenge
Fan Al-Ibdaa, a company specializing in selling clothes and uniforms to factories, hotels, and schools, relied on manual management of invoices, inventory, and vouchers. This led to calculation errors, difficulty tracking inventory, and loss of important documents.
Multi-Device Interface
The system is built on AppSheet to work efficiently on all devices. Each page contains a data table view + a side form for instant adding and editing.
Professional Invoicing System
Professional sales invoicing containing: 15 items with quantity, price, and total, automatic calculation of VAT, grand total, discount, paid amount, and remaining balance. Automatic PDF conversion and storage in Google Drive linked to customer file.
Smart Voucher System
Professional receipt and payment vouchers with: automatic number-to-words conversion in Arabic, Hijri date conversion via API, sequential numbering (0001, 0002...), and automatic PDF generation.
Professional Quotations
Professional quotations with expiry date, complete item details, and automatic PDF conversion with direct storage in Google Drive.
Smart Inventory System
Complete inventory management system that automatically tracks: incoming goods (purchases), outgoing goods (sales), available quantity calculation, last purchase/sale price, reorder level, and automatic code generation (PRD001, PRD002...).
Comprehensive Customer Management
Complete customer data management with automatic linking to all their invoices, vouchers, and quotations.
Purchases & Expenses Management
Accurate tracking of all purchases and expenses with automatic inventory updates and financial report integration.
Comprehensive Financial Reports
Automatic financial reports covering all business aspects: revenue, expenses, profits, and financial performance analysis.
Advanced Automation Engine
Automation system built on +1500 lines of Google Apps Script on Google Sheets.
Complete Automation:
Automatic conversion of invoices/vouchers/quotations to PDF, smart storage in Google Drive, automatic number-to-words conversion, Hijri date conversion, sequential numbering, automatic customer file linking.
Smart Inventory Management:
Automatic available quantity calculation, incoming and outgoing tracking, last purchase/sale prices, reorder levels, product code generation.
Financial Calculations:
VAT calculation, discounts, paid and remaining amounts, totals, revenue and expense reports.
Result: Complete ERP system operating without manual intervention.
Results & Impact
Complete transformation from manual management to an integrated digital ERP system:
• Zero calculation errors (automatic number-to-words and calculations)
• Real-time accurate inventory tracking
• Automatic PDF storage of all documents
• Instant and accurate financial reports
• Multi-device interface (laptop/tablet/mobile)
• 200% increase in work efficiency
The system currently serves a medium-sized company with complete operations management.