Erik, I looked the the "chart" view. It only lists the account and the
account_headings and all of the id's. No linking was apparent. There is
no monetary data shown in the view, as there is when looking at
reports->COA from the web interface.
If the intent of the report is to show monetary information, then
providing a summation for the accounts under the heading make sense. In
my case the "summation" appears to be just reflecting the amount from
the account "id" that matches the account_heading "id".
Regards,
Bill Ott
Email: Mailto:bill...@theotts.org
Website: http://www.theotts.org
On 07/14/2013 04:37 PM, Erik Huelsmann wrote:
On Sun, Jul 14, 2013 at 10:29 PM, Bill Ott <bill...@theotts.org
<mailto:bill...@theotts.org>> wrote:
> For example 1000 Current Assets lists only the checking account
debit. The AR debit
> appears in the Capital Assets debit heading. 1820 Office equipment
> appears under 3300 Share Capital. and so on.
I have been digging around and here is what I've found. in every
case, where an amount is shown on a "heading", the "id" from the
account_heading table matches the "id" from the account table. The
id for the "1000 Current Assets" is 1. The "id" for "Checking
Account" is 1. The "id" for "3300 Share Capital" is 6. The "id"
for "1820 Office Equipment" is 6, etc.
It appears that there is a join between the "account" table and
the "account_heading" table using "id" from each.
That's correct: in LedgerSMB 1.3, there's a "chart" view which does
exactly what you describe. Maybe you could check that and see if it
presents you with incorrect data? If that's the case, we at least know
the cause.
The solution for the CoA report is probably not to use the 'chart'
view, but that'd be the next step.
--
Bye,
Erik.
http://efficito.com <http://efficito.com/> -- Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.
------------------------------------------------------------------------------
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
------------------------------------------------------------------------------
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
