20 Replies Latest reply: Aug 1, 2012 1:01 PM by Ram Kumar Swami RSS

E-TDS quarterly return procedure

Samrat Roy
Currently Being Moderated

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

  • Re: E-TDS quarterly return procedure
    SR B
    Currently Being Moderated

    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

    • Re: E-TDS quarterly return procedure
      Samrat Roy
      Currently Being Moderated

      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

  • This reply has been hidden. This can happen if the message has been hidden by a moderator, or has been reported as abusive.
    • Re: E-TDS quarterly return procedure
      Samrat Roy
      Currently Being Moderated

      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

      • Re: E-TDS quarterly return procedure
        H R S
        Currently Being Moderated

        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

        • Re: E-TDS quarterly return procedure
          Samrat Roy
          Currently Being Moderated

          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

          • Re: E-TDS quarterly return procedure
            H R S
            Currently Being Moderated

            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

            • Re: E-TDS quarterly return procedure
              Samrat Roy
              Currently Being Moderated

              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

              • Re: E-TDS quarterly return procedure
                H R S
                Currently Being Moderated

                Dear Samrat,

                 

                No, the program doent affect other tables. Writing an ABAP program to update Business Place & section code is infact recommended by SAP itself as currently there is no SAP delivered transaction available to carry it out.

                 

                You can check the same with SAP also.

                 

                Regards

                Harika

                • Re: E-TDS quarterly return procedure
                  Samrat Roy
                  Currently Being Moderated

                  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

                  • Re: E-TDS quarterly return procedure
                    Kavita Agarwal
                    Currently Being Moderated

                    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

                    • Re: E-TDS quarterly return procedure
                      Samrat Roy
                      Currently Being Moderated

                      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

                      • Re: E-TDS quarterly return procedure
                        Kavita Agarwal
                        Currently Being Moderated

                        Hi,

                         

                        The Vendor PAN no. must come from CIN maintenance tab in vendor master data and not from tax no. 1 & 2 field.

                         

                        You can also go to t-code J1iD and maintain Vendor pan No.. Both will update the same table.. J_1IPANNO.

                         

                         

                        Regards,

                         

                        SAPFICO

                        • Re: E-TDS quarterly return procedure
                          Samrat Roy
                          Currently Being Moderated

                          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

                • Re: E-TDS quarterly return procedure
                  Samrat Roy
                  Currently Being Moderated

                  Hi,

                   

                  While Creating Remittance Challan on ECC 5 error shows as "Number key not found" with messge no. 8I705.

                   

                   

                  Regards,

                  Samrat

                   

                  Edited by: Samrat Roy on Jul 26, 2009 1:35 PM

                • Re: E-TDS quarterly return procedure
                  Samrat Roy
                  Currently Being Moderated

                  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

            • Re: E-TDS quarterly return procedure
              Samrat Roy
              Currently Being Moderated

              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

              • Re: E-TDS quarterly return procedure
                Samrat Roy
                Currently Being Moderated

                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

                • Re: E-TDS quarterly return procedure
                  SAI  KRISHNA VALLURUPALLI
                  Currently Being Moderated

                  your in which support level in ECC5?

                  have you given correct input during execution of J1INQEFILE?

                  • Re: E-TDS quarterly return procedure
                    Samrat Roy
                    Currently Being Moderated

                    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

Actions

Incoming Links