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) in SunSystems.
  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