Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Change Customer Code Missing Fields - SOLVED?
12-13-2018, 02:27 AM, (This post was last modified: 12-13-2018, 02:36 AM by VortecCPI.)
#1
Change Customer Code Missing Fields - SOLVED?
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'] . "'"
https://www.linkedin.com/in/eclipsepaulbecker
Reply
12-13-2018, 09:52 PM,
#2
RE: Change Customer Code Missing Fields - SOLVED?
See my comment on Z_ChangeSupplierCode.php. Same could be done here.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)