Configuring the Database Connections for Vertex Quantum Tax Applications
To configure Release 9.2 database connections to use the Vertex Quantum applications:
In the Fast Path field, enter G731 to access Vertex Quantum Tax Processing.
The Vertex Quantum Tax Processing panel appears.
Highlight and right-click the Database Connections (P7308) program.
A context menu appears.
On the context menu, select Prompt for Values.
The Processing Options dialog appears.
On Processing Options, click the Quantum tab and enter the following information:
Option #1: Enter which Vertex Quantum applications are installed:
Value
Action
[blank]
Install both Vertex Quantum tax applications.
1
Install the Vertex Quantum for Sales and Use Tax application.
2
Install the Vertex Quantum for Payroll Tax application.
Option #2: Enter location information for the databases:
Value
Action
[blank]
Define databases for both Vertex Quantum tax applications in the same location.
1
Define databases for the Vertex Quantum for Payroll Tax and Vertex Quantum for Sales and Use Tax applications in separate locations.
2
Define databases for the Vertex Quantum for Payroll Tax and Vertex Quantum for Sales and Use Tax applications in separate locations, and the four databases for the Vertex Quantum for Sales and Use Tax application in separate locations.
Option #3: If processing option #2 is set to 1 or 2 (that is, if the Vertex databases are in separate locations), specify the GeoCode database location information:
Value
Action
[blank]
Define the Vertex Quantum Payroll Tax and Sales and Use Tax applications to use the same GeoCode database.
1
Define each of the Vertex applications to use a separate copy of the GeoCode database, and that the two copies are expected in separate locations.
Click OK.
The Vertex Quantum Database Connection panel is displayed. The Database Connection panel contains one or more tabs that correspond to the database connections that must be defined. The displayed tabs are determined by the values you entered in the processing options, in Step 4 of this task.
Note: The GeoCode database is the only Vertex Quantum database that can be shared between the Vertex Quantum Payroll Tax and Sales and Use Tax applications. However, all of the Vertex Quantum databases can be installed in the same location or in different locations.One or more of the following tabs appears on the Database Connection panel:
Tab
Description
All
All Vertex Quantum application databases for both applications are located on the same server and in the same location.
GeoCode
The same GeoCode database is used by both applications.
GeoCode-Sales and Use
The GeoCode database used by the Sales and Use Tax application is located on this server and location. A separate copy of the GeoCode database, at another location, is used by the Payroll Tax application.
GeoCode-Payroll
The GeoCode database used by the Payroll Tax application is located on this server and location. A separate copy of the GeoCode database, at another location, is used by the Sales and Use Tax application.
Sales and Use
The four databases used by the Sales and Use Tax application are located together, on this server and location.
TDM
The Test Data Management (TDM) database, used by the Sales and Use Tax application, is located on this server and location.
Register
The Register database, used by the Sales and Use Tax application, is located on this server and location.
Rate
The Rate database, used by the Sales and Use Tax application, is located on this server and location.
Payroll
The databases used by the Payroll Tax application are located on this server and location.
On the Database Connection panel, select each tab and enter the following information:
Data Source
For ISAM, enter the directory path to the specified database. The location you enter should be the location on the server used for the database when the Vertex applications were installed, as previously described in this step.
Enter the ODBC data source name for your server (for example, SQLSERVER-OWNTS3).
Server
Enter the server name of your Enterprise Server.
For ISAM, leave this field blank.
User ID
Enter the table owner.
For ISAM, leave this field blank.
Password
Enter the password for the table owner.
For ISAM, leave this field blank.
Note: The P7308 program encrypts the user ID and password and also visibly masks the password field. For additional details, refer to "Encrypting Sensitive Data in EnterpriseOne" in the JD Edwards EnterpriseOne Tools Security Administration Guide.Click OK.
The changes do not take effect until you have logged off of your system and logged back on.