1 Topic by codemeit

(1 replies, posted in Report Bugs here)

I am using FrontAccounting 2.1.5
It throws the error below when i view the sale details after perform direct invoice.

The cause is it tried to look for an inventory location with empty string code of the location.

The solution, create new location with empty string as the code.



Error Details
DATABASE ERROR : FATAL : sales order return nothing - 0
sql that failed was : SELECT 1_sales_orders.*, 1_debtors_master.name, 1_debtors_master.curr_code, 1_debtors_master.email AS master_email, 1_locations.location_name, 1_debtors_master.payment_terms, 1_debtors_master.discount, 1_sales_types.sales_type, 1_sales_types.id AS sales_type_id, 1_sales_types.tax_included, 1_shippers.shipper_name, 1_tax_groups.name AS tax_group_name , 1_tax_groups.id AS tax_group_id FROM 1_sales_orders, 1_debtors_master, 1_sales_types, 1_tax_groups, 1_cust_branch, 1_locations, 1_shippers WHERE 1_sales_orders.order_type=1_sales_types.id AND 1_cust_branch.branch_code = 1_sales_orders.branch_code AND 1_cust_branch.tax_group_id = 1_tax_groups.id AND 1_sales_orders.debtor_no = 1_debtors_master.debtor_no AND 1_locations.loc_code = 1_sales_orders.from_stk_loc AND 1_shippers.shipper_id = 1_sales_orders.ship_via AND 1_sales_orders.order_no = 1

Go to forum: Report Bugs here

2 Topic by codemeit

(1 replies, posted in Report Bugs here)

Version 2.1.5 Build 26.08.2009



DATABASE ERROR : The sales order detail record could not be updated
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE order_no = 1' at line 4
sql that failed was : UPDATE 0_sales_order_details SET quantity = qty_sent, type = 0, WHERE order_no = 1

Go to forum: Report Bugs here