[WS Biz]

Quisiera saber cómo han hecho para cargar los costos de cobrar con tarjeta que aplican las financieras (VISA, AmEx, Master, etc.) ya que no encuentro una forma de asociar esos cargos a los comprobantes de venta para tener un resumen completo de esa operación.
Me interesa más que nada reflejar la realidad financiera de las ventas con tarjetas, ya que no se cobra la totalidad del comprobante sino que existe ese costo de la tarjeta.

[WS Biz]

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.

Code:

——————————-
===========> 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]

[WS Biz]

Parece que no hay nadie que haya implementado Libertya con controles sobre los cobros de tarjeta.

[gustavo linos]

Hola
Pudistes solucionarlo?, tengo el mismo problema, si sabes como por favor avisame
gracias de antemano
gustavo

[Autor]

Entradas