What happened
What this says
As at Fri 9 Oct 2026Sunil Kapoor asked how to query the brain to identify variations without matching invoices and set up a repeatable monthly process. Olivia Grant confirmed the brain indexed both variation and invoice records and could be queried by project code.
Problem: Sunil needed a repeatable monthly process to reconcile variations against invoices by project code.
Handling: Olivia Grant confirmed the brain had both records indexed and could query for variations with matching project codes but no invoice recorded. She also noted the dashboards builder could automate this.
Watch: Customer can now manage reconciliation directly. Reflects adoption of advanced query and dashboard capabilities.
Details
Updated 9 Oct 26Trail
- created · Sunil Kapoor 19 Nov 2025 13:54Hi, I need to reconcile our recorded variations against invoiced amounts, and I'm trying to set up a process we can repeat each month. Can I query the brain to show variations that don't have a matching invoice yet? We track everything by project code. Cheers, Sunil
- Public reply · Olivia Grant 19 Nov 2025 15:28Hi Sunil, I've picked this up. The brain has your full variation and invoice records indexed, so you can query it directly for variations where the project code is matched but there's no invoice recorded. That will show you exactly what's pending reconciliation. You can also build a dashboard in the dashboards builder if you want to track this every month. Let me know if you run into any trouble. Thanks, Olivia
- Status change · 2 Dec 2025 23:59