I have an export error, what do I do?
We're going to show you how to find out what the error is, resolve the common ones, and get that data to your accounting system pronto!
Please note that once an invoice is in error, the software will not automatically attempt to send it again, even if the error clears. So once you have resolved the issue, go back to your Accounting > Export page, select the invoice in error and press Send to attempt to export again.
There is a sister article that covers Invoice Errors; this article is specifically about Payment Errors.
Uncovering the Error
On the accounting export page, you can adjust your filter to show only exports in error. Just click on the "Filter" button next to the date selector and choose the "Error" status. To see what is causing an export error, you can click on the word “Error” in red to pull up an audit trail of the export history of your invoice and see the last response from your accounting system describing the error.
Common Payment Export Errors
Check Already in the Accounting System/Duplicate Document Error
A duplicate document error indicates that the check you are attempting to export is already in your accounting system (i.e. a check with the same check number from the same checking account).
Example Messages
-
"org.apache.http.client.HttpResponseException: Unexpected response status: 400 {"Fault":{"Error":[{"Message":"Duplicate Document Number Error","Detail":"Duplicate Document Number Error : You must specify a different number. This number has already been used. DocNumber=#### is assigned to TxnType=Check with TxnId=####","code":"6140","element":""}],"type":"ValidationFault"},"time":"####"BL01001973
-
Replace the check number ##### with an un-used check number against the [mapped bank account name], then try again. Please enter unique check number [Support ID: #####]
How to fix it
If this check is already in your accounting system you can skip exporting this check from MarginEdge.
Exported the Check Payment Before the Invoice has been Exported
In order to pay an invoice with a check payment, that invoice must already be exported to the accounting system. If you attempt to send a check payment before the invoice has been successfully exported, the check will error out as it has nothing to mark as paid.
Example Messages
-
One or more orders associated with Bill Payment have not yet been sent to accounting.
How to Fix It
Export the invoice that hasn't been exported yet then export your check payment again. If you don't know what invoice is missing, you can see all the invoices on paid with this check number on the error log (see example below)
Tips:
- You can use the search bar to look for invoice numbers OR check numbers. If you search for a check number, search results will also include invoices paid with that check number.
- If you can't find the invoice, check your date range filter to see if it's outside the date range you're currently viewing
- If an invoice is in error, that means it hasn't successfully exported and will need to be sent over before a check payment can be exported
- If you don't see the check try changing your filter to include "Sent" and "Skipped". If the invoice is in "Skipped" status you can export it and then send the check payment. If the invoice is in "Sent" status you should be able to just export the check again by selecting it and pressing the "Send" button on the accounting > export page.
Check Number used to Pay Multiple Vendors
This error occurs when the same check number is included in invoices written to more than one vendor.
Example Messages
-
Invalid Check Data Entered. Check number is used on invoices from multiple remote vendors.
How to Fix It
Contact MarginEdge support. We will need to reopen the invoices in question and adjust the check numbers.
Payment Account is Not Mapped
If an invoice is closed to a payment account that has not been mapped to the corresponding balance sheet account in your accounting system, the invoice will not be exportable.
Example Messages
-
Payment Account (Payment Account Name) is not mapped to an accounting system account. Map this account on Accounting > Payment Accounts.
How to Fix It
Go to the Accounting > Payment Accounts page, find the listed payment account, and map it (for full instructions on vendor mapping, check out this article on the topic). Then go to the Accounting > Export page, select the invoice, and press "Send". If the Payment Account is already mapped you will need to manually export the invoice as it is in error status. Go to the Accounting > Export page, select the invoice, and press "Send".
Invoice is Missing Remote ID
When MarginEdge sends an invoice to your accounting system, we attach a remote id so that when a payment exports it knows which invoice to mark as paid. If an invoice is edited in your accounting system, then it removes this id and the payment will not export.
Example Message:
- Object Not Found : Something you're trying to use has been made inactive. Check the fields with accounts, customers, items, vendors or employees.
How to Fix It
If your payment is only associated with one invoice, you can delete that invoice from your accounting system and then re-export both the invoice and payment from MarginEdge. If you have multiple invoices associated with the payment in error, we unfortunately have no way of knowing which invoice was edited. Your choices are to either 1) delete all associated invoices and re-export all invoices and payment, or 2) manually enter the payment into your accounting system and just mark it as "skipped" in your [me] Accounting > Export page.