AJS

AJMP Hub

Welcome back
Quick job lookup
⚠ Overdue Tasks
📅 Due This Week
Your Jobs at Risk
Over Budget
≥ 100%
At Risk
85 – 99%
On Track
< 85%
View all in Job Status →
Company Overview
Job reference
CA-
Batch job lookup
CA- prefix optional. Paste directly from your Excel Job column.
Engineer Assignments
User Management
Management Contacts
CoS Rates by Category
WIP Forecast Rates
Engineer Rates
Meeting Notes Corrections
Daily Backups
Development Tasks
Internal Hub development tracker — developers only
Projects
Live Job Status
No data yet
Job data refreshes automatically at 10:00 PM GMT every night.
Dept:
Design Board
Open jobs with design activity — hours and materials tracked against budget
Design Projects
Design Work Flow — safety function diagrams, design/electrical audits and validation sign-off, one per job
Costing Sheet
Workshop Board
Weekly allocation scheduler — workshop jobs and engineer availability
Software Board
Task scheduling for the Software department
Resource Forecast
Status Job Ref Quote Ref Customer Description Contract Value Updated
Loading quotes…
WIP Forecast
Month End — WIP Accruals & Deferrals
WIP Recognized Profit (To Date) Cumulative — live WIP
Monthly P&L Movement vs Prev Month
Profit Taken to Date From prior periods — editable
Deferred: Accrued: Net WIP Adj: Prev Month Net WIP:
Cashflow Forecast
Loading…
Overdue
Due This Month
Next 3 Months
Forecast Total
Cash Pipeline — Rolling 12 Months
Filters:
Check PO Status
Look up one PO number directly (even if it's since been invoiced and no longer appears in the list below).
Outstanding Purchases
Purchases with no invoice yet, where the expected delivery date is on or before today. Pulled live from AJMP.
Job Cashflow Status
All live CA jobs — total costs (materials/labour/subcontract/warranty) vs. contract value vs. actual invoiced/paid. Refreshed nightly; a job drops off this list once it's closed on AJMP.
CA Job Register
Cumulative log of all C&A Live, Compliance & Shift Cover jobs. Updated nightly.
Loading…
Project Tasks
Status
Stage
Milestones
tasks | overdue | due this week | completed | Across projects
View:
Sort by:
Click Refresh to load project tasks.
Kick-Off
Review
Checkpoints
Closeout
Loading…

Risk Register

Level:
Status:
Job:
Category:
High
Medium
Low
Total shown
Job Description Customer Category Level Details Owner Status Action

Opportunities

Pipeline Value
Weighted Value
Won This Month
Lost This Month
Open Opportunities
🔍
Status:
Owner:
Probability:
Value:
Submit date:
Est. Start:
Project Type:
Overdue:
Docs:
Quote Ref Description Customer Owner Status Prob% Submission Est. Start Docs
Details
Timeline
Details
Timeline

Won / Lost Tracker

Won — Value (YTD)
Won — Count (YTD)
Lost — Value (YTD)
Lost — Count (YTD)
Win Rate (YTD)
Auto-Won (YTD)
PandaDoc signed
Year:
Owner:
Status:
Date range:
Loading…
Status Quote Ref Description Customer Owner Deal Value Completed Completed By Reason
Monthly Trend
Owner Breakdown
Owner Won Count Won Value (£) Lost Count Lost Value (£) Win Rate % Avg Deal Value (£)

Sales Forecast

Total Pipeline
Weighted Forecast
Active Opportunities
Avg Win Probability
Owner:
Customer:
Status:
Project Type:
Probability:
Start Date Range: to
Total Pipeline Weighted Forecast
Grouped by Estimated Start Date. Opportunities with no start date appear in the Unscheduled section below.
Monthly Breakdown
Month Total Pipeline Weighted Count Avg Probability
By Owner
Owner Count Total Pipeline Pipeline vs Max Weighted Forecast Weighted vs Max Avg Prob
Unscheduled — No Estimated Start Date 0
Quote RefDescriptionCustomerOwner StatusProb% Deal ValueWeighted

Invoice Report

Invoiced YTD
Avg Monthly
Outstanding
Paid YTD
Invoice Count
Year:
Month: to
Customer:
Status:
View:
🔍
Invoiced vs YTD Trend
Monthly Invoiced YTD Cumulative
Top Customers by Revenue
Monthly Breakdown
Month Invoiced YTD Total Outstanding Paid Count
Invoice Detail
Invoice # Customer Date Due Reference Amount Tax Outstanding Status

Debtors Report

Total Outstanding
Total Overdue
Current (Not Yet Due)
Max Days Overdue
Customers with Overdue
View:
Grouping:
Customer:
Age filter:
Aged Debtors Summary
Customer Current 1-30 Days 31-60 Days 61-90 Days 90+ Days Total Max Days
Outstanding by Customer
Outstanding Invoice Detail
🔍
Invoice # Customer Inv Date Due Date Reference Invoiced Outstanding Days Overdue Age

Budget vs Actuals

Total Budget
Actual YTD
Live Jobs Pipeline
Opportunities Forecast
Total Projected
Year:
View:
Show:
Customer:
Past — Xero actuals only Current month — Xero + remaining forecast Future — milestones + opps + run rate Hover any cell for source breakdown · Live Jobs tile = all cashflow milestones

Invoice Milestones

Outstanding invoice milestones from Live & Invoiced projects

Total Outstanding
Overdue
Due This Week
Projects
Stage:
Source:
Manager:
Customer:
Assignee:
Due: to
Job Ref:
Open the tab to load data, or click Refresh.

Financial Outlook

3-month lookahead — invoice forecast, cashflow, and weighted opportunity pipeline.

Non-Chargeable / Non-Bookable Time

Hours booked to AJS Control & Automation's internal non-chargeable/non-bookable jobs on AJMP, by category and month.

Hours by category —
Monthly breakdown —

Quoted Hours by Department

Every open C&A opportunity (not Won or Lost), quoted hours per department from its linked Costing Sheet, and a win-probability-weighted total.

Hours by department — quoted vs. probability-weighted
Totals by department — click a department to see it split by month
Open opportunities with a matched Costing Sheet
Budget Settings
Annual budgets and monthly run rates per customer. Run rates are recurring monthly invoice amounts.
Year:
Other / Misc Budget: £ Counts towards the total budget but not attributed to any individual customer (e.g. small / new customers). Previously "Numerous Others".
Customer (Master Name) Annual Budget (£) Monthly Run Rate (£) Notes
Month Detail
Customer Settings — C&A
Group customers under a master name or exclude from reports. Settings are per-entity — hiding a customer here only affects this entity's reports.
Enter a Master Name to group customers. Tick Hidden to exclude from reports.
Customer Name Invoiced (all time) Group under (Master Name) Hidden

Asset Care — Opportunities

Pipeline Value
Weighted Value
Won This Month
Overdue Follow-Ups
Open Opportunities
🔍
Status:
Owner:
Probability:
Value:
Submit date:
Est. Start:
Overdue:
Docs:
Quote Ref Description Customer Owner Status Prob % Est. Value Weighted Submission Follow-Up Est. Start Duration Docs
Loading…

Asset Care — Sales Forecast

Owner:
Customer:
Status:
Probability:
Start Date Range: to
Pipeline Value
Weighted Forecast
Active Deals
Avg Probability
Total Pipeline Weighted Forecast
Grouped by Estimated Start Date. Opportunities with no start date appear in the Unscheduled section below.
Monthly Breakdown
MonthTotal PipelineWeightedDealsAvg %
Unscheduled (no start date)
Quote RefDescriptionCustomerOwnerStatusProb %Est. ValueWeighted

Asset Care — Won / Lost / Created

Won (YTD)
Lost (YTD)
Created (YTD)
Win Rate (YTD)
Week Won Won Value Lost Lost Value Created Created Value
Owner Breakdown
Owner WonWon Value LostLost Value Created Win Rate

AC Invoice Report

Invoiced YTD
Avg Monthly
Outstanding
Paid YTD
Invoice Count
Year:
Month: to
Customer:
Status:
View:
🔍
Invoiced vs YTD Trend
Monthly Invoiced YTD Cumulative
Top Customers by Revenue
Monthly Breakdown
Month Invoiced YTD Total Outstanding Paid Count
Invoice Detail
Invoice # Customer Date Due Reference Amount Tax Outstanding Status

AC Debtors Report

Total Outstanding
Total Overdue
Current (Not Yet Due)
Max Days Overdue
Customers with Overdue
View:
Grouping:
Customer:
Age filter:
Aged Debtors Summary
Customer Current 1-30 Days 31-60 Days 61-90 Days 90+ Days Total Max Days
Outstanding by Customer
Outstanding Invoice Detail
🔍
Invoice # Customer Inv Date Due Date Reference Invoiced Outstanding Days Overdue Age

S&S Invoice Report

Invoiced YTD
Avg Monthly
Outstanding
Paid YTD
Invoice Count
Year:
Month: to
Customer:
Status:
View:
🔍
Invoiced vs YTD Trend
Monthly Invoiced YTD Cumulative
Top Customers by Revenue
Monthly Breakdown
Month Invoiced YTD Total Outstanding Paid Count
Invoice Detail
Invoice # Customer Date Due Reference Amount Tax Outstanding Status

S&S Debtors Report

Total Outstanding
Total Overdue
Current (Not Yet Due)
Max Days Overdue
Customers with Overdue
View:
Grouping:
Customer:
Age filter:
Aged Debtors Summary
Customer Current 1-30 Days 31-60 Days 61-90 Days 90+ Days Total Max Days
Outstanding by Customer
Outstanding Invoice Detail
🔍
Invoice # Customer Inv Date Due Date Reference Invoiced Outstanding Days Overdue Age

Energy Invoice Report

Invoiced YTD
Avg Monthly
Outstanding
Paid YTD
Invoice Count
Year:
Month: to
Customer:
Status:
View:
🔍
Invoiced vs YTD Trend
Monthly Invoiced YTD Cumulative
Top Customers by Revenue
Monthly Breakdown
Month Invoiced YTD Total Outstanding Paid Count
Invoice Detail
Invoice # Customer Date Due Reference Amount Tax Outstanding Status

Energy Debtors Report

Total Outstanding
Total Overdue
Current (Not Yet Due)
Max Days Overdue
Customers with Overdue
View:
Grouping:
Customer:
Age filter:
Aged Debtors Summary
Customer Current 1-30 Days 31-60 Days 61-90 Days 90+ Days Total Max Days
Outstanding by Customer
Outstanding Invoice Detail
🔍
Invoice # Customer Inv Date Due Date Reference Invoiced Outstanding Days Overdue Age
Job reference
AC-

Project Milestones

Overdue & Due Within the Next 7 Days
Overdue Due Soon
Loading milestones…

Opportunity Tracker

Submission Date Overdue & Due Within the Next Week
Completed / Not Required Required Click a Required badge to mark as Completed.
Loading opportunities…

Meeting Actions

Actions from Synergy Meeting Notes
Loading actions…

Meeting Notes

Process transcripts into polished notes, email, and actions
Loading history…

Quote Kick-off Agenda

Select outstanding kick-offs to discuss and send the meeting agenda
Loading…
Recipients
Preview
Marks the selected Dataverse tasks complete and removes them from My Activities — separate from sending the email.

Customers

Key Account Management
🔍
Filter:
Customer Strategic Owner Day-to-day Budget Invoiced YTD Live Jobs Opp Fcst Total Proj. % Budget KAM Plan
Click Refresh to load accounts.