• Registered: 08/29/2009
  • Posts: 2

Topic: Direct Invoice fixed for sales order return nothing - 0

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

  • Registered: 12/25/2007
  • Posts: 2,448

Re: Direct Invoice fixed for sales order return nothing - 0

Can't reproduce this issue. There should be no situation, when sales order is issued but location is not set at all.

Janusz