/
/
Find open jobs with no daily logs in the field
For operations teams who want open Business Central jobs compared with Procore daily logs, by asking their AI assistant.
On this page
Connector
Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.
The problem
Jobs stay open after the field stops logging
Accounting keeps a job open and forecasts against it while the field has gone quiet, or the field keeps logging against a project with no open job. Nobody compares the two lists until a number looks wrong.
Without PopdockAI
- List the open jobs in Business Central
- Check Procore daily logs project by project
- Match job numbers to project names by eye
- Miss the projects that log with no open job
With PopdockAI
- Open jobs and daily log activity read together
- Matched by job number or description, uncertain pairs listed as Possible
- Not-yet-started jobs noted as such
- Gaps listed in both directions with counts
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find Business Central jobs that are open but have no Procore daily log from {date-from} (default the last 14 days), and Procore projects with daily logs that have no open Business Central job.
**Step 1: Read the open jobs (business-central server)**
Call `business-central-get-job` with `status` Open and `max-records` of 200. Keep job-number, description, bill-to-name, starting-date, ending-date and project-manager-name.
**Step 2: Read the field activity (procore-project-management server)**
Call `procore-get-daily-log-headers` with `log-date.from` {date-from} and `max-records` of 200. Group by project-name and keep the project-id, the number of logs and the latest log-date. If {project-name} is not empty, pass it as `project-name.contains`.
**Step 3: Match across**
A job matches a project when the job-number appears in the project-name, or the job description equals the project-name after lower-casing and removing punctuation. If only part of a name matches, list the pair as Possible match with the reason and do not count it as matched.
**Step 4: Report**
Three lists. Open jobs with no daily logs (job number, description, project manager, ending date). Projects with logs but no open job (project name, logs, latest log date). Possible matches. End with counts of each.
**Rules & Guidelines:**
* `business-central-get-job` is on the business-central server; `procore-get-daily-log-headers` is on the procore-project-management server.
* This is read-only. Do not call any `procore-create-*`, `procore-update-*`, `procore-delete-*` or `procore-send-*` tool on the procore-project-management server, and do not call any `business-central-create-*` or `business-central-update-*` tool on the business-central server.
* A job with no logs may simply not have started; use starting-date to say so when it is after {date-from}.
**Validation:**
* If `business-central-get-job` returns nothing, say so and stop.
* If `procore-get-daily-log-headers` returns nothing, say that no project logged in the period and list all open jobs without logs, noting the Procore server may be pointed at the wrong company.Who it's for
One answer, three teams that use it
Operations managers
Spot jobs that have gone quiet
See open jobs with no daily logs, with the project manager and end date, so someone can ask why.
Which open Business Central jobs have had no Procore daily logs since 1 November?
Finance controllers
Stop forecasting against stalled work
Find jobs held open and costed while the field has stopped, before the forecast is published.
List open jobs with no field activity in the last 30 days, with the project manager for each.
Project controls
Find projects logging with no job
See projects with daily logs but no open job, so the job can be reopened or the logs corrected.
Which Procore projects logged in the last 14 days but have no open job in Business Central?
How it works
What PopdockAI does when you ask
You give the period and your AI assistant compares the two lists. It only reads, and it lists uncertain pairs as possible rather than counting them as matched.
Ask
You give a start date, or leave it at the last 14 days, and optionally a project.
Read
It reads the open Business Central jobs and groups the Procore daily logs by project.
Match
It matches jobs to projects by job number or description and lists uncertain pairs as Possible.
Report
You get open jobs with no logs, projects with logs and no open job, possible matches and counts.
What PopdockAI provides
The tools behind the answer
Ready made tools for Microsoft Dynamics 365 Business Central and one secure connection to your AI tool. No code, no exports.
procore-get-daily-log-headers
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Jobs and field activity back in step
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
