# Can't query Consolidated Books anymore **URL:** \ **Category:** Q&A\ **Tags:** Sage-Intacct\ **Created:** [January 23, 2026, 5:48pm UTC](https://community.velixo.com/t/cant-query-consolidated-books-anymore/134 "2026-01-23T17:48:51Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Xavier\_beaudin](https://community.velixo.com/letter_avatar_proxy/v4/letter/x/ad7895/32.png) [@Xavier\_beaudin](https://community.velixo.com/u/Xavier_beaudin)\ **Post date:** [January 23, 2026, 5:48pm UTC](https://community.velixo.com/t/cant-query-consolidated-books-anymore/134/1 "2026-01-23T17:48:51Z")
Hello, I use Velixo with the Sage Intacct integration. Every quarter I have a process where I update a revenue per client spreadsheet. In order to do that, I pull from my consolidated books for all my entities (Locations) the revenue from a specific GL. I have ran this process for more than a year now, without any problem. However, it seems like I’m not able anymore to query consolidated books, even tough I still have consol books in my Intacct instance. When I use the formula =SI.EXPANDCONSOLIDATIONBOOKRANGE(,), it now returns an empty result (#VALUE). Has this happened to anybody else? what had caused this? any changes you had made in your Intacct instance? Thank you! ---
**Author:** ![Harry](https://community.velixo.com/user_avatar/community.velixo.com/harry/32/21_2.png) [@Harry](https://community.velixo.com/u/Harry)\ **Post date:** [January 23, 2026, 5:52pm UTC](https://community.velixo.com/t/cant-query-consolidated-books-anymore/134/2 "2026-01-23T17:52:52Z")
What message is displayed in the Velixo **Status** panel under the **Formulas to Review** section? ![](https://community.velixo.com/uploads/default/original/1X/c0f4e9245d0c651bc5128336a77498a8b78ddde3.png) ---
**Author:** ![Gabriel](https://community.velixo.com/user_avatar/community.velixo.com/gabriel/32/7_2.png) [@Gabriel](https://community.velixo.com/u/Gabriel)\ **Post date:** [January 23, 2026, 6:13pm UTC](https://community.velixo.com/t/cant-query-consolidated-books-anymore/134/3 "2026-01-23T18:13:41Z")
Bonjour Xavier, While waiting for your response on the question Harry asked you, we had our engineering team look at error logs based on your name. It looks like a permission issue, your account no longer has the ability to access the list of consolidated books. This is the error message we found that you will likely see in the “Formulas review” section of the Status panel: PL04000005 You do not have permission for API operation QUERY on objects of type gcbook Is it possible your permissions were modified? Can you double check the username you used to connect? ---
**Author:** ![Xavier\_beaudin](https://community.velixo.com/letter_avatar_proxy/v4/letter/x/ad7895/32.png) [@Xavier\_beaudin](https://community.velixo.com/u/Xavier_beaudin)\ **Post date:** [January 23, 2026, 8:42pm UTC](https://community.velixo.com/t/cant-query-consolidated-books-anymore/134/4 "2026-01-23T20:42:23Z")
Bonjour Gabriel and Harry! Thank you for the prompt feedback. Here is the error message I have after running the formula in excel: ![](https://community.velixo.com/uploads/default/original/1X/47e9c9c58a0d89e1a27b9e837109af5e784e0adf.png) Can you provide instructions in order to look at my Intacct QUERY permissions? Xavier ---
**Author:** ![Harry](https://community.velixo.com/user_avatar/community.velixo.com/harry/32/21_2.png) [@Harry](https://community.velixo.com/u/Harry)\ **Post date:** [January 23, 2026, 11:36pm UTC](https://community.velixo.com/t/cant-query-consolidated-books-anymore/134/5 "2026-01-23T23:36:28Z")
Hello Xavier. If you have sufficient permissions (within Intacct) to access **Company** | **Admin** | **Users** | **View permissions and roles** , you can check. Otherwise, you would want to contact your Intacct administrator. ---
**Author:** ![Xavier\_beaudin](https://community.velixo.com/letter_avatar_proxy/v4/letter/x/ad7895/32.png) [@Xavier\_beaudin](https://community.velixo.com/u/Xavier_beaudin)\ **Post date:** [January 26, 2026, 5:55pm UTC](https://community.velixo.com/t/cant-query-consolidated-books-anymore/134/6 "2026-01-26T17:55:00Z")
Thank you Harry. Yes, with the help of our Intacct admin, we’ve been able to identify the missing permission and it works now. Thank you again. ---
**Author:** ![Xavier\_beaudin](https://community.velixo.com/letter_avatar_proxy/v4/letter/x/ad7895/32.png) [@Xavier\_beaudin](https://community.velixo.com/u/Xavier_beaudin)\ **Post date:** [January 26, 2026, 5:56pm UTC](https://community.velixo.com/t/cant-query-consolidated-books-anymore/134/7 "2026-01-26T17:56:48Z")
As a take-away, I think it would have been helpful if the error message in Velixo would refer to potential missing permissions in Intacct instead of displaying that there is “No Global Consolidation Book” in our instance. Food for thoughts 🙂 Xavier