Skip to main content
Skip table of contents

OpenInvoice Issues Troubleshooting

The below steps should be initiated by Support before engaging another resource to investigate a client issue regarding an OpenInvoice interface issue.

See this Confluence page for additional information regarding OI setup and testing. OpenInvoice Interface

AP Invoice Interface

These steps are for the various scenarios that have occurred causing a failure in the OI AP Invoice sync.

New Client Setup or New Environment Syn Not Working

  1. Verify Client Environment IP addresses have been whitelisted with Enverus.

  2. Verify Certificates have been created and given to Enverus for client.

    1. Verify certs are in the below locations (or as outlined in the config) with the permissions set to read only (chmod 400).

      1. key_path: "/etc/revenue_accounting/client-openinvoice.key"

      2. cert_path: "/etc/revenue_accounting/client-openinvoice.pem"

      3. ca_cert_path: "/etc/revenue_accounting/oildexca.pem"

  3. Pull configs.

  4. Pull logs for the time period in question.

  5. Determine if xml files named “invoice_XXXXXXX.xml” exist on the app server in the location below.

    1. /srv/www/apps/files/open_invoice

    2. Pull xml files if they exist.

Invoices Exported from OI but Not in WES

  1. Verify the Invoices are showing up in the Financial Interface → Interface Inquiry grid.

  2. Pull logs for the time period in question.

  3. Run the following sql query and provide output for further troubleshooting.

    1. CODE
      SELECT DISTINCT
      	fi.accounting_date,
      	fi.journal,
      	fi.invoice_number,
      	fi.journal_name,
      	fi. [source],
      	fi.processing_tag
      FROM
      	financial_integrations fi
      	LEFT JOIN journal_entries je ON je.journal_entry_name = fi.journal_name
      		AND fi.journal = 'Journal Entry'
      	LEFT JOIN ap_invoices ap ON ap.invoice_number = fi.invoice_number
      		AND fi.journal = 'AP Invoice'
      	LEFT JOIN ar_invoices ar ON ar.invoice_number = fi.invoice_number
      		AND fi.journal = 'AR Invoice'
      	LEFT JOIN ar_receipts arr ON arr.payment_reference_number = fi.receipt_payment_reference_number
      		AND fi.journal = 'AR Receipt'
      	LEFT JOIN gl_distributions gld ON gld.financial_integration_id = fi.id
      WHERE
      	gld.id IS NULL
      	AND fi.processing_tag IS NOT NULL
      	and((ap.invoice_number IS NULL
      		AND fi.invoice_number IS NOT NULL
      		AND fi.journal = 'AP Invoice')
      	or(je.journal_entry_name IS NULL
      		AND fi.journal_name IS NOT NULL
      		AND fi.journal = 'Journal Entry')
      	or(ar.invoice_number IS NULL
      		AND fi.invoice_number IS NOT NULL
      		AND fi.journal = 'AR Invoice')
      	or(arr.payment_reference_number IS NULL
      		AND fi.receipt_payment_reference_number IS NOT NULL
      		AND fi.journal = 'AR Receipt'))
      ORDER BY
      	1 DESC;

Any Other Invoice Sync Issue

  1. Pull configs.

  2. Verify certs are in the below locations (or as outlined in the config) with the permissions set to read only (chmod 400).

    1. key_path: "/etc/revenue_accounting/client-openinvoice.key"

    2. cert_path: "/etc/revenue_accounting/client-openinvoice.pem"

    3. ca_cert_path: "/etc/revenue_accounting/oildexca.pem"

  3. Pull logs for the time period in question.

  4. Get xml files named “invoice_XXXXXXX.xml” for the days in question from the below directory.

    1. /srv/www/apps/files/open_invoice

Any Other OI Sync Process

  1. Verify Client Environment IP addresses have been whitelisted with Enverus.

  2. Pull configs.

  3. Verify certs are in the below locations (or as outlined in the config).

    1. key_path: "/etc/revenue_accounting/client-openinvoice.key"

    2. cert_path: "/etc/revenue_accounting/client-openinvoice.pem"

    3. ca_cert_path: "/etc/revenue_accounting/oildexca.pem"

  4. Pull logs for the time period in question.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.