W/H tax amount wrong

[Former Member]

we use payment based W/H tax, we record vendor invoice 107 USD expense account 100 USD, 7 USD for VAT, 107 USD is credit AP

when we do payment, we

Cr bank 103.79

Cr: W/H tax 107*3%=3.21 USD

Dr AP  107

but tax law says W/H tax should be based on 100 USD, thus Cr: W/H tax should be 3 USD not 3.21 USD, I have tried so many times, can't get 3 USD, any configuration i need to change?

[former_member207607]

Dear Agus,

I'd suggest You simply to insert manually the wt amount into Your invoice, into the vendor line item, into the WT pop up. Then when You will do the payment, the WT amount will be 3 as requested.

Thanks.

mauri

[Former Member]

how to insert manually the wt amount into Your invoice?

in vendor invoice, system should generate GST not W/H tax, because W/H tax only generates at payment

[narasimhulu_konnipati]

If the t-codes are FB60 or MIRO, you will get the Withholding tax tab. If you go into it, you will find the Base amount filed for WHT amount calculation. Keep 100 and save it and try to post.

Try this, but this is not a permanent solution

[former_member207607]

You can enter Your invoice number by FB02 --> go into the Vendor line item --> double click --> push the button withholding tax and insert manually the WT amount into the field ACWT_ITEM-WT_QBSHB

(Withholding tax amount in document currency).

Then doing the payment such amount will be considered (System will not overwrite the WT amount inserted manually).

Thanks.

Mauri

[Former Member]

we can't accept this workaround solution

[Former Member]

we want automatic, no manual. I'm asking design, this is support workaround solution

[former_member207607]

Dear Agus,

You have two ways to calculate the WT amount:

1. automatically by the System on the base of the wt base amount and the percentage

2. manually inserting exactly the amount You need the System to calculate.

I hope this helps.

Mauri

[former_member207607]

Dear Agus,

107*3%=3.21

The System calculates the WT amount on the base of the WT base amount and a percentage.

The 3% of 107 can be never 3.

Please take in consideration the rounding  rules of Your relevant wt type and try to test the following:

do an entry into V_T001RWT table for Your relevant wt type with the Unit 100.

All the wt amount as per example 123,56 will be rounded to 123 or 124 depending on the rounding rule (commercial, up, down) defined into the wt type  level.

I hope this can help.

Mauri

[Former Member]

No, if my invoice is 1000000 USD, apply W/H tax on 1000000 and 1007000 is totally different, it is not rounding issue

[former_member207607]

Dear Agus,

therefore I'm sorry but to get Your goal You should only insert the wt amount manually.

Thanks.

mauri