webERP Forum

Full Version: Change Branch Code Missing Fields - SOLVED?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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'] . "'"
See my comment on the change supplier thread