Configuring the Database Connections for Vertex Quantum Tax Applications

To configure Release 9.2 database connections to use the Vertex Quantum applications:

  1. In the Fast Path field, enter G731 to access Vertex Quantum Tax Processing.

    The Vertex Quantum Tax Processing panel appears.

  2. Highlight and right-click the Database Connections (P7308) program.

    A context menu appears.

  3. On the context menu, select Prompt for Values.

    The Processing Options dialog appears.

  4. 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.

  5. 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.

  6. 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.

    • Server

      For ISAM, leave this field blank.

    • User ID

      For ISAM, leave this field blank.

    • Password

      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.
  7. Click OK.

    The changes do not take effect until you have logged off of your system and logged back on.