SQL Authentication

<< Click to Display Table of Contents >>

You are here:  Administration > Users > Web Only Reviewer > Through 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:
 
UsersSQLUserList-mh

 

2.Click Create New SQL Server Login.
 
The Create New SQL Login window displays:
 
UsersAddSQLUser-mh

 

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 make users in Sage Paperless Construction follow those restrictions when setting up a password.
 
The completed window should resemble the following:
 
UsersAddSQLUsercompleteWOU-mh
 

7.Click OK.
 
The Select SQL Login window similar to the following displays:
 
SelectSQLLoginwindowcompleteWOU-mh
 

8.Click to highlight the user's name.

9.Click Select Login.
 
The Add User Wizard window will display similar to the following:
 
AddUserWizard1of4WOU-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 address.

13.The Email Type field is defaulted with MAPI. If the field should reflect SMTP, use the dropdown to select it.

14.In the Phone Number field, enter the user's telephone number.

15.In the Number for Texts, enter the user's cell phone number to receive system-generated text messages.

16.Because this user will be a Web Only Reviewer, click to select the Web Only Reviewer check box.
 
The completed Add User Wizard window should resemble the following:
 
AddUserWizard1of3completeWOU-mh
 
 
Note that when the Web Only Reviewer check box is selected, this window undergoes a transformation.
 
This Add User Wizard window is now Step 1 of 3, not Step 1 of 4.
 
The following fields are no longer editable:
 
Basic Information pane
Login ID
 
Permissions pane
System Administrator
Scanner Administrator
Allow Annotation
 

17.Click Next.
 
The second Add User Wizard window similar to the following displays:
 
AddUserWizard2of3WOU-mh
 

18.Click the AP Reviewer check box.
 
Note: If more than one vault displays, scroll to the appropriate vault and click it to highlight, if appropriate.
 
The window should resemble the following:
 
AddUserWizard2of3activeselectionsWOU-mh
 

19.Determine the permissions for the user in the Web Only Review Role and click the appropriate check boxes.
 
Depending on the role assigned to the user, there are additional permissions which may be granted. These options are located at the bottom of the screen.
 
The Additional Options section heading includes this icon: ManageAPFlowGeneraltabgreencheckmarkicon-mh
 
If the user should have permission to perform all the options listed under the Web Only Reviewer Role, click the icon. All the options in that section will be selected.
If the user should have permission to perform some of the options, you must click the various options manually.
To remove options, you must manually click each appropriate option checkbox 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.

 

Web Only Reviewer

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, ApproveInvoicesPlaceOnHoldicon-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.

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 Limit

ReviewerApprovalLimit-mh

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

The number (38 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.

 

20.Click Next.
 
The final screen of the Add User Wizard window displays:
 
AddUserWizard3of3WOU-mh
 
This window displays a summary of all the settings selected or entered during the Add User Wizard setup for a Web Only Reviewer.

 

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

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

23.Click Finish to create the new Sage Paperless Construction Web Only Reviewer.
 
The following prompt displays:
 
AddUserWizardWOUprompt-mh
 

24.Click OK.
 
The first Add Web User Wizard window resembling the following systematically displays:
 
AddWebUserWizard1of5WOU-mh
 

25.Click the Department field label to display the Previous Department Values dialog box.
You can also use your lookup key (by default this is F4 but it can be configured). This is where the list of departments you have previously added will display.
If you need to add a new department, you can enter it in the Department field. The new department that you added will display on the Previous Department Values dialog box after the user is created.
In this field, you can type any value that you want to filter on.
 
WebUserPreviousDepartmentValuesdialog-mh
 
 
Note that there is a Filter text field where you can start to enter a value to narrow the list if necessary.
Click in the Department column header to sort the values.

 

Click here for details on navigating through the Add Web User Wizard windows to complete the Web Only Reviewer setup.