vertex final
TRANSCRIPT
![Page 1: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/1.jpg)
![Page 2: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/2.jpg)
The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
Safe Harbor Statement
![Page 3: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/3.jpg)
<Insert Picture Here>
EnterpriseOne CNC Vertex Setup and Troubleshooting
Bryan Jones and Jerry SierraSenior Technical Support EngineersEnterpriseOne Tools & Technology
![Page 4: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/4.jpg)
<Insert Picture Here>
Vertex Overview Agenda
• Introduction• What is Vertex? • What do we support?• How does it work with EnterpriseOne?• What are the steps to configure EnterpriseOne to
work with Vertex?• Basic Troubleshooting and Working With Support• Question & Answer
![Page 5: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/5.jpg)
Introduction
• As a consultant or Business Partner, you may be tasked with setting up an EnterpriseOne environment to use Vertex.
• As a company’s CNC administrator, you may be responsible for configuring and maintaining Vertex connectivity within EnterpriseOne.
![Page 6: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/6.jpg)
Introduction
• The majority of service requests open for Vertex connectivity are often resolved by addressing the installation of the Vertex product and/or correcting the EnterpriseOne configuration.
• This presentation will provide an overview of what is supported, who supports what components, the EnterpriseOne CNC setup for Vertex connectivity and how to effectively work with support should you require assistance.
![Page 7: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/7.jpg)
<Insert Picture Here>
Vertex What is it?
![Page 8: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/8.jpg)
What Is Vertex?
• Vertex is a third-party tax application.• Vertex for Payroll Tax (VFPT)
• Calculates taxes applied to employee earnings.• Vertex Sales Tax (VST or QSUT)
• Sales Tax is used with Sales Orders and represents the amount of tax applied and collected for something a customer is selling or has sold.
• Use tax is used with Procurement Orders (Purchase Orders) and represents the amount of tax paid on something the customer has bought.
![Page 9: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/9.jpg)
<Insert Picture Here>
Vertex What do we support?
![Page 10: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/10.jpg)
What Do We Support?
• What we do support:• Only certified versions of the Q Series release of VFPT and
VST can be used with EnterpriseOne applications.• Check third-party MTRs to determine what is currently
certified for use with EnterpriseOne.• For payroll tax, customers must use VFPT. • Customers can use any sales & use tax software, but only
VST is supported by Oracle for use with EnterpriseOne.• EnterpriseOne configuration only:
• We do not provide support for the installation nor maintenance of Vertex applications outside of EnterpriseOne.
• Vertex support or Vertex’s Customer Café.
![Page 11: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/11.jpg)
What Do We Support?
• Note that Vertex releases other than Q Series may work with EnterpriseOne (e.g. Vertex O Series). Vertex support should be contacted to engage their support and consulting services for assistance.
![Page 12: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/12.jpg)
EnterpriseOne MTRs For Vertex
• EnterpriseOne MTRs for Vertex• Available via the MTR Index page, Doc ID 747323.1 under
“Third Party”.• Vertex Q Series Payroll MTR: 705360.1• Vertex Q Series Sales Tax MTR: 705331.1
• Certified versions of Vertex apply to all supported versions of EnterpriseOne applications and tools releases.
• Take note of any required platform fixes (e.g. PTF for AS/400) and any SAR that need to be applied.
• Also note that beginning with SP23_R1 for Xe/ERP8 and 8.95.K1 for 8.9+ applications, the CLI version of Vertex needs to be installed when running things on the AS/400.
![Page 13: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/13.jpg)
<Insert Picture Here>
Vertex How does it work with EnterpriseOne?
![Page 14: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/14.jpg)
How Does Vertex Work With EnterpriseOne?
• VFPT• Connections are made “on the fly” to Vertex tax collections by
the B0700058.
• VST/QSUT• Connections are made by the B0000182 at startup
(environment initialization) and cached.• Clearing connection values that have been cached in memory
for Call Object kernel processes typically requires a restart .
![Page 15: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/15.jpg)
How Does Vertex Work With EnterpriseOne?
• Best to have one install of Vertex per server.• Check with Vertex support for any requirements they have for
installing various versions on a single machine.
• Local configurations can be setup to test that will not affect the production install and its users.
![Page 16: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/16.jpg)
<Insert Picture Here>
Vertex What are the steps to configure EnterpriseOne to work with Vertex?
![Page 17: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/17.jpg)
EnterpriseOne Configuration
• Check version of Vertex and make sure test connections and calculations succeed before beginning EnterpriseOne configuration.
• Verify path to Vertex Utilities directory for Windows implementation.
• If not configuring for local testing, make sure Vertex utilities and EnterpriseOne services are going to run on the same server.
• Check for ESUs and apply as necessary.
![Page 18: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/18.jpg)
EnterpriseOne Configuration
• OCM mapping in System Data Source pointing to SVR data source.• VFPT
• B0700022• B0700030• B0700058• B0700059• B0701490• B0701520• N0701900• R07200
![Page 19: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/19.jpg)
EnterpriseOne Configuration
• OCM mappings in System Data Source pointing to SVR data source.• VST/QSUT
• B0000182• B0000183 • B7300002• B7300004• B7300012• X00TAX
![Page 20: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/20.jpg)
EnterpriseOne Configuration
• VFPT & VST: Database Connections• Menu: G731• APPL: Database Connections (P7308)
• Web-only starting at E811.• Updates: Business Data - <Env>.F7308• Prompt for Values and enter appropriate values to determine how Vertex
collections will be accessed.
![Page 21: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/21.jpg)
EnterpriseOne Configuration
![Page 22: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/22.jpg)
EnterpriseOne Configuration
• Complete fields for Data Source (ODBC, Schema, DB2 library, ISAM path, etc.), Server (Server host name), User ID (qualified DB login user name), and Password (Qualified DB login password)• For ISAM install, only the path to the Vertex collections will be
entered and the other three fields should remain blank.
• Special configurations sometimes necessary for SQL Server and Oracle database configurations.
![Page 23: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/23.jpg)
EnterpriseOne Configuration
![Page 24: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/24.jpg)
EnterpriseOne Configuration
• If using AS/400, use the “AS/400 Libraries” form exit to define the name of the Vertex install library (Utilities library).
![Page 25: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/25.jpg)
EnterpriseOne Configuration
![Page 26: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/26.jpg)
EnterpriseOne Configuration
• VFPT & VST: Constants• Menu: G731• APPL: Constants (P7306)
• Web-only starting at E811.• Updates: Business Data - <Env>.F7306• If using VST, the Quantum Active field should have a value of
“Y”. If not, set it to “N”.
![Page 27: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/27.jpg)
EnterpriseOne Configuration
![Page 28: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/28.jpg)
EnterpriseOne Configuration
• If left at “Y” (default in releases prior to E812) and VST is not used, the following will be in the server’s Call Object kernel log and/or Fat client jde.log:• B0000182:IB0000182_InitializeQuantumSalesTax: Load
library of Vst failed• Specific text of error will depend on platform, but beginning
will still have “B0000182:”.
![Page 29: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/29.jpg)
EnterpriseOne Configuration
• VFPT: OneWorld/EnterpriseOne System Control• APPL: Work With OneWorld System Control (P99410)• If using GeoCoder for Payroll, make sure the “HRGEO”” data
item has a Use Module value of “Yes”.
![Page 30: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/30.jpg)
EnterpriseOne Configuration
![Page 31: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/31.jpg)
EnterpriseOne Configuration
• VFPT: HRM Common Display Settings • APPL: Work With HRM Common Display Settings (P05004)• If using GeoCoder for Payroll, make sure the “HRGEO” data
item has a Current Setting value of “Yes”.
![Page 32: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/32.jpg)
EnterpriseOne Configuration
![Page 33: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/33.jpg)
EnterpriseOne Configuration
• Client session should end. If configuring for VST, EnterpriseOne services on the server the logic is mapped to should be restarted.
• To test Vertex database connections from E1 for Payroll Tax use the P05005.
• To test Vertex database connections from E1 for Sales Tax use the P73GEO.
![Page 34: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/34.jpg)
EnterpriseOne Configuration
![Page 35: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/35.jpg)
EnterpriseOne Configuration
![Page 36: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/36.jpg)
<Insert Picture Here>
Vertex Basic Troubleshooting
![Page 37: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/37.jpg)
Basic Troubleshooting
• Verify Vertex Utilities tests are successful.• Verify MTRs have been met and appropriate ESUs
applied.• Call Object Kernel Logs
• Look for errors/failures on B0000182 (VST) or B0700058 (VFPT).
• Get debug (if feasible) to see values passed to these BSFNs.• If running locally data will be in jde.log and jdedebug.log files.
• Configuration instructions are included in the install guide for the applications release, OS and database used.
• Search Metalink 3 for error message or for solutions beginning with “E1:VERTEX”.
![Page 38: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/38.jpg)
Working Effectively With Support
• When opening an SR, be sure to provide the following information:• Version of EnterpriseOne Applications and Tools Release
• 8.11 SP1 8.96.4.0• Version of Vertex
• Payroll Tax Q Series v2.9.4• If using AS/400, specify CLI or ES version of Vertex.
• OS and Database Version• i5/OS V6R1, DB2/i5 V6R1
• Logs from machine running E1 Vertex-related logic (OCM).• Support Assistant – Vertex Configuration Report
![Page 39: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/39.jpg)
THANK YOU
![Page 40: Vertex Final](https://reader036.vdocuments.us/reader036/viewer/2022081717/55373d1b4a795967228b4ca6/html5/thumbnails/40.jpg)