FrontAccounting forum — Invoice stop printing

Re: Invoice stop printing

null@example.com (kvvaradha) — Sat, 19 Aug 2023 13:44:33 +0000

Your invoice transaction might input duplicate entry in debtor trans table. So the standard FA or non standard FA. The system cant read your invoice with duplicate.

Kindly submit a support ticket on our website along with a copy of your bugged database sql file. And login credentials

Re: Invoice stop printing

null@example.com (rafat) — Sat, 19 Aug 2023 06:28:40 +0000

To me this looks like a non standard FA code. @kvvaradha might be able to help you here.

Re: Invoice stop printing

null@example.com (exodusconsulting50) — Sat, 19 Aug 2023 03:19:45 +0000

From the report page still cannot print. didn't display the invoice to be printed.

===================================================================================
error msg.

/home/ufitflyn/public_html/fly/sales/includes/db/cust_trans_db.inc:214: display_backtrace()
/home/ufitflyn/public_html/fly/reporting/rep107.php:126: get_customer_trans('2','10')
/home/ufitflyn/public_html/fly/reporting/rep107.php:57: print_invoices()
/home/ufitflyn/public_html/fly/modules/KvcodesInvoices/reporting/rep107.php:25: include_once('/home/ufitflyn/public_html/fly/reporting/rep107.php')
/home/ufitflyn/public_html/fly/reporting/prn_redirect.php:58: require('/home/ufitflyn/public_html/fly/modules/KvcodesInvoices/reporting/rep107.php')
DATABASE ERROR : duplicate debtor transactions 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.debtor_ref, cust.curr_code, cust.tax_id, trans.prep_amount>0 as prepaid,com.memo_, 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 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_sales_types, 0_cust_branch branch, 0_tax_groups WHERE trans.trans_no='2' AND trans.type='10' AND trans.debtor_no=cust.debtor_no AND 0_sales_types.id = trans.tpe AND branch.branch_code = trans.branch_code AND branch.tax_group_id = 0_tax_groups.id

Re: Invoice stop printing

null@example.com (rafat) — Fri, 18 Aug 2023 19:23:30 +0000

Look at the logs and see if any errors.
Does print from the Reports page?

Invoice stop printing

null@example.com (exodusconsulting50) — Fri, 18 Aug 2023 15:58:33 +0000

My FA stop printing invoice. After the invoice has been posted nothing will show when you click "print Invoice"

this is the error msg i got.