webERP Forum
Change Branch Code Missing Fields - SOLVED? - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8)
+--- Thread: Change Branch Code Missing Fields - SOLVED? (/showthread.php?tid=8302)



Change Branch Code Missing Fields - SOLVED? - VortecCPI - 12-13-2018

Z_ChangeBranchCode.php

Missing the following fields:

`defaultshipvia`,
`deliverblind`,
`specialinstructions`,


I believe this should do it:

PHP Code:
$sql "INSERT INTO custbranch (`branchcode`,
                    `debtorno`,
                    `brname`,
                    `braddress1`,
                    `braddress2`,
                    `braddress3`,
                    `braddress4`,
                    `braddress5`,
                    `braddress6`,
                    `estdeliverydays`,
                    `area`,
                    `salesman`,
                    `fwddate`,
                    `phoneno`,
                    `faxno`,
                    `contactname`,
                    `email`,
                    `defaultlocation`,
                    `taxgroupid`,
                    `defaultshipvia`,
                    `deliverblind`,
                    `disabletrans`,
                    `brpostaddr1`,
                    `brpostaddr2`,
                    `brpostaddr3`,
                    `brpostaddr4`,
                    `brpostaddr5`,
                    `brpostaddr6`,
                    `defaultshipvia`,
                    `specialinstructions`,
                    `custbranchcode`)
            SELECT '" 
$_POST['NewBranchCode'] . "',
                    `debtorno`,
                    `brname`,
                    `braddress1`,
                    `braddress2`,
                    `braddress3`,
                    `braddress4`,
                    `braddress5`,
                    `braddress6`,
                    `estdeliverydays`,
                    `area`,
                    `salesman`,
                    `fwddate`,
                    `phoneno`,
                    `faxno`,
                    `contactname`,
                    `email`,
                    `defaultlocation`,
                    `taxgroupid`,
                    `defaultshipvia`,
                    `deliverblind`,
                    `disabletrans`,
                    `brpostaddr1`,
                    `brpostaddr2`,
                    `brpostaddr3`,
                    `brpostaddr4`,
                    `brpostaddr5`,
                    `brpostaddr6`,
                    `defaultshipvia`,
                    `specialinstructions`,
                    `custbranchcode`
            FROM custbranch
            WHERE debtorno='" 
$_POST['DebtorNo'] . "'
            AND branchcode='" 
$_POST['OldBranchCode'] . "'"



RE: Change Branch Code Missing Fields - SOLVED? - TimSchofield - 12-13-2018

See my comment on the change supplier thread