Balance sheet report for multiple accounts

[John Ralls]

> On Sep 29, 2016, at 1:17 AM, Larry Evans <cppljevans at suddenlink.net> wrote:
> 
> On 09/28/2016 03:36 PM, Sébastien de Menten wrote:
>> If you are adventurous, you could try to
>> a) create the accounts for each entity at root level and as type equity (or
>> any other type),
>> b) save the file in uncompressed xml format and close it
>> c) open the xml file in a text editor , change the type of these accounts
>> from EQUITY to ROOT and save the file
>> d) open the xml file in gnucash and create the accounts for each entity.
>> You should be able to create accounts of any type.
>> 
>> All untested, USE IT AT YOUR OWN RISK kind of hack, but it worked/works if
>> my memory is good...
>> 
> Tired it. Doesn't work.  When opened file with GC, no accounts appeared.
> Here's the diff between the pre and post edit:
> 
> *** RootLevelEntitiesPostEdit.gnucash	2016/09/28 23:01:18	1.1
> --- RootLevelEntitiesPostEdit.gnucash	2016/09/28 23:03:05
> ***************
> *** 82,88 ****
>  <gnc:account version="2.0.0">
>    <act:name>Entity1</act:name>
>    <act:id type="guid">727f9a00736db3a4d848ae5aabe32954</act:id>
> !   <act:type>EQUITY</act:type>
>    <act:commodity>
>      <cmdty:space>ISO4217</cmdty:space>
>      <cmdty:id>USD</cmdty:id>
> --- 82,88 ----
>  <gnc:account version="2.0.0">
>    <act:name>Entity1</act:name>
>    <act:id type="guid">727f9a00736db3a4d848ae5aabe32954</act:id>
> !   <act:type>ROOT</act:type>
>    <act:commodity>
>      <cmdty:space>ISO4217</cmdty:space>
>      <cmdty:id>USD</cmdty:id>
> ***************
> *** 99,105 ****
>  <gnc:account version="2.0.0">
>    <act:name>Entity2</act:name>
>    <act:id type="guid">e85aedcc24baca1bdeb8bb3f3defcbec</act:id>
> !   <act:type>EQUITY</act:type>
>    <act:commodity>
>      <cmdty:space>ISO4217</cmdty:space>
>      <cmdty:id>USD</cmdty:id>
> --- 99,105 ----
>  <gnc:account version="2.0.0">
>    <act:name>Entity2</act:name>
>    <act:id type="guid">e85aedcc24baca1bdeb8bb3f3defcbec</act:id>
> !   <act:type>ROOT</act:type>
>    <act:commodity>
>      <cmdty:space>ISO4217</cmdty:space>
>      <cmdty:id>USD</cmdty:id>
> ***************
> *** 116,122 ****
>  <gnc:account version="2.0.0">
>    <act:name>Entity3</act:name>
>    <act:id type="guid">7c028148efef6bbf27ade060c444f080</act:id>
> !   <act:type>EQUITY</act:type>
>    <act:commodity>
>      <cmdty:space>ISO4217</cmdty:space>
>      <cmdty:id>USD</cmdty:id>
> --- 116,122 ----
>  <gnc:account version="2.0.0">
>    <act:name>Entity3</act:name>
>    <act:id type="guid">7c028148efef6bbf27ade060c444f080</act:id>
> !   <act:type>ROOT</act:type>
>    <act:commodity>
>      <cmdty:space>ISO4217</cmdty:space>
>      <cmdty:id>USD</cmdty:id>
> 

Larry,

`diff -u` produces more readable diffs: The first block would look like

 <gnc:account version="2.0.0">
   <act:name>Entity1</act:name>
   <act:id type="guid">727f9a00736db3a4d848ae5aabe32954</act:id>
-   <act:type>EQUITY</act:type>
+   <act:type>ROOT</act:type>
   <act:commodity>
     <cmdty:space>ISO4217</cmdty:space>
     <cmdty:id>USD</cmdty:id>

and appear only once.

Regards,
John Ralls