AP Invoice tax error

[Former Member]

hi ,

i am recieving the following error while posting an invoice :" tax amount must not be greater than the tax base".

please let me know what can be the issue.

thanks very much.

[Former Member]

these are the amount figures

tax amount : 878.88 USD

tax base amount : 14,794.45 USD

Gross amount : 15,673.33 USD

Unplanned delivery cost : 146.48 USD.

all the acc keys in FTXP for the tax code used in the invoice are maintained as 100%.

the tax amount is less than the tax base, so why is it giving the error.

please help as the invocie has immediate payment terms and needs to be posted.

thanks very much.

[Former Member]

In FTXP, please check to make sure "From Lvl" is 100. That is what I am referring to not the tax percentage rate.

Let's know if this helps.

Elias

[Former Member]

this is how it looks like in ftxp

Tax type AccKy Tax percent.rate Level Fr.level Cond.type

base amount 100 0 BASB

Calculated Call 105 0

Shared with G/L 200 0

A/P Sales Tax 1 Inv. NVV 100.000 210 100 XP1I

A/P Sales Tax 2 Inv. NVV 100.000 220 100 XP2I

A/P Sales Tax 3 Inv. NVV 100.000 230 100 XP3I

A/P Sales Tax 4 Inv. NVV 100.000 240 100 XP4I

A/P Sales Tax 5 Inv. NVV 100.000 250 100 XP5I

A/P Sales Tax 6 Inv. NVV 100.000 260 100 XP6I

[Former Member]

First of all you have not defined your tax procedure well. Where's your VST? Under base amount, you need to define VST where you specify the tax percentage rate. What you specified is ok but that's not all.

Give me about 10mins so I can give you the complete guide.

Elias

[Former Member]

Proceed as follows:

Navigation Path: SPRO --> IMG --> Financial Accounting Global Setings --> Tax on Sales & Purchases --> Basic Settings --> Check Calculation Procedure

1. Double Click on Define Condition Type

2. Copy one of the CTyp

3. Name it JVST. Next to JVST, type in your description. E.g.: A/P Sales 7%

5. Access Seq: Enter MWST

Under Control Data 1

1. Cond. class: D

2. Calculat.type: A

3. Cond. Category: 2

Under Changes which can be made

1. Check off item condition, amount/percent, value

2. Save your settings

3. Click on the back arrow twice

Next, double click on Define Procedures

1. Look for your country procedure and select it.

2. Double click on control data

3. In the pop-up screen, the first line you will see is the base amount BASB

4. Skip one row

5. Under CType: Use the drop down menu to select the JVST you created a short while ago.

6. Under Fro, enter 100. Now on the same row, enter VST under Acck

7. Next row, type subtotal under description. On the same row, check off the box Stat

8. Next row, type in subtotal again and check off the box under Stat

9. Next row, type in A/P Distributed and check off the box under Stat

10. Next row: ***********************************************************

Make sure you leave at least one row between the settings you just made above and the procedures that you specified exist now.

Save your settings.

Now, go back to transaction code: FTXP. The settings you've just made should show up there. Enter the tax rate there under Tax Percent. Rate. Please, please, this tax rate is not 100%. Enter the correct tax rate that your county or state charges for sales/purchases tax.

Let me know if this helped.

Thanks,

Elias

Edited by: Elias Akorli on Sep 30, 2009 9:29 PM

[Former Member]

Hmmm.......one would have thought that this guy will come back and say the solution did work for me or otherwise.

Thanks,

Elias

[Former Member]

Elias,

sorry got caught up in other issues, but this was very helpful and solved the problem.

thanks for you help.

[Former Member]

Please change your tax calculation procedure and make sure the for from level, the base is always 100. Adjust your tax percentage rates accordingly.

Elias

Edited by: Elias Akorli on Sep 30, 2009 4:32 PM