How to Troubleshoot Common Invoice Export Errors

How do I check what is causing an export error?

On the accounting export page, you can filter your results to show only exports in error. 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.

mceclip0.png

See explanations of the common export error messages below. Please not that once an invoice is in error, we will not automatically attempt to send it again, 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. 

 

What are common export errors?

Duplicate Document Error 

A duplicate document error indicates that the invoice you are attempting to export is already in your accounting system (i.e. an invoice with the same invoice number from the same vendor). 

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=Bill with TxnId=###","code":"6140","element":""}],"type":"ValidationFault"},"time":"####"

How to fix it

If this invoice is already in your accounting system you can skip exporting this invoice from MarginEdge or delete the version in your accounting system to be able to export.


Accounting Code is Not Mapped

This error indicates one of the categories on your invoice has not been mapped to your accounting system. 

Example Messages

  • Category is not mapped to a Quickbooks Account: ####

  • Accounting code is not mapped: ####

How to fix it

To fix this go to the accounting > categories page and map any missing categories. For instructions on how to do this, check out this article on the topic.


The period is Closed, Invoice Cannot Be Exported (Without Changing the Posting Date)

Most accounting systems will not allow invoices to be exported to closed accounting periods or accounting periods outside the current period. 

Example Messages

  • `org.apache.http.client.HttpResponseException: Unexpected response status: 400 {"Fault":{"Error":[{"Message":"Account Period Closed..."

  • “..An attempt was made to modify a General Journal transaction with a date that is on or before the closing date of the company.  If you are sure you really want to do this, please ask a user with Admin privileges to remove the password for editing transactions on or before to closing…”

  • ”…An attempt was made to modify a Bill with a date that is on or before the closing date of the company. If you are sure you really want to do this, please ask a user with Admin privileges to remove the password for editing transactions on or before to closing date…”

How to Fix It

To resolve you can either change the invoice date or skip exporting the invoice.


Id should be a valid number. Supplied value: null

If you attempt to export an invoice for a vendor that has not been mapped to a vendor in your accounting system, your accounting system will reject this export because a necessary value (the vendor) is null (isn't mapped).

Example Messages

  • org.apache.http.client.HttpResponseException: Unexpected response status: 400 {"Fault":{"Error":[{"Message":"Invalid ID","Detail":"Id should be a valid number. Supplied value:null","code":"####","element":"Id"}],"type":"ValidationFault"}}

How to Fix It

Go to the Accounting > Vendor Mapping page, find the vendor 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 vendor 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".

 

mceclip0.png


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 then 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".

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.