Solved

Cannot synchronize consolidation unit ledgers

  • 24 October 2023
  • 5 replies
  • 74 views
cmanhoff
Rank
Userlevel 3

I am trying to set up a consolidation unit in the GL in the F300 training.  The consolidation unit is on a separate tenant from the consolidation company but on the same instance.

My Acumatica version is 2023 R1.

The company name is AZ_Subsidiary.  From what I’ve read, this should also be the Tenant ID.

However, the system throws an error (actually multiple errors) when trying to synchronize the subsidiary ledger to the parent ledger. Looking at the trace log, the first error thrown is “Unable to connect to the remote server.  So I’m assuming the main problem is an incorrect URL.

From what I’ve found on the web, the core tenant URL should be:

where “MyDomain.net/MyInstance” is the public URL for the instance and “AZ_Subsidiary” is the Tenant ID.

But it’s not working.  So I’ve also tried:

  • https://MyDomain.net
  • https://MyDomain.net/MyInstance (i.e. the public URL for the instance without the tenant ID)
  • All of the above with http:
  • ~/AZ_Subsidiary
  • ~

I’ve scoured the help and community sites but can’t find anything relevant.  Am I putting the wrong core tenant URL? Or is something else causing the error?

Thanks for the help.

icon

Best answer by cmanhoff 4 December 2023, 22:11

View original
IT solutions for accountants designed by accountants

5 replies

Laura02
Rank
Badge +18

Hello @cmanhoff ,

We have one live client site using consolidations, and this is what I see in the Consolidation Preferences screen in the Parent tenant:

Active: checked on

Consolidation Ledger: ACTUAL

Consolidation Unit: PARENT (Company name in Cnlsolidation tenant)

Username:  GLConsol@TENANTNAME (where GLConsol is a user login with GL Admin & Internal User roles)

Password:  Password of GLConsol User, who is also set up in the ‘child’ tenant with same password.

URL:  https://[sitename].acumatica.com

Source Ledger: Actual

Source Branch: Branch Name from child tenant

 

I hope this helps you make a connection. 😀

 

Laura

 

 

 

Laura ~ Klear Systems, Inc. Irvine, CA. ~ AUG Forums Episode130 ~
cmanhoff
Rank
Userlevel 3

Hi Laura,

Thanks for the comment.  My configuration matches yours right up to the URL.  It looks like you are using the Acumatica Cloud from your address.  I am using AWS and so my URL is slightly different.  It’s https: //[My instance public URL]/[TenantID]/.  

The [My instance public URL] works fine by itself and properly resolves.  Adding the Tenant ID should be the core tenant URL according to the one source I found on the web.  However, it is from a third-party Acumatica ISV partner.  Acumatica itself doesn’t have any instructions or guidance on this.

It’s very frustrating since this is a core funcitionality for us.  But I do appreciate the comment.

IT solutions for accountants designed by accountants
Chris Hackett
Rank
Userlevel 7
Badge

Hi @cmanhoff were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
cmanhoff
Rank
Userlevel 3

Hi Chris,

Yes, I did.  I got an answer from support.  The correct URL to use is “http://MyDomain.net/MyInstance”.  You do not need to include the tenant name and you don’t use https.  The odd thing is I did try both but the second time it worked.  So, problem solved and thanks for the follow up.

Regards,

Chris

IT solutions for accountants designed by accountants
Chris Hackett
Rank
Userlevel 7
Badge

Thank you for sharing the solution with the community @cmanhoff!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved