Actualizo: a través de la conciliación bancaria no es posible reflejar los costos del uso de la tarjeta.
Por otro lado, los informes relacionados a Entidades Financieras no funciona ninguno.
===========> MPInstance.load: [ProcessCtl.startProcess_1398794092487] – AD_PInstance_ID=0, SQL=SELECT AD_Client_ID,AD_Org_ID,AD_PInstance_ID,AD_Process_ID,AD_User_ID,Created,CreatedBy,ErrorMsg,IsActive,IsProcessing,Record_ID,Result,Updated,UpdatedBy FROM AD_PInstance WHERE AD_PInstance_ID=? [118]
org.postgresql.util.PSQLException: No se ha especificado un valor para el parámetro 1.; State=22023; ErrorCode=0
at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:178)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:205)
at org.openXpertya.model.PO.load(PO.java:1280)
at org.openXpertya.model.PO.load(PO.java:1236)
at org.openXpertya.model.PO.initialize(PO.java:218)
at org.openXpertya.model.PO.(PO.java:204)
at org.openXpertya.model.PO.(PO.java:155)
at org.openXpertya.model.X_AD_PInstance.(X_AD_PInstance.java:15)
at org.openXpertya.model.MPInstance.(MPInstance.java:110)
at org.openXpertya.process.SvrProcess.unlock(SvrProcess.java:475)
at org.openXpertya.process.SvrProcess.startProcess(SvrProcess.java:115)
at org.openXpertya.apps.ProcessCtl.startProcess(ProcessCtl.java:603)
at org.openXpertya.apps.ProcessCtl.run(ProcessCtl.java:293)
——————————-
===========> SvrProcess.unlock: Did not find PInstance 1092206 [118]
——————————-
———–> DataEngine.loadPrintData: NO Rows – ms=104 [118]
===========> DB.executeUpdate: Update=INSERT INTO t_invoice (ad_pinstance_id, c_invoice_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processed, posted, c_doctype_id, c_doctypetarget_id, c_order_id, description, isapproved, istransferred, isprinted, salesrep_id, dateinvoiced, dateprinted, dateacct, c_bpartner_id, c_bpartner_location_id, c_currency_id, paymentrule, c_paymentterm_id, c_charge_id, chargeamt, totallines, grandtotal, m_pricelist_id, istaxincluded, c_campaign_id, c_project_id, ispaid, c_cashline_id, c_conversiontype_id, ispayschedulevalid, ref_invoice_id, c_letra_comprobante_id, datecai, numerocomprobante, puntodeventa, cai, cuit, numerodedocumento, c_region_id, c_invoice_orig_id, nombrecli, caja, invoice_adress, fiscalalreadyprinted, nroidentificcliente, cae, vtocae, idcae, caecbte, caeerror, createcashline, iscopy, authcode, authmatch, doctypename, doctypeprintname, docbasetype) SELECT 1092207, i.c_invoice_id, i.ad_client_id, i.ad_org_id, i.isactive, i.created, i.createdby, i.updated, i.updatedby, i.issotrx, documentno, docstatus, docaction, i.processed, posted, i.c_doctype_id, c_doctypetarget_id, c_order_id, i.description, i.isapproved, istransferred, isprinted, salesrep_id, dateinvoiced, dateprinted, dateacct, c_bpartner_id, c_bpartner_location_id, i.c_currency_id, paymentrule, c_paymentterm_id, c_charge_id, chargeamt, totallines, grandtotal, m_pricelist_id, istaxincluded, i.c_campaign_id, i.c_project_id, ispaid, c_cashline_id, c_conversiontype_id, ispayschedulevalid, ref_invoice_id, c_letra_comprobante_id, datecai, numerocomprobante, puntodeventa, cai, cuit, numerodedocumento, i.c_region_id, c_invoice_orig_id, nombrecli, caja, invoice_adress, fiscalalreadyprinted, nroidentificcliente, cae, vtocae, idcae, caecbte, caeerror, createcashline, iscopy, authcode, authmatch, doc.name, doc.printname, doc.docbasetype FROM C_Invoice as i INNER JOIN c_doctype as doc ON (i.c_doctypetarget_id = doc.c_doctype_id) WHERE (i.issotrx = ‘Y’) AND (doc.docbasetype IN (‘ARI’, ‘ARC’)) AND (i.ad_org_id = 1010053) AND (documentno LIKE ‘%’) [ProcessCtl.startProcess_1398794104226] [122]
org.postgresql.util.PSQLException: ERROR: column reference “datecai” is ambiguous
Position: 1587; State=42702; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
at org.openXpertya.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:245)
at org.openXpertya.util.DB.executeUpdate(DB.java:907)
at org.openXpertya.util.DB.executeUpdate(DB.java:892)
at org.openXpertya.util.DB.executeUpdate(DB.java:862)
at org.openXpertya.process.InvoicesQueryReport.doIt(InvoicesQueryReport.java:83)
at org.openXpertya.process.SvrProcess.process(SvrProcess.java:158)
at org.openXpertya.process.SvrProcess.startProcess(SvrProcess.java:114)
at org.openXpertya.apps.ProcessCtl.startProcess(ProcessCtl.java:603)
at org.openXpertya.apps.ProcessCtl.run(ProcessCtl.java:293)
——————————-
===========> DB.saveError: DBExecuteErrorrr – ERROR: column reference “datecai” is ambiguous
Position: 1587 [122]
——————————-
===========> MPInstance.load: [ProcessCtl.startProcess_1398794104226] – AD_PInstance_ID=0, SQL=SELECT AD_Client_ID,AD_Org_ID,AD_PInstance_ID,AD_Process_ID,AD_User_ID,Created,CreatedBy,ErrorMsg,IsActive,IsProcessing,Record_ID,Result,Updated,UpdatedBy FROM AD_PInstance WHERE AD_PInstance_ID=? [122]
org.postgresql.util.PSQLException: No se ha especificado un valor para el parámetro 1.; State=22023; ErrorCode=0
at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:178)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:205)
at org.openXpertya.model.PO.load(PO.java:1280)
at org.openXpertya.model.PO.load(PO.java:1236)
at org.openXpertya.model.PO.initialize(PO.java:218)
at org.openXpertya.model.PO.(PO.java:204)
at org.openXpertya.model.PO.(PO.java:155)
at org.openXpertya.model.X_AD_PInstance.(X_AD_PInstance.java:15)
at org.openXpertya.model.MPInstance.(MPInstance.java:110)
at org.openXpertya.process.SvrProcess.unlock(SvrProcess.java:475)
at org.openXpertya.process.SvrProcess.process(SvrProcess.java:180)
at org.openXpertya.process.SvrProcess.startProcess(SvrProcess.java:114)
at org.openXpertya.apps.ProcessCtl.startProcess(ProcessCtl.java:603)
at org.openXpertya.apps.ProcessCtl.run(ProcessCtl.java:293)
——————————-
===========> SvrProcess.unlock: Did not find PInstance 1092207 [122]
——————————-
===========> MPInstance.load: [ProcessCtl.startProcess_1398794104226] – AD_PInstance_ID=0, SQL=SELECT AD_Client_ID,AD_Org_ID,AD_PInstance_ID,AD_Process_ID,AD_User_ID,Created,CreatedBy,ErrorMsg,IsActive,IsProcessing,Record_ID,Result,Updated,UpdatedBy FROM AD_PInstance WHERE AD_PInstance_ID=? [122]
org.postgresql.util.PSQLException: No se ha especificado un valor para el parámetro 1.; State=22023; ErrorCode=0
at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:178)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:205)
at org.openXpertya.model.PO.load(PO.java:1280)
at org.openXpertya.model.PO.load(PO.java:1236)
at org.openXpertya.model.PO.initialize(PO.java:218)
at org.openXpertya.model.PO.(PO.java:204)
at org.openXpertya.model.PO.(PO.java:155)
at org.openXpertya.model.X_AD_PInstance.(X_AD_PInstance.java:15)
at org.openXpertya.model.MPInstance.(MPInstance.java:110)
at org.openXpertya.process.SvrProcess.unlock(SvrProcess.java:475)
at org.openXpertya.process.SvrProcess.startProcess(SvrProcess.java:115)
at org.openXpertya.apps.ProcessCtl.startProcess(ProcessCtl.java:603)
at org.openXpertya.apps.ProcessCtl.run(ProcessCtl.java:293)
——————————-
===========> SvrProcess.unlock: Did not find PInstance 1092207 [122]
——————————-
———–> DataEngine.loadPrintData: NO Rows – ms=245 [122]
———–> Msg.getMsg: NOT found: OXPSYS [11]
———–> Msg.getMsg: NOT found: OXPSYS [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 [124]
——————————-
===========> 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 [125]
——————————-
===========> ReportStarter.startProcess: No report file found for given type, falling back to attachment:EntidadFinancieraCuentaCorriente.jrxml [126]
——————————-
===========> ReportStarter.startProcess: Can not find report file at path – attachment:EntidadFinancieraCuentaCorriente.jrxml [126]
——————————-
———–> Msg.getMsg: NOT found: OXPSYS [11]
———–> Msg.getMsg: NOT found: OXPSYS [11]
===========> ReportStarter.startProcess: No report file found for given type, falling back to attachment:EntidadFinancieraBalances.jrxml [128]
——————————-
===========> ReportStarter.startProcess: Can not find report file at path – attachment:EntidadFinancieraBalances.jrxml [128]
——————————-
———–> Msg.getMsg: NOT found: OXPSYS [11]
———–> Msg.getMsg: NOT found: OXPSYS [11]
===========> ReportStarter.startProcess: No report file found for given type, falling back to attachment:EntidadFinancieraSalesPurchases.jrxml [132]
——————————-
===========> ReportStarter.startProcess: Can not find report file at path – attachment:EntidadFinancieraSalesPurchases.jrxml [132]
——————————-
===========> ReportStarter.startProcess: No report file found for given type, falling back to attachment:TotalesPorEntidadFinanciera.jrxml [134]
——————————-
===========> ReportStarter.startProcess: Can not find report file at path – attachment:TotalesPorEntidadFinanciera.jrxml [134]
——————————-
===========> ReportStarter.startProcess: No report file found for given type, falling back to attachment:TotalesPorEntidadFinanciera.jrxml [136]
——————————-
===========> ReportStarter.startProcess: Can not find report file at path – attachment:TotalesPorEntidadFinanciera.jrxml [136]
