There is a situation such that when creating a direct sales invoice, the cash account in the cash payment box comes up empty. If you don't notice it and go ahead with the invoice, there is no error message and the payment is not posted into any account.
When you then go into the Transactions screen and choose the transaction number, the following error appears:
"DATABASE ERROR : no debtor trans found for given params sql that failed was : SELECT 0_debtor_trans.*, ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total, 0_debtors_master.name AS DebtorName, 0_debtors_master.address, 0_debtors_master.email AS email2, 0_debtors_master.curr_code, 0_debtors_master.tax_id, 0_debtors_master.payment_terms , 0_bank_accounts.bank_name, 0_bank_accounts.bank_account_name, 0_bank_accounts.account_type AS BankTransType FROM 0_debtor_trans, 0_debtors_master , 0_bank_trans, 0_bank_accounts WHERE 0_debtor_trans.trans_no='2' AND 0_debtor_trans.type='12' AND 0_debtor_trans.debtor_no=0_debtors_master.debtor_no AND 0_bank_trans.trans_no =2 AND 0_bank_trans.type=12 AND 0_bank_accounts.id=0_bank_trans.bank_act"
This happens when (I'm using the demo company) you go into the direct sales invoice screen and Beefeater appears by default, and then you change the customer to Ghostbusters. In other situations it's fine.
Furthermore, there seems to be no way to correct it manually, because there is no editing access to the GL posting transaction.