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
0 Votes
2 Comments
Sorted by
Gabriel Michaudposted
42 minutes 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
11 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
2 Comments
Gabriel Michaud posted 42 minutes 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 11 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