Good afternoon, Operator.
Today - operational overview across inventory, production, procurement and quality.
Mixing Workstation.
Choose a station to begin your shift.
Raw Materials Inventory
Track and manage your raw material stock levels
| Item Code | Description | UOM | Qty On Hand | Status |
|---|
Finished Goods Inventory
Monitor your finished product stock levels
| Item Code | Description | UOM | Qty On Hand | Status |
|---|
Excise Tax Declared Stock
Finished goods declared under Excise Tax (ET- prefixed items)
| Item Code | Description | UOM | Qty On Hand | Status |
|---|
Recipe Validation and Formation
Past Forecast
Aggregated inventory transactions per item, all categories combined
| Category | Reference | Date | Description | Item Code | Item Description | Qty In | Qty Out | ET Stock | Sage Stock | Total Stock |
|---|---|---|---|---|---|---|---|---|---|---|
| Enter a date range or search term and click Load Data to view transactions. | ||||||||||
Configuration
Note: 1 Case = 24 Cans
Required Materials
Material breakdown and availability
| Item Code | Description | Unit Cost | Required | Actual Cost | % of Total | Sage Qty | To Order | Remaining |
|---|---|---|---|---|---|---|---|---|
| Select a recipe and click Calculate to see results | ||||||||
Sage Batch Draft
Batch tracking, picking sheets & production yield
| Date | Batch No | Item Code | Description | Batch Numbers |
Planned Qty |
Actual Qty |
Raw Material Cost |
Per Case |
STD UC |
Yield % |
Status | Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
No production batches yet Use the Calculator to validate materials and push batches to production |
||||||||||||
Stock Requisition - Additional & Qty Returned
Enter Qty Used per item. Additional / Returned are auto-calculated.
Batch: -
Qty Issued is from the recipe. Enter Qty Used (actual materials consumed). If Qty Used > Qty Issued, the extra is shown as Additional. If Qty Used < Qty Issued, the difference is shown as Qty Returned. The Qty Used amounts will be sent to Sage.
| Item Code | Description | Qty Issued | Qty Used | Additional | Qty Returned |
|---|---|---|---|---|---|
| Loading... | |||||
Sage drafts created successfully! You can now download the filled Stock Requisition PDF.
Picking Sheet - Ingredient Batch Numbers
Batch: -
Enter the Batch Number for each raw material ingredient. These will appear on the Picking Sheet PDF.
| Item Code | Description | Batch Number |
|---|---|---|
| Loading... | ||
PO Processing
Create Proforma Invoices, Summary Sheets & Job Orders from purchase orders
Import from Purchase Order (Optional)
Upload one or more Purchase Order PDFs (same customer). Quantities for the same item code are summed across files.
Customer Details
Local: dispatch FG-OUT posts against the ET- SKU. Export: against the base SKU.
Draft Job Orders
Saved-but-not-processed summary sheets. Edit to reopen in the wizard.
| Ref | Date | Customer | Items / GTIN | To Produce | Actions |
|---|---|---|---|---|---|
| Loading… | |||||
| Ref | Date | Customer | Items / GTIN | To Produce | Status | Actions |
|---|---|---|---|---|---|---|
| No summary sheets saved yet | ||||||
Allocation
Activate pending items to create a Job Order, or edit from-stock / to-produce on existing Job Orders. Use search to filter by item code or description.
Pending Job Orders
Active items in production. Uncheck to return to Allocation. Edit priority and reason inline.
Loading pending job orders...
Inventory Transactions
Fast loading from MongoDB cache - Click "Refresh" to check for new data
| Supplier | Unique Items | Total Qty Received | Current Stock | Total Value (AED) | Actions |
|---|---|---|---|---|---|
| Loading supplier summary... | |||||
| Category | Reference | Date | Description | Item Code | Item Description | Qty In | Qty Out | Value (AED) | Current Stock |
|---|---|---|---|---|---|---|---|---|---|
|
Loading inventory transactions... |
|||||||||
Customer Information
Add Products
Quotation Items
| Code | Description | Qty | Unit Price | Discount | Total | Action |
|---|---|---|---|---|---|---|
| No items added yet | ||||||
Terms & Notes
Settings
Summary
Product Price List
Manage pricing for all finished goods
| Item Code | Description | Standard Cost | Custom Value | 5% Duty | Selling Price | RSP | Excise Tax | Base Price | Currency | UOM | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading price list... | |||||||||||
Customer Database
Manage customer information for quotations
| Code | Name | Phone | Type | Actions | |
|---|---|---|---|---|---|
| Loading customers... | |||||
Quotation & Invoice History
View, edit, convert, and download documents
| Type | Number | Customer | Date | Total | Status | Actions |
|---|---|---|---|---|---|---|
| Loading history... | ||||||
Add New Customer
Pending Production Reports
Reports awaiting completion from production batches
Completed Reports
History of submitted process control reports
Job Orders
Job orders grouped by their Summary Sheet & Purchase Order
Loading job orders...
Analytics Dashboard
Visual insights into inventory movements and transaction trends
Transaction Value Trend
Transaction by Category
Production Output vs Sales
Top 10 Items by Value
Transaction Volume Over Time
Loading analytics data...
Create Sage Entry
Create inventory journal entries for GRN, FG-IN, FG-OUT, or Issue Stock
Add Line Item
| Item Code | Description | Quantity | Unit Cost | Value | Batch | Action |
|---|---|---|---|---|---|---|
| No line items added yet | ||||||
| Total | 0 | 0.00 | ||||
FIFO Stock Allocation Preview
Add line items to see FIFO allocation
Pending Sage Drafts
Unposted batches awaiting approval
| Journal No. | Type | Reference | Description | Created | Lines | Value | Actions |
|---|---|---|---|---|---|---|---|
|
Loading drafts... |
|||||||
Entry Details
Edit Draft Entry
Journal: -
Line Items
| Item Code | Description | Qty In | Qty Out | Unit Cost | Value | Actions |
|---|---|---|---|---|---|---|
| Total: | 0.00 | |||||
Add Line Item
Mixing Section
CIP records, raw material checklist, filter replacement, mixing area daily checklist, and RO plant weekly.
Mixing Utilities
CMPD daily log, plant utility shift report, and boiler daily checklist.
Accounting
Manage cashbook, AR, AP batches and VAT reporting
FTA & Customs
Manage customs declarations and FTA excise tax filings
Golden Rule Summary
Opening + Production - Consumption - Lost/Damaged - Transfers = Closing
Required Documents
User Management
Manage user accounts and permissions
| Name | Username | Role | Status | Created | Actions | |
|---|---|---|---|---|---|---|
| Loading users... | ||||||
Untyped Job Orders
Legacy job orders without a Local/Export flag. Flag each one so dispatch posts FG-OUT against the right SKU.
| JO Ref | Date | Customer | Status | Flag As |
|---|---|---|---|---|
| Click Refresh to load untyped job orders | ||||
Sage Write-Back Approval
Review and approve production batch write-backs and RM Order GRN drafts
| Journal # | Type | Reference | Sage link | Qty | Lines | Value | Created | Actions |
|---|---|---|---|---|---|---|---|---|
|
Loading pending drafts...
|
||||||||
Accounting Draft Approval
Review and approve cashbook vouchers (BPV / CPV / TTPV / BRV) before posting to Sage
| Sage Batch | Type | Voucher # | Date | Description | Amount | Created | Actions |
|---|---|---|---|---|---|---|---|
|
Loading accounting drafts...
|
|||||||
Reception Desk
View visitor and courier check-in records
| Date & Time | Full Name | Company | Designation | Purpose | Contact | ID | Actions |
|---|---|---|---|---|---|---|---|
| Loading visitors... | |||||||
| Date & Time | Recipient | Type | Courier Company | Representative | Contact | ID | Actions |
|---|---|---|---|---|---|---|---|
| Loading couriers... | |||||||
Database Maintenance
Force a complete re-sync of all inventory transactions from Sage into the local cache
This is a destructive operation
This will delete all cached inventory transactions from MongoDB and re-fetch every record directly from the Sage database. Use this when transactions are missing or the cache is out of sync. The operation may take 30-60 seconds.