Noor Al Aala Printing Services

v14.1

Period: All Time (Full History)

Month Sales All Time (Full History)

AED 45,309.76

Target

AED

0.0% Achieved

Month Profit All Time (Full History)

AED 22,153.91

Target

AED

0.0% Realized

Avg: AED 154.92 Margin: 48.9%

056 857-3531 - Mustaali

Job Card #	Date	Invoice #	Customer	PO	Subtotal	Cost	Net Profit	Invoice (VAT)	Payment	Status	Actions
2026/927	20-Oct-26	2610927	RETAIL 056 857-3531 - Mustaali TRN: 100397601400003	PO-04807 PO-04875	19.05	4.54	14.51	20.00	PAID	COMPLETED	Print Invoice
2026/922	19-Oct-26	2610922	FUSION PLUS COMPUTERS TRADING L.L.C 056 614-7653 - Murtuza TRN: 100589177300003	PO-04788 PO-04825	185.00	85.86	99.14	194.25	PAID	COMPLETED	Print Invoice
2026/921	19-Oct-26	2610921	GMM BUILDING MATERIALS TRADING LLC Murtuza	PO-04870 PO-04871	333.33	211.19	122.14	350.00	PAID	COMPLETED	Print Invoice
2026/920	19-Oct-26	2610920	AHMAD & KHADEEJA TRADING CO. LLC 04 225-2788 - Mustaali TRN: 100276151600003	PO-04869	125.00	100.00	25.00	131.25	PAID	COMPLETED	Print Invoice

TRN: 100397601400003

FUSION PLUS COMPUTERS TRADING L.L.C

056 614-7653 - Murtuza

TRN: 100589177300003

GMM BUILDING MATERIALS TRADING LLC

AHMAD & KHADEEJA TRADING CO. LLC

04 225-2788 - Mustaali

TRN: 100276151600003

Master Customer Database

Centralized customer records with tax TRN, contact, authorized staff, and purchase orders

New Customer Registration

Live Duplicate Prevention Active

Customer Name *

TRN (15 digits)

Phone / Mobile

Email Address

Address / City

Payment Terms

Customer Name	TRN Tax #	Contact / Phone	Staff Name	Purchase Orders (PO)
Loading customers...

Master Supplier Directory

Supplier spend intelligence, open balances, and purchase order tracking

New Supplier / Vendor Registration

Live Duplicate Prevention Active

Supplier / Company Name *

TRN (15 digits)

Phone / Mobile

Email Address

Address / Location

Payment Terms

Supplier Name	TRN Tax #	Total POs	Total Spend	Settled	Open Balance
Loading suppliers...

FULL SQL DATA EXPORT (ALL COLUMNS)

Export Granularity (Job Cards)

📄 Invoice-Wise (1 Row / Job) 📋 Item-Wise (Line Items)

Invoice-Wise prevents duplicate rows; guarantees accurate SUM() in Excel.

Payment Status Filter

From Date

To Date

CURRENT VIEW EXPORT (SELECTED COLUMNS)

Loading historical report...

Admin Master Tool Native Excel (.xlsx, .xls) & CSV

Excel & CSV Master Importer & Interactive Editor

Drop your full Excel workbook or CSV. Review, inline-edit cells, modify lines, and auto-detect duplicates before committing safely to MySQL.

Job Cards Template POs Template Status Sync Template TRN & Address Template

Database & Sequence Health Audit

Target Data Type: Auto-Detect Columns TRN & Customer Address Job Cards Purchase Orders (POs) Job Status Sync

Safe Upsert Active

Click to select Excel (.xlsx, .xls) or CSV file, or drag and drop here

You will be able to edit cells, delete rows, verify calculations, and check duplicate Job/PO numbers before committing into MySQL.

Data Type

Job Cards

Total Loaded Rows

New Records

Existing (Will Update)

Selected for Import

Total Value

0.00 AED

Mode:

Tip: You can click inside any cell above to edit text, dates, rates, or quantities directly before saving.

Showing all rows

Close Purchase Order with Bill

Settled Bill is locked.

PO Total: AED 0.00

Billed So Far: AED 0.00

Pending Balance: AED 0.00

Settlement Mode

Full / Final Settlement (Closes PO) Partial / Installment Bill

Supplier Bill / Invoice # No Bill (Auto-generate)

Bill Date

Bill Total Amount (AED)

Notes / Variance Remarks (Optional)

Admin Authorization Required

Enter master admin password to proceed

Admin Password:

Check Duplications

Consolidate spelling variations into a single master name across all Job Cards & POs.

Scanning database for near-duplicate names...

Noor Al Aala ERP v14.1

System Release & Deployment Information

Status: Live on Tasjeel Production

Deployed Date & Time: Wed, 28 Oct 2026 08:05:41 GMT

Build Target: cPanel / Tasjeel Server

Latest Change Log:

v14.1: Unified month scoping & [All Time] toggle; dynamic status & payment tab badges; Idea 1 Invoice-Wise Excel export with payment selector

Noor Al Aala Printing Services

View by Status

View by Payment

2026 Historical Receipt Import & Settlement

Mark Receipt as Settled