LedgerSMB user discussion

Jigme Datse Yli-Rasku | 3 Jul 2012 17:38

Cash Income statement not giving correct values?


When I go in and go through my income statement for the month of June
I want a Cash income statement and I get a value of $75.27 when I
expect a value of $312.29.  If I go by current, I get the same value.
 Which is to be expected.

Accrual is also apparently under reporting income at $947.62 instead
of, $1061.32.  I'm not sure if this is something with the software, or
with how I have entered things.  So far I believe I have entered
everything as either a sales invoice or a vendor invoice.

Right now, it looks like I need to print out my sales invoices to
justify my income for the month.  I have one invoice that I have to
back date, that I forgot to enter.  But this income statement would be
perfect if it was reporting the numbers I expected.  I still have a
few days to figure this out.

Jigme Datse Yli-Rasku

headers

Chris Travers | 5 Jul 2012 03:51

Re: Cash Income statement not giving correct values?

Hi;

I am removing the cash report option for 1.3 for now and working on new reports for 1.4.

The logic and database schema has not changed significantly since the fork here. Chances are if it is not working, it has never worked. Reviewing some other apparent feature requests, this has been a problem since 1.2 at least. We can't really subject the old code to automated tests without an excessive amount of work. The major problem is that the reports were never intended to be subject to automated tests and hence a lot of things don't go out of scope when a test case might expect them to be. So without being able to verify that new reports would work, I don't see how we can fix them in place.

Removing the code for now basically means we are working on real, testable, cash-basis reports. These may be available as a back-port.

Best Wishes,

Chris Travers

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

headers

Chris Travers | 5 Jul 2012 04:03

Re: Cash Income statement not giving correct values?

Also I will probably push the income statement and balance sheet reports ahead of payroll at this point as well. I would expect an alternative at least in trunk within a week or two.

Best Wishes,

Chris Travers

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

headers

Jigme Datse Yli-Rasku | 5 Jul 2012 05:33

Re: Cash Income statement not giving correct values?

On Wed Jul  4 19:03:09 2012, Chris Travers wrote:
> Also I will probably push the income statement and balance sheet
> reports ahead of payroll at this point as well.  I would expect an
> alternative at least in trunk within a week or two.

OK, this makes sense.  I believe I've not ever got a good cash report.
I'm totally willing to print invoices and manually report these values.
 I can understand why cash reporting could be difficult, but almost all
of these were paid on or near when invoiced.  Maybe it was the "near"
invoiced, that was the issue.  I will be having some issues with some
invoices being billed at the end of the month, and being paid at the
beginning of the following month.  I just wish I could be sure they
came up when I searched.  Because I believe that I have an invoice that
will either not be paid, or will be paid some time very far in the
future.

Still, I can understand the not ever working, and removing a feature
that isn't working, rather than trying to fix it.

Jigme Datse Yli-Rasku

headers

Chris Travers | 5 Jul 2012 06:48

Re: Cash Income statement not giving correct values?

On Wed, Jul 4, 2012 at 8:33 PM, Jigme Datse Yli-Rasku <jigme.datse-nZcGC65VimYsIPEtBw668UEOCMrvLtNR@public.gmane.org> wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed Jul 4 19:03:09 2012, Chris Travers wrote:
> Also I will probably push the income statement and balance sheet
> reports ahead of payroll at this point as well. I would expect an
> alternative at least in trunk within a week or two.

OK, this makes sense. I believe I've not ever got a good cash report.
I'm totally willing to print invoices and manually report these values.
I can understand why cash reporting could be difficult, but almost all
of these were paid on or near when invoiced. Maybe it was the "near"
invoiced, that was the issue. I will be having some issues with some
invoices being billed at the end of the month, and being paid at the
beginning of the following month. I just wish I could be sure they
came up when I searched. Because I believe that I have an invoice that
will either not be paid, or will be paid some time very far in the
future.

Still, I can understand the not ever working, and removing a feature
that isn't working, rather than trying to fix it.

Thinking back to discussions on cash reports way back on the old SL lists.... I actually think the way the SL code addresses this problem is problematic. It looks to AR_paid and AP_paid accounts when it would be better to look at the balance of the AR and AP accounts instead.

Best Wishes,

Chris Travers

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users