search

VicenteCool / RetailOne

0 stars 0 forks source link

CA cobrado se realiza DE sale sin FP #39

Closed VicenteCool closed 5 years ago

VicenteCool commented 5 years ago

La CA se cierra con al DE La CA tiene PAGO La DE no tiene FP

select from "@SO1_01VENTA" where Name='003037CA202906' select from "@SO1_01VENTACOBRO" where U_SO1_FOLIO='003037CA202906' select from "@SO1_01DEVOLUCION" where U_SO1_FOLIOCAJA='003037CA202906' select from "@SO1_01DEVOLUCIONPAG" where U_SO1_FOLIO='003037CA202906'

VicenteCool commented 5 years ago

imagen

VicenteCool commented 5 years ago

Todas las DE tiene su FP select t0.name, t0.U_SO1_VERSIONR1, t0.U_SO1_FECHA, t1.U_SO1_CODIGOFP, t2.Name, t2.U_SO1_VERSIONR1, t3.U_SO1_CODIGOFP from "@SO1_01VENTA" t0 inner join "@SO1_01VENTACOBRO" t1 on t0.Name=t1.U_SO1_FOLIO inner join "@SO1_01DEVOLUCION" t2 on t2.U_SO1_FOLIOCAJA=t0.name LEFT join "@SO1_01DEVOLUCIONPAG" t3 on t3.U_SO1_FOLIO=t2.Name where t0.U_SO1_FECHA>='20190301' and t0.U_SO1_TIPO='CA'