Facility to handle multiple Connections in similar manner to multiple branches

Posted almost 2 years ago by Jeffrey Patch

Post a topic

Jeffrey Patch

Implemented

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

4 Comments

Velixo Team posted 2 days ago Admin

Hi everyone!

We have just delivered this multi-connection consolidation feature in Velixo NX 2025.11. See: https://help.velixo.com/doc/main/acumatica/multiple-connections-per-formula

It's currently in preview and we have planned several improvements, but it is already available for you to try.

Please let me know if you have any feedback at [email protected]

Thanks

Damien

0 Votes

Jeremy Myers posted over 1 year ago

This is an ask for several customers.

0 Votes

Damien Zwillinger posted almost 2 years ago

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 almost 2 years ago

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