BAPI_ACC_DOCUMENT_POST and partially non-deductible VAT codes

[Former Member]

Hello,

Has anyone used the BAPI 'BAPI_ACC_DOCUMENT_POST' for Italian invoices before? I'm having an issue with partially non-deductible invoices (VAT 10% non-deductible 60%). So for this example:

100 EUR invoice (account 5080)

4 EUR VAT goes to the VAT account

6 EUR VAT goes back to the Expense account (5080)

Total invoice 106.00

Total VAT 4.00

When passed thru the BAPI it is creating an extra tax line on the invoice, which also creates an extra line in the VAT register.

Warranty (8601) 106.00 correct

Vendor (1960) 100.00- correct

VAT credit (2109) 4.00 correct

When I click on the Taxes box I see this:

Acct VAT amount Base Amount Tax rate

2109 4.00 100.00 4%

8601 6.00 100.00 0%

6.00 106.00 6% -

---

This line is messing everything up and we can't find where it's being created.

thanks

[Former Member]

Hello Sir,

We are trying to post a Non PO invoice coded with a Non Deductable Tax Code [V6]

using BAPI_ACC_DOCUMENT_POST and facing the exact same issue which you have reported earlier.

Can you please let me know how you resolved that issue?

Here are some details:

Conutry : Belgium

Tax Code: V6 Input VAT # 21% (50% Non Deductable)

Thanks and Regards,

Bandi Praveen.

[Former Member]

Hello,

I am also facing a somewhat similar issue. There is the scenario mentioned below:

There are certain Invoices where a part for the tax amount for the items can be recovered. I have provided an example below to understand the situation better:

The total invoice amount is 2048.18.

There are two lines:

a) Amount 1268.52 with 253.70 (20%) VAT

b) Amount 438.30 with 87.66 (20%) VAT

Total Tax: 341.36

Now, this invoice is entered like below:

Vendor Amount: 2048.18

a) Line One: 1268.52 + 126.85 = 1395.37 with a 0% tax (increasing the expense account cost)

b) Line Two: 438.30 with a 0% tax

c) Line Three with GL Account same as that of a tax GL account : Amount = 214.51 with Base Amount = 1072.55 with 20% tax (20% tax being calculated on the Base Amount 1072.55)

To handle this situation I tried two approaches and both have failed.

Approach 1:

a) Created vendor line with amount 2048.18

b) Created two GL lines with line amounts 1395.37 (N0 tax) and 438.30 (N0 tax) [ N0 tax code has 0% tax]

c) Create a tax line with line amount 214.51 with base amount 1072.55 with N1 tax code [N1 has 20% tax]

d) This gave an error u201CTax amount must not be greater than tax baseu201D

My understanding is, in this approach system is trying to get the total of the GL line amounts with tax code N1 for its base amount, instead of taking the base amount that has been passed in the Tax line. This total is of course 0.00 and there fore less than the tax amount and thus results in this error.

Approach 2:

a) Created vendor line with currency amount 2048.18

b) Created two GL lines with currency amounts 1395.37 (N0 tax) and 438.30 (N0 tax) [ N0 tax code has 0% tax]

c) Created the third GL lines with currency amount 214.51, base amount 1072.55 with N1 tax code [N1 has 20% tax]

d) The invoice got booked but when I open the Tax Data from FB02, I see the tax base amount as the line amount of the third line and the tax amount as 0.00

In this approach the third line got saved just like any other GL line where the base amount if passed cannot be more than the line amount. Thus the base amount for this third line defaulted to the line amount. The tax data is thus showing the tax amount as 0.00 as tax line does not exist.

It will be of great help if you can let us know how you resovled the issue..