• Jan
  • Member
  • Offline
  • Registered: 01/16/2008
  • Posts: 18

Topic: Error with entering supplier 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 ' 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

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

Re: Error with entering supplier invoice

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

  • Jan
  • Member
  • Offline
  • Registered: 01/16/2008
  • Posts: 18

Re: Error with entering supplier invoice

It is on the 2.0 demo site.

Jan

4 Reply by itronics (edited by itronics 03/25/2008 12:13:22 pm)

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

Re: Error with entering supplier invoice

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

  • Jan
  • Member
  • Offline
  • Registered: 01/16/2008
  • Posts: 18

Re: Error with entering supplier invoice

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

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

Re: Error with entering supplier invoice

Hi Jan,

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

Thanks a lot for your testing effort

Janusz

  • Jan
  • Member
  • Offline
  • Registered: 01/16/2008
  • Posts: 18

Re: Error with entering supplier invoice

Janusz,

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



Jan