Topic: error message : Incorrect date value: '' for column
I have been spinning my wheels on this for a while and hoping someone can point me in the right direction.
Some time ago I made a Purchase order and received it, then sent a customer invoice for the received goods. I needed to do this because the customer needed the invoice before I could get an invoice from the supplier.
Today, I am trying to convert the purchase order delivery into a supplier invoice. I am on the supplier invoice page, have added the inventory items, filled in dates and reference and such, but consistently get this error:
DATABASE ERROR : cannot add journal entry
error code : 1292
error message : Incorrect date value: '' for column `fa_computerisms_ca`.`journal`.`event_date` at row 1
I have tried a variety of dates, from well before everything happened to next year, nothing seems to change the empty date.
I can't really find any thing in the forums that match this problem, but nonetheless I have tried, and failed, to hack the code in a few places based on what similarities I did find.
FWIW, I had another Purchase order that had not been received. I was able to receive those times and create a supplier invoice for those items. However, I did not send a sales invoice to a customer for those items prior, so perhaps that is the difference.
Any suggestions how I might get this invoice entered?