Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Authorisation of Petty Cash Expenses error
08-24-2021, 08:59 PM, (This post was last modified: 08-24-2021, 09:01 PM by wissedenis22.)
#1
Authorisation of Petty Cash Expenses error
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
Reply
08-24-2021, 11:26 PM,
#2
RE: Authorisation of Petty Cash Expenses error
The value for amount that you are trying to insert isn't zero, it is '-INF'

Pretty sure you have one of your exchange rates set to zero, and so you are doing a division by zero (check your logs for warnings), resulting in a value of Infinity.

Tim
Reply
08-26-2021, 11:07 PM,
#3
RE: Authorisation of Petty Cash Expenses error
(08-24-2021, 11:26 PM)falkoner Wrote: The value for amount that you are trying to insert isn't zero, it is '-INF'

Pretty sure you have one of your exchange rates set to zero, and so you are doing a division by zero (check your logs for warnings), resulting in a value of Infinity.

Tim
 you're very right! that expense had a different currency and was set to zero!
thanks Tim
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)