I am playing withthe ToTable function, 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 created into B10 correctly. When I refresh the data for the GI and apply different parameters (period for example), the GI refreshes nicely, but the table is not refreshing. I tried Table Design>>Refresh, but nothing happened. Am I missing something, is the table meant to be refreshed when the GI result changes? Thank you. Mari-Liis
The TOTABLE is simply provided to help you to output to table for functions that do not have built-in support for table mirroring.
Either way, I will get this to the attention of our documentation team, as improvements can be made to make this clearer and more detailed.
Regards,
Gabriel
0 Votes
M
Mariliis. broughposted
14 days ago
Thanks, Gabriel!
There were two reasons why I tried the TOTABLE function:
Fear of missing out. I wanted to understand how and when I should be using the TOTABLE function.
With a GI output as an array, users could not sort certain fields.
I have now created my table with the OutputColumn1, and it's working fine. It took a few tries, and I kept having the same issue as with TOTABLE, where the "link" between the GI formula and the table disappears. However, it's working now and refreshing as well.
It might be helpful if you could release "how-to" articles about the steps on how the Output column/ToTable (and why?) should be used. I think where I am going wrong is creating the output table first and then editing the GI formula.
0 Votes
Gabriel Michaudposted
16 days ago
Admin
Mari-Liis,
Any reason you are using =TOTABLE() with the generic inquiry? The =GI() function is able to output to a data table -- just reference the first cell where you want it outputted.
0 Votes
H
Harry Lewisposted
27 days ago
Admin
Hello. So far, I have been unable to duplicate what you describe.
In my example, I start with one set of data (just credit memos) in Velixo NX:
When I add debit memos to my filter, the GI and the table both update:
I would suggest submitting your question to the Velixo Help Desk, so that they can look at the specifics.
0 Votes
Hi!
I am playing with the ToTable function, 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 created into B10 correctly.
When I refresh the data for the GI and apply different parameters (period for example), the GI refreshes nicely, but the table is not refreshing. I tried Table Design>>Refresh, but nothing happened. Am I missing something, is the table meant to be refreshed when the GI result changes?
Thank you.
Mari-Liis
0 Votes
4 Comments
Gabriel Michaud posted 14 days ago Admin
Thanks for your reply Mari-Liis!
This page on our web site deals with the table mirroring: https://help.velixo.com/support/solutions/articles/153000219482
The TOTABLE is simply provided to help you to output to table for functions that do not have built-in support for table mirroring.
Either way, I will get this to the attention of our documentation team, as improvements can be made to make this clearer and more detailed.
Regards,
Gabriel
0 Votes
Mariliis. brough posted 14 days ago
Thanks, Gabriel!
There were two reasons why I tried the TOTABLE function:
I have now created my table with the OutputColumn1, and it's working fine. It took a few tries, and I kept having the same issue as with TOTABLE, where the "link" between the GI formula and the table disappears. However, it's working now and refreshing as well.
It might be helpful if you could release "how-to" articles about the steps on how the Output column/ToTable (and why?) should be used. I think where I am going wrong is creating the output table first and then editing the GI formula.
0 Votes
Gabriel Michaud posted 16 days ago Admin
Mari-Liis,
Any reason you are using =TOTABLE() with the generic inquiry? The =GI() function is able to output to a data table -- just reference the first cell where you want it outputted.
0 Votes
Harry Lewis posted 27 days ago Admin
Hello. So far, I have been unable to duplicate what you describe.
In my example, I start with one set of data (just credit memos) in Velixo NX:
When I add debit memos to my filter, the GI and the table both update:
I would suggest submitting your question to the Velixo Help Desk, so that they can look at the specifics.
0 Votes
Login or Sign up to post a comment