TDS amount is posted in particular G/L account. You check the particular TDS G/L account.
Dear,
Check whether the filed WT_QBSHH is added to your Payment advice or not.
You need to check with your ABAPER
Table name is - WITH_ITEM
Thanks
HI freinds..
Payment advice based clearing doc. but vendor clearing table name bsak,this table data will be stored.
i check this table not showing tds amount? is any user exit or functional module?
HI Friend
May be you have posted TDS at the time of Invoice , so that an entry is generated at the time of Invoice entry for the TDS deducted for the vendor. If you wanted to mention this amount at the time of Payment Advice please book the invoice and assign TDS code for deducting at the time of Payment. in this case the TDS entry will shown at the time of payment advice note
HI Freiend..
vendot all clearing data stored in bsak table.i will check table .not showing tds amount,How to logic explain the abap?
Table name is - WITH_ITEM
but system pick data from bsak vendor clearing table? how to pick this
Table name is - WITH_ITEM
As per the standard functionality withholding tax deductions is not printed in the payment advice for invoice time tax type.
In your case if you use withholding tax type for invoice posting, please note the following information with example which is helpful for further understanding.
Payment medium program such as RFFO* programs extracts the invoice & payment information from the payment data tables REGU* to print the payment advice. REGU* tables are updated at the time of payment.
Let's consider an example:
Step 1:
We have a vendor invoice created for which EWT is calculated at the time
of invoice. In the below invoice it is clear that outstanding amount on
vendor account for example "INV06_RI" is 9,506.00.
Invoice Document no: 1900000180
PK Account Account short text Amount
31 INV06_RI Test for EWT - Raj 9,506.00-
40 119100 INterest Expense 9,750.00
50 177000 Withholding tax 205.00-
50 177000 Withholding tax 39.00-
Step 2:
When you carry out the payment for the above invoice and assume that EWT is not relevant at the time of payment.
Payment document no: 1500000123
PK Account Account short text Amount
50 113100 Bank 1 (domestic) 9,506.00-
25 INV06_RI Test for EWT - Raj 9,506.00
Step 3:
Print the payment advice which will have the below information.
Document Date Deductions Gross amount
1900000180 18.05.2006 0.00 9,506.00
Payment doc Check number Date Curr Payment amount
1500000123 100002 19.05.2006 INR 9,506.00
As per the system design the amounts shown up for the invoice document in the payment advice are correct. The reason for this is payment program only extracts the necessary information from invoice document for outstanding amount on the vendor item but not the whole document. Since this is the amount to be paid to vendor.
So I recommend you to inform your vendor at the time of creation of invoice about the EWT deductions calculated. You can check and use transaction J1INCERT to print certificate to send it to vendor. So that Vendor expects the payment amount of 9,506.00.
Hope this helps,
Kind Regards
Soumya
hello
all,
i 'm abaper, i solved this issue.
for tds amount we can find in bsak table from where we can get tds amount.
we called a subroutine to get data into sap script.
assign points
Hi Madhu,
In BSAK table take BELNR ( Payment document number) & Pass the same in BSAK again as AUGBL number and right logic take line items if BELNR not equal to AUGBL numbers line items and Pass the same BELNR number in to WT_ITEM table and You can get With holding base and tax amounts.
Rgds
Mani
