09-06-2019, 12:51 AM,
|
|
ALEXSHEN
Senior Member
|
Posts: 132
Threads: 34
Joined: Sep 2019
|
|
Goods delivery and issue invoice error
Dear Everyone,
I got a problem error #1265 When I deliver the goods.
Step. 1- When I put the new order in "New sales order or quotation", it is ok.
Step. 2- I put the dispatch quantities in this step, click "process invoice" botton.
Then got the problem, I tried many way, but seems problem still there, please help me.
Error information:
"Database Error 1265 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK ASSISTANCE: The debtor transaction taxes records could not be inserted because
Data truncated for column 'taxamount' at row 1"
"Database SQL Failure : The following SQL to insert the debtor transaction taxes record was used
INSERT INTO debtortranstaxes (debtortransid, taxauthid, taxamount) VALUES ('21', '16', 'NAN')"
"Database Rollback Due to Error Above : Rolling Back Transaction OK"
Thanks a lot
|
|
09-09-2019, 02:40 AM,
|
|
ALEXSHEN
Senior Member
|
Posts: 132
Threads: 34
Joined: Sep 2019
|
|
RE: Goods delivery and issue invoice error
Hi Tim,
Please see attached Screenshot
[attachment=973]
Alex
(09-09-2019, 02:14 AM)falkoner Wrote: I suppose the next thing to do is to try and discount some other obvious things. What is the output for the following sql:
SELECT * FROM config WHERE confname='part_pics_dir';
Thanks
Tim
|
|
09-09-2019, 05:29 AM,
|
|
ALEXSHEN
Senior Member
|
Posts: 132
Threads: 34
Joined: Sep 2019
|
|
RE: Goods delivery and issue invoice error
Hi, Paul and Tim,
Yes, Yes, I didn't use the name of the company in the database, but directly used the name "MYSQL".
So I think it is not a matter.
Alex
|
|
|