Edit Report Template

Activity overview

Unified Glossary

Basics of using Ramco Enterprise series web page

Using online help

The “Edit Report Template” page appears.

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.

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.

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.

 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:

  • Formula content for TDS:

Total TDS Payable = s20+s30+s40+s50+s60 (where the variables represent the Tax Classes for TDS Payable)

  • Formula content for IVAT:

Total Input Credit = s20+s30 (where the variables represent Tax Categories, Local Purchases and Purchase Returns)

  • Formula content for CST:

Total Output Credit = s20+s30 (where the variables represent Tax Categories, Inter State Sales and Sales Returns)

  • Formula content for Service Tax:

Total Input Credit = s20+s30+s40+s50 (where the variables represent Tax Classes, Input Credit - Advertisement, Telephone etc.)

  • Formula content for Excise:

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.

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: