Currency Code (USD, EUR, GBP), Amount Minor Units (Cents), Invoice Pair Key, and Dedupe Review Status (Pending Review, Confirmed Duplicate, Approved Separate Bill).
(500.00) to negative integers (-50000), parse the last decimal separator explicitly by vendor locale, and build a sorted pair_key combining vendor_id + currency + amount_cents across invoices dated within 3 days of each other.
pair_key matches an active record into a Duplicate Hold stage and send one daily digest to Slack or Conversations > Team Inbox, pausing payment until a bookkeeper sets Dedupe Review Status to Approved Separate Bill.
Configure duplicate invoice and order detection across n8n and GoHighLevel in sub-account <YOUR_LOCATION_ID>: 1. In Settings > Custom Fields, create Opportunity fields for Currency Code, Amount Minor Units (Cents), Invoice Pair Key, and Dedupe Review Status. 2. In Automation > Workflow Builder and n8n, parse decimal formats and bracketed credits into signed integer cents and generate a sorted pair_key across vendor_id, currency, and amount within a 3-day window. 3. In Opportunities > Pipelines, hold matching pair_key records in Duplicate Hold until Dedupe Review Status is updated to Approved Separate Bill.
# Inspect opportunity custom fields and invoice review pipelines in the sub-account ghl-crm custom-fields list --context <YOUR_CONTEXT> --location <YOUR_LOCATION_ID> ghl-crm pipelines list --context <YOUR_CONTEXT> --location <YOUR_LOCATION_ID>
Official GHL MCP vs. ghl-tools: HighLevel’s official hosted MCP (services.leadconnectorhq.com/mcp) covers public v2 CRM records (contacts, opportunities, appointments, conversations). ghl-tools MCP complements it with workflow graph inspection & recipes, funnel/form builders, DNS/BIMI checks, and ghl-crm doctor audits.
1,234.56 vs 1.234,56), accounting bracket credits ((500.00)), multiple currencies (USD vs EUR), or re-sent bills where the vendor appends a letter (INV-204 vs INV-204A) two days later.Currency Code, Amount in CentsInvoice Pair Key in Settings > Custom Fields, parse locale decimal separators and negative credit brackets explicitly in Automation > Workflow Builder (and n8n)Approved Separate Bill status so bookkeepers do not have to delete rows to clear false positives.| Step | Menu Path in GHL | Action |
|---|---|---|
| Step 1 | Settings > Custom Fields | Create Opportunity fields for Currency Code (USD, EUR, GBP), Amount Minor Units (Cents), Invoice Pair Key, and Dedupe Review Status (Pending Review, Confirmed Duplicate, Approved Separate Bill). |
| Step 2 | Automation > Workflow Builder | Convert bracketed amounts (500.00) to negative integers (-50000), parse the last decimal separator explicitly by vendor locale, and build a sorted pair_key combining vendor_id + currency + amount_cents across invoices dated within 3 days of each other. |
| Step 3 | Opportunities > Pipelines | Route any bill whose pair_key matches an active record into a Duplicate Hold stage and send one daily digest to Slack or Conversations > Team Inbox, pausing payment until a bookkeeper sets Dedupe Review Status to Approved Separate Bill. |
Connect Claude Code, Cursor, or OpenAI Codex to our ghl-tools MCP Server & Rust CLI to build workflows, forms, and funnels from your editor, or start your GoHighLevel plan through our partner link to unlock $612+ in ready-to-import kits (including GHL & n8n Invoice Deduplication Workflow Pack) and weekly live clinics.