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 (0) Purchase Orders (1,496) In-Stock Materials (1,555 Items) Receipt Book (854 Vouchers)

Total Purchase Orders

1,496

Total PO Amount (Excl. Tax)

288,646.48 AED

Open / In-Stock POs

169

Settled / Closed Bills

1,327

Purchase Orders List

All POs 1,496 In Stock Units 1,280 Unbilled 169 Partial Bills 6 Settled Bills 1,327

Filtered POs for Supplier: FAROOK INTERNATIONAL STATIONERY LLC (Showing all Open, Partial & Settled)

Clear Supplier Filter

PO Number	PO Date	Vendor / Supplier Name	Linked Job Card	PO Total (AED)	Usage	Actions
PO-02922	11-Feb-26	FAROOK INTERNATIONAL STATIONERY LLC	2026/155	1.85	10.00 / 10.00 used 100% Allocated	View

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

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

Noor Al Aala Printing Services

Purchase Orders List

2026 Historical Receipt Import & Settlement

Mark Receipt as Settled

Noor Al Aala Printing Services

Purchase Orders List

Master Customer Database

Master Supplier Directory

Excel & CSV Master Importer & Interactive Editor

Close Purchase Order with Bill

Admin Authorization Required

Check Duplications

Noor Al Aala ERP v14.2

2026 Historical Receipt Import & Settlement

Mark Receipt as Settled