Topic: Database Error !!!
thanks for your continuous response to all my question.
There is this error that my entry clerk told me ocurred.
By user rights and privilege, she can only enter invoices and cant enter payment.
two days back, she entered and invoice and surprisingly, a payment was created for that same invoice. When you try to click the invoice number to open it, it displays the following errors:
DATABASE ERROR: no debtor trans found for given params sql that failed was: SELECT 1_debtor_trans.*, ov_amount + ov_gst + ov_freight +ov_freight_tax + ov_discount AS Total, 1_debtors_master.name AS DebtorName, 1_debtors_master.address, 1_debtors_master.email AS email2, 1_debtor master *********************. and so on.
Please what is the cause of this error.
thanks in advance joe