A major update bringing a Fiori-inspired UI redesign, comprehensive statement management, advanced reporting and user access control across the entire platform.
Full user management under System → Manage Users. Create admin and staff users, activate/deactivate accounts, change passwords and assign granular menu-level permissions with a checkbox grid.
Comprehensive customer statement page with month/year filtering, opening balance calculation, running balance, summary cards, Excel export and print support.
Complete supplier statement with date range filtering, opening balance tracking, purchase and payment transaction merging, Excel export and paginated views.
Bank statement feature showing all credits (sale payments) and debits (supplier payments) with month/year filters, running balance, summary cards and Excel export.
Added opening balance fields when creating new customers, suppliers and banks. The balance is factored into all statement calculations and date-filtered views.
Export the full product inventory list to an Excel file with formatted headers, product details, stock quantities and pricing information.
Added Bootstrap 4 pagination links and result summaries to purchase and sales invoice listing pages for improved navigation on large datasets.
Applied a modern Fiori-inspired design system across all management pages — consistent cards, form fields, tables, buttons, badges and color-coded summary cards.
Redesigned purchase and sales list pages with styled table headers, hover effects, action icon buttons and cleaner layout structure.
Refactored bank and customer list pages with professional card layouts, icon avatars, financial badges and streamlined edit modals.
Tightened sidebar menu spacing for a cleaner, more compact navigation experience.
Enhanced supplier payment system with bank integration — payments now deduct from bank balances and track payment methods, dates and notes.
All statement pages now support month/year filtering with dynamically recalculated opening balances and one-click Excel downloads.
Fixed bank balance tracking to use the correct amount field for consistent financial data.
menu_permissions — stores per-user menu access with user_id, menu_key and has_access columns.
users.type ENUM expanded to include 'staff'. Added opening_balance columns to users, suppliers and banks tables.
Added MenuPermission model with User relationship. Updated User model with hasMenuAccess() helper and menuPermissions() relationship.