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.

Note:  The account codes used in these steps refer to those in the PK1 demonstration business unit.

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

  1. Select Event Profiles (EVP).
  2. Enter a new event profile code, click OK and create the new profile.
  3. Enter a description and click OK.
  4. Click Detail to display the Condition details.
  5. Click Create.
  6. Enter the following condition field details to define the If Function Code = Tax Reporting statement. You must press Enter or click OK 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.
  7. Click Create to add a new condition.
  8. 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

  9. Click Exit to return to the event profile header details.
  10. Click Exit again to leave the form.

Defining the rule set for the event profile

Note:  You must take care to enter each Decision Columns value in the correct column to set the rule actions correctly.
  1. Select Rule Sets (RST).
  2. Select the new event profile code you defined in the steps above.
  3. Enter a new rule set code, click OK and create a new rule set for the event profile.
  4. Enter a description for the rule set and click OK.
  5. Click Detail to display the rule set details.
  6. Click Create.
  7. Enter the following details to define the conditions that identify the gross accounts. Remember to press Enter or click OK 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).
    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.
    1. Identify the first gross account code in the range and click Create:
      Command Value 1 Operator Value 2 Decision Columns
      Select If. Select Account Code 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.
    2. Identify the last gross account code in the range and click Create:
      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.
  8. 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).
    1. Identify the first net account code in the range and click Insert, to insert this condition before the first Set statement:
      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 10000 Enter Y in the second decision column.
    2. Identify the final net account code in the range and click Insert:
      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 19999 Enter Y in the second decision column.
  9. 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).
    1. Identify the first tax account code in the range and click Insert, to insert this condition before the first Set statement:
      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 94000 Enter Y in the third decision column.
    2. Identify the final tax account code in the range and click Insert:
      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.
  10. 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.
    1. Enter the command to set the tax indicator for gross accounts as follows and click Create:
      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.
    2. Enter the command to set the tax indicator for net accounts as follows and click Create:
      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.
    3. Enter the command to set the tax indicator for tax accounts as follows and click Create:
      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.
  11. Click Exit to accept the commands and return to the rule set header details.
  12. Click Exit 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