FrontAccounting forum — DB Error while Placing a Direct Invoice with no customer selected.

Re: DB Error while Placing a Direct Invoice with no customer selected.

2012-10-17T06:51:20Z

Ah, the supp_trans table share info with payment records. But this could be hidden more effectively in purchase_order_entry.php. Will look at it in more detail.

/Joe

Re: DB Error while Placing a Direct Invoice with no customer selected.

2012-10-17T04:10:41Z

Thanks Joe. Maybe in v2.4, if the said field is not used, it can be removed.

Mercurial Changeset 3084.

Re: DB Error while Placing a Direct Invoice with no customer selected.

2012-10-16T15:03:52Z

@surreyhills

Thanks for telling us. In certain releases of MySql or MySql setup won't allow the insert of empty value.

Fixed in HG repository. Your fix was used.

No problems in the Direct Sales Invoice.

/Joe

Re: DB Error while Placing a Direct Invoice with no customer selected.

2012-10-16T14:49:31Z

The supp_trans table is used by both documents and the payments. It is correct to set the value to 0 here.

Certain setup and versions of MySql accepts this though.

Will be fixed asap.

/Joe
BTW will check the ddebtor_trans also.

Re: DB Error while Placing a Direct Invoice with no customer selected.

2012-10-16T14:31:55Z

Is this fix needed in Line 460 in the current version of the said file purchasing/po_entry_items.php ?

The field ov_discount in the table supp_trans is set to be NOT NULL for good reason - arithmetic cannot be done on NULL values. Hence setting it to 0.0 is correct. If it is not used as stated in the comments, then the field should be removed.

The same field name and NOT NULL state is observed in the debtor_trans table as well. Any similar inserts failing on it?

Re: DB Error while Placing a Direct Invoice with no customer selected.

2012-10-16T12:39:24Z

I have the same error on supplier Direct Invoice. Direct GRN works but Direct Invoice gives the following

At file G:\ServerFolders\Documents\htdocs\FATest\purchasing\includes\db\supp_trans_db.inc:45:
Cannot insert a supplier transaction record
error code : 1265
error message : Data truncated for column 'ov_discount' at row 1
sql that failed was : INSERT INTO 0_supp_trans (trans_no, type, supplier_id, tran_date, due_date, reference, supp_reference, ov_amount, ov_gst, rate, ov_discount, tax_included) VALUES ('3', '20', '2', '2008-12-31', '2009-01-01', '3', '123', '10', '0', '1', '', '0')

The bug is due to a fix made before in line 456 in po_entry_items.php which waas commented out and left ov_discount as null not 0.0. I have changed the code to:

// MRB 16-10-12 - ov-discount set to zero to avoid DB error on insert
$inv->ov_discount = 0.0;
// End of fix 16-10-12

which works.

Re: DB Error while Placing a Direct Invoice with no customer selected.

2010-03-14T06:52:54Z

Similar issue while placing a purchase order, mantis 0000217.

DB Error while Placing a Direct Invoice with no customer selected.

2010-03-13T12:54:20Z

Hello,

Added to mantis 0000216: DB Error while Placing a Direct Invoice with no customer selected.

FA 2.2.7

If a Direct invoice is placed with no customer selected a DB error is shown. This can be avoided validating if a customer is selected before posting.

Edit: Tried to place a Sales Quotation with no customer selected and is properly detected : "You must enter the person or company to whom delivery should be made to."

Side efect of this error is that Sales Order is incremented.
Suppose all are initial transactions. After placing a correct Direct Invoice, in customer transactions you can see that Invoice number is #1 Sales Order is #2 and Sales Order #1 is 'lost'.

Regards, Oscar.