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=
