• From: USA, Wisconsin
  • Registered: 09/28/2007
  • Posts: 23

Topic: DATABASE ERROR : The debtor transaction record could not be inserted

DATABASE ERROR : The debtor transaction record could not be inserted
error code : 1292
error message : Incorrect date value: '' for column 'due_date' at row 1

I am trying to just enter a payment for an account.  There are no orders or invoices for this customer.  Just trying to get my costs and my customer payments in place first.

Is this not possible?  The field in the 0_debtor_trans.due_date is not null with a default of '0000-00-00'.

  • From: USA, Wisconsin
  • Registered: 09/28/2007
  • Posts: 23

Re: DATABASE ERROR : The debtor transaction record could not be inserted

Version is 1.13

  • Registered: 12/25/2007
  • Posts: 2,448

Re: DATABASE ERROR : The debtor transaction record could not be inserted

Where did you encounter this problem?
You can enter customer payments and costs in any time, there is no need to issue invoice/delivery first.

BTW Current stable version is 1.16. This week Joe will release version 2.0 beta. If you want to start using FA we advice to install the new version so you will avoid troubles with moving data. The new version is under constant maintenance, so you can be sure any issues will be removed quickly.

Janusz