X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/aa0c7e72dc143e3f29e9bfdbda962ae98c503274..aeeea53192101dd80e4f3a5fae86b0e979bff1e5:/SL/WH.pm diff --git a/SL/WH.pm b/SL/WH.pm index a548bda77..6f693d2fa 100644 --- a/SL/WH.pm +++ b/SL/WH.pm @@ -25,7 +25,8 @@ # GNU General Public License for more details. # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software -# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. +# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, +# MA 02110-1335, USA. #====================================================================== # # Warehouse module @@ -191,7 +192,7 @@ sub transfer_assembly { my $query = qq|SELECT assembly.parts_id, assembly.qty, parts.warehouse_id FROM assembly INNER JOIN parts ON assembly.parts_id = parts.id - WHERE assembly.id = ? AND (inventory_accno_id IS NOT NULL OR parts.assembly = TRUE)|; + WHERE assembly.id = ? AND parts.part_type != 'service'|; my $sth_part_qty_assembly = prepare_execute_query($form, $dbh, $query, $params{assembly_id});