How to create a SOD Group ID, Exclusion ID, and review the SOD Reports

Subject:

The steps here describe how to create a Segregation of Duties (SOD) Group ID, an Exclusion ID, and how to review the SOD reports.

Information:

These steps may be used in different scenarios, but the example here is specific to Payables Management.

We have already identified where there is a Segregation of Duty (SOD) conflict in Microsoft Dynamics GP.

  • Users who enter Payables Management transactions may not post the batch or create a payment.
  • Users who post Payables Management batches and create payments may not enter Payable Management transactions.

Create the SOD Group IDs

This may be done manually or by importing an existing Security Task. Importing the Security Task is efficient and helpful if you are basing your SOD on your Security Tasks.

Create Payable Transaction Group

  1. Go to Microsoft Dynamics GP | Tools | Setup | Auditor | Segregation of Duties Groups.
  2. Enter a Segregation Group ID and Segregation Group Description.
  3. In the Forms section, click + to add the windows to the PM TRX group.
  4. In the Resource Explorer window, expand Microsoft Dynamics GP and Purchasing.
  5. Click Payables Transaction Entry.
  6. In the Display column, click Main: Payables Transaction Entry.

  1. Click OK.
  2. Follow steps c-f again but select the following windows instead.
    • Edit Payables Transactions – Main: Edit Payables Transactions
    • Void Open Payables Transactions – Main: Void Open Payables Transactions

Note: Add any other windows you wish to include.

  1. Click Save.

Create Payables Post Group

  1.  Go to Microsoft Dynamics GP | Tools | Setup | Auditor | Segregation of Duties Groups.
  2. Enter a Segregation Group ID and Segregation Group Description for the first group. For example, PM POST and Payments and Posting.
  3. In the Forms section, click + to add the windows to the PM POST group.
  4. Expand Microsoft Dynamics GP  and Purchasing.
  5. Click Build Payment Batch.
  6. In the Display Column, click Main: Build Payment Batch.
  7. Click OK.
  8. Follow steps c-f again and select the following windows instead.
    • Edit Payment Batch – Main: Edit Payment Batch
    • Edit Vendor Payment – Main: Edit Vendor Payment
    • Payables Batch Entry – Main: Payable Batch Entry

Note: Add any other windows you wish to include.

  1. Click Save.

Create Segregation of Duty Conflict

  1. In the Segregation of Duties Group Maintenance window, select PM TRX Group ID.
  2. In the Mutual Exclusion section, click + to add a new exclusion.
  3. Click PM POST.
  4. Click Select to open the Exclusion Maintenance window.
  5. Enter an Exclusion ID and Description.

  1. Click OK.
  2. Click Save in the Segregation of Duties Group Maintenance window.
  3. Close the window to build the conflict group.

Print the SOD Report

By Exclusion ID

  1. Go to Microsoft Dynamics GP | Tools | Setup | Auditor | Segregation of Duties Groups.
  2. In the Segregation of Duties Group Maintenance window, click Print.
  3. In the Report field, select Exclusions with Segregation of Duties Conflicts Report to print by Exclusion ID.
  4. Click Print.
  5. Review the report to identify any conflicts and adjust security as necessary.

By User ID

  1. Go to Microsoft Dynamics GP | Tools | Setup | Auditor | Segregation of Duties Groups.
  2. In the Segregation of Duties Group Maintenance window, click Print.
  3. In the Report field, select User Segregation of Duties Conflicts Report to print by User ID.
  4. Click Print.
  5. Review the report to identify any conflicts and adjust security as necessary.

 

More Information:

You may use the Import Security Task function to create your SOD groups.

  1. Go to Auditor | Segregation of Duties Groups.
  2. Click Actions | Import Security Task and select the Security Task you wish to import.

Note: The Segregation Group ID is populated with the Security Task ID and may not be changed. You may change the Segregation Group Description.

  1. Click Save.

Related Content