1 Reply by exodusconsulting50

(4 replies, posted in Accounts Receivable)

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

Go to forum: Accounts Receivable

2 Topic by exodusconsulting50

(4 replies, posted in Accounts Receivable)

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

Go to forum: Accounts Receivable

3 Topic by exodusconsulting50

(2 replies, posted in Dimensions)

Please i'm looking for a way to attached dimension and cash account to a user setup

The reason being that we have 3 cashiers and all cash takings and payment should be reflected in their cash account separately.

Perhaps, this can be achieved if cash account or dimension is link to a user via user's setup. This will restrict a cashier to their working fund and easy daily balancing.

Your reply will be highly appreciated.

Thanks

Exodus

Go to forum: Dimensions

4 Reply by exodusconsulting50

(2 replies, posted in Accounts Receivable)

Please can you assist me. Guide me with instructions on how to do it. thanks

Go to forum: Accounts Receivable

5 Topic by exodusconsulting50

(2 replies, posted in Accounts Receivable)

How to print 80MM Pos receipt and Invoice. A4 Paper is expensive in my country here.

Thanks

Go to forum: Accounts Receivable

6 Reply by exodusconsulting50

(5 replies, posted in Accounts Receivable)

can please assist me with this. your ideals good but i don't know how effect this. I want to restrict some user to a particular location so that they will not raise invoice to all customers on customers list

Go to forum: Accounts Receivable

7 Reply by exodusconsulting50

(5 replies, posted in Accounts Receivable)

How do I get the custom extension

Go to forum: Accounts Receivable

8 Topic by exodusconsulting50

(5 replies, posted in Accounts Receivable)

For example:

A Company with 3 Sales Locations/Branch (Location A,Location B and Location C) with different inventory locations.

Branch A should be able to raise invoice for her customers only. Same applies to other locations.

Branch B should not have access to Branch A or C Customers and inventory locations

How can we restrict Branch A user to her location and customer only? so that Branch B or C will not raise invoice for Branch A customers and vice versa.

Your responses the highly needed.

Thanks

Mr Adetola Rapheal

Go to forum: Accounts Receivable