# Latest **URL:** https://community.velixo.com/latest.md?page=2 [Latest](https://community.velixo.com/latest.md) · [Categories](https://community.velixo.com/categories.md) · [Tags](https://community.velixo.com/tags.md) **Page:** 3 --- ## [Distribution error Exception from HRESULT: 0x800A03EC](https://community.velixo.com/t/distribution-error-exception-from-hresult-0x800a03ec/96)
**Author:** [@Mari\_Liis\_Brough2](https://community.velixo.com/u/Mari_Liis_Brough2)\ **Replies:** 4\ **Last updated:** [April 25, 2025, 8:17pm UTC](https://community.velixo.com/t/distribution-error-exception-from-hresult-0x800a03ec/96 "2025-04-25T20:17:14Z")
I am getting an error Exception from HRESULT: 0x800A03EC when distributing. The distribution manages to create the file and auto-hide rows but does not create email. I have checked Name Manager for anything obvious. Al… --- ## [ToTable function and table not refreshing](https://community.velixo.com/t/totable-function-and-table-not-refreshing/95)
**Author:** [@Mari\_Liis\_Brough2](https://community.velixo.com/u/Mari_Liis_Brough2)\ **Replies:** 4\ **Last updated:** [April 24, 2025, 8:35pm UTC](https://community.velixo.com/t/totable-function-and-table-not-refreshing/95 "2025-04-24T20:35:14Z")
Hi! I am playing withthe ToTablefunction, and I am a bit stuck. I have a GI listing transaction (GL Transaction listing).My formula is simple: TOTABLE(AR10#,TRUE,B10) AR10 has a formula =GI(…GIFILTER…) The table is c… --- ## [Multiple Connections](https://community.velixo.com/t/multiple-connections/98)
**Author:** [@Nathan\_Gayeski](https://community.velixo.com/u/Nathan_Gayeski)\ **Replies:** 5\ **Last updated:** [April 22, 2025, 7:29pm UTC](https://community.velixo.com/t/multiple-connections/98 "2025-04-22T19:29:20Z")
Hello, is there a way to query on multiple connections? Example SI.EXPANDLOCATIONRANGE(Connection 1;Connection 2,Range)) Thanks! --- ## [Velixo Training For Project Dimension Data](https://community.velixo.com/t/velixo-training-for-project-dimension-data/97)
**Author:** [@Bdemasellis](https://community.velixo.com/u/Bdemasellis)\ **Replies:** 1\ **Last updated:** [April 22, 2025, 2:03pm UTC](https://community.velixo.com/t/velixo-training-for-project-dimension-data/97 "2025-04-22T14:03:50Z")
Does anyone have any good documentation or training on how they access the project dimension data in Sage Intacct so that I can build a WIP report with Velixo including overhead allocations? --- ## [Financial period 'mm-yyyy' does not exist in the company](https://community.velixo.com/t/financial-period-mm-yyyy-does-not-exist-in-the-company/94)
**Author:** [@Steve\_Gagne](https://community.velixo.com/u/Steve_Gagne)\ **Replies:** 6\ **Last updated:** [April 3, 2025, 1:10pm UTC](https://community.velixo.com/t/financial-period-mm-yyyy-does-not-exist-in-the-company/94 "2025-04-03T13:10:48Z")
Can anyone assist with this error? I receive the error “Error! Financial period ‘mm-yyyy’ does not exist in the company ‘COMPANY’” with the ACCOUNTENDINGBALANCE formula. I have ten companies in the same file and this e… --- ## [Pull GL balances for all branches](https://community.velixo.com/t/pull-gl-balances-for-all-branches/93)
**Author:** [@Steve\_Gagne](https://community.velixo.com/u/Steve_Gagne)\ **Replies:** 7\ **Last updated:** [April 1, 2025, 6:10pm UTC](https://community.velixo.com/t/pull-gl-balances-for-all-branches/93 "2025-04-01T18:10:31Z")
I support several companies, most of which use only a few branches. I have one retail chain with over 100 branches and growing. Is there a way to pull in the combined ending balance for an account/subaccount combinatio… --- ## [Auto-hide rules not being individually applied to worksheets created with distribution blueprints](https://community.velixo.com/t/auto-hide-rules-not-being-individually-applied-to-worksheets-created-with-distribution-blueprints/92)
**Author:** [@Derek\_Daane](https://community.velixo.com/u/Derek_Daane)\ **Replies:** 3\ **Last updated:** [April 1, 2025, 4:28pm UTC](https://community.velixo.com/t/auto-hide-rules-not-being-individually-applied-to-worksheets-created-with-distribution-blueprints/92 "2025-04-01T16:28:38Z")
When using the blueprint functionality in the Distribution lists, it looks like the auto-hide rules aren’t being applied to each worksheet created. Instead, it looks like the autohide rules are set by the first workshe… --- ## [SI.EXPANDACCOUNTSINGROUP return child account groupings by account group](https://community.velixo.com/t/si-expandaccountsingroup-return-child-account-groupings-by-account-group/58)
**Author:** [@Tom\_Roberts](https://community.velixo.com/u/Tom_Roberts)\ **Replies:** 4\ **Last updated:** [April 1, 2025, 12:23am UTC](https://community.velixo.com/t/si-expandaccountsingroup-return-child-account-groupings-by-account-group/58 "2025-04-01T00:23:51Z")
We have a number of nested account groups it would be useful to have SI.EXPANDACCOUNTSINGROUP or a similar function return an array which shows the nested names and account numbers. Example: Lets say we have an account… --- ## [Displaying values on row level instead of columns](https://community.velixo.com/t/displaying-values-on-row-level-instead-of-columns/91)
**Author:** [@Harshita\_Sethia](https://community.velixo.com/u/Harshita_Sethia)\ **Replies:** 3\ **Last updated:** [March 24, 2025, 5:23pm UTC](https://community.velixo.com/t/displaying-values-on-row-level-instead-of-columns/91 "2025-03-24T17:23:22Z")
Hello all, I was wondering if it would be possible to display the column level data as row level in Velixo. So its like the columns of a GI should be displayed as rows and the values of those next to it. I have shared a… --- ## [Function that will mirror the Dimension Balances Report](https://community.velixo.com/t/function-that-will-mirror-the-dimension-balances-report/68)
**Author:** [@Patrick\_Young](https://community.velixo.com/u/Patrick_Young)\ **Replies:** 14\ **Last updated:** [March 19, 2025, 6:04pm UTC](https://community.velixo.com/t/function-that-will-mirror-the-dimension-balances-report/68 "2025-03-19T18:04:21Z")
Auditors are typically resistant to the consolidated trial balance and still want to see a breakdown by account number, department, and location. So, we use the dimension balances report to satisfy that request. It woul… --- ## [How to group values to create a single writeback transaction instead of multiple?](https://community.velixo.com/t/how-to-group-values-to-create-a-single-writeback-transaction-instead-of-multiple/90)
**Author:** [@Harshita\_Sethia](https://community.velixo.com/u/Harshita_Sethia)\ **Replies:** 7\ **Last updated:** [March 19, 2025, 9:57am UTC](https://community.velixo.com/t/how-to-group-values-to-create-a-single-writeback-transaction-instead-of-multiple/90 "2025-03-19T09:57:44Z")
Hello all, I have been trying to use the Velixo writeback feature to create debit memos from the data. So the scenario is if there are 3 line items with Project A and amount 10$, 20$& 30$, as of now it would create 3 se… --- ## [Auto-close side panel after Refresh](https://community.velixo.com/t/auto-close-side-panel-after-refresh/52)
**Author:** [@Amir\_Friedman](https://community.velixo.com/u/Amir_Friedman)\ **Replies:** 3\ **Last updated:** [March 18, 2025, 5:16pm UTC](https://community.velixo.com/t/auto-close-side-panel-after-refresh/52 "2025-03-18T17:16:32Z")
Whenever a refresh is started, the NX Status side panel pops out and displays the count-down of functions to be calculated. It would be nice to have an option to auto-close the side panel when the refresh is completed. … --- ## [Distribute List to Create an Option to Distribute to a new tab](https://community.velixo.com/t/distribute-list-to-create-an-option-to-distribute-to-a-new-tab/61)
**Author:** [@Maximilian\_Dyer](https://community.velixo.com/u/Maximilian_Dyer)\ **Replies:** 2\ **Last updated:** [March 11, 2025, 11:51pm UTC](https://community.velixo.com/t/distribute-list-to-create-an-option-to-distribute-to-a-new-tab/61 "2025-03-11T23:51:55Z")
Hello - we have an “enhancement” request for a feature that we think could be very useful. It would be great, if one of the methods of distribution from the Distribution List, was to create a new tab in the workbook, wit… --- ## [Pulling Project Transaction Details](https://community.velixo.com/t/pulling-project-transaction-details/89)
**Author:** [@David\_Falls](https://community.velixo.com/u/David_Falls)\ **Replies:** 4\ **Last updated:** [February 27, 2025, 5:09pm UTC](https://community.velixo.com/t/pulling-project-transaction-details/89 "2025-02-27T17:09:16Z")
Has anybody found a way to pull the Project Transaction Details in the same way it is put together in the Inquiry screen? --- ## [Ability to customize Drilldown sheets](https://community.velixo.com/t/ability-to-customize-drilldown-sheets/88)
**Author:** [@Damien](https://community.velixo.com/u/Damien)\ **Replies:** 0\ **Last updated:** [February 26, 2025, 7:36am UTC](https://community.velixo.com/t/ability-to-customize-drilldown-sheets/88 "2025-02-26T07:36:35Z")
Creating on behalf of John B. I would like to see a column to the right of column C that essentially says “Offset.” Then in the row for Meals and Entertainment in that example, the Offset column would show “Credit Card … --- ## [Error installing Velixo Classic](https://community.velixo.com/t/error-installing-velixo-classic/86)
**Author:** [@Claude\_Matherne](https://community.velixo.com/u/Claude_Matherne)\ **Replies:** 5\ **Last updated:** [February 25, 2025, 5:21pm UTC](https://community.velixo.com/t/error-installing-velixo-classic/86 "2025-02-25T17:21:55Z")
I’m tying to install Velixo Add in on a user’s PC, and I keep getting this error message on the install. I can confirmed Trust Center is correct, no instances of Excel are open and the user is on a recent version of Exc… --- ## [Toolbar button that will allow you to turn on and off the Velixo formulas](https://community.velixo.com/t/toolbar-button-that-will-allow-you-to-turn-on-and-off-the-velixo-formulas/75)
**Author:** [@Patrick\_Young](https://community.velixo.com/u/Patrick_Young)\ **Replies:** 7\ **Last updated:** [February 14, 2025, 7:16pm UTC](https://community.velixo.com/t/toolbar-button-that-will-allow-you-to-turn-on-and-off-the-velixo-formulas/75 "2025-02-14T19:16:04Z")
Toolbar button that will allow you to turn on and off the Velixo formulas This idea had 1 vote on the previous Velixo community. --- ## [MYOB Acumatica user profile does not have an API User Access license assigned](https://community.velixo.com/t/myob-acumatica-user-profile-does-not-have-an-api-user-access-license-assigned/87)
**Author:** [@Esnath\_Mungazi](https://community.velixo.com/u/Esnath_Mungazi)\ **Replies:** 1\ **Last updated:** [February 12, 2025, 9:46pm UTC](https://community.velixo.com/t/myob-acumatica-user-profile-does-not-have-an-api-user-access-license-assigned/87 "2025-02-12T21:46:10Z")
I have a client who was using Velixo without any issues, until the site was upgraded to MYOB Acumatica version 2024.114.202.2619. When attempting to use Velixo an error now pops “Your ERP user profile does not have an A… --- ## [GI() in Excel says GI not found. ](https://community.velixo.com/t/gi-in-excel-says-gi-not-found/85)
**Author:** [@James\_Sparks](https://community.velixo.com/u/James_Sparks)\ **Replies:** 2\ **Last updated:** [January 17, 2025, 10:51pm UTC](https://community.velixo.com/t/gi-in-excel-says-gi-not-found/85 "2025-01-17T22:51:56Z")
I have created a GI in Acumatica and Exposed it to Odata, but when I use Excel function GI(), it says the GI is not found --- ## [How to Auto-Hide headers](https://community.velixo.com/t/how-to-auto-hide-headers/84)
**Author:** [@Mari\_Liis\_Brough](https://community.velixo.com/u/Mari_Liis_Brough)\ **Replies:** 2\ **Last updated:** [December 30, 2024, 7:21am UTC](https://community.velixo.com/t/how-to-auto-hide-headers/84 "2024-12-30T07:21:43Z")
Hi Looking for an easy way to auto-hide headers. In the example below, I have three Account Classes listed, and in the C column, I am using VTEXTSPLIT(AccountClassList()) to list accounts within the account class. If … --- ## [Gi Function date filter](https://community.velixo.com/t/gi-function-date-filter/83)
**Author:** [@David\_Racer](https://community.velixo.com/u/David_Racer)\ **Replies:** 6\ **Last updated:** [December 19, 2024, 5:08pm UTC](https://community.velixo.com/t/gi-function-date-filter/83 "2024-12-19T17:08:51Z")
I am trying to filter a date from the GI and the array is returning an error. The filter actually goes through correctly and I can see the filter details in the cell, but the query returns a #value error. Below is the va… --- ## [Operator to Exclude a Dimension Value](https://community.velixo.com/t/operator-to-exclude-a-dimension-value/82)
**Author:** [@Nathan\_Gayeski](https://community.velixo.com/u/Nathan_Gayeski)\ **Replies:** 3\ **Last updated:** [December 5, 2024, 12:24am UTC](https://community.velixo.com/t/operator-to-exclude-a-dimension-value/82 "2024-12-05T00:24:42Z")
Hello, In the formulate below, I would like to include all dimension values EXCEPT ones that contain Class “transfer”. However, I can’t find the right formula. If I add"\<\> transfer", I receive an error. Thanks! =SI.TUR… --- ## [ACCOUNTENDINGBALANCE formula behave differently in Velixo Classic and Velixo Nx](https://community.velixo.com/t/accountendingbalance-formula-behave-differently-in-velixo-classic-and-velixo-nx/81)
**Author:** [@Chris\_Chun](https://community.velixo.com/u/Chris_Chun)\ **Replies:** 3\ **Last updated:** [November 18, 2024, 8:06pm UTC](https://community.velixo.com/t/accountendingbalance-formula-behave-differently-in-velixo-classic-and-velixo-nx/81 "2024-11-18T20:06:44Z")
I switched from Velixo Classis to Velixo Nx last week and am having an issue. The ‘ACCOUNTENDINGBALANCE’ formula used in Velixo seems to behave differently when running in Velixo Classic or Velixo Nx. In one G&A expense… --- ## [Excel Static Copy](https://community.velixo.com/t/excel-static-copy/80)
**Author:** [@Godfrey\_vandeleur](https://community.velixo.com/u/Godfrey_vandeleur)\ **Replies:** 4\ **Last updated:** [November 15, 2024, 12:23am UTC](https://community.velixo.com/t/excel-static-copy/80 "2024-11-15T00:23:20Z")
Hello, New user here. Is there a way to create an excel static copy where formulas do not break for other users of the report? --- ## [Optional parameters](https://community.velixo.com/t/optional-parameters/30)
**Author:** [@Damien](https://community.velixo.com/u/Damien)\ **Replies:** 1\ **Last updated:** [November 14, 2024, 6:27am UTC](https://community.velixo.com/t/optional-parameters/30 "2024-11-14T06:27:54Z")
Hi there. I thought I’d share this one here. It is something that may be obvious to most users as it is a core concept of Velixo functions, but since it was confusing to someone we had a call with, it’s worth documenting… --- ## [Velixo.VBA object available on Velixo NX?](https://community.velixo.com/t/velixo-vba-object-available-on-velixo-nx/78)
**Author:** [@Royce\_Pruitt](https://community.velixo.com/u/Royce_Pruitt)\ **Replies:** 6\ **Last updated:** [October 24, 2024, 4:01pm UTC](https://community.velixo.com/t/velixo-vba-object-available-on-velixo-nx/78 "2024-10-24T16:01:28Z")
Does anyone know if the Velixo VBA object is available on Velixo NX? If so, does anyone know how to install it? I am trying to pause my VBA code so that Velixo will calc before it proceeds and found a VBA command that… --- ## [GIFilter function returns Cell number, not Cell Value](https://community.velixo.com/t/gifilter-function-returns-cell-number-not-cell-value/77)
**Author:** [@Claude\_Matherne](https://community.velixo.com/u/Claude_Matherne)\ **Replies:** 2\ **Last updated:** [October 2, 2024, 10:47pm UTC](https://community.velixo.com/t/gifilter-function-returns-cell-number-not-cell-value/77 "2024-10-02T22:47:23Z")
Trying to build a spreadsheet that will filter a GI brought into it. I have Cell B2 as a financal period, then I populate cells B2 and B3 with the FINANCIALPERIODSTARTDATE and FINANCIALPERIODENDDATE. Then I have my GIF… --- ## [Date Functions - MTD, QTD, YTD](https://community.velixo.com/t/date-functions-mtd-qtd-ytd/76)
**Author:** [@Patrick\_Young](https://community.velixo.com/u/Patrick_Young)\ **Replies:** 3\ **Last updated:** [September 25, 2024, 3:37am UTC](https://community.velixo.com/t/date-functions-mtd-qtd-ytd/76 "2024-09-25T03:37:47Z")
Hello, I am aware of the “start date” and “end date” arguments for the various Velixo functions, but have you guys given any thought to introducing a turnover function where you only need to provide the end date and the… --- ## [Journal Entries Not Refreshing](https://community.velixo.com/t/journal-entries-not-refreshing/74)
**Author:** [@Nathan\_Gayeski](https://community.velixo.com/u/Nathan_Gayeski)\ **Replies:** 3\ **Last updated:** [September 20, 2024, 2:35pm UTC](https://community.velixo.com/t/journal-entries-not-refreshing/74 "2024-09-20T14:35:36Z")
Hello, So when we make an entry, go into our report and refresh. Everything pulls in our report. However, If we make an edit to the entry and than go back into our Velixo report, the entry won’t fully update and will be… --- ## [What goes in the "Task" column in Project Forecast Writeback sheet?](https://community.velixo.com/t/what-goes-in-the-task-column-in-project-forecast-writeback-sheet/73)
**Author:** [@Julie\_Zhu](https://community.velixo.com/u/Julie_Zhu)\ **Replies:** 2\ **Last updated:** [September 11, 2024, 9:09pm UTC](https://community.velixo.com/t/what-goes-in-the-task-column-in-project-forecast-writeback-sheet/73 "2024-09-11T21:09:05Z")
Hello! I am trying to perform a project forecast writeback using the Project Forecast Worksheet. Below is the error message I am getting when I try performing writeback, basically saying my project task cannot be found.… [Previous page](https://community.velixo.com/latest.md?page=1) [Next page](https://community.velixo.com/latest.md?page=3)