Skip to content

Module 05: Master Data Management

The Master Data module (/masters/*) forms the core informational directory of ebosAi MicroERP, maintaining master catalogs for employees, commercial counterparties, analytical project cost centers, and capital fixed assets.

🎯 Master Catalogs

1. Employees Directory (/masters/employees)

  • Centralized personnel register tracking employee contact details, role designations, department assignments, passport/visa numbers, and employment contracts.
  • Integrated with HRMS and Payroll modules for automated salary processing.

2. Customer Master (/masters/customers)

  • Commercial & Tax Metadata:
  • Legal Customer Name & Trade Alias.
  • Tax Registration Number (TRN) for UAE 5% VAT invoicing.
  • Payment Terms (e.g. Net 30 Days, Immediate Cash, Net 60 Days).
  • Credit Limit threshold (triggers automated credit hold on Sales Orders if exceeded).
  • Multi-currency billing preferences (AED, SAR, USD, EUR).
  • Primary Billing & Shipping addresses.

3. Vendor Master (/masters/vendors)

  • Supplier Procurement Metadata:
  • Legal Supplier Name & TRN.
  • Default Expense Account & Payable Account for automated bill posting.
  • Supplier bank account IBAN & SWIFT for wire transfer payments.
  • Payment terms and currency mapping.

4. Projects & Cost Centers (/masters/projects)

  • Analytical project tracking registry allowing transactions across Sales, Purchases, Expenses, and Journal Entries to be tagged to specific projects for analytical profit center reporting.
  • Project status tracking (Planning, Active, On Hold, Completed).

5. Fixed Assets Register (/masters/assets)

  • Capital asset register tracking physical equipment, vehicles, IT infrastructure, and furniture.
  • Asset Metadata: Serial Number, Acquisition Date, Purchase Cost, Depreciation Method (Straight Line, Reducing Balance), Depreciation Rate (%), Accumulated Depreciation, and Net Book Value.

💡 Step-by-Step Instructions

Creating a New Customer Record

  1. Navigate to Master Data → Customers (/masters/customers).
  2. Click Add Customer.
  3. Enter Customer Name, TRN number (15-digit UAE tax ID), select Currency (AED), and set Credit Limit (e.g. 50,000 AED).
  4. Click Save Customer. The customer is now available in CRM and Sales Order dropdowns.