[Jose Luis Aragon]

Estimados agradecere pues pase de 13.01 a 14.02 y todo estaba funcionando bien en 13.01 solo que no me imprime Recibos ni OP …. Me el siguiente error java.lang.NullPointerException tengo que solucionar este problema ala brevedad agradecere si alguien me postea la solucion..

Por otro lado adjunto el error de la consola

[

---

19:59:44.093 OpenXpertya.startup: Libertya (r) Versión 14.02_24-02-2014 – Software Libre de Gestión- (c) 2013 DISYTEL; Implementación: Versión 14.02 20150319-1437 – ${env.CONSULTORA_OXP}
19:59:44.093 OpenXpertya.startup: XP – Java HotSpot(TM) Client VM 20.4-b02 – Windows XP 5.1 Service Pack 3

---

> CConnection.setAppsServerInfo: jnp://localhost:1099
– javax.naming.CommunicationException: Receive timed out [Root exception is java.net.SocketTimeoutException: Receive timed out]
– {java.naming.provider.url=jnp://localhost:1099, java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, jnp.discoveryTimeout=5000, jnp.timeout=5000, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces, jnp.sotimeout=5000}

---

> CConnection.setAppsServerInfo: jnp://localhost:1099
– javax.naming.CommunicationException: Receive timed out [Root exception is java.net.SocketTimeoutException: Receive timed out]
– {java.naming.provider.url=jnp://localhost:1099, java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, jnp.discoveryTimeout=5000, jnp.timeout=5000, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces, jnp.sotimeout=5000} [11]

---

> CConnection.setAppsServerInfo: jnp://localhost:1099
– javax.naming.CommunicationException: Receive timed out [Root exception is java.net.SocketTimeoutException: Receive timed out]
– {java.naming.provider.url=jnp://localhost:1099, java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, jnp.discoveryTimeout=5000, jnp.timeout=5000, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces, jnp.sotimeout=5000} [11]
===========> MTree.loadNodes: loadNodes – Nodes w/o parent – adding to root – [Exporta archivos duplicados electrónicos, Generar tablas para duplicados electrónicos]

---

---

> Msg.getMsg: NOT found: OXPSYS [11]

---

> Msg.getMsg: NOT found: OXPSYS [11]

---

> SvrProcess.process: java.lang.NullPointerException [27]

---

> SvrProcess.process: java.lang.NullPointerException [28]
===========> MField.createDefault: MField.createDefault (daysdue) – For input string: “” [11]

---

===========> MField.createDefault: MField.createDefault (daysdue) – For input string: “” [11]

---

===========> MField.createDefault: MField.createDefault (SalesRep_ID) – For input string: “-” [11]

---

===========> MField.createDefault: MField.createDefault (daysdue) – For input string: “” [11]

---

===========> MField.createDefault: MField.createDefault (daysdue) – For input string: “” [11]

---

===========> MField.createDefault: MField.createDefault (SalesRep_ID) – For input string: “-” [11]

---

===========> MField.createDefault: MField.createDefault (daysdue) – For input string: “” [11]

---

===========> MField.createDefault: MField.createDefault (daysdue) – For input string: “” [11]

---

===========> MField.createDefault: MField.createDefault (SalesRep_ID) – For input string: “-” [11]

---

---

> Msg.getMsg: NOT found: FileXLS [11]

---

> Msg.getMsg: NOT found: FileXLS [11]

---

> Msg.getMsg: NOT found: OXPSYS [11]

---

> Msg.getMsg: NOT found: OXPSYS [11]

---

> SvrProcess.process: java.lang.NullPointerException [65]

---

> SvrProcess.process: java.lang.NullPointerException [66]

---

> Msg.getMsg: NOT found: OXPSYS [11]

---

> Msg.getMsg: NOT found: OXPSYS [11]

---

> SvrProcess.process: java.lang.NullPointerException [67]
===========> AccessSqlParser.getTableInfo: parse – could not remove ON C_BPartner, AD_User c, C_BPartner_Location l, C_Location a foo ON l.C_BPartner_Location_ID = foo.C_BPartner_Location_ID [71]

---

---

> Msg.getMsg: NOT found: FileXLS [11]

---

> Msg.getMsg: NOT found: FileXLS [11]
===========> AccessSqlParser.getTableInfo: parse – could not remove ON C_BPartner, AD_User c, C_BPartner_Location l, C_Location a foo ON l.C_BPartner_Location_ID = foo.C_BPartner_Location_ID [97]

---

===========> AccessSqlParser.getTableInfo: parse – could not remove ON C_BPartner, AD_User c, C_BPartner_Location l, C_Location a foo ON l.C_BPartner_Location_ID = foo.C_BPartner_Location_ID [103]

Servidor = localhost : 1099 (No Activo)
Tunnel=false, Objects=false, Process=false
Base de datos = Jose-5abbea2352 : 5432 / cmp
Esquema = libertya
Usuario = AdminLibertya
Perfil = Administración
Compañía = CIA MINERA LOS PIUQUENES S.R.L.
Organización = MINERA
Fecha = 2015-03-19 00:00:00
Impresora = Microsoft XPS Document Writer
Implementation-Vendor = SERVICIOS_DIGITALES
Implementation-Title = CCTools Libertya
Implementation-Version = Libertya 20140225-1019
Specification-Vendor = (C) 2005-2006 FUNDESLE.
Specification-Title = Herramientas de Cliente oxp
Implementation-URL = http://www.openxpertya.org
Specification-Version = Libertya
OXPHome = XP
Language=[Español (Argentina),Locale=es_AR,AD_Language=es_AR,DatePattern=DD.MM.YYYY,DecimalPoint=false]
MClient[1010016-CIA MINERA LOS PIUQUENES S.R.L.]
Documentos Multi-idioma = false
BaseLanguage = false/false
PDF License=true
Java HotSpot(TM) Client VM 20.4-b02
Windows XP 5.1 Service Pack 3
=== Environment === 1376298848
Libertya (r) Versión 14.02_24-02-2014 – Software Libre de Gestión- (c) 2013 DISYTEL; Implementación: Versión 14.02 20150319-1437 – ${env.CONSULTORA_OXP}
Jose-5abbea2352/192.168.2.129
CConnection[name=localhost{Jose-5abbea2352-cmp-libertya},AppsHost=localhost,AppsPort=1099,RMIoverHTTP=false,type=PostgreSQL,DBhost=Jose-5abbea2352,DBport=5432,DBname=cmp,BQ=false,FW=false,FWhost=,FWport=0,UID=libertya,PWD=libertya]
Database=PostgreSQL – 8.3.8 – Driver =PostgreSQL Native Driver – PostgreSQL 9.0 JDBC4 (build 801) – via DataSource
DB_PostgreSQL[jdbc:postgresql://Jose-5abbea2352:5432/cmp?encoding=UTF-8]
AppsServerOK=false, DatabaseOK=true

=== Context ===
#AD_Client_ID == 1010016
#AD_Client_Name == CIA MINERA LOS PIUQUENES S.R.L.
#AD_Language == es_AR
#AD_Org_ID == 1010053
#AD_Org_Name == MINERA
#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 == 1030666
#AD_User_ID == 1010717
#AD_User_Name == AdminLibertya
#C_BP_Group_ID == 1010045
#C_ConversionType_ID == 114
#C_Country_ID == 119
#C_Letra_Comprobante_ID == 1010018
#C_PaymentTerm_ID == 1010083
#C_Region_ID == 1000027
#C_TaxCategory_ID == 1010047
#C_Tax_ID == 1010084
#C_UOM_ID == 1000000
#CheckCuitControl == N
#Date == 2015-03-19 00:00:00
#GL_Category_ID == 1010098
#IsPOSJournalActive == N
#M_Locator_ID == 1010278
#M_PriceList_ID == 1010595
#M_Product_Category_ID == 1010146
#M_Warehouse_ID == 1010048
#POSJournalSupervisor == Y
#PasswordExpirationActive == N
#PrintPreview == Y
#Printer == Microsoft XPS Document Writer
#SalesRep_ID == 1010717
#ShowAcct == Y
#ShowAdvanced == Y
#ShowTrl == N
#StdPrecision == 2
#UniqueKeyActive == N
#User_Level == CO
#User_Org == 0,1010053
#VoidingInvoicePOSJournalConfig == U
#VoidingInvoicePaymentsPOSJournalConfig == P
#YYYY == Y
$C_AcctSchema_ID == 1010016
$C_Currency_ID == 118
$Element_AC == Y
$Element_BP == Y
$Element_MC == Y
$Element_OO == Y
$Element_PJ == Y
$Element_PR == Y
$Element_SR == Y
$HasAlias == Y
0|WindowName == Menú
10|AD_Org_ID == 0
10|DateAcct == 2006-03-01 00:00:00.0
10|IsSOTrx == N
1110|Find_Table_ID == 735
1113|1113|AD_User_ID == 0
1113|1113|C_BPartner_ID == 1012568
1113|1113|C_BPartner_Location_ID == 1012580
13|AD_Org_ID == 1010053
13|AccountType == V
13|C_BP_Group_ID == 1010045
13|IsSOTrx == N
13|Scope == OO
13|SortCriteria == BP
13|TrueDateTrx == 2014-06-30 00:00:00.0
15|AD_Org_ID == 1010053
15|AccountType == V
15|C_BP_Group_ID == 1010045
15|IsSOTrx == N
15|Scope == AL
15|SortCriteria == BP
15|TrueDateTrx == 2014-06-30 00:00:00.0
17|AD_Org_ID == 1010053
17|AccountType == V
17|C_BP_Group_ID == 1010045
17|IsSOTrx == N
17|Scope == OO
17|SortCriteria == BP
17|TrueDateTrx == 2014-06-30 00:00:00.0
19|AD_Org_ID == 1010053
19|AccountType == V
19|DateTrx == 2005-03-01 00:00:00.0
19|IncludeOpenOrders == N
19|IsSOTrx == N
19|ShowDetailedReceiptsPayments == N
20|C_BPartner_ID == 1012568
20|C_BankAccount_ID == 1010048
20|C_DocType_ID == 1010512
20|IsAllocated == Y
20|IsSOTrx == Y
20|TenderType == K
22|AD_Org_ID == 1010053
22|AccountType == V
22|C_BP_Group_ID == 1010045
22|IsSOTrx == N
22|Scope == AL
22|SortCriteria == BP
22|TrueDateTrx == 2014-06-30 00:00:00.0
24|0|AD_Tab_ID == 1000188
24|0|AD_Table_ID == 735
24|0|AccessLevel == 1
24|0|IsActive == N
24|0|Name == Recibo de Cliente
24|0|Processed == Y
24|0|SQL == SELECT C_AllocationHdr_ID,Processed,Processing,IsApproved,C_POSJournal_ID,IsManual,ActionDetail,AD_Client_ID,AD_Org_ID,C_DocType_ID,DocumentNo,AllocationType,DateTrx,DateAcct,C_BPartner_ID,Description,C_Currency_ID,Retencion_Amt,GrandTotal,ApprovalAmt,DocStatus,DocAction,AllocationAction,IsActive,Posted,Created,CreatedBy,Updated,UpdatedBy FROM C_AllocationHdr WHERE AllocationType in (‘RC’,’RCA’) AND C_AllocationHdr.AD_Client_ID IN(0,1010016) AND C_AllocationHdr.AD_Org_ID IN(0,1010053) ORDER BY Created
24|1|AD_Tab_ID == 1000189
24|1|AD_Table_ID == 1000137
24|1|AccessLevel == 3
24|1|Name == Detalle
24|99|FindSQL == SELECT COUNT(*) FROM C_AllocationHdr WHERE AllocationType in (‘RC’,’RCA’) AND AD_Client_ID IN(0,1010016) AND AD_Org_ID IN(0,1010053)
24|AD_Client_ID == 1010016
24|AD_Org_ID == 1010053
24|AllocationAction == RX
24|AllocationType == RC
24|ApprovalAmt == 0.00
24|AutoCommit == Y
24|BaseTable_ID == 735
24|C_AllocationHdr_ID == 1011831
24|C_BPartner_ID == 1012165
24|C_Currency_ID == 118
24|Created == 2010-12-25 12:41:12.0
24|CreatedBy == 1010717
24|DateAcct == 2010-12-25 00:00:00
24|DateTrx == 2010-12-25 00:00:00
24|Description == Recibo de Cliente 2010-12-25 [Recibo de Cliente RC]
24|DocAction == —
24|DocStatus == RE
24|DocumentNo == 1000001^
24|Find_Table_ID == 735
24|GrandTotal == 24862.50
24|IsActive == N
24|IsApproved == Y
24|IsManual == N
24|IsSOTrx == Y
24|Posted == Y
24|Processed == Y
24|Processing == N
24|Retencion_Amt == 0.00
24|Updated == 2010-12-25 22:05:01.3
24|UpdatedBy == 1010717
24|WindowName == Recibos de Clientes Existentes
3|IsSOTrx == Y
4|AD_Org_ID == 1010053
4|DateDoc == 2003-03-01 00:00:00.0
4|IsSOTrx == N
4|ShowDocuments == D
4|accountType == C
6|AD_Org_ID == 1010053
6|DateDoc == 2005-03-01 00:00:00.0
6|IsSOTrx == N
6|ShowDocuments == D
6|accountType == C
8|AD_Org_ID == 1010053
8|DateDoc == 2007-03-01 00:00:00.0
8|IsSOTrx == N
8|ShowDocuments == D
8|accountType == V
AutoCommit == Y
P1010098|InventoryKind == IO
P103|Type == S
P189|DataType == S
P|AD_FTDoc == 1002145
P|AllowExchangeDifference == 0.01
P|AuditReferenceCurrencyISOCode == USD
P|C_Dockey == 018a9567ea15470312c40d3e5d6bbcd4
P|C_Region_ID_FACTURA_ARCIBA == 1000082
P|DIF_CAMBIO_ARTICULO == 10000001
P|DIF_CAMBIO_PTO_VENTA == 1
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|LookupMaxRowsAllowed == 1000
P|Maintenance_Inventory == 6
P|MantenimientoPadron == 3
P|NCFiscal_ComprobanteOriginal_ClaveTiposDocumentoPedido == SOSOTD;SOSOTH
P|OpenTrxLowerLimit == 6
P|OpenTrxTimeOutMS == 3600000
P|OpenTrxUpperLimit == 10
P|POSCashJounal_ValidDiff == 0.5
P|PathPadronCSV == C:Padron
P|ReasonVoid == Anulación
P|ReplicationEventsActive == Y
P|SeparadorDeCampoEnCSVPadron == ;
P|TransferDueDateDays == 1
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:DOCUME~1MICROS~1CONFIG~1Temp
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
java.awt.headless=true
java.awt.printerjob=sun.awt.windows.WPrinterJob
java.class.path=C:DOCUME~1MICROS~1CONFIG~1Temptemp1.jar;C:ServidorOXP.libbatik-awt-util.jar;C:ServidorOXP.libbatik-dom.jar;C:ServidorOXP.libbatik-svggen.jar;C:ServidorOXP.libbatik-util.jar;C:ServidorOXP.libbatik-xml.jar;C:ServidorOXP.libCMPCS.jar;C:ServidorOXP.libJasperReports.jar;C:ServidorOXP.libjboss.jar;C:ServidorOXP.libjsp-api-2.0.jar;C:ServidorOXP.liboracle.jar;C:ServidorOXP.libOXP.jar;C:ServidorOXP.libOXPApps.jar;C:ServidorOXP.libOXPInstall.jar;C:ServidorOXP.libOXPRoot.jar;C:ServidorOXP.libOXPSLib.jar;C:ServidorOXP.libOXPXLib.jar;C:ServidorOXP.libpostgresql.jar;C:ServidorOXP.libsqlj.jar;C:ServidorOXP.libsqlServer.jar;C:ServidorOXP.libsybase.jar;C:ServidorOXP.libXOXPTools.jar;C:ServidorOXP.libswing-layout-1.0.jar;C:ServidorOXP.libPDFRenderer.jar;C:ServidorOXP.libJasperReports.jar;
java.class.version=50.0
java.endorsed.dirs=C:Archivos de programaJavajdk1.6.0_29jrelibendorsed
java.ext.dirs=C:Archivos de programaJavajdk1.6.0_29jrelibext;C:WINDOWSSunJavalibext
java.home=C:Archivos de programaJavajdk1.6.0_29jre
java.io.tmpdir=C:DOCUME~1MICROS~1CONFIG~1Temp
java.library.path=C:Archivos de programaJavajdk1.6.0_29bin;C:WINDOWSSunJavabin;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;C:Archivos de programaQuickTimeQTSystem;C:Archivos de programaATI TechnologiesATI.ACECore-Static;C:Archivos de programaJavajdk1.6.0_25bin;C:Archivos de programaJavajdk1.6.0_25jrebin;C:Archivos de programaJavajdk1.6.0_25jrebinclient;C:Javajdk1.6.0_29bin;C:Javajdk1.6.0_29jrebin;C:Javajdk1.6.0_29jrebinclient;bin;C:Javajdk1.6.0_25bin;C:Javajdk1.6.0_25jrebin;C:Javajdk1.6.0_25jrebinclient;C:PostgreSQL8.3bin;C:Archivos de programaJavajdk1.6.0_29bin;C:Archivos de programaJavajdk1.6.0_29jrebin;C:Archivos de programaJavajdk1.6.0_29jrebinclient;C:Archivos de programaPostgreSQL8.3bin;C:Archivos de programaArchivos comunesAheadLib;.
java.runtime.name=Java(TM) SE Runtime Environment
java.runtime.version=1.6.0_29-b11
java.specification.name=Java Platform API Specification
java.specification.vendor=Sun Microsystems Inc.
java.specification.version=1.6
java.vendor=Sun Microsystems Inc.
java.vendor.url=http://java.sun.com/
java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi
java.version=1.6.0_29
java.vm.info=mixed mode, sharing
java.vm.name=Java HotSpot(TM) Client VM
java.vm.specification.name=Java Virtual Machine Specification
java.vm.specification.vendor=Sun Microsystems Inc.
java.vm.specification.version=1.0
java.vm.vendor=Sun Microsystems Inc.
java.vm.version=20.4-b02
line.separator=

os.arch=x86
os.name=Windows XP
os.version=5.1
path.separator=;
sun.arch.data.model=32
sun.boot.class.path=C:Archivos de programaJavajdk1.6.0_29jrelibresources.jar;C:Archivos de programaJavajdk1.6.0_29jrelibrt.jar;C:Archivos de programaJavajdk1.6.0_29jrelibsunrsasign.jar;C:Archivos de programaJavajdk1.6.0_29jrelibjsse.jar;C:Archivos de programaJavajdk1.6.0_29jrelibjce.jar;C:Archivos de programaJavajdk1.6.0_29jrelibcharsets.jar;C:Archivos de programaJavajdk1.6.0_29jrelibmodulesjdk.boot.jar;C:Archivos de programaJavajdk1.6.0_29jreclasses
sun.boot.library.path=C:Archivos de programaJavajdk1.6.0_29jrebin
sun.cpu.endian=little
sun.cpu.isalist=
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=Service Pack 3
suppressSwingDropSupport=true
user.country=ES
user.dir=C:ServidorOXP
user.home=C:Documents and SettingsMicrosoft
user.language=es
user.name=Microsoft
user.timezone=America/Cayenne
user.variant

[Jose Luis Aragon]

Estimado Gaston como estas=? espero que muy bien

Vi el hilo yo hace tpo que estoy llevando una empresa en Ly y no ha usado el esquema de retenciones ya Afip esta mas jodida asi que tengo que retener Ganancias por lo menos a los proveedores

Podrias indicarme por favor con pantallas como parametrizar una asi pruebo esto

Desde ya muchas gracias

[Jose Luis Aragon]

Claro Federico pero na minima idea de como trabaja el esquema de retenciones? Podrias darme?

Gracias

Un saludo

José Luis

[Jose Luis Aragon]

Estimados al momento del cierre, puesto que cuando se importa el extracto de banco genera un solo Documento y este no permite ser completado hasta que se concilien todas las lineas de ese documento, por lo cual, mi duda es la siguiente al cierre, por ejm yo voy a tener los gastos que si los voy a poder conciliar pero voy a tener muchas cobrabzas y cheques de pago a proveedores que no las voy a poder conciliar por que por ejm los Cheques a proveedores, todavia no ingresas al banco y por ello, no me va a dejar completar e impactar contablemente al cierre esos movimientos… Mi pregunta es como hacer como han hecho como lo han trabajado a esto quienes importaron el extracto de bancos???

Agradeceré los comentarios de quien pueda aportarme a resolver esta duda

[Jose Luis Aragon]

Estimado en el perfil Adminisracion arriba ala izq tenes el menu ” Ver” ahi clicas y elegis Visor de Cuentas

Un saludo

J.L.

[Jose Luis Aragon]

Federico gracias por la pronta respuesta, paso a comentarte que yo no uso ese tipo de tarifa, y cuando pago o cobros sin retenciones no hay problema el problema se genera, con las retenciones tanto de cliente como proveedor..

Bueno espero que sirva el feedback un saludo

José Luis

[Jose Luis Aragon]

Estimados yo estoy teniendo el mismo problema, miro la configuracion del TPV y esta correcta.

Por lo cual adjunto imagen.

Por favor espero su ayuda urgente pues yo estoy con una base de produccion
[attachment=405]ErrorLy.JPG[/attachment]

[Jose Luis Aragon]

Mayta por favor necesito saber como seria la configuracion de dos campos mas para extracto bancario uno es el Nro de Comprobante o Documento, y el otro es, la Fecha de aplicacion contable.

Por favor me podrias pasar la configuracion de esas dos pantallas

Muchas Gracias

[Jose Luis Aragon]

Claro Mayta te comento que tengo muchos problemas para convertir el formato de Fecha que me da el banco que es dd/mm/yyyy para pasarlo al de Ly que es dd-mm-yyyy.

Es posible que en el formato de importacion de extracto cambie las los “-” por “/”??

Bueno pues al pasar al csv me genera problemas para convertirlo…

Bueno espero tu ayuda con este tema ya que me sera de mucha utilidad

Un gran saludo

[Jose Luis Aragon]

Estimada Mayta puedo importar tanto un archivo de txt como uno de csv?

A los dos los toma?

[Jose Luis Aragon]

Muchas Gracias G Bochez, por el consejo, te comento que trabajo en 2PC, por lo cual, no impacte la base de produccion, pero necesito la 13.01 para importar facturas

Estimados dejo los errores que tengo en la carga del recibo

[attachment=402]ErrorRecibo13.01.JPG[/attachment]

---

11:53:35.421 OpenXpertya.startup: Libertya (r) Versión 13.01_21-01-2013 – Software Libre de Gestión- (c) 2011 DISYTEL; Implementación: Versión 13.01 20130302-1556 – ${env.CONSULTORA_OXP}
11:53:35.421 OpenXpertya.startup: XP – Java HotSpot(TM) Client VM 20.0-b11 – Windows XP 5.1 Service Pack 3

---

> AccessSqlParser.getTableInfo: getTableInfo – More than one FROM clause – SELECT c_currency_id FROM C_Conversion_Rate cr WHERE (isActive = ‘Y’) AND (ad_client_id = 1010016) AND ((ad_org_id = 1010053) OR (ad_org_id = 0)) AND ((c_currency_id = 118) OR (c_currency_id_to = 118)) AND (validfrom <= current_date) AND (validto >= current_date) UNION SELECT c_currency_id_to FROM C_Conversion_Rate cr WHERE (isActive = ‘Y’) AND (ad_client_id = 1010016) AND ((ad_org_id = 1010053) OR (ad_org_id = 0)) AND ((c_currency_id = 118) OR (c_currency_id_to = 118)) AND (validfrom <= current_date) AND (validto >= current_date) [11]
===========> MSequence.getDocumentNo: C_DocType_ID=0 [11]

---

===========> MSequence.getDocumentNo: C_DocType_ID=0 [11]

---

===========> MPayment.set_Value: CreditCardExpMM=0 – MinValue=1(1) – compared with Numeric Value=0(0) – results in 1 [11]

---

===========> MPayment.set_Value: CreditCardExpYY=0 – MinValue=3(3) – compared with Numeric Value=0(0) – results in 1 [11]

---

===========> MPayment.set_Value: CreditCardExpMM=0 – MinValue=1(1) – compared with Numeric Value=0(0) – results in 1 [11]

---

===========> MPayment.set_Value: CreditCardExpYY=0 – MinValue=3(3) – compared with Numeric Value=0(0) – results in 1 [11]

---

---

> MPayment.saveUpdate: DocumentNo updated: : #1223 -> : #1223 [11]
===========> MPayment.set_Value: CreditCardExpMM=0 – MinValue=1(1) – compared with Numeric Value=0(0) – results in 1 [11]

---

===========> MPayment.set_Value: CreditCardExpYY=0 – MinValue=3(3) – compared with Numeric Value=0(0) – results in 1 [11]

---

===========> MPayment.set_Value: CreditCardExpMM=0 – MinValue=1(1) – compared with Numeric Value=0(0) – results in 1 [11]

---

===========> MPayment.set_Value: CreditCardExpYY=0 – MinValue=3(3) – compared with Numeric Value=0(0) – results in 1 [11]

---

---

> MPayment.saveUpdate: DocumentNo updated: : #21552 -> : #21552 [11]

---

> MAllocationHdr.saveUpdate: DocumentNo updated: 1000158 -> 1000212 [11]
===========> MAllocationHdr.get_Value: Column not found – C_DocTypeTarget_ID [11]

---

===========> MAllocationHdr.get_Value: En Po.Get_value, retornado un nulo [11]

---

===========> MPayment.set_Value: CreditCardExpMM=0 – MinValue=1(1) – compared with Numeric Value=0(0) – results in 1 [11]

---

===========> MPayment.set_Value: CreditCardExpYY=0 – MinValue=3(3) – compared with Numeric Value=0(0) – results in 1 [11]

---

---

> MPayment.saveUpdate: DocumentNo updated: : #21552 -> : #21552 [11]
===========> MPayment.set_Value: CreditCardExpMM=0 – MinValue=1(1) – compared with Numeric Value=0(0) – results in 1 [11]

---

===========> MPayment.set_Value: CreditCardExpYY=0 – MinValue=3(3) – compared with Numeric Value=0(0) – results in 1 [11]

---

---

> MPayment.saveUpdate: DocumentNo updated: : #1223 -> : #1223 [11]

---

> MInvoice.saveUpdate: DocumentNo updated: A000100000275 -> A000100000275 [11]
===========> MAcctSchemaElement.getAcctSchemaElements: No default value for Cuenta [11]

---

===========> APanel.actionPerformed: ex [11]
java.lang.NullPointerException
at org.openXpertya.apps.APanel.cmd_print(APanel.java:1885)
at org.openXpertya.apps.APanel.actionPerformed(APanel.java:1498)
at org.openXpertya.apps.AppsAction.actionPerformed(AppsAction.java:292)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
at java.awt.Component.processMouseEvent(Component.java:6288)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6053)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4651)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4481)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2478)

Servidor = localhost : 1099 (21-01-2013)
Tunnel=false, Objects=false, Process=false
Base de datos = Jose-5abbea2352 : 5432 / libertya
Esquema = libertya
Usuario = AdminLibertya
Perfil = Administración
Compañía = CIA MINERA LOS PIUQUENES S.R.L.
Organización = MINERA
Fecha = 2013-03-03 00:00:00
Impresora = Microsoft XPS Document Writer
Implementation-Vendor = SERVICIOS_DIGITALES
Implementation-Title = CCTools Libertya
Implementation-Version = Libertya 20130124-0921
Specification-Vendor = (C) 2005-2006 FUNDESLE.
Specification-Title = Herramientas de Cliente oxp
Implementation-URL = http://www.openxpertya.org
Specification-Version = Libertya
OXPHome = XP
Language=[Español,Locale=es_ES,AD_Language=es_ES,DatePattern=DD/MM/YYYY,DecimalPoint=false]
MClient[1010016-CIA MINERA LOS PIUQUENES S.R.L.]
Documentos Multi-idioma = false
BaseLanguage = false/false
PDF License=true
Java HotSpot(TM) Client VM 20.0-b11
Windows XP 5.1 Service Pack 3
=== Environment === 403368704
Libertya (r) Versión 13.01_21-01-2013 – Software Libre de Gestión- (c) 2011 DISYTEL; Implementación: Versión 13.01 20130302-1556 – ${env.CONSULTORA_OXP}
Jose-5abbea2352/192.168.2.2
CConnection[name=localhost{Jose-5abbea2352-libertya-libertya},AppsHost=localhost,AppsPort=1099,RMIoverHTTP=false,type=PostgreSQL,DBhost=Jose-5abbea2352,DBport=5432,DBname=libertya,BQ=false,FW=false,FWhost=,FWport=0,UID=libertya,PWD=jose1979]
Database=PostgreSQL – 8.3.8 – Driver =PostgreSQL Native Driver – PostgreSQL 9.0 JDBC4 (build 801) – via DataSource
DB_PostgreSQL[jdbc:postgresql://Jose-5abbea2352:5432/libertya?encoding=UTF-8]
AppsServerOK=true, DatabaseOK=true

=== Context ===
#AD_Client_ID == 1010016
#AD_Client_Name == CIA MINERA LOS PIUQUENES S.R.L.
#AD_Language == es_ES
#AD_Org_ID == 1010053
#AD_Org_Name == MINERA
#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 == 1028679
#AD_User_ID == 1010717
#AD_User_Name == AdminLibertya
#C_BP_Group_ID == 1010045
#C_ConversionType_ID == 114
#C_Country_ID == 119
#C_Letra_Comprobante_ID == 1010018
#C_PaymentTerm_ID == 1010083
#C_Region_ID == 1000027
#C_TaxCategory_ID == 1010047
#C_Tax_ID == 1010084
#C_UOM_ID == 1000000
#CheckCuitControl == N
#Date == 2013-03-03 00:00:00
#GL_Category_ID == 1010098
#IsPOSJournalActive == N
#M_Locator_ID == 1010278
#M_PriceList_ID == 1010595
#M_Product_Category_ID == 1010146
#M_Warehouse_ID == 1010048
#POSJournalSupervisor == Y
#PasswordExpirationActive == N
#PrintPreview == N
#Printer == Microsoft XPS Document Writer
#SalesRep_ID == 1010717
#ShowAcct == Y
#ShowAdvanced == Y
#ShowTrl == N
#StdPrecision == 2
#UniqueKeyActive == N
#User_Level == CO
#User_Org == 0,1010053
#YYYY == Y
$C_AcctSchema_ID == 1010016
$C_Currency_ID == 118
$Element_AC == Y
$Element_BP == Y
$Element_MC == Y
$Element_OO == Y
$Element_PJ == Y
$Element_PR == Y
$Element_SR == Y
$HasAlias == Y
0|C_Currency_ID == 118
0|WindowName == Menú
1110|Find_Table_ID == 735
1113|1113|AD_User_ID == 0
1113|1113|C_BPartner_ID == 1012173
1113|1113|C_BPartner_Location_ID == 1012186
2|C_BPartner_ID == 0
2|C_Currency_ID == 118
2|IsSOTrx == Y
2|WindowName == Recibos de Clientes
3|0|AD_Tab_ID == 338
3|0|AD_Table_ID == 407
3|0|AccessLevel == 3
3|0|IsActive == Y
3|0|Name == Libro de Caja
3|0|Processed == N
3|0|SQL == SELECT C_Cash_ID,Processing,IsActive,Processed,AD_Client_ID,AD_Org_ID,C_CashBook_ID,(SELECT CashBookType FROM C_CashBook WHERE C_CashBook.C_CashBook_ID = C_Cash.C_CashBook_ID) AS CashBookType,Name,Description,StatementDate,DateAcct,C_Project_ID,C_Activity_ID,C_Campaign_ID,AD_OrgTrx_ID,User1_ID,User2_ID,BeginningBalance,IsApproved,StatementDifference,EndingBalance,DocStatus,DocAction,Posted,Created,CreatedBy,Updated,UpdatedBy FROM C_Cash WHERE (Processed=’N’ OR Updated>(current_timestamp-cast(cast(7 as text)|| ‘days’ as interval))) AND C_Cash.AD_Client_ID IN(0,1010016) AND C_Cash.AD_Org_ID IN(0,1010053) ORDER BY Name DESC
3|1|AD_Tab_ID == 339
3|1|AD_Table_ID == 410
3|1|AccessLevel == 3
3|1|LinkColumnName == C_Cash_ID
3|1|Name == Línea de Caja
3|2|AD_Tab_ID == 1010244
3|2|AD_Table_ID == 390
3|2|AccessLevel == 1
3|2|LinkColumnName == C_CashLine_ID
3|2|Name == Asignaciones
3|AD_Client_ID == 1010016
3|AD_Org_ID == 1010053
3|AutoCommit == Y
3|BaseTable_ID == 407
3|BeginningBalance == -33.00
3|C_CashBook_ID == 1010038
3|C_Cash_ID == 1010186
3|CashBookType == G
3|Created == 2013-03-03 11:56:04.6
3|CreatedBy == 1010717
3|DateAcct == 2013-03-03 00:00:00
3|Description == COBROS EFECTIVO
3|DocAction == CO
3|DocStatus == DR
3|EndingBalance == -33.00
3|IsActive == Y
3|IsApproved == N
3|IsSOTrx == Y
3|Name == CAJA COBRANZAS Y GASTOS MENORES 03/03/2013
3|Posted == N
3|Processed == N
3|Processing == N
3|StatementDate == 2013-03-03 00:00:00
3|StatementDifference == 0.00
3|Updated == 2013-03-03 11:56:04.6
3|UpdatedBy == 1010717
3|WindowName == Libro de Caja
4|0|AD_Tab_ID == 1000188
4|0|AD_Table_ID == 735
4|0|AccessLevel == 1
4|0|IsActive == Y
4|0|Name == Recibo de Cliente
4|0|Processed == Y
4|0|SQL == SELECT C_AllocationHdr_ID,Processed,Processing,IsApproved,C_POSJournal_ID,IsManual,ActionDetail,AD_Client_ID,AD_Org_ID,C_DocType_ID,DocumentNo,AllocationType,DateTrx,DateAcct,C_BPartner_ID,Description,C_Currency_ID,Retencion_Amt,GrandTotal,ApprovalAmt,DocStatus,DocAction,AllocationAction,IsActive,Posted,Created,CreatedBy,Updated,UpdatedBy FROM C_AllocationHdr WHERE AllocationType in (‘RC’,’RCA’) AND C_BPartner_ID=1012173 AND C_AllocationHdr.AD_Client_ID IN(0,1010016) AND C_AllocationHdr.AD_Org_ID IN(0,1010053) ORDER BY Created
4|1|AD_Tab_ID == 1000189
4|1|AD_Table_ID == 1000137
4|1|AccessLevel == 3
4|1|Name == Detalle
4|99|FindSQL == SELECT COUNT(*) FROM C_AllocationHdr WHERE AllocationType in (‘RC’,’RCA’) AND C_BPartner_ID=1012173 AND AD_Client_ID IN(0,1010016) AND AD_Org_ID IN(0,1010053)
4|AD_Client_ID == 1010016
4|AD_Org_ID == 1010053
4|AllocationType == RC
4|ApprovalAmt == 0.00
4|AutoCommit == Y
4|BaseTable_ID == 735
4|C_AllocationHdr_ID == 1012141
4|C_BPartner_ID == 1012173
4|C_Currency_ID == 118
4|Created == 2013-03-03 11:56:54.
4|CreatedBy == 1010717
4|DateAcct == 2013-03-03 00:00:00
4|DateTrx == 2013-03-03 00:00:00
4|Description == Recibo de Cliente 2013-03-03 [Recibo de Cliente RC]
4|DocAction == CL
4|DocStatus == CO
4|DocumentNo == 1000212
4|Find_Table_ID == 735
4|GrandTotal == 3000.00
4|IsActive == Y
4|IsApproved == Y
4|IsManual == N
4|IsSOTrx == Y
4|Posted == Y
4|Processed == Y
4|Processing == N
4|Retencion_Amt == 0.00
4|Updated == 2013-03-03 11:56:57.0
4|UpdatedBy == 1010717
4|WindowName == Recibos de Clientes Existentes
AutoCommit == Y
P1010098|InventoryKind == IO
P103|Type == S
P189|DataType == S
P|AD_FTDoc == 1002145
P|AllowExchangeDifference == 0.01
P|AuditReferenceCurrencyISOCode == USD
P|C_Dockey == 018a9567ea15470312c40d3e5d6bbcd4
P|DIF_CAMBIO_ARTICULO == 10000001
P|DIF_CAMBIO_PTO_VENTA == 1
P|InfoMaxRowsAllowed == 1000
P|InfoRowCountMethod == C
P|LOCAL_AR == Y
P|L_AR_CFMontoMaximo == 1000
P|L_AR_MaxOrderLineQty == 999
P|LookupMaxRowsAllowed == 1000
P|MantenimientoPadron == 3
P|OpenTrxLowerLimit == 6
P|OpenTrxTimeOutMS == 3600000
P|OpenTrxUpperLimit == 10
P|POSCashJounal_ValidDiff == 0.5
P|ReplicationEventsActive == Y
P|TransferDueDateDays == 1
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:DOCUME~1MICROS~1CONFIG~1Temp
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
java.awt.headless=true
java.awt.printerjob=sun.awt.windows.WPrinterJob
java.class.path=C:DOCUME~1MICROS~1CONFIG~1Temptemp0.jar;C:ServidorOXP.libbatik-awt-util.jar;C:ServidorOXP.libbatik-dom.jar;C:ServidorOXP.libbatik-svggen.jar;C:ServidorOXP.libbatik-util.jar;C:ServidorOXP.libbatik-xml.jar;C:ServidorOXP.libCMPCS.jar;C:ServidorOXP.libJasperReports.jar;C:ServidorOXP.libjboss.jar;C:ServidorOXP.libjsp-api-2.0.jar;C:ServidorOXP.liboracle.jar;C:ServidorOXP.libOXP.jar;C:ServidorOXP.libOXPApps.jar;C:ServidorOXP.libOXPInstall.jar;C:ServidorOXP.libOXPRoot.jar;C:ServidorOXP.libOXPSLib.jar;C:ServidorOXP.libOXPXLib.jar;C:ServidorOXP.libpostgresql.jar;C:ServidorOXP.libsqlj.jar;C:ServidorOXP.libsqlServer.jar;C:ServidorOXP.libsybase.jar;C:ServidorOXP.libXOXPTools.jar;C:ServidorOXP.libswing-layout-1.0.jar;C:ServidorOXP.libPDFRenderer.jar;C:ServidorOXP.libJasperReports.jar;
java.class.version=50.0
java.endorsed.dirs=C:Javajdk1.6.0_25jrelibendorsed
java.ext.dirs=C:Javajdk1.6.0_25jrelibext;C:WINDOWSSunJavalibext
java.home=C:Javajdk1.6.0_25jre
java.io.tmpdir=C:DOCUME~1MICROS~1CONFIG~1Temp
java.library.path=C:Javajdk1.6.0_25bin;.;C:WINDOWSSunJavabin;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;C:Archivos de programaArchivos comunesDivX Shared;C:Archivos de programaQuickTimeQTSystem;C:Archivos de programaATI TechnologiesATI.ACECore-Static;C:Archivos de programaJavajdk1.6.0_25bin;C:Archivos de programaJavajdk1.6.0_25jrebin;C:Archivos de programaJavajdk1.6.0_25jrebinclient;C:Javajdk1.6.0_29bin;C:Javajdk1.6.0_29jrebin;C:Javajdk1.6.0_29jrebinclient;C:Archivos de programaJavajdk1.6.0_29bin;C:Archivos de programaJavajdk1.6.0_29jrebin;C:Archivos de programaJavajdk1.6.0_29jrebinclient;C:Archivos de programaPostgreSQL8.3bin;C:Javajdk1.6.0_25bin;C:Javajdk1.6.0_25jrebin;C:Javajdk1.6.0_25jrebinclient;C:PostgreSQL8.3bin
java.runtime.name=Java(TM) SE Runtime Environment
java.runtime.version=1.6.0_25-b06
java.specification.name=Java Platform API Specification
java.specification.vendor=Sun Microsystems Inc.
java.specification.version=1.6
java.vendor=Sun Microsystems Inc.
java.vendor.url=http://java.sun.com/
java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi
java.version=1.6.0_25
java.vm.info=mixed mode, sharing
java.vm.name=Java HotSpot(TM) Client VM
java.vm.specification.name=Java Virtual Machine Specification
java.vm.specification.vendor=Sun Microsystems Inc.
java.vm.specification.version=1.0
java.vm.vendor=Sun Microsystems Inc.
java.vm.version=20.0-b11
line.separator=

os.arch=x86
os.name=Windows XP
os.version=5.1
path.separator=;
sun.arch.data.model=32
sun.boot.class.path=C:Javajdk1.6.0_25jrelibresources.jar;C:Javajdk1.6.0_25jrelibrt.jar;C:Javajdk1.6.0_25jrelibsunrsasign.jar;C:Javajdk1.6.0_25jrelibjsse.jar;C:Javajdk1.6.0_25jrelibjce.jar;C:Javajdk1.6.0_25jrelibcharsets.jar;C:Javajdk1.6.0_25jrelibmodulesjdk.boot.jar;C:Javajdk1.6.0_25jreclasses
sun.boot.library.path=C:Javajdk1.6.0_25jrebin
sun.cpu.endian=little
sun.cpu.isalist=
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=Service Pack 3
suppressSwingDropSupport=true
user.country=ES
user.dir=C:ServidorOXP
user.home=C:Documents and SettingsMicrosoft
user.language=es
user.name=Microsoft
user.timezone=America/Cayenne
user.variant=

[Jose Luis Aragon]

Estimados yo estoy teniendo el mismo problema con la carga de recibos en 13.01, pido por favor que le den prioridad por que yo estoy en una base de produccion.

A la brevedad posteare los errores que me genera

Un cordial saludo

[Jose Luis Aragon]

Bien Matias pero te comento que al momento de operar , por la misma rapidez que se hacen las cosas etc se cometen errores de tipeo , en fechas , montos , etc etc, cual seria la forma de corregirlo si ya esta completo el documento?? Haciendo la Inversa-Correccion? esa seria la unica manera?? No es posible mediante sentencia corregirlo, esto es por el mismo tema por los tiempos.

Agradecere tus comentarios

Un cordial saludo

José Luis

[Jose Luis Aragon]

Estimado Juan podrias pasarme un archivo formato para importar el Extracto bancario?
Mi duda es como yo tomo ese formato y lo adapto con los datos de mi extracto bancario para importarlo??

[Jose Luis Aragon]

Estimado Cacho , cuando ejecuto el Segundo Script para un volver un Documento Completo y pasarlo a Modo de completar para editar o setear los campos no me permite hacelo,
Hay algo que me falte hacer?==

O algo que deba hacer para que me permita setear los campos , Nro de Doc , fecha , Tipo de Documento, LInea Etc etc??

[Autor]

Entradas