- $sql = "SELECT SUM(qty) FROM ".TB_PREF."stock_moves WHERE stock_id=".db_escape($stock_id) . "
- AND loc_code=".db_escape( $StockLocation) . "
- AND tran_date < '" . $after_date . "'";
+ $sql = "SELECT SUM(qty) FROM ".TB_PREF."stock_moves WHERE stock_id=".db_escape($stock_id);
+ if ($StockLocation)
+ $sql .= " AND loc_code=".db_escape( $StockLocation);
+ $sql .= " AND tran_date < '" . $after_date . "'";