Menu
▾
▴
Re: [WebERP-developers] Problem in posting pre-dated supplier invoice
|
From: Tim S. <ti...@we...> - 2010-03-16 07:25:58
|
Hi Anand,
I have been trying to work out why you are getting this problem, and I
am not. I can see that lastdate_in_period is in the format YYYY-mm-dd
and we are comparing it with a date in the format YYYY/mm/dd. Your fix
will compare dates in the same format. This leads me to think that it
is a msql mode problem. I have tried a variety of modes, but still
can't replicate the problem.
Anyway, I will update he code so that we are comparing dates in
identical format. Would:
$GetPrdSQL = "SELECT periodno FROM periods WHERE lastdate_in_period < '" .
Date('Y-m-d', $MonthAfterTransDate) . "' AND lastdate_in_period >= '"
. Date('Y-m-d', $TransDate) . "'";
be a neater solution?
Thanks
Tim
On 11 March 2010 09:14, yoganand_bija <yog...@bi...> wrote:
>
> Hi Tim,
>
> Thanks for the reply.
>
> Yes the periods are automatically set and the prohibit date in our case is
> prior to 31/03/2009.
>
> The problem occurred in only the month end dates and we were able to
> identify the cause of the problem as i had mentioned in the first email.
>
> I was able to post even one day prior to that date and one day after that
> date. So I presume that it should not be a problem about the periods. I
> don't see any configuration for the month end dates too.
>
> As i had mentioned in the first email, the date format is not fetched
> properly and if I use the date format function it works fine. Have I
> identified the problem correctly or is there something beneath that.
>
> thanks and regards
>
> Anand
> --
> View this message in context: http://n4.nabble.com/Period-error-tp1574598p1588477.html
> Sent from the web-erp-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
--
WebERP Africa Ltd
+447710427049
+255784602561
www.weberpafrica.com
|