Hello!
I'm getting the error below when I trying to authorize the petty cash expense! I don't understand why the amount (
1,140,500.00) is being truncated to 0.
Code:
ERROR Message Report : The date does not appear to be in a valid format. The date being converted from SQL format was:
Database Error 1265 :
Data truncated for column 'amount' at row 1
Database SQL Failure : The SQL that failed was
INSERT INTO `gltrans` (`counterindex`, `type`, `typeno`, `chequeno`, `trandate`, `periodno`, `account`, `narrative`, `amount`, `posted`, `jobref`, `tag`) VALUES (NULL, '2', '305', 0, '2021-08-05', '2', '1030', 'Petty Cash - COMMISIONS - ASSIGNCASH - commisiion for Robert july - 33404', '-INF', 0, '', '0')
Database Rollback Due to Error Above : Rolling Back Transaction OK