Setting up the business rules for Tax Reporting
You must define a business rule for the Tax Reporting reports. The rule sets the tax indicator that allows the tax reports to distinguish between the gross, net and tax transactions. The business rule must identify the gross, net and tax account codes within your chart of accounts.
You must create an event profile for the Tax Reporting function. You must then define a rule set for this profile that sets the Gross/Net/Tax indicator on each transaction to Gross, Net or Tax for the account ranges identified:
Account Code Ranges | Set Indicator |
64001 to 64999 (Debtor accounts) | Gross |
10000 to 19999 (Income accounts) | Net |
94000 to 94999 (Tax accounts) | Tax |
Creating the Event Profile
- Select Event Profiles (EVP).
- Enter a new event profile code, click and create the new profile.
- Enter a description and click .
- Click to display the Condition details.
- Click .
- Enter the following
condition field details to define the
'If Function Code = Tax Reporting'
statement. You must press or click after each field to accept the information.Command Data Item field Operator Date or Value Item Select If. Select Function Code from the Rule Common Fields hierarchy. Select =. Select Tax Reporting from the Financials option on the data dictionary lookup. - Click to add a new condition.
- Enter the following
condition to define the 'If Call Point = Start of Session'
statement.
Command Data Item field Operator Date or Value Item Select If. Select Call Point from the Rule Common Fields hierarchy. Select =. Select Start of Session from the options available. The event profile should now contain the following statements at the bottom of the window:
If Function Code = Tax Reporting
If Call Point = Start of Session
- Click to return to the event profile header details.
- Click again to leave the form.
Defining the rule set for the event profile
- Select Rule Sets (RST).
- Select the new event profile code you defined in the steps above.
- Enter a new rule set code, click and create a new rule set for the event profile.
- Enter a description for the rule set and click .
- Click to display the rule set details.
- Click .
- Enter the following details
to define the conditions that identify the gross accounts. Remember to press
Note: The account codes referenced in the following steps relate to the PK1 demonstration business unit. You will need to adapt these steps to identify the gross, net and tax accounts in your chart of accounts.
- Identify the first
gross account code in the range and click
Command Value 1 Operator Value 2 Decision Columns Select If. Select from the Interface Table option on the Function Data hierarchy.Note: You could select this field, or another field from the Ledger Entry Journal Line Details table.Select >=. Enter 64000 Enter Y in the first decision column.
:
- Identify the last
gross account code in the range and click
Command Value 1 Operator Value 2 Decision Columns Select If. Select Account Code from the Interface Table option on the Function Data hierarchy. Select <=. Enter 65000 Enter Y in the first decision column.
:
or click after each individual field.
These conditions apply to decision column 1. The action that is carried out for this
decision column i.e. to set the tax indicator to Gross, is defined later in step 10
(i).
- Identify the first
gross account code in the range and click
- Enter the following
details to define the conditions that identify the net accounts. These
conditions apply to decision column 2. The action that is carried out for this
decision column i.e. to set the tax indicator to Net, is defined later in step
10 (ii).
- Identify the first
net account code in the range and click
Command Value 1 Operator Value 2 Decision Columns Select If. Select from the Interface Table option on the Function Data hierarchy.Select >=. Enter 10000 Enter Y in the second decision column.
, to insert this condition before the first Set
statement:
- Identify the final
net account code in the range and click
Command Value 1 Operator Value 2 Decision Columns Select If. Select from the Interface Table option on the Function Data hierarchy.Select <=. Enter 19999 Enter Y in the second decision column.
:
- Identify the first
net account code in the range and click
- Enter the following
details to define the conditions that identify for the tax accounts. These
conditions apply to decision column 3. The action that is carried out for this
decision column i.e. to set the tax indicator to Tax, is defined later in step
10 (iii).
- Identify the first
tax account code in the range and click
Command Value 1 Operator Value 2 Decision Columns Select If. Select from the Interface Table option on the Function Data hierarchy.Select >=. Enter 94000 Enter Y in the third decision column.
, to insert this condition before the first Set
statement:
- Identify the final
tax account code in the range and click
Command Value 1 Operator Value 2 Decision Columns Select If. Select Account Code from the Interface Table option on the Function Data hierarchy. Select <=. Enter 94999 Enter Y in the third decision column.
:
- Identify the first
tax account code in the range and click
- Enter the following
commands to set the tax indicator correctly for the gross/net/tax accounts. The
different types of account are identified by the decision columns identified
above.
- Enter the command to
set the tax indicator for gross accounts as follows and click
Command Value 1 Value 2 Decision Columns Select Set. Select Gross/Net/Tax from the Interface Table option on the Function Data hierarchy. Select 00001 Gross. Enter X in the first decision column.
:
- Enter the command to
set the tax indicator for net accounts as follows and click
Command Value 1 Value 2 Decision Columns Select Set. Select Gross/Net/Tax from the Interface Table option on the Function Data hierarchy. Select 00002 Net. Enter X in the second decision column.
:
- Enter the command to
set the tax indicator for tax accounts as follows and click
Command Value 1 Value 2 Decision Columns Select Set. Select Gross/Net/Tax from the Interface Table option on the Function Data hierarchy. Select 00003 Tax. Enter X in the third decision column.
:
- Enter the command to
set the tax indicator for gross accounts as follows and click
- Click to accept the commands and return to the rule set header details.
- Click to leave the form.
When you have added all of the rule set commands, the grid at the bottom of the window should look like this:
Command | Value 1 | Rule Operator | Value 2 | Rule Action 1 | Rule Action 2 | Rule Action 3 |
If | Account Code | >= | 64000 | Y | ||
If | Account Code | <= | 64999 | Y | ||
If | Account Code | >= | 10000 | Y | ||
If | Account Code | <= | 19999 | Y | ||
If | Account Code | >= | 94000 | Y | ||
If | Account Code | <= | 94999 | Y | ||
Set | Gross/Net/Tax | Gross | X | |||
Set | Gross/Net/Tax | Net | X | |||
Set | Gross/Net/Tax | Tax | X |