Setting Up User Defined Tax Reporting

Tax Reporting (TXR) uses the following SunSystems facilities to produce the standard tax reports delivered with the system:

  • Document formats to identify the tax reports
  • Filters to extract the gross, net or tax transactions for the report
  • Rule sets to be able to distinguish between gross, net and tax transactions

You can use Report Designer to define your own tax reports. You need to consider how the report identifies, extracts and analyzes the appropriate tax related transactions.

You must define:

  • The report using Report Designer.
  • A document format for the report using Document Format (DFS).
  • The tax filters required to extract the transactions for the report using Filter Designer (FLD).
  • Any user defined selection criteria input forms to support the tax filters using Form Designer (FRD).
  • Any business rules required to analyze the transactions using Business Rules.

Defining the Filters

You should use filters to extract the tax report transactions for the tax report. You can use more than one filter to select the transactions you need.

The standard tax reports use a single filter to extract only one type of transaction, gross, net or tax. The document format Offset facility is used to extract the other two types of transaction.

You could define three separate filters to extract the gross, net and tax transactions independently. If so, all three filters must be linked to the tax report document format using Document Format (DFS) and the Offset option would not be set.

Each filter is run separately and displays the selected transaction on a control desk. As the user selects the transactions they want to include on the report they are added to a separate interface table until the report is produced.

Once the user has selected transactions using all of the filters, the total number of transactions held on the interface table is displayed and the user can then choose to produce the report.

Defining the Business Rules

The standard tax reports analyze the selected transactions into three value columns on the report: Gross, Net and Tax, based on the Gross/Net/Tax indicator that is available on each transaction held on the interface table.

The Gross/Net/Tax indicator for each transaction is set by a business rule that must be established for tax reporting purposes. You should define business rules to set this Gross/Net/Tax indicator according to your own report requirements. For information on how the standard SunSystems tax reports use this indicator, see 'Setting Up the Standard Tax Reports'.

User Defined Transaction Classifications

In addition to the Gross/Net/Tax indicator, each transaction on the interface table contains an additional ten classification code fields. Each classification code can contain up to 15 characters.

You can use these codes to analyze the tax reporting transactions in different ways. You must define business rules to set these codes, and then use the Report Manager (RMA) to analyze and report on the transactions.

For example, you may want to produce a report which separates the net value into different columns depending on the type of tax rate. In this case you could use classification code 1 to group together your tax rates as required. For example, grouping transactions for tax codes V04, V07 and V16 as 'Standard Rates', transactions with tax codes A04, A07 and A16 as 'Self Supply Rates', and transactions with rate code VEX as 'Export Rates'. You could then set up a report that prints separate columns for gross and tax based on the Gross/Net/Tax indicator, and extra columns for each different type of net total, depending on the Gross/Net/Tax indicator and Classification Code 1 field values.