1 Topic by exodusconsulting50 (edited by exodusconsulting50 08/19/2023 03:42:56 am)

  • From: Nigeria, Lagos
  • Registered: 07/07/2020
  • Posts: 11

Topic: Invoice stop printing

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.

/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

2 Reply by rafat (edited by rafat 08/18/2023 07:24:33 pm)

  • rafat
  • Senior Member
  • Offline
  • From: UAE, Dubai
  • Registered: 11/28/2017
  • Posts: 540

Re: Invoice stop printing

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

rafat's Website

3 Reply by exodusconsulting50 (edited by exodusconsulting50 08/19/2023 03:44:32 am)

  • From: Nigeria, Lagos
  • Registered: 07/07/2020
  • Posts: 11

Re: Invoice stop printing

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

  • rafat
  • Senior Member
  • Offline
  • From: UAE, Dubai
  • Registered: 11/28/2017
  • Posts: 540

Re: Invoice stop printing

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

rafat's Website

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,182

Re: Invoice stop printing

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

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website