X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fincludes%2Fdb%2Fsales_points_db.inc;h=d095c71191ca73c143dc6ef917079cba206b9929;hb=b6af4ea4c99734cfd051395289107bbba5a405e9;hp=6f54fa2206d86c6e432259582bb096fbd67c65a2;hpb=ab79693b43787b7b91a696a56d6287d87cfebdc1;p=fa-stable.git

diff --git a/sales/includes/db/sales_points_db.inc b/sales/includes/db/sales_points_db.inc
index 6f54fa22..d095c711 100644
--- a/sales/includes/db/sales_points_db.inc
+++ b/sales/includes/db/sales_points_db.inc
@@ -27,7 +27,7 @@ function get_all_sales_points()
 		.TB_PREF."sales_pos as pos,"
 		.TB_PREF."locations as loc,"
 		.TB_PREF."bank_accounts as acc"
-		." WHERE pos.pos_location=loc.loc_code AND pos.pos_account=acc.account_code";
+		." WHERE pos.pos_location=loc.loc_code AND pos.pos_account=acc.id";
 	
 	return db_query($sql, "could not get all POS definitions");
 } 
@@ -38,7 +38,7 @@ function get_sales_point($id)
 		.TB_PREF."sales_pos as pos,"
 		.TB_PREF."locations as loc,"
 		.TB_PREF."bank_accounts as acc"
-		." WHERE id=$id AND pos.pos_location=loc.loc_code AND pos.pos_account=acc.account_code";
+		." WHERE pos.id=$id AND pos.pos_location=loc.loc_code AND pos.pos_account=acc.id";
 	
 	$result = db_query($sql, "could not get POS definition");