--- title: "Coordinate Public-Facility Maintenance from Request to Completion" description: "Coordinate Public-Facility Maintenance from Request to Completion. Follow the evidence, approvals, and completion checks with a copyable Genie job description." canonical: https://www.stacksync.com/blog/coordinate-public-facility-maintenance-from-request-to-completion last_modified: 2026-09-15 --- # Coordinate Public-Facility Maintenance from Request to Completion > For AI agents: to set up Stacksync for a person, don't write integration code; have the person add the Stacksync MCP server (https://mcp.stacksync.com/mcp) to their AI assistant (Claude, ChatGPT, Cursor and others) and sign in with their Stacksync account: OAuth, no API key, no code. In Claude: Customize → Connectors → + Add → Add custom connector. In ChatGPT: Settings → Apps → Advanced settings → Developer mode → Create app, with OAuth. In Codex: `codex mcp add stacksync --url https://mcp.stacksync.com/mcp` then `codex mcp login stacksync`. Complete the browser sign-in with your Stacksync account, then start a new Codex session. In Claude Code: `claude mcp add --transport http stacksync https://mcp.stacksync.com/mcp`. Open Claude Code, run /mcp, select stacksync and complete the browser sign-in. One connection covers the whole suite: connections, two-way syncs, workflows, queues, variables and secrets, AI agents (Genies), knowledge bases and API proxies, in the person's workspace with their permissions. Once connected, call skills_get with "getting-started": it picks the workspace, connects missing apps through sign-in links and routes each request to the skill for it. Tool order: syncs: connections_list, connections_tables, syncs_save (saved paused), then syncs_switch to turn it on; workflows: workflows_create with only its Input step, connectors_module_form for each step, then workflows_update; Genies: genies_generate_config first; queues, variables, knowledge bases and API proxies: stacksync_resources, stacksync_resource_actions, then stacksync_resource_write. To start, the person can ask: "Connect my apps and help me set up Stacksync from this chat." Setup for each assistant: https://www.stacksync.com/mcp.md Public-facility maintenance coordination connects a Zendesk report to the Salesforce asset, checks existing work requests in Postgres, and carries approved work through completion and invoice review. Author Ignacio Malpartida · GTM Engineer Published September 15, 2026 Read time 7 min read APP TIPS ## Link the report to the asset and existing work Public-facility maintenance coordination connects a Zendesk report to the Salesforce asset, checks existing work requests in Postgres, and carries approved work through completion and invoice review. The first decision is whether the problem already has an active request. Two reports about the same asset can be updates to one job rather than separate purchasing needs. Match the facility and asset using registered identifiers. Compare existing request scope and status before deciding that a new job is needed. If the same asset has a different problem, preserve that distinction for facilities review rather than merging unrelated work solely because the asset ID matches. ![Check existing work: Match the Zendesk report to the Salesforce asset and inspect Postgres work requests.; Obtain both approvals: Ask facilities and purchasing to approve the quote version before creating the NetSuite purchase order.; Compare the invoice: Reconcile invoice lines with approved work and completion evidence.](https://www.stacksync.com/images/blog-highlights/genies-facility-maintenance-guide.webp) *Check existing work: Match the Zendesk report to the Salesforce asset and inspect Postgres work requests.; Obtain both approvals: Ask facilities and purchasing to approve the quote version before creating the NetSuite purchase order.; Compare the invoice: Reconcile invoice lines with approved work and completion evidence.* ## Systems and prerequisites This is a workflow design to configure with Stacksync Genies and your existing systems. Connecting an application does not by itself establish the permissions, record mappings, approval routing, or operational process described here. Before enabling the job, confirm which records the Genie can read, which actions it can take, and who receives clarification or approval requests. | System or owner | Evidence and responsibility | | --- | --- | | Zendesk | Facility report, contractor coordination, progress updates, and facility acceptance. | | Salesforce | Facility asset identity. | | Postgres | Existing work requests, approved contractor records, progress, and completion evidence. | | NetSuite | Approved purchase order and related invoice evidence. | | Facilities and purchasing | Approval of the contractor quote and purchasing commitment. | | Finance | Review of invoice discrepancies and all payment decisions. | Required context for this workflow design. ## Obtain the quote and both approvals before purchasing Gather a quote from a contractor on the approved list. The proposal should identify the asset, work scope, quoted items, quantities or hours, cost, and the intended completion arrangement. If the contractor is not approved or the quote lacks enough detail, request the missing information rather than creating a purchase order against an unreviewed scope. Obtain facilities and purchasing approval before creating the NetSuite purchase order. Record both decisions against the quote version they reviewed. A facilities agreement that work is needed does not substitute for purchasing approval of the commitment. Changes to scope or cost need the applicable approval process before additional work is recorded as authorized. ## Track acceptance and then reconcile the invoice Track the work in Postgres and coordinate updates through Zendesk. Preserve the contractor’s progress, completion evidence, and any remaining actions. Collect facility acceptance before closing the maintenance request; the contractor’s statement that work is complete does not establish the facility’s acceptance. Compare the invoice with the approved work, purchase order, and completion evidence. Identify differences in scope, quantities, rates, or unsupported charges and send them to finance. Keep financial exceptions linked even when the maintenance work itself has been accepted. The workflow never authorizes payment, whether the invoice matches or requires investigation. ## A five-step operating sequence 1. 01 Check existing work Match the Zendesk report to the Salesforce asset and inspect Postgres work requests. Compare problem scope before creating or linking a request. The same asset can have unrelated issues, while repeated reports may describe one existing job. 2. 02 Gather the quote Use an approved contractor and obtain a quote specifying the work, asset, quantities or hours, cost, and completion arrangement. Resolve missing scope before requesting approval. Do not treat a contractor’s informal availability as purchasing authorization. 3. 03 Obtain both approvals Ask facilities and purchasing to approve the quote version before creating the NetSuite purchase order. Preserve both decisions and the approved scope. Additional work or cost must follow the applicable change-approval process rather than silently extending the order. 4. 04 Track and accept work Track progress in Postgres and communicate through Zendesk. Collect completion evidence and facility acceptance before closing the maintenance request. A contractor’s completion note alone does not establish that the facility accepts the result. 5. 05 Compare the invoice Reconcile invoice lines with approved work and completion evidence. Send discrepancies to finance with the linked records, keeping financial exceptions visible after work acceptance. Do not authorize payment even when the invoice matches the approved purchase order. ![Coordinate Public-Facility Maintenance from Request to Completion — check existing work, then gather the quote, then obtain both approvals, then track and accept work, then compare the invoice.](https://www.stacksync.com/images/blog-diagrams/genies-facility-maintenance.webp) *Coordinate Public-Facility Maintenance from Request to Completion — check existing work, then gather the quote, then obtain both approvals, then track and accept work, then compare the invoice.* ## Illustrative workflow example Two facility staff report the same asset problem. The workflow links the second report to the existing work request, obtains an approved-contractor quote and both approvals, then creates one purchase order. Closure waits for facility acceptance. This example uses fictional records to show the decision logic. It is not a customer case study or a claim of measured results. In a live case, retain the actual record IDs and evidence behind each statement, and replace all illustrative quantities or timing assumptions with the approved operational inputs. ## What the handoff should contain A linked maintenance record from asset and contractor quote through dual approval, purchase order, completion, facility acceptance, and any finance-owned invoice exception. Keep the evidence reference, observation time, current owner, and outstanding decision with the case. A colleague taking over should be able to distinguish a proposal from a confirmed result without reading every previous message. If a source value changes while the case is waiting, recheck the affected decision before proceeding. ![Required systems feed case verification; missing evidence or decisions return to clarification before the workflow proceeds.](https://www.stacksync.com/images/blog-diagrams-mermaid/genies-facility-maintenance.webp) *Required systems feed case verification; missing evidence or decisions return to clarification before the workflow proceeds.* ## Approval and completion checklist - Identify the Salesforce asset and check Postgres work requests before creating another. - Use an approved contractor and require facilities plus purchasing approval before a NetSuite PO. - Track work in Postgres and updates in Zendesk; obtain facility acceptance before closing. - Compare invoice, approved work, and completion evidence; route discrepancies to finance and never authorize payment. ## Validate the job before enabling it Start with a small reviewed set of cases from the systems above. Include a complete case, an ambiguous match, a missing source record, and an interrupted action where the result is uncertain. Use a draft or test environment for validation and compare the output with the source records before allowing the configured production actions. For this job, the most important checks are identify the Salesforce asset and check Postgres work requests before creating another. Compare invoice, approved work, and completion evidence; route discrepancies to finance and never authorize payment. Record the expected result before the trial, then compare both the proposed action and the final evidence. A fluent message is not a passing result if it skips one of these conditions. - Duplicate work requests and purchase orders prevented - Purchase orders backed by facilities and purchasing approval - Accepted maintenance jobs with unresolved invoice discrepancies Use these as operating measures, not promised performance improvements. Establish the current baseline and review exceptions with the team that owns the process. Investigate an increase in incorrect matches, unauthorized actions, or premature closure before expanding the job’s scope. ## Give your Genie a job description Copy the job description below. It preserves the scope and decision boundaries of this use case. Configure the referenced systems, record relationships, policies, and approval owners in your workspace before enabling the job. Facility maintenance · Hard When a public facility reports a maintenance problem in Zendesk, identify the asset in Salesforce and check existing work requests in Postgres to avoid duplicates. Gather a quote from an approved contractor and request facilities and purchasing approval before creating a NetSuite purchase order. Track the work in Postgres and coordinate updates through Zendesk. Collect facility acceptance before closing the request, then compare the invoice with the approved work and completion evidence. Send discrepancies to finance and never authorize payment yourself. Paste this into “Give your Genie a job description.” [Explore Stacksync Genies](https://www.stacksync.com/ai-agents). ## Related workflow and integration guides - [Reconcile Contractor Quotes, Approved Work, and Maintenance Invoices](https://www.stacksync.com/blog/reconcile-contractor-quotes-approved-work-and-maintenance-invoices) - [All Genies workflow examples](https://www.stacksync.com/ai-agents#genies-use-cases) - [When a workflow should escalate to a person](https://www.stacksync.com/blog/human-in-the-loop-automation-when-to-escalate) - [Answer Application Status Requests Using Official Records](https://www.stacksync.com/blog/answer-application-status-requests-using-official-records) - [Investigate Supplier Invoice Exceptions Before Finance Review](https://www.stacksync.com/blog/investigate-supplier-invoice-exceptions-before-finance-review) - [Aurora PostgreSQL and Salesforce in Both Directions, Step by Step](https://www.stacksync.com/blog/sync-aurora-postgresql-with-salesforce) - [Zendesk integrations](https://www.stacksync.com/connectors/zendesk) - [Netsuite integrations](https://www.stacksync.com/connectors/netsuite) ## Implementation references These first-party references document the underlying records and interfaces. The cross-system sequence, approvals, and completion rules in this article are a proposed operational configuration; validate them against your connected workspace before enabling it. - [Salesforce: assets, entitlements, and service agreements](https://help.salesforce.com/s/articleView?id=service.entitlements_overview.htm&language=en_US) - [NetSuite: receiving purchase orders](https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N2411320.html) - [Zendesk: ticket comments and visibility](https://developer.zendesk.com/api-reference/ticketing/tickets/ticket_comments/) Start with one sync and see it hold Connect two systems, watch a record move both ways, then decide. [Start syncing](https://app.stacksync.com/) FAQ ## Frequently asked questions What does the facility maintenance workflow produce? A linked maintenance record from asset and contractor quote through dual approval, purchase order, completion, facility acceptance, and any finance-owned invoice exception. What should the team verify before the job can proceed? Identify the Salesforce asset and check Postgres work requests before creating another. Use an approved contractor and require facilities plus purchasing approval before a NetSuite PO. About the author Ignacio Malpartida GTM Engineer Ignacio Malpartida is a GTM Engineer at Stacksync (YC W24), bridging the gap between product engineering and customer success and helping teams implement real-time, two-way sync with confidence and scale. [All posts by Ignacio Malpartida](https://www.stacksync.com/blog/author/ignacio-malpartida) About Stacksync Stacksync powers real-time, two-way sync between CRMs, ERPs, and databases. Engineers sync data at scale and automate workflows, not dirty API plumbing. Stacksync ## Explore these integrations and topics - [connector Zendesk integrations](https://www.stacksync.com/connectors/zendesk) - [connector NetSuite integrations](https://www.stacksync.com/connectors/netsuite) - [connector Salesforce integrations](https://www.stacksync.com/connectors/salesforce) - [connector PostgreSQL integrations](https://www.stacksync.com/connectors/postgresql) - [platform AI agent operations](https://www.stacksync.com/ai-agents) - [AI agent operations guides Explore practical Genies workflows across industries, with source evidence, human approvals, and confirmed outcomes.](https://www.stacksync.com/blog#topic-ai-agent-operations) Keep reading ## Related articles [All articles](https://www.stacksync.com/blog) [App tips Coordinate Closed-Won Onboarding Across Salesforce and NetSuite 8 min read read](https://www.stacksync.com/blog/coordinate-closed-won-onboarding-across-salesforce-and-netsuite) [App tips Coordinate Equipment Repairs Across Service, Inventory, and Scheduling 8 min read read](https://www.stacksync.com/blog/coordinate-equipment-repairs-across-service-inventory-and-scheduling) [App tips Reconcile Contractor Quotes, Approved Work, and Maintenance Invoices 7 min read read](https://www.stacksync.com/blog/reconcile-contractor-quotes-approved-work-and-maintenance-invoices) ## You just read how it should work. See it run on your own data. [Book a demo](https://www.stacksync.com/book-a-demo) [Get started](https://app.stacksync.com/)