Select the “Edit Report Template” link under the “Taxation Reports” business component.
The “Edit Report Template” page appears.
Enter the following fields:
|
Report ID. |
A unique code identifying the report template that you want to modify. (Alphanumeric, 40). The entered report ID must be an existing ID. For the existing report ID, the Tax type, Tax community and Report type is defaulted with values for which that report id is created. |
The system displays the following:
|
Desc. |
A textual description of the report ID. |
Enter the following fields:
|
Tax Type |
Use the drop-down list box to select the tax type for which you want to modify the report template. The applicable tax types that are defined for the company in the “Company Parameter Setup” component will be available for selection. The system displays the first value by default on the launch of the page. |
|
Tax Community |
Use the drop-down list box to select the tax community for which you want to modify the report template. The valid tax community for the selected “Tax Type” which is defined in for the company in the “CPS” component will be available for selection. The system displays the first value by default on the launch of the page. |
|
Report Type |
Use the drop-down list box to select the report type for which you want to modify the report template. Based on the values selected in the “Tax Type” and “Tax Community” the report type values are available for selection. The system displays the first value by default on the launch of the page. Tax Register can be generated in two formats - Document level / line level tax details. |
Enter the following fields in the “Position Details” multiline:
|
Position No. |
The number identifying the position in which the position details appear in the report. (Integer). The position number must be unique for each row. The Position Number should be in the format 010, 020 etc. |
|
Position Desc. |
A textual description of the position number. (Alphanumeric, 100).For example, for Position 010, the description may be given as TDS Payable Details. |
|
Variable |
The value identifying the variable of the position number. (Alphanumeric, 20). The variable must be unique for each row. For example, for Position 010, the variable may be given as S10. |
|
Round Off |
Use the drop-down list box to select the rounded off total value of the report. You can select from "0.1","0.01","1","10","100","1000", "10,000", "100,000" and blank. The system displays blank by default on the launch of the page. |
Enter the following fields in the “Formula Details” multiline:
|
Position No. |
The number identifying the after position number in which the position details must appear in the report. (Integer). The after position number must exist for the report ID. |
|
Formula Id. |
The code identifying the formula ID of the formula that you want to use in the report. (Alphanumeric, 20). |
|
Desc. |
A textual description of the formula ID. (Alphanumeric, 150). |
|
Formula Content |
The value identifying the formula content of the formula that you want to use in the report. (Alphanumeric, 255). Formula Content may be given in the following manner:
Total TDS Payable = s20+s30+s40+s50+s60 (where the variables represent the Tax Classes for TDS Payable)
Total Input Credit = s20+s30 (where the variables represent Tax Categories, Local Purchases and Purchase Returns)
Total Output Credit = s20+s30 (where the variables represent Tax Categories, Inter State Sales and Sales Returns)
Total Input Credit = s20+s30+s40+s50 (where the variables represent Tax Classes, Input Credit - Advertisement, Telephone etc.)
Total Input Credit = s20+s30+s40+s50 (where the variables represent Tax Categories National Purchases, Sales Returns, Job Work Receipt etc.) |
|
Round Off |
Use the drop-down list box to select the rounded off total value of the report. You can select from "0.1","0.01","1","10","100","1000", "10,000", "100,000" and blank. The system displays blank by default on the launch of the page. |
Click the “Edit Report Id.” pushbutton to modify the report ID.
The system displays the following:
|
Created By |
The login ID of the user who created the report template. |
|
Created Date |
The date on which the report template was created. |
|
Last Modified By |
The login ID of the user who last modified the report template. |
|
Last Modified Date |
The date on which the report template was last modified. |
To proceed, carry out the following:
Select the “Maintain Position Mapping” link to maintain the position mapping of the report.