• Registered: 05/08/2010
  • Posts: 2

Topic: Cash payment on direct sales invoice

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.

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

Re: Cash payment on direct sales invoice

You are right. The problem is that there was no Points of Sales setup before using the Direct Invoice. This information was also missing in the Setting Up in the Wiki. This has been entered now.

You can void the Direct Invoice in Setup tab, Void Transaction. Fix the Point of Sales and reenter the Invoice.

We will have to fix this check also.

/Joe