1 Reply by rocapa

(5 replies, posted in Accounts Receivable)

In the FA 2.3.17 version. The problem appears when I select Customer Payment Entry.
I select a client from payment, after the write bank charge and the allocation and press the update payment boton.
I tried with direct invoice and with all the flow sales order entry - invoice. And it happend in both cases

Rogelio

Go to forum: Accounts Receivable

2 Reply by rocapa

(5 replies, posted in Accounts Receivable)

I have similar error. With FA 2.3.15 y 17. With direct invoice and invoice from Sales Order Entry. And I can repeat the error. And I can not record the payments. Any idea?
I'm using the The standar new company American COA for digits.

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 ,bank_act,0_bank_accounts.bank_name, 0_bank_accounts.bank_account_name, 0_bank_accounts.account_type AS BankTransType FROM 0_debtor_trans trans LEFT JOIN 0_comments com ON trans.type=com.type AND trans.trans_no=com.id LEFT JOIN 0_shippers ON 0_shippers.shipper_id=trans.ship_via, 0_debtors_master cust, 0_bank_trans, 0_bank_accounts WHERE trans.trans_no='3' AND trans.type='12' AND trans.debtor_no=cust.debtor_no AND 0_bank_trans.trans_no ='3' AND 0_bank_trans.type=12 AND 0_bank_trans.amount != 0 AND 0_bank_accounts.id=0_bank_trans.bank_act

Rogelio

Go to forum: Accounts Receivable