Providing the Bridge Between Vena & Dynamics GP
What is Opal's Vena Connector?
Opal’s Vena Connector is an application that bridges data in Dynamics GP and Vena. It works by exporting files from GP and putting them to a shared directory or SFTP site where it is then consumed by Vena.
ACCOUNT PAYABLE SUB-LEDGER EXTRACT
ACCOUNT RECONCILIATIONS SUB-LEDGER EXTRACT
CASH SUB-LEDGER EXTRACT
GL BEGINNING BALANCES EXTRACT
GL TRANSACTIONS EXTRACT
How does Vena Connector work?
The OBS Vena Connector Tool is configured with user credentials that run a Windows Scheduled Task that then executes a procedure to create the extract files on the desired frequency. The procedure can be adapted for each customer, in order to provide the required data to Vena according to the template.
Where should it be installed?
It can be installed on a terminal server, the SQL Server machine, or even a workstation. Normally, the processes are somewhat transparent to the staff because it runs automatically. It can only be installed on one machine and the machine MUST have internet access; FTP ports on the firewall must be open for this machine.
What happens when GP is upgraded?
This depends on the modules licensed for Vena. For extracts going from GP to the Vena FTP site, there will probably be no changes. For extracts going from the Vena FTP site to GP, eConnect will need to be upgraded and it may require an update to the import module.
What modules do you currently support?
AP Sub ledger Extract, AR Sub Ledger Extract, Cash Sub Ledger Extract, GL Beginning Balances Extract, GL Transactions Extract
Who will install and configure it, how long will it take?
The implementation team will work remotely with your IT group to install and configure the OBS Blackline Connector Tool. The IT group will need to supply credentials for SQL Server, Windows account credentials for the task scheduler, and Blackline login credentials. The setup usually takes about an hour to complete.
How will the period end date be determined?
The Account Reconciliations and Subledger Reconciliations require that a period end date be used to pull balances. To determine the period end date, use the oldest open period within the Fiscal Period Setup window in GP.