search

VicenteCool / RetailOne

0 stars 0 forks source link

DA sin pago, se realiza la DE y sale con FP #46

Closed VicenteCool closed 4 years ago

VicenteCool commented 4 years ago

imagen

VicenteCool commented 4 years ago

select t0.Name as Venta, t0.U_SO1_FECHA, t0.U_SO1_STATUS, t1.U_SO1_FOLIO as Pago, t2.Name as Devolucion, t2.U_SO1_VERSIONR1, t3.U_SO1_CODIGOFP from "@SO1_01VENTA" t0 left join "@SO1_01VENTACOBRO" t1 on t0.U_SO1_FOLIODESTINO=t1.U_SO1_FOLIO left join "@SO1_01DEVOLUCION" t2 on t2.U_SO1_FOLIOCAJA=t0.U_SO1_FOLIODESTINO left join "@SO1_01DEVOLUCIONPAG" t3 on t3.U_SO1_FOLIO=t2.Name where t0.U_SO1_TIPO='DA' --and t0.U_SO1_STATUS='V' order by t0.U_SO1_FECHA

VicenteCool commented 4 years ago

imagen

VicenteCool commented 4 years ago

se pasa la version .76 imagen

VicenteCool commented 4 years ago

Se realiza la correccion en Nichupte.

delete "@SO1_01DEVOLUCIONPAG" where U_SO1_FOLIO in ( '003045DE22479', '003045DE22640', '003045DE22791')