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

diff --git a/sales/includes/db/sales_points_db.inc b/sales/includes/db/sales_points_db.inc
index d444ea76..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 pos.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");