
Hola Federico, muchas gracias por responder.
te adjunto el error que sale al exportar el citi… si te parece arrancamos por este y vemos si tiene el mismo origen.
muchas gracias!!
——————————-
===========> SvrProcess.saveError: Exportacion Citi Compras – Prepare – ERROR: no existe la función lpad(integer, integer, integer)
Hint: Ninguna función coincide en el nombre y tipos de argumentos. Puede ser necesario agregar conversión explícita de tipos.
Position: 27 [1537]
Servidor = localhost : 1099 (31-07-2019)
Tunnel=false, Objects=false, Process=false
Base de datos = federico1-PC : 5432 / libertya
Esquema = libertya
Usuario = Supervisor
Perfil = Administración
Compañía = DNG Soluciones SRL
Organización = DNG SOLUCIONES
Fecha = 2019-09-27 00:00:00
Impresora = Microsoft Print to PDF
Implementation-Title = CCTools Libertya
Implementation-Version = Libertya 20190726-0835
Specification-Vendor = (C) 2005-2006 FUNDESLE.
Specification-Title = Herramientas de Cliente oxp
Specification-Version = Libertya
Implementation-URL = http://www.openxpertya.org
Implementation-Vendor = SERVICIOS_DIGITALES
OXPHome = XP
Language=[Español (Argentina),Locale=es_AR,AD_Language=es_AR,DatePattern=DD.MM.YYYY,DecimalPoint=false]
MClient[1010016-DNG]
Documentos Multi-idioma = false
BaseLanguage = false/false
PDF License=true
Java HotSpot(TM) Client VM 25.131-b11
Windows 10 10.0
=== Environment === 1945982272
Libertya (r) Versión 19.07_31-07-2019 – Software Libre de Gestión- (c) 2019 DISYTEL; Implementación: Versión 19.07 20190926-1709 – ${env.CONSULTORA_OXP}
federico1-PC/192.168.1.127
CConnection[name=localhost{federico1-PC-libertya-libertya},AppsHost=localhost,AppsPort=1099,RMIoverHTTP=false,type=PostgreSQL,DBhost=federico1-PC,DBport=5432,DBname=libertya,BQ=false,FW=false,FWhost=,FWport=0,UID=libertya,PWD=cordoba2015]
Database=PostgreSQL – 9.5.7 – Driver =PostgreSQL JDBC Driver – 42.0.0.jre6 – via DataSource
DB_PostgreSQL[jdbc:postgresql://federico1-PC:5432/libertya?encoding=UTF-8]
AppsServerOK=true, DatabaseOK=true
=== Context ===
#AD_Client_ID == 1010016
#AD_Client_Name == DNG Soluciones SRL
#AD_Language == es_AR
#AD_Org_ID == 1010053
#AD_Org_Name == DNG SOLUCIONES
#AD_PrintColor_ID == 100
#AD_PrintFont_ID == 130
#AD_PrintPaper_ID == 103
#AD_PrintTableFormat_ID == 1000006
#AD_Role_ID == 1010076
#AD_Role_Name == Administración
#AD_Session_ID == 1031026
#AD_User_ID == 100
#AD_User_Name == Supervisor
#C_BP_Group_ID == 1010045
#C_BankAccount_ID == 1010204
#C_CashBook_ID == 1010024
#C_ConversionType_ID == 114
#C_Country_ID == 119
#C_Letra_Comprobante_ID == 1010161
#C_PaymentTerm_ID == 1010083
#C_Region_ID == 1000027
#C_TaxCategory_ID == 1010048
#C_Tax_ID == 1010085
#C_UOM_ID == 1000000
#CheckCuitControl == Y
#Date == 2019-09-27 00:00:00
#GL_Category_ID == 1010098
#IsPOSJournalActive == N
#M_Locator_ID == 1010278
#M_PriceList_ID == 1010597
#M_Warehouse_ID == 1010048
#POSJournalApplication == B
#POSJournalSupervisor == Y
#PasswordExpirationActive == N
#PrintPreview == Y
#Printer == Microsoft Print to PDF
#SalesRep_ID == 100
#ShowAcct == Y
#ShowAdvanced == Y
#ShowTrl == Y
#StdPrecision == 2
#SysAdmin == Y
#UniqueKeyActive == N
#User_Level == CO
#User_Org == 0
#VoidingInvoicePOSJournalConfig == U
#VoidingInvoicePaymentsPOSJournalConfig == P
#YYYY == Y
$AmortizationAppPeriod == A
$C_AcctSchema_ID == 1010016
$C_Currency_ID == 118
$Element_AC == Y
$Element_BP == Y
$Element_OO == Y
$Element_PR == Y
$FactAcctBalanceActive == Y
$HasAlias == Y
$M_Amortization_Method_ID == 1000001
0|C_Currency_ID == 118
0|WindowName == Menú
1110|Find_Table_ID == 735
1113|1113|AD_User_ID == 0
1113|1113|C_BPartner_ID == 1012391
1113|1113|C_BPartner_Location_ID == 1012402
11|AD_Org_ID == 1010053
11|C_BPartner_ID == 1012388
11|Condition == A
11|IncludeOpenOrders == N
11|IsSOTrx == N
11|ShowDetailedReceiptsPayments == Y
12|AD_Org_ID == 1010053
12|Condition == A
12|IncludeOpenOrders == N
12|IsSOTrx == N
12|ShowDetailedReceiptsPayments == N
14|AD_Org_ID == 1010053
14|C_BPartner_ID == 1012421
14|Condition == A
14|IncludeOpenOrders == N
14|IsSOTrx == Y
14|ShowDetailedReceiptsPayments == N
14|WindowName == Asignación de Cobros y Pagos
15|C_BPartner_ID == 1012388
15|IsSOTrx == Y
16|Amount == 0
16|IsSOTrx == N
17|ChangePayments == Y
17|FiscalAlreadyPrinted == Y
17|IsSOTrx == Y
20|AD_Org_ID == 1010053
20|C_BPartner_ID == 1012391
20|Condition == A
20|DaysDue == 30
20|IsSOTrx == N
20|ShowDocuments == O
20|accountType == C
23|AD_Org_ID == 1010053
23|C_BPartner_ID == 1012318
23|DateFrom == 2019-08-01 00:00:00.0
23|DateTo == 2019-08-31 00:00:00.0
23|DaysDue == 30
23|Directorio == libertya
23|IsSOTrx == N
24|DateFrom == 2019-08-01 00:00:00.0
24|DateTo == 2019-08-31 00:00:00.0
24|Directorio == ll
24|IsSOTrx == N
26|C_BankAccount_ID == 1010204
26|IsSOTrx == Y
27|AD_Org_ID == 1010053
27|C_BPartner_ID == 1012421
27|DaysDue == 30
27|IsSOTrx == Y
2|AD_Org_ID == 1010053
2|C_BP_Group_ID == 1010045
2|C_BPartner_ID == 1012421
2|Condition == A
2|CutDate == 2019-09-27 00:00:00
2|IncludeOpenOrders == Y
2|IsSOTrx == Y
2|OnlyDebts == Y
2|ShowDetailedReceiptsPayments == Y
3|AD_Org_ID == 1010053
3|C_BP_Group_ID == 1010045
3|Condition == P
3|CutDate == 2019-09-27 00:00:00
3|IsSOTrx == Y
3|OnlyDebts == Y
3|WindowName == Selección de Pagos (manual)
4|AD_Org_ID == 1010053
4|C_AcctSchema_ID == 1010016
4|C_BP_Group_ID == 1010217
4|C_BPartner_ID == 1012421
4|C_Currency_ID == 118
4|C_Period_ID == 1010463
4|Condition == A
4|CutDate == 2019-09-27 00:00:00
4|IsSOTrx == Y
4|OnlyDebts == Y
4|PaymentRule == P
4|PostingType == A
4|WindowName == Recibos de Clientes
6|AD_Org_ID == 1010053
6|C_BPartner_ID == 1012391
6|Condition == A
6|IsSOTrx == N
6|ShowDocuments == O
6|accountType == C
7|IsSOTrx == Y
AutoCommit == Y
C_Currency_118 == ARS
P1010096|ProductChangePriceVariation == 30
P1010098|InventoryKind == IO
P103|Type == S
P143|AD_Org_ID == 1010053
P143|C_Tax_ID == 1010085
P143|M_Warehouse_ID == 1010048
P165|Classname == org.openXpertya.JasperReport.LaunchInOut
P189|DataType == S
P194|C_Charge_ID == -1
P260|M_AttributeSet_ID == -1
P|AD_FTDoc == 1002145
P|AllowExchangeDifference == 0.01
P|AuditReferenceCurrencyISOCode == USD
P|AutoCommit == Y
P|AutoNew == Y
P|C_DocType_ID == 1010521
P|C_Dockey == 018a9567ea15470312c40d3e5d6bbcd4
P|C_Region_ID_FACTURA_ARCIBA == 1000082
P|CentralPosBaseURL == https://liquidacion.centralpos.com/api/v1
P|CentralPosEmail == usuario@server.net
P|CentralPosPageSize == 100
P|CentralPosPassword == unPassword
P|Client == 1010016
P|ConversationSecurityPolicy == E
P|DIF_CAMBIO_ARTICULO == DIFCAMBIO
P|DIF_CAMBIO_PTO_VENTA == 1
P|DIF_CAMBIO_TARIFA_CREDITO == DIF_DE_CAMBIO_CREDITO
P|DIF_CAMBIO_TARIFA_DEBITO == DIF_DE_CAMBIO_DEBITO
P|DeclaracionValores_FilterProductValues == RECUPERO;RECHAZO
P|DocAction == CO
P|FindAddEndWildcard_Description == N
P|FindAddEndWildcard_Documentno == N
P|FindAddEndWildcard_Name == N
P|FindAddEndWildcard_Value == N
P|FiscalDescription_VoidedDocument == ANULADO
P|InfoMaxRowsAllowed == 1000
P|InfoRowCountMethod == C
P|LOCAL_AR == Y
P|L_AR_CFMontoMaximo == 1000
P|L_AR_LibroIVA_CFMontoMaximoAgrupacion == 1000
P|L_AR_MaxOrderLineQty == 999
P|Language == Español (Argentina)
P|LogTransactionEvents == N
P|LookupMaxRowsAllowed == 1000
P|Maintenance_Inventory == 6
P|MantenimientoPadron == 3
P|MenuCollapsed == N
P|MultiOrgTransactionFilterRulesPropertiesFileLocation == /ServidorOXP/utils/replicacion/filters/MultiOrgTransactionFilterRules.properties
P|NCFiscal_ComprobanteOriginal_ClaveTiposDocumentoPedido == SOSOTD;SOSOTH
P|OpenTrxLowerLimit == 6
P|OpenTrxTimeOutMS == 3600000
P|OpenTrxUpperLimit == 10
P|Organization == 1010053
P|POSCashJounal_ValidDiff == 0.5
P|PathPadronCSV == C:\\Padron\\
P|PorcentajeDeAumentoDePrecio == 100
P|ReasonVoid == Anulación
P|RejectedCheckDocTypeKey == RCD
P|ReplicationEventsActive == Y
P|Role == 1010076
P|SeparadorDeCampoEnCSVPadron == ;
P|SinPercepcionNCManual == ‘N’
P|SkipColumnsFilterRulesPropertiesFileLocation == /ServidorOXP/utils/replicacion/filters/SkipColumnsFilterRules.properties
P|TransferDueDateDays == 1
P|URL_IMAGE_OP == URL_IMAGE_OP
P|URL_IMAGE_RC == URL_IMAGE_RC
P|WAIT_FOR_WORKER_SECONDS == 0
P|Warehouse == 1010048
P|WindowTabCollapsible == Y
P|WindowTabPlacement == Left
java.naming.provider.url == jnp://localhost:1099
=== System ===
awt.toolkit=sun.awt.windows.WToolkit
file.encoding=UTF-8
file.encoding.pkg=sun.io
file.separator=\
jasper.reports.compile.keep.java.file=false
jasper.reports.compile.temp=C:\Users\FEDERI~1\AppData\Local\Temp\
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
java.awt.headless=true
java.awt.printerjob=sun.awt.windows.WPrinterJob
java.class.path=C:\Users\FEDERI~1\AppData\Local\Temp\temp50.jar;C:\ServidorOXP\.\lib\batik-awt-util.jar;C:\ServidorOXP\.\lib\batik-dom.jar;C:\ServidorOXP\.\lib\batik-svggen.jar;C:\ServidorOXP\.\lib\batik-util.jar;C:\ServidorOXP\.\lib\batik-xml.jar;C:\ServidorOXP\.\lib\CMPCS.jar;C:\ServidorOXP\.\lib\JasperReports.jar;C:\ServidorOXP\.\lib\jboss.jar;C:\ServidorOXP\.\lib\jsp-api-2.0.jar;C:\ServidorOXP\.\lib\oracle.jar;C:\ServidorOXP\.\lib\OXP.jar;C:\ServidorOXP\.\lib\OXPApps.jar;C:\ServidorOXP\.\lib\OXPInstall.jar;C:\ServidorOXP\.\lib\OXPRoot.jar;C:\ServidorOXP\.\lib\OXPSLib.jar;C:\ServidorOXP\.\lib\OXPXLib.jar;C:\ServidorOXP\.\lib\postgresql.jar;C:\ServidorOXP\.\lib\sqlj.jar;C:\ServidorOXP\.\lib\sqlServer.jar;C:\ServidorOXP\.\lib\sybase.jar;C:\ServidorOXP\.\lib\XOXPTools.jar;C:\ServidorOXP\.\lib\swing-layout-1.0.jar;C:\ServidorOXP\.\lib\PDFRenderer.jar;C:\ServidorOXP\.\lib\JasperReports.jar;
java.class.version=52.0
java.endorsed.dirs=C:\Java\jdk1.8.0_131\jre\lib\endorsed
java.ext.dirs=C:\Java\jdk1.8.0_131\jre\lib\ext;C:\WINDOWS\Sun\Java\lib\ext
java.home=C:\Java\jdk1.8.0_131\jre
java.io.tmpdir=C:\Users\FEDERI~1\AppData\Local\Temp\
java.library.path=C:\Java\jdk1.8.0_131\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Python27\;C:\Python27\Scripts;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files (x86)\PostgreSQL\9.5bin;C:\Program Files (x86)\Java\jre1.8.0_211\bin;C:\Program Files (x86)\Java\jre1.8.0_211\jre\bin;C:\Program Files (x86)\Java\jre1.8.0_211\jre\bin\client;C:\Program Files (x86)\PostgreSQL\9.5\bin;C:\\jre\bin;C:\\jre\bin\client;C:\\bin;C:\PostgreSQL\9.5\bin;C:\PostgreSQL\9.5bin;C:\Java\jdk1.8.0_131\bin;C:\Java\jdk1.8.0_131\jre\bin;C:\Java\jdk1.8.0_131\jre\bin\client;\bin;C:\Users\federico1\AppData\Local\Microsoft\WindowsApps;;.
java.runtime.name=Java(TM) SE Runtime Environment
java.runtime.version=1.8.0_131-b11
java.specification.name=Java Platform API Specification
java.specification.vendor=Oracle Corporation
java.specification.version=1.8
java.vendor=Oracle Corporation
java.vendor.url=http://java.oracle.com/
java.vendor.url.bug=http://bugreport.sun.com/bugreport/
java.version=1.8.0_131
java.vm.info=mixed mode
java.vm.name=Java HotSpot(TM) Client VM
java.vm.specification.name=Java Virtual Machine Specification
java.vm.specification.vendor=Oracle Corporation
java.vm.specification.version=1.8
java.vm.vendor=Oracle Corporation
java.vm.version=25.131-b11
line.separator=
org.compiere.report.path=C:\Users\FEDERI~1\AppData\Local\Temp
os.arch=x86
os.name=Windows 10
os.version=10.0
path.separator=;
sun.arch.data.model=32
sun.awt.enableExtraMouseButtons=true
sun.boot.class.path=C:\Java\jdk1.8.0_131\jre\lib\resources.jar;C:\Java\jdk1.8.0_131\jre\lib\rt.jar;C:\Java\jdk1.8.0_131\jre\lib\sunrsasign.jar;C:\Java\jdk1.8.0_131\jre\lib\jsse.jar;C:\Java\jdk1.8.0_131\jre\lib\jce.jar;C:\Java\jdk1.8.0_131\jre\lib\charsets.jar;C:\Java\jdk1.8.0_131\jre\lib\jfr.jar;C:\Java\jdk1.8.0_131\jre\classes
sun.boot.library.path=C:\Java\jdk1.8.0_131\jre\bin
sun.cpu.endian=little
sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86
sun.desktop=windows
sun.io.unicode.encoding=UnicodeLittle
sun.java.command=org.openXpertya.OpenXpertya
sun.java.launcher=SUN_STANDARD
sun.jnu.encoding=Cp1252
sun.management.compiler=HotSpot Client Compiler
sun.os.patch.level=
suppressSwingDropSupport=true
user.country=AR
user.dir=C:\ServidorOXP
user.home=C:\Users\federico1
user.language=es
user.name=federico1
user.script=
user.timezone=America/Buenos_Aires
user.variant=