Skip to main content
Solved

Cannot synchronize consolidation unit ledgers


cmanhoff
Jr Varsity I

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.

Best answer by cmanhoff

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

View original

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • October 24, 2023

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)

UsernameGLConsol@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.

URLhttps://[sitename].acumatica.com

Source Ledger: Actual

Source Branch: Branch Name from child tenant

 

I hope this helps you make a connection. 😀

 

Laura

 

 

 


cmanhoff
Jr Varsity I
  • Jr Varsity I
  • October 24, 2023

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.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • November 30, 2023

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


cmanhoff
Jr Varsity I
  • Jr Varsity I
  • December 4, 2023

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


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • December 5, 2023

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings