FrontAccounting forum — Error with entering supplier invoice

Re: Error with entering supplier invoice

2008-03-28T19:24:31Z

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

2008-03-26T11:08:12Z

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

2008-03-25T17:32:09Z

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

2008-03-25T12:11:55Z

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

2008-03-23T09:24:27Z

It is on the 2.0 demo site.

Jan

Re: Error with entering supplier invoice

2008-03-20T09:43:24Z

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

Error with entering supplier invoice

2008-03-19T15:33:54Z

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