on 06-15-2009 6:47 PM
Hi,
Kindly guide me E-TDS quarterly return including Form 26Q and Form 27Q procedure including any configuration.
Regards,
Samrat
Edited by: Samrat Roy on Jun 22, 2009 1:13 PM
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Harika,
I have understood the process. I was cleared in upto TDS Certificate printout including J1INCHLN and J1INBANK. But our client uses ECC5 where table J_1IEWT_ACKN_N is not available and we are not able to maintain in SM30. Even tcode J1INQEFILE is not available in ECC5 which is J1INEFILE. There are few differences in layout between two versions. SAP has recommended to use two notes are 1172387 for J_1IEWT_ACKN and 1148361 both Acknowledgement and TDS return process. I have created the tcode J1INQEFILE under SE93 with programme name J_1I_QER_EFILE and saved in J1IN package. But these two notes are pending for apply and testing also.
You kindly tell me is it necessary to maintain all the fields in Withholding Tax data in J1INQEFILE like 'Section Code' and 'TDS Section'.
Regards,
Mr. Roy
Dear Samrat,
Yes it is mandatory to have business place and section code in a document. Even I have faced some issues for the same for which we had applied a support package. Apply the notes mentioned by SAP and test in the system.
The input parameters in J1INQEFILE which are mandatory are
Company Code
Deductor STatus: C or O
State:
TAN Number: same number which is assigned in the Section code configuration
Period: Q1(Quarter one), Q2, Q3 and Q4. This is the period for which you are executing the report. If just for testing purpose you want to run for only one month then enter the date range in the fiscal period and the quarter in which this paticular month would fall in "Period" field.
Business Place: For which you want to run the report.
Address Details: Fill mandatroy fileds
Responsible Persons Details: Taxation department head details
Output processing options: Here ALV list button is selected by default. Also select e-file generation button. Select presentation server and give a file name as mentioned below in the text file name and excel file name.
c:\<name of file>
c:\<name of the file>
Try as explained above. If you further have any doubts get back to me.
Regards
Harika
Dear Harika,
I have doubt in small you said to mention File name as .txt and .xls after choosing Presentation Server under Output Processing Options tab in J1INEFILE. You kindly tell me 3 excel files and one text file which will be generated from the report, if I choose one excel file or one text file, how it will save under one file after executing report ? Or shall I run the report 4 times separately after choosing the file one by one ?
Regards,
Samrat
Dear Samrat,
Sorry for the mistake. Its not the file name. Its the path. You have to give the path (folder) where the files generated would be stored in the system. You need not run the report thrice. It generate all 4 files at a time and temporarily store in the path you have mentioned. For example:
C:\ Samrat is the path (not folder), the files would be generated as follows:
Samrat Challan.xls, Samrat Deductee.xls, Samrat Deductor.xls, Samrat (text file).
After that, go to My computer , "C" drive and check for the files. These files shall be overwritten the next time if you run the report without changing the path in Output Processing details tab. Please try and let me know if you have any issue further.
Regards
Harika
Edited by: Harika Raj on Jun 25, 2009 11:01 AM
Dear Harika,
Ok. I understood. Though this step will come last. I have another little query to get proper report appearing in TDS Certificate and TDS return, Business Place and Section code must be mandatory field. In our client frst time they will implement TDS Certificate and Return Process. Lot of documents are missing from Section Code. If we update this Business Place and Section Code as BSEG_BUPLA and BSEG_SECCO by writing program, shall it may effect other tables apart from BSEG ?
Regards,
Samrat
Dear Harika,
Atlast our client's instruction we have started work regarding this issue. I need some clarification regarding TDS Certificate print out. "PAN NO. OF THE PAYEE' will come from Vendor Master. 'TAX DEDUCTION A/C OF THE DEDUCTOR' i.e, TAN No of the Company will come from Section Code's Search term under Address detail. 'PAN NO OF THE DEDUCTOR' i.e PAN NO of the Company, where I can put this Company PAN No which I need guide from your end.
Regards,
Samrat
Hi,
In company code global settings, you have a tab right at the top...Additional Data..if you click on that...one screen will be displayed where you can enter PAN No. of your compnay code. But remember to enter the correct PAN No. there means an actual existing PAN no. as system validates that..if you use dummy PAN no. J1INQEFILE will throw error files ..
Regards,
SAPFICO
Hi SAPFICO,
Thanks for your help. But I need one clarification which I have forgotten to mention in my previous post. Vendor PAN No must come from Vendor Master Record. Which field of Vendor Master I should use for Vendor PAN Number ? Is it CIN Master Maintenance tab and under Withholding Tax - PAN Field. Because this field says 'Specified Organization's PAN' or Tax Number 1 and Tax Number 2 under Tax Information that I need little clarification.
Regards,
Samrat
Hi SAPFICO,
Thanks. I need one clarifications which is mentioned below :
1> What is the actual function of Journal Voucher losses under EWT -Posting - India - Journal Vouchers - Specify GL A/Cs for
Journal Voucher Losses. Why journal voucher loss arrise ? Is it mandatory to keep provision for GL A/c as loss of Journal
Voucher for all Withholding tax type and withholding tax codes ?
Regards,
Samrat
Edited by: Samrat Roy on Jul 24, 2009 8:33 PM
Hi..
Before implementing E-TDS quarterly return it is found that TDS Certificate layout is being different in our client version is ECC 5 comparing with ECC 6. In ECC 5 FORM 16 is missing with Acknowledgement Number which is shown at present as "TDS Circle where Annual Return under section 206 is to be delivered". And other missing areas are TDS, surcharge, Education Cess, Total Tax Deposited, Cheque/DD No, BSR code of Bank Branch,. Kindly need your suggestions.
Regards,
Samrat
Edited by: Samrat Roy on Jul 28, 2009 9:10 PM
Dear Harika,
As per client instruction regrding this issue while I run Etds Quarterly retrun in J1INEFILE (Version ECC 5), no file is being generated and message shows as "No data has been selected for the given selection criteria". I have followed the stepe which you have instructed clearly. I have mentioned Company code, Deductor Status - O, ITD State Code - WB, Fiscal Period,Tan Number of Company, Section Code under E/WT Section Code, Mandatory fields under Statutory Signatory Details tab, Addess Detail fields, and finally under Output processing Options tab check ALV file generation and e-file generation, choose Presentation Server and mention the path under file name and execute. Nothing is generated.
Regards,
Samrat
Hi friends,
Kindly let me know during testing J1INEFILE(Quarterly - Etds Return) in Quality Server error msssge shows as "No data has been selected for the given selection criteria" . Message no shows : 8I066. Here version is ECC 5. After Remittance Challan and Bank challan Updata I am running Quarterly Etds Return.
Regards,
Samrat
Edited by: Samrat Roy on Aug 11, 2009 7:37 PM
Hi,
J1INQEFILE tcode is used in ECC 6. ECC 5 the tcode is J1INEFILE. This old version tcode J1INEFILE's screen is missing few fields comparing with ECC 6 tcode. In initial screen I have used all fields except Withholding Tax(classic) area i.e TDS Section and Business Area. Is it necessary to fill this area ? If it is require kindly let me know the config are of TDS section under withholding tax classic area which is not under Extended Withholding tax area. Beside I have filled the tabs are Statutory Signatory Details, Address Details and under Output Processing options tick ALV output, tick e-file generation, select Presentation Server and mention path under file name where four files will generate. Initial screen Fiscal Period is used in 1st August to till today i.e, 2nd Quarter.
Regards,
Samrat
Edited by: Samrat Roy on Aug 12, 2009 12:11 AM
J1inqefile
Fill the relevant data.
Once if you execute you will get 2 files one is having Deductor details and another one is having deducteee details.
J_1IEWT_ACKN_N
Maintain the Ack. No. in the above table. The same will be reflected in TDS certificate
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi BSR,
You are saying if I fill up all the informations under J1INQEFILE and execute two files will be generated automatically as Deductor Details and Deductee Details. Are they FORM 26Q i.e for sec 193, 194, 194C, 194D, 194G, 194H, 194I, 194J and FORM 27Q i.e for Sec195 for non resident ? In the screen there is a Deductor Status as two options are C and O. I think it should be 'C' And there is no separate configuration requiers for this operation ?
Regards,
Mr. Roy
Edited by: Samrat Roy on Jun 22, 2009 2:15 PM
User | Count |
---|---|
91 | |
11 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.