[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: 1.4.28 --- income statement messed up



Hi Michael,


On Wed, Jun 22, 2016 at 3:21 PM, Michael Richardson <..hidden..> wrote:
Erik Huelsmann <..hidden..> wrote:
    > Thanks for your report! Based on it, I can conclude that apparently
    > nobody has been using check printing in 1.4... because the "project_id"
    > column has been removed when making the step from 1.3 to 1.4.

More problems with 1.4.28:
  http://www.sandelman.ca/tmp/mcrcapture/1576.2016-06-22/capture1.png

I ask for an income statement, and I get a confused piece of balance sheet.
I tried with various settings for ignoring year end.

For some reason, LedgerSMB thinks you set up your CoA for 'hierarchy reporting', but the "Current earnings" node apparently is not pointing the right direction. When using "hierarchy reporting", all children of the "current earnings" node will be included in your income statement.

The current earnings node is configured in the System > Defaults screen:

Inline image 1
 

I asked for a balance sheet and got all sorts of income/expense accounts
listed, and then mysteriously the second time (having tried GIFI for fun in
between), I got something sane...

Ah, Balance sheet: "Full" gives me everything.
  http://www.sandelman.ca/tmp/mcrcapture/6180.2016-06-22/capture1.png

Accounting categories gives me "sane":
  http://www.sandelman.ca/tmp/mcrcapture/3614.2016-06-22/capture1.png

This is a clear indication there's something wrong with your hierarchy of accounts, I mean the fact that Accounting Categories works, means that the categories aren't messed up, nor is the mapping of categories to the balance sheet. That means, your hierarchy may be off in the sense that the hierarchy doesn't group the accounts you want grouped.
 

The numbers may be way off, I don't know yet.

For the Income statement, setting  a starting date has the same effect as closing the prior year.
 
I guess I have to do the 2015 summary manually.

What further debug can I provide?  It's as if the COA is screwed up and has
placed accounts into the wrong categories.  Yes, I'll update to .29.

Given your screenshots above, I'd say that you should be able to get expected (sane) output using the "Account categories" reports types. You should be able to do that on 1.4.28.

The solution to getting "sane" output in hierarchy reporting, is to determine your hierarchy requirements (e.g. do you want cost sub categories, like "employee costs") and to create an account tree accordingly.


Hope that helps!


Regards,


Erik.

------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel