SELECT Pos_Pagos.Cj_Cve_Caja, Forma_Pago.Fp_Cve_Forma_Pago, Forma_Pago.Fp_Descripcion, isnull(SUM(Pos_Pagos.Pos_Importe),0) - isnull(SUM(Pos_Pagos.POS_Descuento_Importe),0) as POS_Importe, isnull(POS_Declaracion.Pd_Importe,0) as POS_Declarado FROM Forma_Pago LEFT JOIN Pos_Pagos ON Pos_Pagos.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago AND POS_Pagos.POS_Folio = '03-0000361' LEFT JOIN POS_Declaracion ON POS_Declaracion.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago AND POS_Declaracion.POS_Folio = '03-0000361' GROUP BY POS_Declaracion.Pd_Importe, Pos_Pagos.Cj_Cve_Caja, Forma_Pago.Fp_Cve_Forma_Pago, Forma_Pago.Fp_Descripcion SELECT Sc_Prefijo_General as Campo FROM Sucursal WHERE Sc_Cve_Sucursal = '0003' SELECT Fl_Folio FROM Folio_Sucursal WHERE Sc_Cve_Sucursal = '0003' AND Fl_Tabla = 'POS_Recepcion_Valores' UPDATE Folio_Sucursal SET Fl_Folio = Fl_Folio + 1 WHERE Sc_Cve_Sucursal = '0003' AND Fl_Tabla = 'POS_Recepcion_Valores' SELECT Fl_Folio FROM Folio_Sucursal WHERE Sc_Cve_Sucursal = '0003' AND Fl_Tabla = 'POS_Recepcion_Valores' SELECT Sc_Descripcion AS Nombre FROM Sucursal WHERE Sc_Cve_Sucursal = '0003' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_FOLIO_X_SUCURSAL' INSERT INTO POS_Declaracion(POS_Folio,Pd_ID,Fp_Cve_Forma_Pago,Pd_Importe, Oper_Alta, Fecha_Alta, Oper_Ult_Modif, Fecha_Ult_Modif ) VALUES ('03-0000361','0003','0004',258.35,'0001','2023-04-03 20:55:18','0001','2023-04-03 20:55:18') INSERT INTO POS_Declaracion(POS_Folio,Pd_ID,Fp_Cve_Forma_Pago,Pd_Importe, Oper_Alta, Fecha_Alta, Oper_Ult_Modif, Fecha_Ult_Modif ) VALUES ('03-0000361','0001','0001',1184.4715,'0001','2023-04-03 20:55:18','0001','2023-04-03 20:55:18') SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_GENERAR_RECIBO_CAJA_AL_DECLARAR' UPDATE POS_Ventas SET Oper_Ult_Modif = '0001', Fecha_Ult_Modif = '2023-04-03 20:55:17', POS_Declarado = 'SI', POS_Fecha_Final = '2023-04-03 20:55:17', POS_Transaccion_Final = '0000003144', POS_Ventas = 8, POS_Importe = ISNULL((SELECT SUM(POS_Importe_Real) FROM POS_Pagos WHERE POS_Folio = '03-0000361' AND POS_Pagos.POS_Tipo <> '0002'), 0) WHERE POS_Folio = '03-0000361' SELECT GetDate() as Fecha UPDATE POS_Control_Cajas SET Oper_Ult_Modif = '0001', Fecha_Ult_Modif = '2023-04-03 20:55:17', Ca_Declarado = 'SI' WHERE POS_Folio = '03-0000361' UPDATE POS_Control_Cajas SET Oper_Ult_Modif = '0001', Fecha_Ult_Modif = '2023-04-03 20:55:17', Cj_Cortada = 'SI' WHERE POS_Folio = '03-0000361' SELECT COUNT(DISTINCT(Cj_Transaccion)) AS Ventas FROM POS_Pagos WHERE POS_Folio = '03-0000361' SELECT GetDate() as Fecha *** BEGIN TRANSACION *** SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_PREFIJO_FOLIOS_EMPRESA' SELECT Fl_Folio FROM Folio WHERE Fl_Tabla = 'CAJA:000001' SELECT Forma_Pago.Fp_Descripcion, SUM(POS_Pagos.POS_Importe) as POS_Importe FROM POS_Pagos INNER JOIN Forma_Pago ON POS_Pagos.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago WHERE Cj_Cve_Caja = '000001' AND Cj_Transaccion >= '0000003137' AND POS_Pagos.Es_Cve_Estado <> 'CA' GROUP BY Forma_Pago.Fp_Descripcion SELECT Forma_Pago.Fp_Descripcion, SUM(ABS(POS_Pagos.POS_Importe)) as POS_Importe FROM POS_Pagos INNER JOIN Forma_Pago ON POS_Pagos.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago WHERE POS_Tipo = '0002' AND Cj_Cve_Caja = '000001' AND Cj_Transaccion >= '0000003137' AND POS_Pagos.Es_Cve_Estado <> 'CA' GROUP BY Forma_Pago.Fp_Descripcion SELECT Forma_Pago.Fp_Descripcion, SUM(ABS(POS_Pagos.POS_Importe)) as POS_Importe FROM POS_Pagos INNER JOIN Forma_Pago ON POS_Pagos.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago WHERE POS_Tipo = '0004' AND Cj_Cve_Caja = '000001' AND Cj_Transaccion >= '0000003137' AND POS_Pagos.Es_Cve_Estado <> 'CA' GROUP BY Forma_Pago.Fp_Descripcion SELECT Forma_Pago.Fp_Descripcion, SUM(POS_Pagos.POS_Importe) as POS_Importe FROM POS_Pagos INNER JOIN Forma_Pago ON POS_Pagos.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago WHERE POS_Tipo NOT IN ('0002', '0004') AND Cj_Cve_Caja = '000001' AND Cj_Transaccion >= '0000003137' AND POS_Pagos.Es_Cve_Estado <> 'CA' GROUP BY Forma_Pago.Fp_Descripcion SELECT POS_Folio, POS_Transaccion_Inicial, POS_Fecha_Inicial FROM POS_Ventas WHERE POS_Folio = '03-0000361' AND Cj_Cve_Caja = '000001' AND Ca_Cve_Cajero = '0001' SELECT GetDate() as Fecha SELECT DISTINCT Vn_Folio FROM Venta INNER JOIN Producto ON Venta.Pr_Cve_Producto = Producto.Pr_Cve_Producto WHERE Venta.Vn_Inventario_Pendiente = 'SI' AND Vn_Referencia = '03-0000361' AND Venta.Es_Cve_Estado <> 'CA' AND Producto.Pr_Tipo_Producto NOT IN ('99', '06') SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_MODO_DESCARGAR_VENTA_PENDIENTE_CORTE' SELECT Pos_Pagos.Cj_Cve_Caja, Forma_Pago.Fp_Cve_Forma_Pago, Forma_Pago.Fp_Descripcion, isnull(SUM(Pos_Pagos.Pos_Importe),0) - isnull(SUM(Pos_Pagos.POS_Descuento_Importe),0) as POS_Importe, isnull(POS_Declaracion.Pd_Importe,0) as POS_Declarado FROM Forma_Pago LEFT JOIN Pos_Pagos ON Pos_Pagos.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago AND POS_Pagos.POS_Folio = '03-0000361' LEFT JOIN POS_Declaracion ON POS_Declaracion.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago AND POS_Declaracion.POS_Folio = '03-0000361' GROUP BY POS_Declaracion.Pd_Importe, Pos_Pagos.Cj_Cve_Caja, Forma_Pago.Fp_Cve_Forma_Pago, Forma_Pago.Fp_Descripcion SELECT Sc_Prefijo_General as Campo FROM Sucursal WHERE Sc_Cve_Sucursal = '0003' SELECT Fl_Folio FROM Folio_Sucursal WHERE Sc_Cve_Sucursal = '0003' AND Fl_Tabla = 'POS_Recepcion_Valores' UPDATE Folio_Sucursal SET Fl_Folio = Fl_Folio + 1 WHERE Sc_Cve_Sucursal = '0003' AND Fl_Tabla = 'POS_Recepcion_Valores' SELECT Fl_Folio FROM Folio_Sucursal WHERE Sc_Cve_Sucursal = '0003' AND Fl_Tabla = 'POS_Recepcion_Valores' SELECT Sc_Descripcion AS Nombre FROM Sucursal WHERE Sc_Cve_Sucursal = '0003' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_FOLIO_X_SUCURSAL' INSERT INTO POS_Declaracion(POS_Folio,Pd_ID,Fp_Cve_Forma_Pago,Pd_Importe, Oper_Alta, Fecha_Alta, Oper_Ult_Modif, Fecha_Ult_Modif ) VALUES ('03-0000361','0003','0004',258.35,'0001','2023-04-03 20:55:10','0001','2023-04-03 20:55:10') INSERT INTO POS_Declaracion(POS_Folio,Pd_ID,Fp_Cve_Forma_Pago,Pd_Importe, Oper_Alta, Fecha_Alta, Oper_Ult_Modif, Fecha_Ult_Modif ) VALUES ('03-0000361','0001','0001',1184.4715,'0001','2023-04-03 20:55:10','0001','2023-04-03 20:55:10') SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_GENERAR_RECIBO_CAJA_AL_DECLARAR' UPDATE POS_Ventas SET Oper_Ult_Modif = '0001', Fecha_Ult_Modif = '2023-04-03 20:55:09', POS_Declarado = 'SI', POS_Fecha_Final = '2023-04-03 20:55:09', POS_Transaccion_Final = '0000003144', POS_Ventas = 8, POS_Importe = ISNULL((SELECT SUM(POS_Importe_Real) FROM POS_Pagos WHERE POS_Folio = '03-0000361' AND POS_Pagos.POS_Tipo <> '0002'), 0) WHERE POS_Folio = '03-0000361' SELECT GetDate() as Fecha UPDATE POS_Control_Cajas SET Oper_Ult_Modif = '0001', Fecha_Ult_Modif = '2023-04-03 20:55:09', Ca_Declarado = 'SI' WHERE POS_Folio = '03-0000361' UPDATE POS_Control_Cajas SET Oper_Ult_Modif = '0001', Fecha_Ult_Modif = '2023-04-03 20:55:09', Cj_Cortada = 'SI' WHERE POS_Folio = '03-0000361' SELECT COUNT(DISTINCT(Cj_Transaccion)) AS Ventas FROM POS_Pagos WHERE POS_Folio = '03-0000361' SELECT GetDate() as Fecha *** BEGIN TRANSACION *** SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_PREFIJO_FOLIOS_EMPRESA' SELECT Fl_Folio FROM Folio WHERE Fl_Tabla = 'CAJA:000001'