Loading Records...

Updating Noor Al Aala ERP view (100 per page)...

Noor Al Aala Printing Services

v14.2

Job Card PO In-Stock Receipt

Job Cards (4) Purchase Orders (1,496) In-Stock Materials (1,555 Items) Receipt Book (854 Vouchers)

Total Job Cards

4

Total Sales (No VAT)

5,700.00 AED

Supplier Costs

4,658.19 AED

Total Invoiced (With VAT)

5,985.00 AED

Filter Month: All Time Jan Feb Mar Apr May Jun Jul Aug Sep Oct

Period: All Time (Full History)

Month Sales All Time (Full History)

AED 45,409.76

Target

AED

0.0% Achieved

Month Profit All Time (Full History)

AED 22,253.91

Target

AED

0.0% Realized

Calculating...

Avg: AED 154.54 Margin: 49.0%

View by Status

All Job Cards 976 New 0 Drafts 7 In Progress 111 Completed 858 NVI Jobs 9

Date Range:

View by Payment

All Payments 976 Unpaid 120 Partially Paid 0 Paid 856

Job Card #	Date	Invoice #	Customer	PO	Subtotal	Cost	Net Profit	Invoice (VAT)	Payment	Status	Actions
2026/849	05-Oct-26	2610849	MOGUL ELECTROMECH LLC 058 527-8640 - Shabbir Sanjeli TRN: 100337875700003	PO-04736 PO-04756	10.00	2.34	7.66	10.50	UNPAID	COMPLETED	Print Invoice
2026/845	03-Oct-26	2610845	AL ZERWA TRADING CO. LLC. 04 285-7916 - Mustaali TRN: 100384598700003	PO-04750	1,875.00	1,550.00	325.00	1,968.75	UNPAID	COMPLETED	Print Invoice
2026/843	03-Oct-26	2610843	NILE BLDG. MATERIALS TRADING L.L.C. 04 223-3950 - Mustaali TRN: 100210028500003	PO-04747	3,800.00	3,100.00	700.00	3,990.00	UNPAID	COMPLETED	Print Invoice
2026/841	02-Oct-26	2610841	NILE BLDG. MATERIALS TRADING L.L.C. 04 223-3950 - Mustaali TRN: 100210028500003	PO-04736 PO-04743	15.00	5.85	9.15	15.75	UNPAID	COMPLETED	Print Invoice

Showing entries...

Master Customer Database

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

0 Customers

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

0 Suppliers

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

EXPORT MASTER DATA

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)

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

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

0

New Records

0

Existing (Will Update)

0

Selected for Import

0

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