11-01-2021, 09:59 AM
Hi Harry, try also this ...
Open the file C:\SYSME\SGC\actualizabdsysmehotel.txt and copy this lines:
Then save the file and restart Sysme Pos.
Open the file C:\SYSME\SGC\actualizabdsysmehotel.txt and copy this lines:
Código:
create table almacen_complementg2 select * from almacen_complementg;
insert into almacen_complementg (id_centro,id_empresa,id_almacen,id_tipo_comg,id_complementog,cantidad,stock_minimo,complementog,variacion,desc_variacion)
select "01","001","01",id_tipo_comg,id_complementog,0,0,complementog,0,"" from complementog where cafeteria = "S" and id_complementog not in (select id_complementog from almacen_complementg2);
drop table almacen_complementg2;
Then save the file and restart Sysme Pos.