Transferencia de Archivos FTP y SFTP (Friar)

Friar utiliza el sistema seguro de transferencia de archivos SFTP. Accedemos al servidor mediante la aplicacion WINSCP

Podemos configurar las conexiones a los servidores como se muestra en la imagen. En caso de que no la tengamos configurada, el usuario es por lo general el nombre de la empresa en minúscula y la clave es el cuit

Cada empresa, y cada sucursal tienen configurada un carpeta en el servidor de SFTP donde se cargar los archivos que se importan y se exportan mediante servicios configurados en Windows Server.

El servicio es SabioGoGuardian y SabioGoService. Ambos deben estar corriendo

Accedemos a la configuración de estos servicios a través de la versión Server de Sabio Go, en la pestaña a la derecha de la ventana principal

Haciendo click en esta pestaña se nos abre una ventana que nos muestra los diferentes servicios configurados

Los servicios por lo general configurados son: Exportaciones de ventas, liquidaciones, pedidos, avícolas, etc. las importaciones son de precios, productos, remitos, etc.

Cada empresa, de acuerdo al trato que tiene con Friar, posee su propia configuración, aunque hay generalidades

En el disco del servidor, en la siguiente ubicación, vemos las carpetas donde se guardan los archivos que se transfieren, tanto por SFTP como por FTP

En el archivo Servicios vemos el XML de los servicios configurados para ejecutar. En el caso de Friar, los servicios usuales son los siguientes:

En Casa Central

Exportación de Pedidos: (ejemplo)

<EXPORT-PEDIDOS-FRIAR>
<CRON>0 */10 * * * ? </CRON>
<Base>MAPE</Base>
<ArchivoXML>PEDIDO_NROCTA_NROCOM.xml</ArchivoXML>
<SQL>PEDIDOS</SQL>
<SQLCOMPROBANTE>
SELECT * FROM MOVNOCONTABLES nc
WHERE nc.FECHA >= dateadd(-5 DAY TO CURRENT_DATE)
AND nc.ESTADO = 3
AND nc.COMPRO = 'PEF'
ORDER BY nc.FECHA ASC
</SQLCOMPROBANTE>
<SQLDETALLE>select dm.codart,dm.descri,
cast(iif(art.unidad=1,coalesce(dm.presen,1),dm.cantid) as integer) as cantid,
cast(iif(art.unidad<>1,coalesce(dm.presen,1),dm.cantid) as numeric(10,4)) as kilos
from detmovnoconart dm
inner join articulos art on dm.codart=art.codigo
where dm.numero=@1 </SQLDETALLE>
<FtpHost>200.71.237.211</FtpHost>
<FtpPort>2200</FtpPort>
<FtpUser>mape</FtpUser>
<FtpPass>U0ZSdFRdPnA+I3k=</FtpPass>
<FtpPath>/CT1320/PEDIDOS/</FtpPath>
<FtpSeguro>SI</FtpSeguro>
<MailPrefijo>[Avisos: Pedidos a FRIAR] </MailPrefijo>
</EXPORT-PEDIDOS-FRIAR>

Exportacion Avícola: (tantas como sucursales tenga la empresa)

<EXPORT-AVICOLA1>
<CRON>0 0 1 1,5 * ? </CRON>
<Base>MAPE</Base>
<ArchivoCSV>AVI_19381_MAPESRL_0001.CSV</ArchivoCSV>
<Comillas>"</Comillas>
<Cabecera>SI</Cabecera>
<SQL>SELECT
LPAD(extract(day from a.FECHA),2,'0')||'/'|| LPAD(extract(month from a.FECHA),2,'0')||'/'|| LPAD(extract(year from a.FECHA),4,'0') as FECHA,
A.CODART,
a.DESCRI,
sum(a.CANTID) as cantid,
ROUND(IIF(a.tipcom='NC',-a.neto,a.NETO),4) AS NETO ,
sum(ROUND((a.NETO * A.CANTID),2)) as IMPORTE,
A.NROCOM,
a.TIPCOM
FROM
V_VENTAS_FRIAR_1 A
WHERE
A.NUMNEG = 10010
AND
extract(year from A.fecha) = extract(year from DATEADD(-1 MONTH TO current_date)) and
extract(month from A.fecha) = extract(month from DATEADD(-1 MONTH TO current_date))
AND a.NUMSUC =1
group by 1,2,3,5,7,8</SQL>
<FtpHost>200.71.237.211</FtpHost>
<FtpPort>2200</FtpPort>
<FtpUser>avicola</FtpUser>
<FtpPass>KHVIW2g0VyMqVCkw</FtpPass>
<FtpPath>/home/avicola/datos/</FtpPath>
<FtpURL>/home/avicola/datos/</FtpURL>
<FtpSeguro>SI</FtpSeguro>
<Debug>1</Debug>
</EXPORT-AVICOLA1>

Exportación Ventas:

<EXPORT-VENTAS-FRIAR>
<Server>192.168.1.111</Server>
<Base>MAPE</Base>
<ArchivoTXT>CUIT_COM_NROCOM.TXT</ArchivoTXT>
<SQL>NEWVENTAS</SQL>
<SQLCOMPROBANTE>
select m.asient,'02' as bloque,
cast(substr(m.NROCOM,13,13)||substr(m.NROCOM,1,12) as char(13)) as NRO_CPTE,
right('000'||t.codigo,3) as tipo_com,
cast( right('0'||extract(day from m.fecha),2) || '/' || right('0'||extract(month from m.fecha),2) || '/' || extract(year from m.fecha) as varchar(10)) as FECHA_EMIS,
replace(m.cuit,'-','') as CUIT,
right('00'||i.codiva,2) as codiva,
m.titula as RAZON_SOCIAL,
right('00'||m.forpag,2) as convta,
m.total as IMPORTE_TOTAL,
m.neto1+m.neto2+m.nograb as IMPORTE_NETO,
m.iva1+m.iva2 as IVA,
m.retdgr + m.retiva + m.retgan as OTROS
from movcontables m
inner join comprobantes c on m.compro=c.codigo
inner join tbl_compro_iva t on m.compro=t.codcom and substr(m.NROCOM,13,13)=t.letra
inner join cuentas e on m.numtit=e.numint
inner join regiva i on e.regiva = i.numero
where m.fecanu is null and c.tipo=1 and coalesce(m.nrocbu,'00') = '00' and
m.fecha > '2016-01-01' and
m.fecha > (current_date - 60) and
left(m.nrocom,4) in ('0001','0002','0003','0007','0015')
order by m.asient
</SQLCOMPROBANTE>
<SQLIMPUESTO>
select '04' as bloque,
d.reglon - ((select min(dd.reglon) from detmovcontables dd where dd.asient=d.asient)-1) as linea,
d.iva as ALICUOTA,
cast(d.cantid * d.preuni * (1-(d.descue/cast(100 as float))) as numeric(10,2)) as NETO,
cast(d.cantid * d.preuni * (1-(d.descue/cast(100 as float))) * (d.iva/cast(100 as float)) as numeric(10,2)) as IVA,
right('00'||(select first 1 cast(p.numer2 as integer) from parametros p where p.codigo starting with 'PORIVA' and p.numer1=d.iva),2) as tipo
from detmovcontables d
inner join articulos a on d.codart=a.codigo
inner join unidades u on a.unidad=u.numero
where d.asient = @1
union all
select '04' as bloque,
d.reglon - ((select min(dd.reglon) from detmovcontables dd where dd.asient=d.asient)-1) as linea,
m.dedali as ALICUOTA,
cast(d.cantid * d.preuni * iif(right(m.nrocom,1)='B',(1+(d.iva/cast(100 as float))),1) * (1-(d.descue/cast(100 as float))) as numeric(10,2)) as NETO,
cast(d.cantid * d.preuni * iif(right(m.nrocom,1)='B',(1+(d.iva/cast(100 as float))),1) * (1-(d.descue/cast(100 as float))) * (m.dedali/cast(100 as float)) as numeric(10,2)) as Importe,
'C6' as tipo
from detmovcontables d
inner join movcontables m on d.asient = m.asient
inner join articulos a on d.codart=a.codigo
inner join unidades u on a.unidad=u.numero
where d.asient = @1 and m.dedali <> 0 and m.retdgr <> 0 and
(select p.texto2 from parametros p where p.codigo='PERIBRTUCU' and p.empres = 1) containing a.tippro
union all
select '04' as bloque,
d.reglon - ((select min(dd.reglon) from detmovcontables dd where dd.asient=d.asient)-1) as linea,
m.dedal2 as ALICUOTA,
cast(d.cantid * d.preuni * (1-(d.descue/cast(100 as float))) as numeric(10,2)) as NETO,
cast(d.cantid * d.preuni * (1-(d.descue/cast(100 as float))) * (m.dedal2/cast(100 as float)) as numeric(10,2)) as Importe,
'C7' as tipo
from detmovcontables d
inner join movcontables m on d.asient = m.asient
inner join articulos a on d.codart=a.codigo
inner join unidades u on a.unidad=u.numero
where d.asient = @1 and m.dedal2 <> 0 and m.retgan <> 0 and
(select p.memo1 from parametros p where p.codigo='PERMUNTUCU' and p.empres = 1) containing a.tippro
</SQLIMPUESTO>
<SQLDETALLE>
select '03' as bloque,
d.reglon - ((select min(dd.reglon) from detmovcontables dd where dd.asient=d.asient)-1) as linea,
left(d.codart,10) as codigo, left(d.descri,200) as descri,
d.cantid, iif(upper(u.nombre) containing 'KG' or upper(u.nombre) containing 'KILO','KG','UN') as UNIDAD,
cast(d.preuni as numeric(10,2)) as PRECIO,
cast(d.cantid * d.preuni as numeric(10,2)) as SUBTOTAL,
d.descue as PC_BONIFIC,cast((d.cantid*d.preuni/cast(100 as float)) * d.descue as numeric(10,2) ) as BONIFICACION,
'L'||d.lispre as lispre
from detmovcontables d
inner join articulos a on d.codart=a.codigo
inner join unidades u on a.unidad=u.numero
where d.asient = @1
</SQLDETALLE>
<FtpHost>200.71.237.211</FtpHost>
<FtpPort>2200</FtpPort>
<FtpUser>cptes</FtpUser>
<FtpPass>TkhMKFhbVlJs</FtpPass>
<FtpPath>/home/cptes/upload/</FtpPath>
<FtpURL>/home/cptes/upload/</FtpURL>
<MailPrefijo>[Avisos:Catamarca MAPE SRL] </MailPrefijo>
<Debug>1</Debug>
</EXPORT-VENTAS-FRIAR>

Liquidaciones No Consignadas con CAE:

<EXPORT-LIQUIDACIONES_NO_CON_CAE>
<Server>192.168.1.111</Server>
<Base>MAPE</Base>
<ArchivoXML>LSP_019381_NROCOM.XML</ArchivoXML>
<SQL>LIQUIDACIONES</SQL>
<SQLCABECERA>

select distinct v.liqpro,0,
'019381' as NROCLI,
'MAPE CARNICERIA' as NOMBRE,
substr(v.nroliq,7,19) as NROCPTE,
(case substr(v.nroliq,1,2) when 'NL' then 'FC' else substr(v.nroliq,1,2) end) as TCPTE,
v.obsliq as OBSERVACIONES,
v.LP_NROCAE as CAE,
v.LP_FECCAE as VENCCAE,
v.fecdes as FEC_DESDE,
v.fechas as FEC_HASTA,
cast(v.LP_SUBTOTAL - v.lp_imp_comision as numeric(10,2)) as T_NETO_GRAVADO,
'IVA' as I_TIPO_IMPUESTO,
cast(v.LP_SUBTOTAL - v.lp_imp_comision as numeric(10,2)) as I_IMPORTE_IMPONIBLE,
cast(v.lp_alicuota as numeric(10,2)) as I_ALICUOTA,
cast(v.LP_IVA as numeric(10,2)) as I_IMPORTE_IMPUESTO,
cast(v.LP_TOTAL as numeric(10,2)) as T_TOTAL
from v_liquido_producto v
where v.LP_NROCAE is not null and v.fecdes is not null and v.fechas > (current_date-25) and v.cantid<>0 and v.tippro=1
order by 1

</SQLCABECERA>
<SQLDETALLE>

select v.liqpro,0,
(case v.signo
when '+' then 'FC'
when '-' then 'NC'
end) as TCPTE,
v.nrocom as NRO_CPTE,
v.articulo as PRODUCTO,
cast(v.cantid as numeric(15,4)) as CANTIDAD,
v.medida as MEDIDA,
cast(v.preuni as numeric(15,4)) as PRECIO,
cast(v.totnet as numeric(10,2)) as IMP_NETO,
v.iva as ALICUOTA,
cast(v.l_factor * 100 as numeric(10,2)) as PC_COMISION,
cast(v.l_comisi as numeric(10,2)) as IMP_COMISION,
v.autori as ID_AUTORIZACION,
0 as IIBB,
'CT1320' as CTKEY,
v.fecha as FECHA,v.descue as BONIF_PC, v.totdes as BONIF_IM,'L'||v.numlis as LISTA
from v_liquido_producto v
where v.tippro=1 and v.liqpro=@1
order by 1,2,3,4

</SQLDETALLE>
<SQLRESUMEN>

Liquidaciones No Consignadas

<EXPORT-LIQUIDACIONES_NO_CON>
<Server>192.168.1.111</Server>
<Base>MAPE</Base>
<ArchivoXML>LIQ_019381_NROCOM.XML</ArchivoXML>
<SQL>LIQUIDACIONES</SQL>
<SQLCABECERA>select distinct v.liqpro,0,
'019381' as NROCLI,
'MAPE CARNICERIA' as NOMBRE,
substr(v.nroliq,7,19) as NROCPTE,
(case substr(v.nroliq,1,2) when 'NL' then 'FC' else 'NC' end) as TCPTE,
v.obsliq as OBSERVACIONES,
v.nrocai as CAI,
v.feccai as VENCCAI,
v.fecdes as FEC_DESDE,
v.fechas as FEC_HASTA,
cast(v.LP_SUBTOTAL - v.lp_imp_comision as numeric(10,2)) * cast((case substr(v.nroliq,1,2) when 'NL' then 1 else -1 end) as numeric(10,2)) as T_NETO_GRAVADO,

'IVA' as I_TIPO_IMPUESTO,
cast(v.LP_SUBTOTAL - v.lp_imp_comision as numeric(10,2)) * cast((case substr(v.nroliq,1,2) when 'NL' then 1 else -1 end) as numeric(10,2)) as I_IMPORTE_IMPONIBLE,
cast(v.lp_alicuota as numeric(10,2)) as I_ALICUOTA,
cast(v.LP_IVA as numeric(10,2)) * cast((case substr(v.nroliq,1,2) when 'NL' then 1 else -1 end) as numeric(10,2)) as I_IMPORTE_IMPUESTO,

cast(v.LP_TOTAL as numeric(10,2)) * cast((case substr(v.nroliq,1,2) when 'NL' then 1 else -1 end) as numeric(10,2)) as T_TOTAL
from v_liquido_producto v
inner join movcontables liq on v.liqpro=liq.asient
where v.nrocai is not null and v.LP_NROCAE is null and v.fecdes is not null and liq.fecha > (current_date-60) and v.cantid<>0 and v.tippro=1
order by 1</SQLCABECERA>
<SQLDETALLE>

select v.liqpro,0,
(case v.signo
when '+' then 'FC'
when '-' then 'NC'
end) as TCPTE,
v.nrocom as NRO_CPTE,
v.articulo as PRODUCTO,
cast(v.cantid as numeric(15,4)) as CANTIDAD,
v.medida as MEDIDA,
cast(v.preuni as numeric(15,4)) as PRECIO,
cast(v.totnet as numeric(10,2)) as IMP_NETO,
v.iva as ALICUOTA,
cast(v.l_factor * 100 as numeric(10,2)) as PC_COMISION,
cast(v.l_comisi as numeric(10,2)) as IMP_COMISION,
v.autori as ID_AUTORIZACION,
0 as IIBB,
(case v.numsuc
when 1 then 'CT1320'
when 2 then 'CT8047'
end) as CTKEY,
v.fecha as FECHA,v.descue as BONIF_PC, v.totdes as BONIF_IM,'L'||v.numlis as LISTA
from v_liquido_producto v
where v.nrocai is not null and v.fecdes is not null and v.tippro=1 and v.liqpro=@1
order by 1,2,3,4
</SQLDETALLE>
<SQLRESUMEN>

select v.liqpro,0,
v.articulo as PRODUCTO,
v.descri as DESCRIPCION,
v.iva as ALICUOTA,
cast(sum(cast(v.cantid as numeric(15,4))) as numeric(15,4)) as CANTIDAD,
cast(iif(sum(v.cantid)=0,0,sum(v.totnet)/sum(v.cantid)) as numeric(15,4)) as PRECIO,
cast(sum(v.totnet) as numeric(10,2)) as IMPORTE,
cast(sum(coalesce(v.l_moniva,v.s_moniva)) as numeric(10,2)) as IMPUESTO,
cast(sum(coalesce(v.l_totiva,v.s_totiva)) as numeric(10,2)) as SUBTOTAL
from v_liquido_producto v
where v.nrocai is not null and v.fecdes is not null and v.tippro=1 and v.liqpro=@1
group by 1,2,3,4,5
having sum(v.cantid)<>0
order by 1

</SQLRESUMEN>
<SQLTOTALES> select v.liqpro,0,cast(v.l_factor * 100 as numeric(10,2)) as PC_COMISION,
cast(sum(v.totnet) as numeric(10,2)) as IMPORTE_IMPONIBLE,
cast(abs(sum(v.l_comisi)) as numeric(10,2)) as IMP_COMISION
from v_liquido_producto v
where v.nrocai is not null and v.fecdes is not null and v.cantid<>0 and v.tippro=1 and v.liqpro=@1
group by 1,2,3

</SQLTOTALES>
<XMLRoot>LIQUIDACION</XMLRoot>
<FtpHost>200.71.237.211</FtpHost>
<FtpPort>2200</FtpPort>
<FtpUser>mape</FtpUser>
<FtpPass>U0ZSdFRdPnA+I3k=</FtpPass>
<FtpPath>/CT1320/LIQUIDACIONES/</FtpPath>
<FtpURL>/CT1320/LIQUIDACIONES/</FtpURL>
<FtpSeguro>SI</FtpSeguro>
<MailTo>adminfcex@e-friar.com.ar</MailTo>
<MailPrefijo>[Avisos:Catamarca MAPE SRL] </MailPrefijo>
<Debug>1</Debug>
</EXPORT-LIQUIDACIONES_NO_CON>

select v.liqpro,0,cast(v.l_factor * 100 as numeric(10,2)) as PC_COMISION,
cast(sum(v.totnet) as numeric(10,2)) as IMPORTE_IMPONIBLE,
cast(sum(v.l_comisi) as numeric(10,2)) as IMP_COMISION
from v_liquido_producto v
where v.tippro=1 and v.liqpro=@1
group by 1,2,3

</SQLTOTALES>
<SQLCAE>

select v.codafi as CODIGO_AFIP,v.can_entera as CANTIDAD,round(v.neto_entero,2) as PRECIO,round(v.can_entera * v.neto_entero,2) as IMPORTE
from v_cortes_liquidados v where v.liqpro=@1

</SQLCAE>
<XMLRoot>LIQUIDACION</XMLRoot>
<FtpURL>/CT1320/LIQUIDACIONES/</FtpURL>
<FtpHost>200.71.237.211</FtpHost>
<FtpPort>2200</FtpPort>
<FtpUser>mape</FtpUser>
<FtpPass>U0ZSdFRdPnA+I3k=</FtpPass>
<FtpPath>/CT1320/LIQUIDACIONES/</FtpPath>
<FtpSeguro>SI</FtpSeguro>
<MailTo>adminfcex@e-friar.com.ar</MailTo>
<MailPrefijo>[Avisos:Catamarca MAPE SRL] </MailPrefijo>
</EXPORT-LIQUIDACIONES_NO_CON_CAE>

Liquidaciones Consignadas con CAE:

<EXPORT-LIQUIDACIONES_CONSIG_CAE>
<Server>192.168.1.111</Server>
<Base>MAPE</Base>
<ArchivoXML>LSP_019381_NROCOM.XML</ArchivoXML>
<SQL>LIQUIDACIONES</SQL>
<SQLCABECERA>

select distinct v.liqpro,0,
'019381' as NROCLI,
'MAPE CARNICERIA' as NOMBRE,
substr(v.nroliq,7,19) as NROCPTE,
(case substr(v.nroliq,1,2) when 'NL' then 'FC' else substr(v.nroliq,1,2) end) as TCPTE,
v.obsliq as OBSERVACIONES,
v.LP_NROCAE as CAE,
v.LP_FECCAE as VENCCAE,
v.fecdes as FEC_DESDE,
v.fechas as FEC_HASTA,
cast(v.LP_SUBTOTAL - v.lp_imp_comision as numeric(10,2)) as T_NETO_GRAVADO,
'IVA' as I_TIPO_IMPUESTO,
cast(v.LP_SUBTOTAL - v.lp_imp_comision as numeric(10,2)) as I_IMPORTE_IMPONIBLE,
cast(v.lp_alicuota as numeric(10,2)) as I_ALICUOTA,
cast(v.LP_IVA as numeric(10,2)) as I_IMPORTE_IMPUESTO,
cast(v.LP_TOTAL as numeric(10,2)) as T_TOTAL
from v_liquido_consignados_monto v
where v.LP_NROCAE is not null and v.fecdes is not null and v.fechas > (current_date-25)
order by 1

</SQLCABECERA>
<SQLDETALLE>

select v.liqpro,0,
(case v.signo
when '+' then 'FC'
when '-' then 'NC'
end) as TCPTE,
v.nrocom as NRO_CPTE,
v.codart as PRODUCTO,
cast(v.cantid as numeric(15,4)) as CANTIDAD,
v.medida as MEDIDA,
cast(v.preuni as numeric(15,4)) as PRECIO,
cast(v.totnet as numeric(10,2)) as IMP_NETO,
v.iva as ALICUOTA,
cast(v.l_factor * 100 as numeric(10,2)) as PC_COMISION,
cast(v.l_comi as numeric(10,2)) as IMP_COMISION,
v.autori as ID_AUTORIZACION,
0 as IIBB,'CT1320' as CTKEY,
v.fecha as FECHA,v.descue as BONIF_PC, v.totdes as BONIF_IM,'L'||v.numlis as LISTA,
v.nrorem as NRO_RTO, v.idlinea as ID_LINEA
from v_liquido_consignados_monto v
where v.liqpro=@1 and cast(v.cantid as numeric(10,2))<>0 and cast(v.totnet as numeric(10,2))<>0

</SQLDETALLE>
<SQLRESUMEN>

select v.liqpro,0,
v.codart as PRODUCTO,
a.descri as DESCRIPCION,
v.iva as ALICUOTA,
cast(sum(v.cantid) as numeric(15,4)) as CANTIDAD,
cast(iif(sum(v.cantid)=0,0,sum(v.totnet)/sum(v.cantid)) as numeric(15,4)) as PRECIO,
cast(sum(v.totnet) as numeric(10,2)) as IMPORTE,
cast(sum(coalesce(v.l_moniva,0)) as numeric(10,2)) as IMPUESTO,
cast(sum(coalesce(v.l_totiva,0)) as numeric(10,2)) as SUBTOTAL
from v_liquido_consignados_monto v
inner join articulos a on a.codigo=v.codart
where v.liqpro=@1
group by 1,2,3,4,5
having sum(v.cantid)<>0
order by 1

</SQLRESUMEN>
<SQLTOTALES>

select v.liqpro,0,cast(v.l_factor * 100 as numeric(10,2)) as PC_COMISION,
cast(sum(v.totnet) as numeric(10,2)) as IMPORTE_IMPONIBLE,
cast(sum(v.l_comi) as numeric(10,2)) as IMP_COMISION
from v_liquido_consignados_monto v
where v.liqpro=@1
group by 1,2,3

</SQLTOTALES>
<SQLCAE>

select v.codafi as CODIGO_AFIP,v.can_entera as CANTIDAD,round(v.neto_entero,2) as PRECIO,round(v.can_entera * v.neto_entero,2) as IMPORTE
from v_cortes_liquidados v where v.liqpro=@1

</SQLCAE>
<SQLREMITOS>

select distinct v.nrorem as REMITO
from v_liquido_consignados_monto v
where v.liqpro=@1

</SQLREMITOS>
<XMLRoot>LIQUIDACION</XMLRoot>
<FtpURL>/CT1320/LIQUIDACIONES/</FtpURL>
<FtpHost>200.71.237.211</FtpHost>
<FtpPort>2200</FtpPort>
<FtpUser>mape</FtpUser>
<FtpPass>U0ZSdFRdPnA+I3k=</FtpPass>
<FtpPath>/CT1320/LIQUIDACIONES/</FtpPath>
<FtpSeguro>SI</FtpSeguro>
<MailTo>adminfcex@e-friar.com.ar</MailTo>
<MailPrefijo>[Avisos:Catamarca MAPE SRL] </MailPrefijo>
</EXPORT-LIQUIDACIONES_CONSIG_CAE>

Liquidaciones Consignadas

<EXPORT-LIQUIDACIONES_CONSIG>
<Server>192.168.1.111</Server>
<Base>MAPE</Base>
<ArchivoXML>LIQ_019381_NROCOM.XML</ArchivoXML>
<SQL>LIQUIDACIONES</SQL>
<SQLCABECERA>

select distinct v.liqpro,0,
'019381' as NROCLI,
'MAPE CARNICERIA' as NOMBRE,
substr(v.nroliq,7,19) as NROCPTE,
(case substr(v.nroliq,1,2) when 'NL' then 'FC' else substr(v.nroliq,1,2) end) as TCPTE,
v.obsliq as OBSERVACIONES,
v.nrocai as CAI,
v.feccai as VENCCAI,
v.fecdes as FEC_DESDE,
v.fechas as FEC_HASTA,
cast(v.LP_SUBTOTAL - v.lp_imp_comision as numeric(10,2)) as T_NETO_GRAVADO,
'IVA' as I_TIPO_IMPUESTO,
cast(v.LP_SUBTOTAL - v.lp_imp_comision as numeric(10,2)) as I_IMPORTE_IMPONIBLE,
cast(v.lp_alicuota as numeric(10,2)) as I_ALICUOTA,
cast(v.LP_IVA as numeric(10,2)) as I_IMPORTE_IMPUESTO,
cast(v.LP_TOTAL as numeric(10,2)) as T_TOTAL
from v_liquido_consignados_monto v
where v.NROCAI is not null and v.LP_NROCAE is null and v.fecdes is not null and v.fechas > (current_date-25)
order by 1

</SQLCABECERA>
<SQLDETALLE>

select v.liqpro,0,
(case v.signo
when '+' then 'FC'
when '-' then 'NC'
end) as TCPTE,
v.nrocom as NRO_CPTE,
v.articulo as PRODUCTO,
cast(v.cantid as numeric(15,4)) as CANTIDAD,
v.medida as MEDIDA,
cast(v.preuni as numeric(15,4)) as PRECIO,
cast(v.totnet as numeric(10,2)) as IMP_NETO,
v.iva as ALICUOTA,
cast(v.l_factor * 100 as numeric(10,2)) as PC_COMISION,
cast(v.l_comi as numeric(10,2)) as IMP_COMISION,
v.autori as ID_AUTORIZACION,
0 as IIBB,'CT1320' as CTKEY,
v.fecha as FECHA,v.descue as BONIF_PC, v.totdes as BONIF_IM,'L'||v.numlis as LISTA,
v.nrorem as NRO_RTO, v.idlinea as ID_LINEA
from v_liquido_consignados_monto v
where v.liqpro=@1 and cast(v.cantid as numeric(10,2))<>0 and cast(v.totnet as numeric(10,2))<>0

</SQLDETALLE>
<SQLRESUMEN>

select v.liqpro,0,
v.articulo as PRODUCTO,
v.descri as DESCRIPCION,
v.iva as ALICUOTA,
cast(sum(v.cantid) as numeric(15,4)) as CANTIDAD,
cast(iif(sum(v.cantid)=0,0,sum(v.totnet)/sum(v.cantid)) as numeric(15,4)) as PRECIO,
cast(sum(v.totnet) as numeric(10,2)) as IMPORTE,
cast(sum(coalesce(v.l_moniva,0)) as numeric(10,2)) as IMPUESTO,
cast(sum(coalesce(v.l_totiva,0)) as numeric(10,2)) as SUBTOTAL
from v_liquido_consignados_monto v
where v.liqpro=@1
group by 1,2,3,4,5
having sum(v.cantid)<>0
order by 1

</SQLRESUMEN>
<SQLTOTALES>

</SQLTOTALES>
<SQLREMITOS> select distinct v.nrorem as REMITO
from v_liquido_consignados_monto v
where v.liqpro=@1
</SQLREMITOS>
<XMLRoot>LIQUIDACION</XMLRoot>
<FtpURL>/CT1320/LIQUIDACIONES/</FtpURL>
<FtpHost>200.71.237.211</FtpHost>
<FtpPort>2200</FtpPort>
<FtpUser>mape</FtpUser>
<FtpPass>U0ZSdFRdPnA+I3k=</FtpPass>
<FtpPath>/CT1320/LIQUIDACIONES/</FtpPath>
<FtpSeguro>SI</FtpSeguro>
<MailTo>adminfcex@e-friar.com.ar</MailTo>
<MailPrefijo>[Avisos:Catamarca MAPE SRL] </MailPrefijo>
</EXPORT-LIQUIDACIONES_CONSIG>

Importación de Notificación de Pedidos:

<IMPORT-NOTIPED>
<Server>192.168.1.111</Server>
<Base>C:\Sabio\DataBase\MAPE_SRL.FDB</Base>
<TIPO>NOTIPED</TIPO>
<Compro>PEF</Compro>
<Boca>01</Boca>
<FtpHost>200.71.237.211</FtpHost>
<FtpPort>2200</FtpPort>
<FtpPath>/CT1320/PEDIDOS/</FtpPath>
<FtpUser>mape</FtpUser>
<FtpPass>U0ZSdFRdPnA+I3k=</FtpPass>
<FtpSeguro>SI</FtpSeguro>
<MailPrefijo>[Avisos: Notificaciones de Pedidos a FRIAR] </MailPrefijo>
<Estado>5</Estado>
</IMPORT-NOTIPED>

Importación de Productos:

<IMPORT-PRODUCTOS>
<Server>192.168.1.111</Server>
<Base>C:\Sabio\DataBase\MAPE_SRL.FDB</Base>
<TIPO>PRODUCTOS</TIPO>
<XMLRoot>PRODUCTO</XMLRoot>
<FtpHost>200.71.237.211</FtpHost>
<FtpPort>2200</FtpPort>
<FtpPath>/home/</FtpPath>
<FtpUser>productos</FtpUser>
<FtpPass>NDI0U2NHY2g9</FtpPass>
<FtpURL>productos/productos.xml</FtpURL>
<FtpSeguro>SI</FtpSeguro>
<FtpResURL>productos/PRODUCTOS_CT1320.RES</FtpResURL>
<MailFrom>avisos@sabiogo.com</MailFrom>
<MailTo>friarcatamarca@e-friar.com.ar</MailTo>
<MailCCO>avisos@sabiogo.com</MailCCO>
<MailPrefijo>[EG.Avisos:Catamarca MAPE SRL] </MailPrefijo>
<SMTPUser>avisos@sabiogo.com</SMTPUser>
<SMTPPass>TTJsKFhbVltt</SMTPPass>
<Consignados>1</Consignados>
</IMPORT-PRODUCTOS>

Importación de Remitos:

<IMPORT-REMITOS_DIS>
<Server>192.168.1.111</Server>
<Base>C:\Sabio\DataBase\MAPE_SRL.FDB</Base>
<User>SYSDBA</User>
<Port>3050</Port>
<XMLRoot>REMITOS</XMLRoot>
<TIPO>REMITOS</TIPO>
<Compro>RWD</Compro>
<CtaCte>1</CtaCte>
<FtpHost>200.71.237.211</FtpHost>
<FtpPort>2200</FtpPort>
<FtpPath>/CT1320/REMITOS/</FtpPath>
<FtpURL>/CT1320/REMITOS/</FtpURL>
<FtpUser>mape</FtpUser>
<FtpPass>U0ZSdFRdPnA+I3k=</FtpPass>
<FtpSeguro>SI</FtpSeguro>
<MailPrefijo>[EG.Avisos:Catamarca MAPE SRL] </MailPrefijo>
<MailTo>friarcatamarca@e-friar.com.ar</MailTo>
<MailCCO>avisos@sabiogo.com</MailCCO>
<MailFrom>avisos@sabiogo.com</MailFrom>
<SMTPUser>avisos@sabiogo.com</SMTPUser>
<SMTPPass>TTJsKFhbVltt</SMTPPass>
</IMPORT-REMITOS_DIS>

Importación Remitos CSV de cada carpeta correspondiente a las sucursales:

<IMPORT-RTO-CSV_1320>
<Server>192.168.1.111</Server>
<Base>C:\Sabio\DataBase\MAPE_SRL.FDB</Base>
<User>SYSDBA</User>
<Port>3050</Port>
<TIPO>RTO-CSV</TIPO>
<Compro>RVF</Compro>
<CtaCte>1</CtaCte>
<FtpHost>200.71.237.211</FtpHost>
<FtpPort>2200</FtpPort>
<FtpPath>/CT1320/LIQCXL/</FtpPath>
<FtpURL>/CT1320/LIQCXL/</FtpURL>
<FtpUser>mape</FtpUser>
<FtpPass>U0ZSdFRdPnA+I3k=</FtpPass>
<FtpSeguro>SI</FtpSeguro>
<MailPrefijo>[EG.Avisos:Catamarca MAPE SRL] </MailPrefijo>
<MailTo>friarcatamarca@e-friar.com.ar</MailTo>
<MailCCO>avisos@sabiogo.com</MailCCO>
</IMPORT-RTO-CSV_1320>

Importación de precios:

<IMPORT-PRECIOS_DIS>
<Server>192.168.1.111</Server>
<Base>C:\Sabio\DataBase\MAPE_SRL.FDB</Base>
<TIPO>PRECIOS</TIPO>
<XMLRoot>LISTAS</XMLRoot>
<TOPSECRET>12345678</TOPSECRET>
<RESERVO>0</RESERVO>
<MailGUIDCCO>avisos@sabiogo.com</MailGUIDCCO>
<FtpHost>200.71.237.211</FtpHost>
<FtpPort>2200</FtpPort>
<FtpPath>/CT1320/PRECIOS/</FtpPath>
<FtpUser>mape</FtpUser>
<FtpPass>U0ZSdFRdPnA+I3k=</FtpPass>
<FtpURL>/CT1320/PRECIOS/</FtpURL>
<FtpSeguro>SI</FtpSeguro>
<MailFrom>avisos@sabiogo.com</MailFrom>
<MailTo>friarcatamarca@e-friar.com.ar</MailTo>
<MailCCO>avisos@sabiogo.com</MailCCO>
<MailPrefijo>[EG.Avisos:Catamarca MAPE SRL] </MailPrefijo>
<SMTPUser>avisos@sabiogo.com</SMTPUser>
<Debug>1</Debug>
</IMPORT-PRECIOS_DIS>

Importación de la respuesta de ventas Friar:

<IMPORT-RESP-VENTAS-FRIAR>
<Server>192.168.1.111</Server>
<Base>Catamarca MAPE SRL</Base>
<User>SYSDBA</User>
<Port>3050</Port>
<ArchivoResp>RESP_CUIT_COM_NROCOM.TXT</ArchivoResp>
<TIPO>NEWVENTAS</TIPO>
<FtpURL>ftp://200.71.237.210:2121/CPTES/DOWNLOAD/</FtpURL>
<FtpUser>admin</FtpUser>
<MailPrefijo>[EG.Avisos:Catamarca MAPE SRL] </MailPrefijo>
<Mailto>soporte@sabiogo.com</Mailto>
<MailCCO>avisos@sabiogo.com</MailCCO>
</IMPORT-RESP-VENTAS-FRIAR>

Exportacion del BackUp de la base de Datos: (Esto se realiza en todos los servidores)

<BACKUP>
<BACKUP-FRIAR_CAT_MAPE_SRL>
<Server>192.168.1.111</Server>
<Base>C:\Sabio\DataBase\MAPE_SRL.FDB</Base>
<GBAK>C:\Program Files\Firebird\Firebird_3_0\gbak.exe</GBAK>
<MailFrom>avisos@sabiogo.com</MailFrom>
<MailTo>soporte@sabiogo.com</MailTo>
<MailCCO>mduarte@sabiogo.com</MailCCO>
<MailPrefijo>[EG.Avisos:Backup Catamarca MAPE SRL] </MailPrefijo>
<SMTPUser>avisos@sabiogo.com</SMTPUser>
</BACKUP-FRIAR_CAT_MAPE_SRL>
<CONFIG_BACKUP>
<Intervalo>3600</Intervalo>
</CONFIG_BACKUP>

</BACKUP>

Configurar Facturas M

No podemos acceder al servidor por escritorio remoto

Se tilda el sistema a cada rato

Transferencia de Archivos FTP y SFTP (Friar)

Control de replicaciones

Transferencia de Archivos FTP y SFTP (Friar)