• From: USA
  • Registered: 01/12/2011
  • Posts: 8

Topic: DATABASE ERROR

We are testing FA....we have entered several customer invoices.  I am trying to print them at the Reports and Analysis / Invoice/Credit Notes. 

It gives me an error concerning invoice #1, but if I start at #2, all is well.  I am trying to now find somewhere to look at the invoice to see what I did wrong, but it won't allow me to look at it....what can I do?

Here is the error:

DATABASE ERROR : no debtor trans found for given params
sql that failed was : SELECT trans.*,ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total,cust.name AS DebtorName, cust.address, cust.curr_code, cust.tax_id , 0_shippers.shipper_name, 0_sales_types.sales_type, 0_sales_types.tax_included, branch.*, cust.discount, 0_tax_groups.name AS tax_group_name, 0_tax_groups.id AS tax_group_id FROM 0_debtor_trans trans, 0_debtors_master cust, 0_shippers, 0_sales_types, 0_cust_branch branch, 0_tax_groups WHERE trans.trans_no='1' AND trans.type='10' AND trans.debtor_no=cust.debtor_no AND 0_shippers.shipper_id=trans.ship_via AND 0_sales_types.id = trans.tpe AND branch.branch_code = trans.branch_code AND branch.tax_group_id = 0_tax_groups.id

How can I delete/edit/modify this invoice if I can't pull it up?

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: DATABASE ERROR

There seems to be something wrong with invoice #1. I you can't enter it to look at it, you can try with phpMyAdmin and look at information in debtor_trans and debtor_trans_details.

/Joe

  • From: USA
  • Registered: 01/12/2011
  • Posts: 8

Re: DATABASE ERROR

According to our IT Manager we shouldn't need to access the database in this way.  There
shouldn't be a need to do this since the program should reject the invalid data and not let me process the invoice?
Correct???

But we did look at the database and all the information is the same as other invoices that we can look at.

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: DATABASE ERROR

You are correct in your opinion, but I never know exactly what users have been done all the time. I only try to help as creatively as possible.

There must be some kind of link problem, but I cant tell you what.

If you want me to help, you will need to send me a backup script of your company.

/Joe