FrontAccounting forum — Error with entering supplier invoice

Re: Error with entering supplier invoice

null@example.com (Jan) — Fri, 28 Mar 2008 19:24:31 +0000

Janusz,

Browsed about 30 trough fa 2.0 demo and looks good!
No errors etc.
Latest fixes and extra's working well.

Jan

Re: Error with entering supplier invoice

null@example.com (itronics) — Wed, 26 Mar 2008 11:08:12 +0000

Hi Jan,

Found. This was related to tax structure changes. Demo and CVS updated.

Thanks a lot for your testing effort

Janusz

Re: Error with entering supplier invoice

null@example.com (Jan) — Tue, 25 Mar 2008 17:32:09 +0000

Janusz,

At Suppliers, Supplier invoice, Enter new Supplier invoice, Supplier Brezan after putting received items on the invoice i get this error again when i try to complete the invoice.

Training Co. | fa2.iron.from.pl | Demo User Help Logout 
 

Enter Supplier Invoice 


DATABASE ERROR : The supplier transaction tax detail could not be added
error code : 1064
error message : You have an error in your SQL syntax near ' 265.2)' at line 2
sql that failed was : INSERT INTO 0_supp_invoice_tax_items (supp_trans_type, supp_trans_no, tax_type_id, rate, included_in_price, amount) VALUES (20, 10, 3, 25, , 265.2)

Jan

Re: Error with entering supplier invoice

null@example.com (itronics) — Tue, 25 Mar 2008 12:11:55 +0000

I still cannot find it. In what cicumstances you have this issue?
For which supplier it have appeared, for what items? I need some more info to find and repair this, I'm afraid.

Janusz

Re: Error with entering supplier invoice

null@example.com (Jan) — Sun, 23 Mar 2008 09:24:27 +0000

It is on the 2.0 demo site.

Jan

Re: Error with entering supplier invoice

null@example.com (itronics) — Thu, 20 Mar 2008 09:43:24 +0000

I cannot reply this issue. Which FA release do you use ?

Error with entering supplier invoice

null@example.com (Jan) — Wed, 19 Mar 2008 15:33:54 +0000

Training Co. | fa2.iron.from.pl | Demo User Help Logout

Enter Supplier Invoice

DATABASE ERROR : The supplier transaction tax detail could not be added
error code : 1064
error message : You have an error in your SQL syntax near ' 270.4)' at line 2
sql that failed was : INSERT INTO 0_supp_invoice_tax_items (supp_trans_type, supp_trans_no, tax_type_id, rate, included_in_price, amount) VALUES (20, 8, 3, 25, , 270.4)

Jan