Adding Users - SQL Authentication

<< Click to Display Table of Contents >>

You are here:  Administration > Users > Standard Users > Adding Users >

Adding Users - SQL Authentication

This is the first Add User Wizard window:
 

AddUserWizard1of4

 

1.To set up a SQL Server Authenticated user, click SQL, AddUserWizard1of4SQL-mh.
 
The Select SQL Login window displays:
 
SQLUserList

 

2.Click Create New SQL Server Login.
 
The Create New SQL Login window displays:
 
AddSQLUser
 

3.In the Login field, type the new user's login name.

4.In the Password field, type the associated password.

5.In the Confirm Password field, reenter the associated password.

6.If appropriate and based on your company's standards, click the Enforce Password Policy check box (for SQL Server version 2005 or later).
 
If this check box is selected, the SQL server password policy is enforced. This is something the user sets up on their own in SQL and it is configurable. They can restrict it to whatever they want. For example, they can determine there is a minimum or maximum number of characters, that special characters are required as are upper and lower case characters, etc. All this check box does is read the restrictions from SQL that the client has set up and makes users in Sage Paperless Construction follow those restrictions when setting up a password.
 
The completed window should resemble the following:
 
UsersAddSQLUsercomplete-mh
 

7.Click OK.
 
The Select SQL Login window re-displays.
 
The newly added SQL user name should display in the Available Logins column similar to the following:
 
UsersSQLUserListwithAvailableLogin-mh
 

8.Click to highlight the new SQL user name in the Available Logins column.

9.Click Select Login.
 
The first Add User Wizard window re-displays with the Login ID field systematically populated.
 
UserSettingsblank-mh
 

10. In the First Name field, enter the user's first name.

11. In the Last Name field, enter the user's last name.

12. In the Email field, enter the user's email.

13. In the Email Type field, MAPI is the default. MAPI is appropriate if the company uses a MAPI-compliant email client such as MS Outlook.
If the company uses an external web-based email client such as Yahoo or Google Mail, select SMTP from the dropdown.
 
Note: SMTP email settings are located in the Administration screen, SMTP Configuration menu.

 

14. The Automatically try SMTP when MAPI unavailable check box should already be selected as the default. If not, click the check box so the system will attempt to email SMTP if the local email client cannot be reached.

15. In the Phone Number field, type the user's telephone number.

16. In the Number for Texts field, type the cell phone number of the user to take advantage of the text option in the Document Alerts feature.

17. Click the Create and Assign this User to a Queue check box to create a User Queue for this user.
 
Note: This check box should already be selected as the default.
 

18. If the newly added user will be a web only reviewer, click the Web Only Reviewer check box. Otherwise, leave this check box blank.

19. In the Permissions column, the following optional permissions may be assigned to the user as appropriate:
 
System Administrator - Gives the user full system administrator access. Warning:  Limit this permission to users who should have full security rights to every option in the system.
User Administrator - Gives the user permission to create new users within the vaults to which the User Administrator is also the Vault Administrator. Click here to read more about it.
Scanner Administrator - Allows the user to edit or set up scanner profiles for locally attached scanners.
Allow Annotation Burn In - Allows the user to "burn in", or make permanent, annotations to documents.
 
The completed Add User Wizard (Step 1 of 4) window should resemble the following:
 
UserSettingsFilled

 

20. Click Next.
 
The second Add User Wizard window displays:
 
AddUserWizard2of4
 
Important:  Every user must be associated with at least one Security Group.
 

21. Highlight the group(s) to which the user should be assigned.

22. Click the SelectFileGreenArrowButtonSmall icon to assign the user to the group(s).
 
The window should resemble the following:
 
AddUserWizard2of4complete-mh
 

23. Click Next.
 
The third Add User Wizard window displays:
 
AddUserWizard3of4
 
Notes:
 
If the APFlow™ Accounts Payable Invoice Workflow module was purchased, the APFlow™ Settings setup screen will displays.
This is where APFlow™ roles and permissions are assigned for the new user. Refer to APFlow™ Module for details.
If the APFlow™ Accounts Payable Invoice Workflow module was not purchased, this window does not display and the Add User Wizard consists of three screens.
 

Vault Filter

To locate a particular vault, begin typing the vault number or name in the Vault Filter field. This lists of vaults displaying in the grid will reflect the numbers or letters entered in this field.

AP Processor

Users assigned to this role enter and route accounts payable invoices to Reviewers for approval.

Each Processor is considered the "owner" of the invoice with work queues that track invoice status until invoices are exported to the bridged accounting system.

AP Reviewer

Reviewers have access to Approve Invoices where they view and approve invoices routed to them by AP Processors.

AP Supervisor

AP Supervisors can access the APFlow™ setup screens which include the Manage AP Flow setup screen as well as routing rule setup and Invoice Manager.

AP Supervisors also have access to all AP Processor queues.

AP Check Reviewer

This role gives a user rights to the AP Payment Manager module where payments, AP checks and associated invoice information can be reviewed.

AP Auditor

Reserved for auditors of the APFlow™ system.

Anyone assigned to this role is granted read-only access to the Invoice Manager screen.

This allows the auditor to access the APFlow™ system for auditing purposes but does not allow information to be changed.

 

Depending on the role(s) assigned to the user, there are additional permissions which may be granted. These options are located at the bottom of the screen.

Each Additional Options section heading includes this icon: ManageAPFlowGeneraltabgreencheckmarkicon-mh

If the user should have permission to perform all the options listed under a specific section, click the icon for that section. All the options in that section will be selected.

If the user should have permission to perform some of the options listed under a specific section, you must click the desired options manually.

To remove options, you must manually click each option check box individually to remove the checkmark.

Note:  A section, including the corresponding icon, will be disabled if the highlighted user does not have permission for the options displaying in that section.

 

General

Allow User Approval Alert

This allows Processors to add an Approval Alert to an invoice.

Allow User Vendor History

This allows a Processor access to view all documents in Vendor History for this vault.

This permission is user-specific and vault-specific. it is not vendor-specific or APFlow™ role-specific.

Processor Role

Allow Processor Approval

Gives a Processor the permission to approve an invoice without routing it to Reviewers.
If Reviewers are assigned to the invoice, the invoice will be marked Approved for each Reviewer.

An audit note will systematically be added to indicate that the invoice was "approved for xyz reviewer by abc processor".

If a Processor does not have this access, all invoices must be routed to the appropriate Reviewer(s) for approval.

Allow Processor Credit Card Import

Gives a Processor or Supervisor access to the Credit Card Importer.

Only Processors with this security right can import credit card transactions files to add the line items to an invoice that can then be coded and routed for approval and finally exported to their respective accounting systems.

Allow Processor Export

Gives a Processor access to the Export tab in the APFlow™ sidebar.
Click Export on the Invoice Manager screen or click Export Invoices on the APFlow™ Administration sidebar. There is also an Export icon on the Invoice Entry screen.

Only Processors with this security right can export approved invoices to their respective accounting system.

Allow Processor Reset For Edit

This controls whether or not the Reset For Edit button is enabled on the Invoice Manager screen.
 
Note:  Supervisor rights can override.

Allow Processor Override Route Group

Gives a Processor the ability to choose an alternative routing group or to turn off the default routing rules and route an invoice manually.

Allow Processor Delete Invoice

Gives a Processor the ability to delete an invoice that is still in the system and not yet exported.

Allow Processor Add Vendor

This allows Processors to add a vendor into their accounting system from the Invoice Entry screen.

Not all systems support this functionality.

Allow Processor DocRoute™

If selected, the DocRoute™ icon displays on the Invoice Entry toolbar.

If not selected, the DocRoute™ icon is not visible on the Invoice Entry toolbar.
 
Note: This does not turn the DocRoute™ module on or off.

Reviewer Role

Allow Reviewer Multi Select

Allows a Reviewer to select more than one invoice in their queue at a time and approve or take other action on the selected invoices all at once.

If this option is not allowed, the Reviewer must take action on each invoice individually.

Allow Reviewer Change Line Type

Allows a Reviewer to change the line type of an invoice in Approve Invoices.

In Approve Invoices, Reviewers can click the Change Line Type icon, ChangeLineType-lineicon-mh, located on the invoice line needing to be changed.

This feature allows a Reviewer to change any line type to any other available line type.

Allow Reviewer Split Invoice Lines

In Approve Invoices, Reviewers can click the Split Line icon, SplitLine-lineicon-mh, located on the invoice line needing to be split.

Use this function to "break out" invoice line amounts into additional lines than were originally assigned.

The amount of the invoice sent to the Reviewer by the Processor must be allocated fully before any changes can be saved.

Allow Reviewer Invoice Hold

Gives the Reviewer the ability to place an invoice on hold through the Place On Hold icon, PlaceOnHoldicon-mh, located on the Approve Invoices toolbar.

This is based on the bridged system.

Allow Reviewer Reroute Invoice

Enables the Route Invoice icon, RouteInvoiceicon-mh, in Approve Invoices.

Allow Reviewer Edit Invoice

Gives the Reviewer the permission to make changes to an invoice.

The Edit Invoice button, EditInvoicebutton-mh, displays on the Approve Invoices screen in the lower right corner.

Allow Reviewer Invoice Manager

Gives the Reviewer Invoice Manager permissions without having to give Processor permissions.

Auto-Open Main Viewer

Systematically opens an image in the main viewer every time an invoice is highlighted.

Auto-Open Document Match

Opens the Document Match screen every time a new invoice is highlighted.

This way, the Reviewer always sees the invoice and the Document Match window without having to click on the Document Match icon.

Invoice Routing

Invoice Routing Default Sequence

The number entered here identifies in what sequence the document should be reviewed. This would be the default.

The lowest number gets the invoice first.

Accounting System Mapping

Must be a Reviewer.

Uses the accounting system routing rules option in some accounting systems. (Advanced bridge setting must be set.)

Follows the accounting system routing and displays it in Sage Paperless Construction.

Reviewer Approval Limits

ReviewerApprovalLimit-mh

This identifies a specific Reviewer selected in the associated Lookup Utility.

The number (1 in the example) reflects the arbitrary number that the Reviewer was assigned when originally added to the Reviewer list.

The Reviewer's name displays below the number.

The Sequence number (4 in the example) indicates in what order the Reviewer should see invoices.

Any invoice with a total exceeding the entered dollar amount ($10,000.00 in the example) will systematically be routed to the identified Reviewer.

 
A completed Add User Wizard (Step 3 of 4) window should resemble the following:
 
AddUserWizard3of4complete-mh
 

24. Click Next.
 
The final Add User Wizard window displays:
 
AddUserWizard4of4
 
This window displays a summary of all the settings selected or entered during the Add User Wizard setup.
 

25. Review the information in the Summary portion of this screen.

26. If any of the information is incorrect, click Back to make necessary corrections and then return to this screen.

27. Click Finish to create the new Sage Paperless Construction user.