table that stores withholding tax upon payment

[Former Member]

Hello

We created a customer invoice with withholding tax type/ code that is configured to be deductible upon customer payment.

WITH_ITEM table does store only withholding tax base amount but not the tax amount.

I need to bring the withholding tax amount in one of the Z report. which table should we read?

Thanks

Rakesh

[Former Member]

Hi Rakesh,

As you said that you have defined WHT at the time of payment posting, so WHT calculation would happen during payment posting and you would be able to see WHT amount in payment document in WITH_ITEM table.

There would be no WHT amount calculation for invoice so no WHT amount in WITH_ITEM table for invoice document number.

Thanks and Regards,

Gaurav

[Former Member]

Hi Rakesh,

With_item is one table which stores all info regarding the Witholding taxes and  the field Witholding tax amount is also available in With_item table and the technical name is WT_QBSHH.

Regards,

Kavita

[Former Member]

Dear Kavita

We have configured w.tax type as upon customer payment. we selected this w.tax type and code at the time of invoice. Now when I go to table WITH_ITEM, it shows the withholding tax base amount but not the withholding tax amount.

Can you pls check this behaviour in your system and revert?

Thanks

Rakesh