Return-Path: X-Original-To: apmail-ofbiz-user-archive@www.apache.org Delivered-To: apmail-ofbiz-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D2DD0CBAE for ; Wed, 12 Mar 2014 18:47:37 +0000 (UTC) Received: (qmail 74980 invoked by uid 500); 12 Mar 2014 18:47:37 -0000 Delivered-To: apmail-ofbiz-user-archive@ofbiz.apache.org Received: (qmail 74750 invoked by uid 500); 12 Mar 2014 18:47:36 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 74728 invoked by uid 99); 12 Mar 2014 18:47:34 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Mar 2014 18:47:34 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,NORMAL_HTTP_TO_IP,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of archdove@gmail.com designates 209.85.220.66 as permitted sender) Received: from [209.85.220.66] (HELO mail-pa0-f66.google.com) (209.85.220.66) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Mar 2014 18:47:27 +0000 Received: by mail-pa0-f66.google.com with SMTP id fb1so851500pad.5 for ; Wed, 12 Mar 2014 11:47:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=wVbNCgXu5koLNdmUi9OjaVfScQZ3DCJi2aBRmXG7zpU=; b=JugnHN0S25z80gnJxxhJFCwk0ZtbZglxTszn4m46w2Q5e2JzeAK36ftYFVCE6m3trf di63FC1tJT7RKkGV1OQb/dHridbZEQasAqLhUSnj/Qsx9wQCs2nWCNxxvRBRq2scfkJU wTDnlal1+KReyHjn/C7uIpG0b9Fqzli3TxeLfwo+fnw6jnjkLuCXkupuH0f0PJ40s98B PT2J1Co76Qvp8pFUknfsqkcQ/HFjvmYSn+6vbz2sA/PnAEbnkDZAWZsz613wvRNMfxBD eBx46MvNtSXjtaeZCsTNq8aQVPZERx+rZqgjD52Mk0pf3nKhXf5xSmoryFBSxPyqM4J7 jLiw== MIME-Version: 1.0 X-Received: by 10.66.217.169 with SMTP id oz9mr6916354pac.20.1394650025075; Wed, 12 Mar 2014 11:47:05 -0700 (PDT) Received: by 10.68.112.65 with HTTP; Wed, 12 Mar 2014 11:47:05 -0700 (PDT) In-Reply-To: References: <55DB5980-3CE1-4A90-9D0A-1FF9ABAF9D55@gmail.com> Date: Wed, 12 Mar 2014 19:47:05 +0100 Message-ID: Subject: Re: Currencies of invoice and payment not compatible - All the time From: Adrian Stern To: user Content-Type: multipart/alternative; boundary=047d7b5d594854ac7a04f46d43e1 X-Virus-Checked: Checked by ClamAV on apache.org --047d7b5d594854ac7a04f46d43e1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I tried the following with Demo Data: 1. Create Invoice USD; Pay invoice with USD Payment =3D> works 2. Create Invoice CHF; Pay invoice with CHF Payment =3D> currencies don't match For the CHF payment i created the Foreing Exchange Rates: CHF to USD - 1.14 USD to CHF - 0.67 I also tried to replace all USD with CHF in demo data with the same resutl. Currencies won't match. Could anyone try this out and report if the problem exists? On 12 March 2014 16:13, Adrian Stern wrote: > Some more Information: > > In the file > > ofbiz/applications/accounting/script/org/ofbiz/accounting/payment/Payment= Services.xml > > the error would be somwhere here: > * > * > resource=3D"general" property=3D"currency.uom.id.default" default=3D"*USD= *"/> > > > > operator=3D"equals" to-field=3D"defaultCurrencyUomId"/> > > field=3D"invoice.currencyUomId" operator=3D"not-equals" > to-field=3D"defaultCurrencyUomId"/> > field=3D"invoice.currencyUomId" operator=3D"equals" > to-field=3D"payment.actualCurrencyUomId"/> > > > > operator=3D"not-equals" to-field=3D"defaultCurrencyUomId"> > > method-name=3D"getPaymentNotApplied" > class-name=3D"org.ofbiz.accounting.payment.PaymentWorker" > ret-field=3D"notAppliedPayment"> > > > > > > > > property=3D"AccountingCurrenciesOfInvoiceAndPaymentNotCompatible"/> > > > > > > > Stack Trace of when its going wrong (all the time): > > [java] 2014-03-12 15:54:49,207 (http-bio-0.0.0.0-8443-exec-8) [ > ControlServlet.java:140:INFO ] [[[createPaymentApplication(Domain: > https://localhost)] Request Begun, encoding=3D[UTF-8]- total:0.0,since > last(Begin):0.0]] > [java] 2014-03-12 15:54:49,231 (http-bio-0.0.0.0-8443-exec-8) [ > ConfigXMLReader.java:116:INFO ] controller loaded: 0.009s, 482 requests, > 228 views in jndi:/0.0.0.0/accounting/WEB-INF/controller.xml > [java] 2014-03-12 15:54:49,236 (http-bio-0.0.0.0-8443-exec-8) [ > ConfigXMLReader.java:116:INFO ] controller loaded: 0.001s, 39 requests, = 19 > views in > file:/home/adrian/projects/ofbiz/framework/common/webcommon/WEB-INF/commo= n-controller.xml > [java] 2014-03-12 15:54:49,239 (http-bio-0.0.0.0-8443-exec-8) [ > ConfigXMLReader.java:116:INFO ] controller loaded: 0.0s, 0 requests, 0 > views in > file:/home/adrian/projects/ofbiz/framework/common/webcommon/WEB-INF/handl= ers-controller.xml > [java] 2014-03-12 15:54:49,242 (http-bio-0.0.0.0-8443-exec-8) [ > ConfigXMLReader.java:116:INFO ] controller loaded: 0.0s, 4 requests, 0 > views in > file:/home/adrian/projects/ofbiz/applications/commonext/webapp/WEB-INF/co= ntroller.xml > [java] 2014-03-12 15:54:49,266 (http-bio-0.0.0.0-8443-exec-8) [ > TransactionUtil.java:378:WARN ] > [java] ---- exception report > ---------------------------------------------------------- > [java] [TransactionUtil.setRollbackOnly] Calling transaction > setRollbackOnly; this stack trace shows where this is happening: > [java] Exception: java.lang.Exception > [java] Message: Error in simple-method [Create a Payment Application > [file:/home/adrian/projects/ofbiz/applications/accounting/script/org/ofbi= z/accounting/payment/PaymentServices.xml#createPaymentApplication]]: > ; [Die W=E4hrungen der Rechnung und der Zahlung passen nicht zusammen] > [java] ---- stack trace > --------------------------------------------------------------- > [java] java.lang.Exception: Error in simple-method [Create a Payment > Application > [file:/home/adrian/projects/ofbiz/applications/accounting/script/org/ofbi= z/accounting/payment/PaymentServices.xml#createPaymentApplication]]: > ; [Die W=E4hrungen der Rechnung und der Zahlung passen nicht zusammen] > [java] > org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionU= til.java:378) > [java] > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.jav= a:319) > [java] org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:578) > [java] > org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:271) > [java] > org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:290) > [java] > org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine= .java:79) > [java] > org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:4= 8) > [java] > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:385) > [java] > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) > [java] > org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(Gene= ricDispatcherFactory.java:83) > [java] > org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.jav= a:338) > [java] > org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:695) > [java] > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:420= ) > [java] > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:214) > [java] > org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:86) > [java] javax.servlet.http.HttpServlet.service(HttpServlet.java:641) > [java] javax.servlet.http.HttpServlet.service(HttpServlet.java:722) > [java] > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat= ionFilterChain.java:303) > [java] > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte= rChain.java:208) > [java] > org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:314) > [java] > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat= ionFilterChain.java:241) > [java] > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte= rChain.java:208) > [java] > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve= .java:220) > [java] > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve= .java:122) > [java] > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorB= ase.java:501) > [java] > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:= 170) > [java] > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:= 98) > [java] > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j= ava:116) > [java] > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) > [java] > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:40= 8) > [java] > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Pr= ocessor.java:1040) > [java] > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(Abst= ractProtocol.java:607) > [java] > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.ja= va:315) > [java] > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java= :1145) > [java] > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.jav= a:615) > [java] java.lang.Thread.run(Thread.java:744) > [java] > -------------------------------------------------------------------------= ------- > [java] > [java] 2014-03-12 15:54:49,267 (http-bio-0.0.0.0-8443-exec-8) [ > ServiceDispatcher.java:520:ERROR] Error in Service > [createPaymentApplication]: Die W=E4hrungen der Rechnung und der Zahlung > passen nicht zusammen > [java] 2014-03-12 15:54:49,267 (http-bio-0.0.0.0-8443-exec-8) [ > TransactionUtil.java:341:ERROR] > [java] ---- exception report > ---------------------------------------------------------- > [java] [TransactionUtil.rollback] > [java] Exception: java.lang.Exception > [java] Message: Stack Trace > [java] ---- stack trace > --------------------------------------------------------------- > [java] java.lang.Exception: Stack Trace > [java] > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.jav= a:340) > [java] > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.jav= a:317) > [java] > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:524) > [java] > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) > [java] > org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(Gene= ricDispatcherFactory.java:83) > [java] > org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.jav= a:338) > [java] > org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:695) > [java] > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:420= ) > [java] > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:214) > [java] > org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:86) > [java] javax.servlet.http.HttpServlet.service(HttpServlet.java:641) > [java] javax.servlet.http.HttpServlet.service(HttpServlet.java:722) > [java] > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat= ionFilterChain.java:303) > [java] > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte= rChain.java:208) > [java] > org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:314) > [java] > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat= ionFilterChain.java:241) > [java] > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte= rChain.java:208) > [java] > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve= .java:220) > [java] > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve= .java:122) > [java] > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorB= ase.java:501) > [java] > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:= 170) > [java] > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:= 98) > [java] > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j= ava:116) > [java] > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) > [java] > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:40= 8) > [java] > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Pr= ocessor.java:1040) > [java] > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(Abst= ractProtocol.java:607) > [java] > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.ja= va:315) > [java] > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java= :1145) > [java] > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.jav= a:615) > [java] java.lang.Thread.run(Thread.java:744) > [java] > -------------------------------------------------------------------------= ------- > [java] > [java] 2014-03-12 15:54:49,267 (http-bio-0.0.0.0-8443-exec-8) [ > TransactionUtil.java:351:INFO ] [TransactionUtil.rollback] transaction > rolled back > [java] 2014-03-12 15:54:49,267 (http-bio-0.0.0.0-8443-exec-8) [ > ServiceDispatcher.java:586:INFO ] Sync service > [accounting/createPaymentApplication] finished in [20] milliseconds > [java] 2014-03-12 15:54:49,268 (http-bio-0.0.0.0-8443-exec-8) [ > RequestHandler.java:696:INFO ] Ran Event > [service:#createPaymentApplication] from [request], result is [error] > [java] 2014-03-12 15:54:49,268 (http-bio-0.0.0.0-8443-exec-8) [ > RequestHandler.java:479:WARN ] Could not find response in request > [createPaymentApplication] for event return [error] > [java] 2014-03-12 15:54:49,268 (http-bio-0.0.0.0-8443-exec-8) [ > RequestHandler.java:814:INFO ] Rendering View [editPaymentApplications], > sessionId=3DF17B26D438585A88886D3CF3382C441A.jvm1 > [java] 2014-03-12 15:54:49,337 (http-bio-0.0.0.0-8443-exec-8) [ > ServiceDispatcher.java:586:INFO ] Sync service > [accounting/getUserPreferenceGroup] finished in [1] milliseconds > [java] 2014-03-12 15:54:49,343 (http-bio-0.0.0.0-8443-exec-8) [ > ScreenFactory.java:130:INFO ] Got 13 screens in 0.006s from: > file:/home/adrian/projects/ofbiz/applications/accounting/widget/PaymentSc= reens.xml > [java] experiment: creating class manager > [java] experiment: creating class manager > [java] experiment: creating class manager > [java] 2014-03-12 15:54:49,569 (http-bio-0.0.0.0-8443-exec-8) [ > ScreenFactory.java:130:INFO ] Got 10 screens in 0.008s from: > file:/home/adrian/projects/ofbiz/applications/accounting/widget/CommonScr= eens.xml > [java] 2014-03-12 15:54:49,577 (http-bio-0.0.0.0-8443-exec-8) [ > ScreenFactory.java:130:INFO ] Got 1 screens in 0.007s from: > file:/home/adrian/projects/ofbiz/applications/commonext/widget/CommonScre= ens.xml > [java] 2014-03-12 15:54:49,578 (http-bio-0.0.0.0-8443-exec-8) [ > PrimaryKeyFinder.java:158:INFO ] Returning null because found incomplete > primary key in find: [GenericEntity:PartyNameView][partyId,null()] > [java] 2014-03-12 15:54:49,629 (http-bio-0.0.0.0-8443-exec-8) [ > ServiceDispatcher.java:586:INFO ] Sync service > [accounting/getLastSystemInfoNote] finished in [17] milliseconds > [java] 2014-03-12 15:54:49,653 (http-bio-0.0.0.0-8443-exec-8) [ > ScreenFactory.java:130:INFO ] Got 24 screens in 0.013s from: > file:/home/adrian/projects/ofbiz/framework/common/widget/CommonScreens.xm= l > [java] 2014-03-12 15:54:49,679 (http-bio-0.0.0.0-8443-exec-8) [ > ServiceDispatcher.java:586:INFO ] Sync service > [accounting/getVisualThemeResources] finished in [23] milliseconds > [java] 2014-03-12 15:54:49,922 (http-bio-0.0.0.0-8443-exec-8) [ > ServiceDispatcher.java:586:INFO ] Sync service > [accounting/acctgBasePermissionCheck] finished in [43] milliseconds > [java] 2014-03-12 15:54:49,928 (http-bio-0.0.0.0-8443-exec-8) [ > ServiceDispatcher.java:586:INFO ] Sync service > [accounting/acctgBasePermissionCheck] finished in [3] milliseconds > [java] experiment: creating class manager > [java] 2014-03-12 15:54:50,079 (http-bio-0.0.0.0-8443-exec-8) [ > ServerHitBin.java:637:INFO ] Visit delegatorName=3Ddefault, ServerHitBin > delegatorName=3Ddefault > [java] 2014-03-12 15:54:50,084 (http-bio-0.0.0.0-8443-exec-8) [ > ControlServlet.java:324:INFO ] [[[createPaymentApplication(Domain: > https://localhost)] Request Done- total:0.877,since > last([createPaymentApp...):0.877]] > > > > On 12 March 2014 15:44, Adrian Stern wrote: > >> Ok. >> >> I made the change from USD to CHF in this file, but the outcome is still >> the same: >> >> applications/commonext/script/org/ofbiz/setup/SetupEvents.xml: >> >> applications/commonext/script/org/ofbiz/setup/SetupEvents.xml: >> >> >> >> >> >> On 11 March 2014 17:14, Pierre @GMail wrote: >> >>> Yes. It is in the entity with the same name. >>> >>> Sent from my iPhone >>> >>> > On 11 mrt. 2014, at 15:22, Adrian Stern wrote: >>> > >>> > Sorry. It is hard to find. Do you refer to somwhere in the GUI or do >>> you >>> > refer to some XML file? >>> > >>> > I did find this: >>> > applications/commonext/script/org/ofbiz/setup/SetupEvents.xml: >>> >> > field=3D"acctgPreferenceCtx.baseCurrencyUomId" value=3D"USD"/> >>> > >>> > Ist this the right one? Otherwise i would appreciate a more precise >>> > insruction. >>> > >>> > >>> >> On 11 March 2014 14:32, Pierre Smits wrote: >>> >> >>> >> Adrian, >>> >> >>> >> If you have changed your default currency manually, I advice you to >>> also >>> >> check the 'baseCurrencyUomId' value in PartyAcctgPreference. >>> >> >>> >> This must be in sync. >>> >> >>> >> Regards, >>> >> >>> >> Pierre Smits >>> >> >>> >> *ORRTIZ.COM * >>> >> Services & Solutions for Cloud- >>> >> Based Manufacturing, Professional >>> >> Services and Retail & Trade >>> >> http://www.orrtiz.com >>> >> >>> >> >> > --047d7b5d594854ac7a04f46d43e1--