Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Statement of Cash Flows - Ignore Tiny Amounts?
12-15-2018, 05:59 AM (This post was last modified: 12-15-2018 06:06 AM by VortecCPI.)
Post: #1
Statement of Cash Flows - Ignore Tiny Amounts?
GLCashFlowsIndirect.php

This report is showing data for accounts balances that are tiny. Other reports are not doing this so I assume this is something specific to this report. I increased decimal places so I could see the true values:

       

If I change this:

PHP Code:
if($MyRow['ActualAmount']<>

To this:

PHP Code:
if(abs($MyRow['ActualAmount'])>0.005 

The accounts with $0.00 come off the report.

Is there a more elegant way we can ignore these tiny amounts? Perhaps by using $_SESSION['CompanyRecord']['decimalplaces'] to set accuracy/granularity?

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
12-15-2018, 10:22 PM
Post: #2
RE: Statement of Cash Flows - Ignore Tiny Amounts?
Maybe this is a good thing a s it causes us to dig deeper into why zero is not really zero...

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
12-15-2018, 11:19 PM
Post: #3
RE: Statement of Cash Flows - Ignore Tiny Amounts?
(12-15-2018 05:59 AM)VortecCPI Wrote:  Is there a more elegant way we can ignore these tiny amounts? Perhaps by using $_SESSION['CompanyRecord']['decimalplaces'] to set accuracy/granularity?

That is the way we normally use, but the most elegant solution would be to not have those tiny amounts in the first place.
Visit this user's website Find all posts by this user
Quote this message in a reply
12-15-2018, 11:32 PM (This post was last modified: 12-15-2018 11:47 PM by VortecCPI.)
Post: #4
RE: Statement of Cash Flows - Ignore Tiny Amounts?
Agreed but in our case this is due to tiny rounding differences in tax and per-unit price. With only four decimal places at the stock level there is no getting around it.
I suppose some sort of manual GL Journal entry would fix it but it will always exist as we move on with business transactions.

You can see the differences below:

   

We only have two decimal places for USD but costs and taxes use far more so we will always have a small discrepancy. Our stock per-unit cost/price uses all four decimal places and even that is not enough to produce cost/price matches in all cases. Z_CheckDebtorsControl.php shows small (but matching) differences for every period.

So far tax has caused us the greatest pain as whether we were to round up or round down we we always have a small difference.

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)