RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry

[Jesse P. <je...@st...>]

Sure, kudos to you... did you not see anything I wrote back to him? =
Speed is not a problem - but I think if you find yourself replying to a =
message again or to yourself fairly quickly that possibly a little more =
time could have been taken...

jesse

-----Original Message-----
From: skaill [mailto:sk...@ro...]
Sent: Tuesday, October 12, 2004 15:39
To: web...@li...
Subject: Re: [Web-erp-developers] Re: [Web-erp-users] Order Entry


I would like to point out that I was the one who quickly answered =
Melvin's
problem, who discovered that the value had a negative and narrowed it to
being something in the assembly and disassembly of those values.  I also
posted code similar to that which is likely to be the problem.  This, in =
my
opinion, is why we are so far into solving this problem already.

Anyway, I can sit back and not answer this fast in the future.  That's =
no
problem for me to do.

Steve

----- Original Message -----=20
From: "Jesse Peterson" <je...@st...>
To: <web...@li...>
Sent: Tuesday, October 12, 2004 1:57 PM
Subject: RE: [Web-erp-developers] Re: [Web-erp-users] Order Entry


Steve, please be mindful to have a grasp of the problem before posting
things... this may simply confuse everyone or get 2 or 3 people doing =
the
same things, especially since you have posted a bit of code that is
different than what Melvin on the Users list is using. I know you are =
trying
to be helpful, but, in general, having to wade through emails with lots =
of
guesses & maybes, but little solid information is not horribly helpful.

That said, I have his version of this, from the 2.9 version and have not
been able to recreate the error. The first thing I tested was this =
section,
and it seems fine so far. I do wonder about the "+3", as 2.9 does has it =
as
"+1" - that may be the point of contention, but I need a little more =
testing
to tell for sure. I'm also in the middle of a work day, though, so it =
may
not be in the next 30 minutes...

If I find a problem for sure, I will let everyone know.


jesse


-----Original Message-----
From: skaill [mailto:sk...@ro...]
Sent: Tuesday, October 12, 2004 12:53
To: web...@li...
Subject: [Web-erp-developers] Re: [Web-erp-users] Order Entry


Actually, looks like a variable may be assembling or disassembling the
parameter incorrectly.  Possibly...the Select variable.

$_POST['Select'] =3D $myrow["DebtorNo"] . " - ". $myrow["BranchCode"];
...
$_SESSION['Items']->Branch =3D
substr($_POST['Select'],strpos($_POST['Select']," - ")+3);
...
$_POST['Select'] =3D substr($_POST['Select'],0,strpos($_POST['Select']," =
-
"));

You get dashes and then they are stripped where used.  Only I think that
Branch Code with the minus sign in it is not being stripped correctly.  =
I'm
thinking this info will help someone who has more experience in that =
code
know what the issue is...

Steve

----- Original Message -----=20
From: "Melvin Sequera" <kat...@ya...>
To: <web...@li...>
Sent: Tuesday, October 12, 2004 11:11 AM
Subject: [Web-erp-users] Order Entry


> Good morning guys.
>
> Right now I'm trying to introduce a nuew order to be
> billing later. But the system throw me this error:
>
> The branch details for branch code: against customer
> code: 0130000200 could not be retrieved. Check the set
> up of the customer and branch.
> The SQL that failed to get the branch details was:
> SELECT CustBranch.BrName,
> CustBranch.BrAddress1,BrAddress2, BrAddress3,
> BrAddress4, PhoneNo, Email, DefaultLocation,
> DefaultShipVia From CustBranch WHERE
> CustBranch.BranchCode=3D'- 0130000202' AND
> CustBranch.DebtorNo =3D '0130000200'
>
> The question is why? I've configured the master
> customer record and configured two branchs, one of tis
> branchs has the code 0130000202 so I don't understand
> where is the problem.
>
> Could you help me please?
>
> Thanks in advance.
>
> Melvin
>
> _________________________________________________________