From: skaill <sk...@ro...> - 2004-10-12 19:37:49
|
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 ----- 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'] = $myrow["DebtorNo"] . " - ". $myrow["BranchCode"]; ... $_SESSION['Items']->Branch = substr($_POST['Select'],strpos($_POST['Select']," - ")+3); ... $_POST['Select'] = 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 ----- 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='- 0130000202' AND > CustBranch.DebtorNo = '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 > > _________________________________________________________ > Do You Yahoo!? > Información de Estados Unidos y América Latina, en Yahoo! Noticias. > Visítanos en http://noticias.espanol.yahoo.com > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Web-erp-users mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ Web-erp-developers mailing list Web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-developers ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ Web-erp-developers mailing list Web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |