10-04-2016, 06:59 PM
This error appears on ConfirmDispatch_Invoice.php when processing invoice:
Problem = database schema:
The field salesmancode on salesman table has a type varchar(4) while on salesanalysis table, it is char(3).
Solution: fix salesanalysis table
Code:
Database Error 1406 : Sales analysis record could not be added or updated because
Data too long for column 'salesperson' at row 1
Problem = database schema:
The field salesmancode on salesman table has a type varchar(4) while on salesanalysis table, it is char(3).
Solution: fix salesanalysis table
Code:
ALTER TABLE `salesanalysis` CHANGE `salesperson` `salesperson` VARCHAR(4) DEFAULT '' NOT NULL;