In the same manner as you handle multiple branches it would be handy to handle multiple Connections.
In multi-tenant scenarios, company go to great lengths to ensure the same chart of accounts, same subaccounts, same financial calendar, same currency. In that situation, instead of having formulas such as: =ACCOUNTTURNOVER(nConnection,S$4,$G23,$A23#,$B23,S$5,S$2,S$3)+ACCOUNTTURNOVER(nConnection2,S$4,$G23,$A23#,$B23,S$5,S$2,S$3)+ACCOUNTTURNOVER(nConnection3,S$4,$G23,$A23#,$B23,S$5,S$2,S$3)+ACCOUNTTURNOVER(nConnection4,S$4,$G23,$A23#,$B23,S$5,S$2,S$3)+ACCOUNTTURNOVER(nConnection5,S$4,$G23,$A23#,$B23,S$5,S$2,S$3)+ACCOUNTTURNOVER(nConnection6,S$4,$G23,$A23#,$B23,S$5,S$2,S$3) it would be easier to easier to have a formula such as:
:=ACCOUNTTURNOVER(nConnections,S$4,$G23,$A23#,$B23,S$5,S$2,S$3) where nConnections is a TEXTJOIN of the multiple connections.
I believe there is a lot of value in supporting this scenario - not the case today, and there is no other way but to combine multiple functions like you do.
We will leave the idea there for the community to add more votes, and we will research and consider this idea at the same time.
Thanks and Happy holidays!
1 Votes
Miron Shikhovposted
about 1 year ago
Admin
Hi Jeffrey!
This looks like a great idea for a feature request. Thank you for bringing it to our attention!
2 Votes
In the same manner as you handle multiple branches it would be handy to handle multiple Connections.
In multi-tenant scenarios, company go to great lengths to ensure the same chart of accounts, same subaccounts, same financial calendar, same currency. In that situation, instead of having formulas such as: =ACCOUNTTURNOVER(nConnection,S$4,$G23,$A23#,$B23,S$5,S$2,S$3)+ACCOUNTTURNOVER(nConnection2,S$4,$G23,$A23#,$B23,S$5,S$2,S$3)+ACCOUNTTURNOVER(nConnection3,S$4,$G23,$A23#,$B23,S$5,S$2,S$3)+ACCOUNTTURNOVER(nConnection4,S$4,$G23,$A23#,$B23,S$5,S$2,S$3)+ACCOUNTTURNOVER(nConnection5,S$4,$G23,$A23#,$B23,S$5,S$2,S$3)+ACCOUNTTURNOVER(nConnection6,S$4,$G23,$A23#,$B23,S$5,S$2,S$3)
it would be easier to easier to have a formula such as:
:=ACCOUNTTURNOVER(nConnections,S$4,$G23,$A23#,$B23,S$5,S$2,S$3) where nConnections is a TEXTJOIN of the multiple connections.
2 Votes
3 Comments
Jeremy Myers posted 6 months ago
This is an ask for several customers.
0 Votes
Damien Zwillinger posted about 1 year ago Admin
Hi Jeffrey
Thanks for posting this great idea! I have moved it to the Acumatica Ideas & Feature requests forum.
I believe there is a lot of value in supporting this scenario - not the case today, and there is no other way but to combine multiple functions like you do.
We will leave the idea there for the community to add more votes, and we will research and consider this idea at the same time.
Thanks and Happy holidays!
1 Votes
Miron Shikhov posted about 1 year ago Admin
Hi Jeffrey!
This looks like a great idea for a feature request. Thank you for bringing it to our attention!
We actually have a separate section for ideas - https://help.velixo.com/support/discussions/forums/153000037035. It might be worth duplicating it there.
Let me ask our Product team to review your request and provide a feedback.
1 Votes
Login or Sign up to post a comment