Customer Login

[MacPhotoBiker]

Hi Phil,

I just tried to modify an existing Sales Order, but I got an error message. I believe this is related to the changes I made regarding the customer login, that´s why I´m posting it in this thread. Below, please find the error message, it occurs when I try to modify an existing Sales Order.

Could you help me out? Thanks a lot!!

**********************************************
Database Error : The order cannot be retrieved because
Unknown column 'salesorders.salesperson' in 'field list'
Database SQL Failure : The SQL that failed was
SELECT salesorders.debtorno, debtorsmaster.name, salesorders.branchcode, salesorders.customerref, salesorders.comments, salesorders.orddate, salesorders.ordertype, salestypes.sales_type, salesorders.shipvia, salesorders.deliverto, salesorders.deladd1, salesorders.deladd2, salesorders.deladd3, salesorders.deladd4, salesorders.deladd5, salesorders.deladd6, salesorders.contactphone, salesorders.contactemail, salesorders.salesperson, salesorders.freightcost, salesorders.deliverydate, debtorsmaster.currcode, currencies.decimalplaces, paymentterms.terms, salesorders.fromstkloc, salesorders.printedpackingslip, salesorders.datepackingslipprinted, salesorders.quotation, salesorders.deliverblind, debtorsmaster.customerpoline, locations.locationname, custbranch.estdeliverydays, custbranch.salesman FROM salesorders INNER JOIN debtorsmaster ON salesorders.debtorno = debtorsmaster.debtorno INNER JOIN salestypes ON salesorders.ordertype=salestypes.typeabbrev INNER JOIN custbranch ON salesorders.debtorno = custbranch.debtorno AND salesorders.branchcode = custbranch.branchcode INNER JOIN paymentterms ON debtorsmaster.paymentterms=paymentterms.termsindicator INNER JOIN locations ON locations.loccode=salesorders.fromstkloc INNER JOIN currencies ON debtorsmaster.currcode=currencies.currabrev WHERE salesorders.orderno = '3'
**********************************************

---

Hi Phil,

regarding the customer login: It basically works, but there is one thing you may want to change: Placing orders works, a customer can only place orders for himself. However, a customer can see all invoices, i. e. including invoices from other customers, which for privacy reasons is obviously unacceptable.