Skip to main content
Solved

Upload Company Tree instead of setting up on screen

  • December 30, 2021
  • 15 replies
  • 1110 views
  • Translate All

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,

View original

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,

Translate

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.

Translate

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

Thank You so much @vkumar and @Irina 

Translate

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

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.

 

Translate

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

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 

Translate

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,

Translate

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

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.

Translate

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,

Translate

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

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.

Translate

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

@saiful murad, nice! 

Happy Holidays,

Regards,

Translate

Forum|alt.badge.img

@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?

Translate

Forum|alt.badge.img

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

Translate

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

 

Translate

Forum|alt.badge.img

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

 

Translate

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.

Translate