Re: [WebERP-developers] Possible bug in DebtorsAtPeriodEnd.php

[emdeex <em...@gm...>]

Thanks Phil,

The reason for the code is great (seeing a balance at some period in
the past).  Very useful.

But the balance its displaying for the current period (Feb 2006), is
the current 'real' balance (ie. $50,000) minus the fx/afterdatetrans
(ie. -$43000), equalling a balance of $93,000.00.  Which is inflated
by $43,000.

thanks,
muz

On 2/16/06, Phil Daintree <we...@pa...> wrote:
> Well this is how the code works - it is pretty machine intensive!
> It takes the current balance and adjusts back for every transaction after=
 the
> month end that you select to have balances reported at. These reports wer=
e
> created at the request of auditors who wished to be able to figure out
> balances retrospectively - ie what they were at some point in history.
>
> Phil
>
> On Tue, 14 Feb 2006 19:51, emdeex wrote:
> > Hi All,
> >
> > I cant really explain this one adequately, but perhaps someone can
> > work out whats going on...
> >
> > The SQL, as it is, in DebtorsAtPeriodEnd.php, produces two fields
> > called 'afterdatetrans' and 'fxafterdatetrans'.
> >
> > For one of my clients, the SQL is producing a negative amount for
> > those fields.  The PDF script is then adding (+) the current balance
> > to the 'afterdatetrans', this is producing an inflated balance.
> >
> > Something is wrong, but I'm not sure what, the SQL or the script, and
> > this report produced a correct balance last month.
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by: Splunk Inc. Do you grep through log
> > files for problems?  Stop!  Download the new AJAX search engine that ma=
kes
> > searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=103432&bid#0486&dat=12164=
2
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> --
> Phil Daintree
> webERP Project Admin
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log fi=
les
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&dat=
=3D121642
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>