Reprint of TDS Certificate in J1INREP from date and to date

[Former Member]

Dear Experts,

On 18.11.2008 We had taken the print out of TDS Certificates for Section 194C with from date 01.10.08 to 31.10.2008. Due to printer problem a series of TDS certificates could not be taken properly.

Now when we are taking the print out using J1INREP u201CFOR THE PERIODu201D is wrongly printed as the lowest and highest date of the document for which TDS was deducted. This date should be the 1st date of the period (01.10.2008) and last date of the period(31.10.2008) for which TDS deducted and deposited.

Regards,

Alok

[Former Member]

self solved

[former_member206396]

Hi Ram,

Did u use J_1I7_USEREXIT_CERTPRINT?

Can i hv the code?

i am having problem with the form and to dates.

Ram

[Former Member]

Hello Seetaramaiah,

I have exactly the same issue.

could you please tell me , how it got resolved.

[Former Member]

create an append strcture in tabel J_1IEWT_CERTIF_N

with fields zzfrom date and zzto date of type budat

know cretate an enhancement in user exit J_1I7_USEREXIT_CERTPRINT

and use this code

enhancement 1 zfrm_to_date_j1irep. "active version

" Explict Enhancepoint

" Objective: for saving from date & to date in table J_1IEWT_CERTIF_N and get the date's on TDS Certificate

" while reprinting TDS Certificate

*BREAK-POINT.

data : wa_withtab1 like with_item.

if sy-tcode eq 'J1INCERT'.

wa_j_1iewt_certif_n-zzfrom_date = from_date.

wa_j_1iewt_certif_n-zzto_date = to_date.

modify j_1iewt_certif_n from wa_j_1iewt_certif_n .

commit work and wait.

elseif sy-tcode eq 'J1INREP'.

wa_withtab1 = wa_withtab.

wa_j_1iewt_certif_n-bukrs = wa_withtab1-bukrs.

wa_j_1iewt_certif_n-gjahr = wa_withtab1-gjahr.

wa_j_1iewt_certif_n-ctnumber = wa_withtab1-ctnumber.

select single * from j_1iewt_certif_n

into wa_j_1iewt_certif_n

where bukrs = wa_j_1iewt_certif_n-bukrs "Company Code

and gjahr = wa_j_1iewt_certif_n-gjahr "Fiscal Year

and ctnumber = wa_j_1iewt_certif_n-ctnumber. "Withholding Tax Certificate Number

if sy-subrc = 0.

from_date = wa_j_1iewt_certif_n-zzfrom_date.

to_date = wa_j_1iewt_certif_n-zzto_date. "zpdate-high.

endif.

endif.

endenhancement.

$$-End: (1)----

---

$$

endfunction.