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
Verify Client Environment IP addresses have been whitelisted with Enverus.
Verify Certificates have been created and given to Enverus for client.
Verify certs are in the below locations (or as outlined in the config) with the permissions set to read only (chmod 400).
key_path: "/etc/revenue_accounting/client-openinvoice.key"
cert_path: "/etc/revenue_accounting/client-openinvoice.pem"
ca_cert_path: "/etc/revenue_accounting/oildexca.pem"
Pull configs.
Pull logs for the time period in question.
Determine if xml files named “invoice_XXXXXXX.xml” exist on the app server in the location below.
/srv/www/apps/files/open_invoice
Pull xml files if they exist.
Invoices Exported from OI but Not in WES
Verify the Invoices are showing up in the Financial Interface → Interface Inquiry grid.
Pull logs for the time period in question.
Run the following sql query and provide output for further troubleshooting.
- 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
Pull configs.
Verify certs are in the below locations (or as outlined in the config) with the permissions set to read only (chmod 400).
key_path: "/etc/revenue_accounting/client-openinvoice.key"
cert_path: "/etc/revenue_accounting/client-openinvoice.pem"
ca_cert_path: "/etc/revenue_accounting/oildexca.pem"
Pull logs for the time period in question.
Get xml files named “invoice_XXXXXXX.xml” for the days in question from the below directory.
/srv/www/apps/files/open_invoice
Any Other OI Sync Process
Verify Client Environment IP addresses have been whitelisted with Enverus.
Pull configs.
Verify certs are in the below locations (or as outlined in the config).
key_path: "/etc/revenue_accounting/client-openinvoice.key"
cert_path: "/etc/revenue_accounting/client-openinvoice.pem"
ca_cert_path: "/etc/revenue_accounting/oildexca.pem"
Pull logs for the time period in question.