LCO Withholding - Foreign Currency

Muhammad Rizwan Anwar

unread,

Nov 25, 2015, 8:54:39 AM11/25/15

to iDempiere

Dear Community

I am using LCO Withholding in iDempiere 2.1 (Daily). My WithHoling Calc setting set to "is calc on payment". But when I receive payment against invoice that use foreign currency(Euro), system does not convert with holding amount to accounting schema's currency(USD).

My test case is as follow:

· Accounting Schema Currency is USD

· Currency Used for Transaction is Euro

· Rate is 1.249 (Euro to USD)

Post Invoice (Customer): Currency is Euro, Grand Total:100, Withholding Amount = 10 (WHT rate is 10%)

Posting of invoice is and it is OK:

Trade Revenue (credited)		124.90
Accounts Receivable (debited)	124.90

Create payment 90 Euro, allocate against above invoice WHT Amount is 10

Posting of payment is as follow and it’s also OK:

Checking In-Transfer (debited)	112.41
Checking Unallocated Receipts (credited)		112.41

Posting of allocation is as follow and it is Not OK:

Checking Unallocated Receipts (debited)	112.41
Accounts Receivable – Trade (credited)		124.90
Tax due	10.00

As you noticed Tax due amount 10.00 is wrong it should be 12.49

What is wrong here? Please guide me

Thank you

Rizwan Anwar

Eduardo Gil

unread,

Nov 25, 2015, 5:32:16 PM11/25/15

to iDempiere

Hi rizwan.

Some time ago i had the same problem and my solution (is not the best by the way) was edit the query in file LCO_ValidatorWH and modifying the method accountingForInvoiceWithholdingOnPayment to force the convertion to venezuelan currency

			String sql = 
					  "SELECT i.C_Tax_ID,NVL(SUM(i.TaxBaseAmt),0) AS TaxBaseAmt, NVL(SUM(i.TaxAmt),0) AS TaxAmt, " +
					  "COALESCE(SUM( currencyconvert(i.TaxBaseAmt,ci.c_currency_id, 205, " +
					  "i.dateacct, ci.c_conversiontype_id, i.ad_client_id, i.ad_org_id) ),0) AS TaxBaseAmtVE, " +
					  "COALESCE(SUM(currencyconvert(i.TaxAmt ,ci.c_currency_id, 205, " +
					  "i.dateacct, ci.c_conversiontype_id, i.ad_client_id, i.ad_org_id)),0) AS TaxAmtVE, t.Name, t.Rate, t.IsSalesTax "
					 + " FROM LCO_InvoiceWithholding i, C_Tax t, C_Invoice ci "
					+ " WHERE i.C_Invoice_ID = ? AND " +
							 "i.IsCalcOnPayment = 'Y' AND " +
							 "i.IsActive = 'Y' AND " +
							 "i.Processed = 'Y' AND " +
							 "i.C_AllocationLine_ID = ? AND " +
							 "i.C_Tax_ID = t.C_Tax_ID AND " +
							 "i.C_Invoice_ID = ci.C_Invoice_ID "
					+ "GROUP BY i.C_Tax_ID, t.Name, t.Rate, t.IsSalesTax ";

Maybe with this guide you can implement a better and general solution for you.

Regards,

sidhar...@sodtechnologies.com

unread,

Dec 1, 2015, 12:47:44 AM12/1/15

to iDempiere

Hi Rizwan,

I'm trying to add LCO with holding with Idempiere 2.1, but it's not installing it properly (Able to add in Idempiere 1.x without any issues) and showing the following error stack.

As you have already deployed the same with 2.1, it ll be a great help if you can provide me a solution for this issue.

SEVERE: importXML:

java.lang.NumberFormatException: For input string: "IsWithholding"

at java.lang.NumberFormatException.forInputString(Unknown Source)

at java.lang.Integer.parseInt(Unknown Source)

at java.lang.Integer.<init>(Unknown Source)

at org.adempiere.pipo2.PoFiller.setInteger(PoFiller.java:112)

at org.adempiere.pipo2.PoFiller.autoFill(PoFiller.java:275)

at org.adempiere.pipo2.handler.ColumnElementHandler.startElement(ColumnElementHandler.java:73)

at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:226)

at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:234)

at org.adempiere.pipo2.PackInHandler.endElement(PackInHandler.java:303)

at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)

at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)

at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)

at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)

at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)

at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)

at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)

at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)

at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)

at javax.xml.parsers.SAXParser.parse(Unknown Source)

at org.adempiere.pipo2.PackIn.importXML(PackIn.java:168)

at org.adempiere.pipo2.PackIn.importXML(PackIn.java:131)

at org.adempiere.pipo2.PackInProcess.doIt(PackInProcess.java:132)

at org.compiere.process.SvrProcess.process(SvrProcess.java:198)

at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)

at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:172)

at org.compiere.apps.AbstractProcessCtl.startProcess(AbstractProcessCtl.java:466)

at org.compiere.apps.AbstractProcessCtl.run(AbstractProcessCtl.java:234)

at org.adempiere.webui.apps.WProcessCtl.process(WProcessCtl.java:170)

at org.adempiere.webui.apps.AbstractProcessDialog$ProcessDialogRunnable.doRun(AbstractProcessDialog.java:631)

at org.adempiere.util.ContextRunnable.run(ContextRunnable.java:38)

at org.adempiere.webui.apps.DesktopRunnable.run(DesktopRunnable.java:40)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Nov 30, 2015 6:04:06 PM org.adempiere.pipo2.PackIn importXML

SEVERE: importXML:

java.lang.RuntimeException: For input string: "IsWithholding"

at org.adempiere.pipo2.PackIn.importXML(PackIn.java:179)