Writing custom reports for Customers

[Wm]

Sun, 14 Dec 2014 07:55:08 <548D96BC.8070301 at cmail.nu>  Matt Kowske 
<jmk at cmail.nu>

>I will have to look more into utilizing the SQL database -- sounds like
>it could work pretty well.
>
>As far s the CoA goes I played around with the structure you have and
>it seems to work pretty well, although of course there is the downside
>that I have to maintain many more accounts now. Shouldn't be too bad by
>leveraging the CSV import functionality and utilizing the "hidden
>account" option when a property is sold.

A further thought.  I think you'd be able to create an account tree 
representing a new investment and just import that, it is something I've 
been meaning to do myself.  Let me know otherwise I probably won't 
bother mentioning it here.

Also, you don't have to maintain the accounts once you've exited the 
investment.  If you delete an account gnc asks you what you want to do 
with the transactions.  So (say) after the year-end reporting is done 
you could delete the account trees for completed investments and move 
the transactions into a tree for that purpose rather than hiding 
multiple accounts.  I do this for a local tax where I track each year in 
detail in case of errors and when I am happy it balances I delete the 
2013-14 accounts and xfer the transactions to the general account and 
create a new ones for 2014-15, works fine once you realise deleting the 
account doesn't mean deleting the transactions.

And ... you can also repurpose the num field / column to contain 
anything you want (e.g. Property A) and then use that for later 
reporting which is another way to go.  I haven't seen that general route 
discussed much here because the option is a bit fiddly to get right. 
Once again, ask.

>That said, I do still think a feature that would allow this would be
>very useful. Thanks for the suggestions.

It is on a list somewhere :)

-- 
Wm...