Issue with execution of J1INCERT

[Former Member]

Dear All,

I have executed-J1INCHLN - Create Remittance Challan & the challan is updated.

Then executed -J1INBANK - Enter Bank Challan & the challan is also updated.

While executing J1INCERT - Print the system displays list contains no data.Where i did mistake i am not able to idetify.

Please suggest.

Rgds,

Durga.

[Former Member]

Hi... as per your issue

First note: Check the master data tds rates were maintained or not . and the new rates were updated in all the vendor master data or not

In EWT a field called business place is playing major roll. Please check that all the transactions should have business place. if some transactions do not have business place than it will not consider for challan posting.

1. Post invoice with TDS (importantly update the business place and section code)

2. Run J1INCHLN for monthly remittance to Govt.

3. Update J1INBANK for back challan updatation

Note : checked the table with_item and the bseg,bkpf tables.basically the j1incert picks/parses data from the with_item table(the program fetches all the data from bkpf and checks with with_item table and does some filtering and its shown in the certificate print)

4. Run J1INCERT to print the TDS Certificates

Note: Finally just look into your J1INCERT entering parameters screen, the problem lies in the paramaters most probably in dates only assuming all the required configuration has been correctly done

Also Please change the assigned form J_1IEWT_CERT to J_1IEWT_CERT_N

I hope it will helps you...please confirm

Regards

vamsi

[Former Member]

Hi Vamsi,

I have verified as you said.

1.invoice is posted with Business place & section codes

2.Remittence challan is getting updated & also bank challan.

3.changed the assigned form J_1IEWT_CERT to J_1IEWT_CERT_N

4.checked the table with_item and the bseg,bkpf tables.data are available

Even then also it is not printing.

Please suggest.

Rgds,

Durga.

[former_member600294]

checked the table with_item and the bseg,bkpf tables.data are available

internal challan no is also available in the above table.Even then it is not printing the certificate.

[Former Member]

Hi...

are you doing this senario first time..?

If yes... please check the follow steps

1. Activate Extended Withholding Tax

2. Assign Withholding Tax Types to Company Codes

3. Define Withholding Tax Keys

4. Check Recipient Types

5. Define Business Places

6.Assign Factory Calendars to Business Places

7.Define Withholding Tax Type for Invoice Posting

8. Define Withholding Tax Type for Payment Posting

9. Define Exchange Rate Type for Withholding Tax Type

10. Define Rounding Rule for Withholding Tax Type

11. Define Withholding Tax Codes

12. Define Accounts for Withholding Tax to be Paid Over

13. Define Accounts for Withholding Tax Offsetting Entry

14. Specify Document Type (Accounts Payable)

15.Maintain Number Groups

16. Maintain Number Ranges

17.Maintain Number Groups and SAPscript Forms

18.Maintain Number Ranges(T.code: J1INCT)

19.Define Minimum Amounts per Withholding Tax Code

20. Define Minimum Amounts per Withholding Tax Type

21. And go to SNRO maintain the Number ranges based on the Object name : J_1ICERT,J_1ICHLNNO,

In case if you have Aknowledgement No for TDS certificate update those no in the table : J_1IEWT_ACKN_NUM

Also please check the in vendor master records withholding tax Lable..wether it is tick or not

And let me know if you have any doubts and i hope it will helps

Regards

vamsi

[former_member600294]

Thanks Vamsi for your response.The steps 1-21 mentioned by you are already in place.

And in SNRO the Number ranges are already maintained based on the Object name : J_1ICERT,J_1ICHLNNO,

Kindly advice how to proceed further.

[Former Member]

Hai Vamsi,

Thanks for the update.

In SNRO number ranges are maintained with the objects you are mentioned...even then also it is not printing...

Please suggest...

Rgds.

Durga.