Invoice Vendor clearing with round ammount difference

[Leszek Bober]

Hi All,

How to account for a purchase invoice (taxes, payments, posting) when on the source document the gross value differ by EUR 0.01 of the document   versus the gross amount on the tax summary in iD.

Sometimes there are differences of EUR 0.01 - 0.08 from rounding in the calculation of taxes.

How to account for this invoice to:

1. the invoice posting is correct

2. BPartner has received correct amount (payment transfer export to the bank)

3. the invoice in iD is paid (despite the difference of 0.01)

Regards

Leszek Bober

[Carlos Antonio Ruiz Gomez]

What I always do to avoid this is to set the taxes to calculate at line
level.

Taxes at document level are a big source for these rounding issues.

Regards,

Carlos Ruiz



El 13/10/21 a las 9:44, Leszek Bober escribió:

> --

[Leszek Bober]

Thanks Carlos, it's a very good solution.

[Marco Longo]

Hi Leszek,

about VAT tax inside  UE and therefore also for Poland  as i Know is  calculated at Document and not on Line Level.

iDempiere support specific case that needs to be  calculated on line level but you could have some difference as you mentioned.

Marco Longo

https://idempiere.consulting

[Leszek Bober]

Thanks Marco,

We implementing a little workarround for this case:

If on AP Invoice are differences, for this invoice we uncheck "Document Level" for purchase tax conf.

After complete we come back Document level to Y.

Postings are correct.

Regards

Leszek Bober

[Martin Schönbeck]

Hi Leszek,

we had the problem, too, with different vendors. Some of them calculate on line level, some on document level. My solution was to prepare to different tax entries. Of course this requires to assign those entries on the line level. An ideal solution (for me) would be override the default calculation method at business partner level in the vendor area.

Regards,

Martin

[Norbert Bede]

hello everyone !

we implemented a isFixedTaxAmt checkbox on c_invoiceline. 

When tax module calculate a specific amount, this amt different to your vendor tax amt, then bookeeper simle select Fixed Tax Amt checkbox, enter TaxAmt (vat), and idempiere force vat calcuation. 

This way tax differences can be eliminated. IMO, this or similar solution is necessary in idempiere base.

wdyt ?

norbert

[Martin Schönbeck]

Hi Norbert,

+1

and as it doesn't change anything if not checked, it's fully downward compatible. So no reason not to put it in core. I can't count how often I entered the correct tax amount only to see that it was reacalculated at doc level.

Regards,

Martin

[Leszek Bober]

Thanks for All, Guys

Base solution (from Carlos post) was tested and works perfectly.

Norbert's solution sounds "sexy" but I'm think so "under isFixedTaxAmt" was a callout or plugin that force change "document level" checkbox in tax and force recalculate document and came back "document level" checkbox.
Am I right, Norbert?

[Norbert Bede]

hi,

i tried to find it in code (i'm not developer)

the idea is - sales invoice line behaviour is not  changed, when taxamt is not entered manually, then system calculate the tax based on regular tax setup.

MInvoiceLine.java around line 1100..

// TaxAmt recalculations should be done if the TaxAmt is zero

// or this is an Invoice(Customer) - teo_sarca, globalqss [ 1686773 ]

// CLDE - Allow Tax Change for IsSOTrx Invoices. Documents

if (!isFixedTaxAmt() && (m_IsSOTrx || getTaxAmt().compareTo(Env.ZERO) == 0))

setTaxAmt();

//

This is only small snippet, not sure this is the full change. just for illustration.

[Carlos Antonio Ruiz Gomez]

Hi sorry to jump a bit late (I was on holidays).

I'm not sure I understand the problem.

In Invoice (Vendor) the system calculates a tax, but I'm able to change it and when saved the change is preserved, same when completing.

So, I'm not sure where is the problem, can you please describe a problematic case where the tax cannot be edited, or is recalculated after edited?

Regards,

Carlos Ruiz

El 20/10/21 a las 19:41, Norbert Bede escribió:

--

[Norbert Bede]

hi Carlos,

i did some test in latest demo. i created a use case with 10 usd + 5%. Idempiere calculates 0.50 TaxAmt. 

I change 0.5 to 0.51, override working (this doesn't work before i assume this was the reason why we did changes around v3.1)

I discovered a bug, c_invoicetax base 10USD, Tax 0.50 (instead 0.51)  The proper taxamt in c_invoicetax 0.51.

norbert

[Carlos Antonio Ruiz Gomez]

I just tested in demo and test and the invoice tax tab is updating coirrectly.

Regards,

Carlos Ruiz

El 21/10/21 a las 18:47, Norbert Bede escribió:

[Norbert Bede]

Hello Carlos,

if you have some minutes you can click here.

https://test.idempiere.org/webui/index.zul?Action=Zoom&AD_Table_ID=318&Record_ID=1000001

i re-created my use case.

norbert

[Carlos Antonio Ruiz Gomez]

Yes, because the tax is calculated at document level, I understand that is OK - when tax is calculated at document level, then it doesn't matter what you put in line level, it must be recalculated at the end.

Regards,

Carlos Ruiz

El 22/10/21 a las 12:17, Norbert Bede escribió:

--

[Martin Schönbeck]

Hi,

for me it works as required if I use different tax entries for calculation at document level and at line level. And when using calculation at line level I can change the automatically calculated tax value and it will be respected on document level. Only when calculating at document level my changes at line level are ignored, but that is what calculation at document level requires.

Regards,

Martin