+- 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 Customer Code Missing Fields - SOLVED? (/showthread.php?tid=8301)
Change Customer Code Missing Fields - SOLVED? - VortecCPI - 12-13-2018
Z_ChangeCustomerCode.php
This script is missing:
`address5`
`address6`,
`taxrref`
`customerpoline`
`languageid`
I believe this should do it:
PHP Code:
$sql = "INSERT INTO debtorsmaster (`debtorno`,
`name`,
`address1`,
`address2`,
`address3`,
`address4`,
`address5`,
`address6`,
`currcode`,
`salestype`,
`clientsince`,
`holdreason`,
`paymentterms`,
`discount`,
`discountcode`,
`pymtdiscount`,
`lastpaid`,
`lastpaiddate`,
`creditlimit`,
`invaddrbranch`,
`ediinvoices`,
`ediorders`,
`edireference`,
`editransport`,
`ediaddress`,
`ediserveruser`,
`ediserverpwd`,
`taxrref`,
`customerpoline`,
`languageid`,
`typeid`)
SELECT '" . $_POST['NewDebtorNo'] . "',
`name`,
`address1`,
`address2`,
`address3`,
`address4`,
`address5`,
`address6`,
`currcode`,
`salestype`,
`clientsince`,
`holdreason`,
`paymentterms`,
`discount`,
`discountcode`,
`pymtdiscount`,
`lastpaid`,
`lastpaiddate`,
`creditlimit`,
`invaddrbranch`,
`ediinvoices`,
`ediorders`,
`edireference`,
`editransport`,
`ediaddress`,
`ediserveruser`,
`ediserverpwd`,
`taxrref`,
`customerpoline`,
`languageid`,
`typeid`
FROM debtorsmaster
WHERE debtorno='" . $_POST['OldDebtorNo'] . "'";
RE: Change Customer Code Missing Fields - SOLVED? - TimSchofield - 12-13-2018
See my comment on Z_ChangeSupplierCode.php. Same could be done here.