Skip to main content
Answer

Upload Company Tree instead of setting up on screen

  • December 30, 2021
  • 15 replies
  • 974 views

saiful murad
Jr Varsity II
Forum|alt.badge.img

Hi. 

We have a client requiring setting up of company tree for 156 branches.

We believed we can expedite by either using import scenario or, worst case scenario,do a direct SQL.

Anyone encounter such experience before?

Thanks in advance.

Best answer by vkumar

Hi @saiful murad 

Refer to attached sample scenario xml file. Hope this helps.
Regards,

15 replies

Forum|alt.badge.img+12
  • Acumatica Support Team
  • Answer
  • December 30, 2021

Hi @saiful murad 

Refer to attached sample scenario xml file. Hope this helps.
Regards,


Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Platform Analyst
  • December 30, 2021

Hello @saiful murad 

In addition to scenario provided by Vijay’s, there is also a step-by-step guide for another form having a tree structure, Budget Configuration. See 

knowledge base article for reference.


saiful murad
Jr Varsity II
Forum|alt.badge.img
  • Author
  • December 30, 2021

Thank You so much @vkumar and @Irina 


saiful murad
Jr Varsity II
Forum|alt.badge.img
  • Author
  • December 30, 2021

Hi @vkumar ,

I downloaded both XML and XLS.  When i tried to import the XML into Import Scenarios [SM.20.60.25],

it gave me the error below:

'<', hexadecimal value 0x3c,is an invalid attribute character. Line157, position 112.

 


saiful murad
Jr Varsity II
Forum|alt.badge.img
  • Author
  • December 30, 2021

Hi @vkumar ,

I downloaded both XML and XLS.  When i tried to import the XML into Import Scenarios [SM.20.60.25],

it gave me the error below:

'<', hexadecimal value 0x3c,is an invalid attribute character. Line157, position 112.

 

Got it sorted @vkumar 


Forum|alt.badge.img+12
  • Acumatica Support Team
  • December 30, 2021

Hi @saiful murad 

It worked when I did not map the user column at my end. I will test this further. Will take some time though. 

Regards,


saiful murad
Jr Varsity II
Forum|alt.badge.img
  • Author
  • December 30, 2021

Hi @saiful murad 

It worked when I did not map the user column at my end. I will test this further. Will take some time though. 

Regards,

Hi @vkumar ,

Its ok. I got it resolved.  Thanks.


Forum|alt.badge.img+12
  • Acumatica Support Team
  • December 30, 2021

Hi @saiful murad 

Nice, if you have made further changes on the scenario, do upload your xml here. Will be useful.

Regards,


saiful murad
Jr Varsity II
Forum|alt.badge.img
  • Author
  • December 30, 2021

Hi @saiful murad 

Nice, if you have made further changes on the scenario, do upload your xml here. Will be useful.

Regards,

I just reopened your XML file and save using XML Editor.


Forum|alt.badge.img+12
  • Acumatica Support Team
  • December 30, 2021

@saiful murad, nice! 

Happy Holidays,

Regards,


Forum|alt.badge.img
  • Freshman II
  • March 22, 2023

@Irina The link you posted to a step-by-step guide for another form having a tree structure, Budget Configuration appears to be invalid. I’m not able to access the guide.  Can you provide a valid link?


Forum|alt.badge.img

Hi, @vkumar @Irina is there an updated version of the scenario, link provided is not working on 2023r2 version


martingaxiola
Varsity I
Forum|alt.badge.img

Hi, @vkumar @Irina is there an updated version of the scenario, link provided is not working on 2023r2 version

Hola @shelsantillan96 , did you ever get the Company Tree Import working? I am trying to do the same right now, and cant seem to make the scenario that is mention on this thread, as the screen is different on 2024R1

 


Forum|alt.badge.img

@martingaxiola the scenario didn’t work, I needed the help of a developer to create an automation for Company Tree.

 


Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Platform Analyst
  • September 10, 2024

@martingaxiola I am not seeing any changes in the company tree form. Please note that tree import is case sensitive, make sure that the node to which you’re importing is written exactly as on the form.