Which are the common error messages you get when you sync the documents from your ERP software with QuickBooks Online? How to solve errors between MRP and QuickBooks Online sync?
The emergence of cloud computing and, in particular, the Application Programming Interface (API), has made great strides in linking diverse applications. Application users imagine that the process is simple and that only one “click” is enough and the data will be synchronized, something like receiving and sending an e-mail. But in practice, there are problems from the technical side that are completely incomprehensible and frustrating to the users.
Apart from the inaccessibility of the service, the most common problems are related to so-called “Dirty data”. By “dirty data” we do not consider anything bad, the data from one system being sent to another system does not satisfy the logical control of the database entry.
In ERPAG, the “SKU” must be unique, while the item name can be repeated. When entering data in ERPAG, it will be allowed to enter it with the same name (eg SKU: 00155 Name: Small Bolt and SKU: 00156 Name: Small Bolt). From our point of system identification and functioning, the name of the product is not relevant.
With QuickBooks Online the situation is different, as it will not allow the manual entry of a new item if the identical name is previously entered, so it will not allow even an API entry. From the point of view of QuickBooks Online, this is “dirty information”.
In this text, we will describe the most common mistakes, problems with synchronization, and how to solve them.
In ERPAG by “clicking” on the info icon you can see the error message on each document.
The solution depends solely on the error message description.
Every online service has its own “downtime”, a time when it is unavailable. The reasons for the unavailability of the service may vary, from some error through security to regular maintenance and system updates. In most cases, ERPAG initiates synchronization so that the operator does not know if the QuickBooks Online services are available, and only when synchronization is activated an error occurs.
The service is temporarily unavailable. An error occurred on the server while processing the request. Resubmit request once; if it persists, contact developer support.
Whether the QuickBooks services are available you can check on these two official Intuit links:
In the introduction of this text, we provided an example of “dirty data”. In ERPAG, the identification is SKU, while QuickBooks Online uses the item description (the reason is the most likely that QuickBooks Online can function without SKU numbers). So there is no verification of duplicate names in ERPAG, while this verification is embedded in QuickBooks Online.
The name supplied already exists. : Another product or service is already using this name. Please use a different name.
The primary solution would be to import the whole QuickBooks Online codebook through an Excel file before the first synchronization, after exporting the product and service list from ERPAG.
The system will then execute the logical control of the entered items.
If this is not possible, one of the solutions is to change the name in QuickBooks Online (for example, add a suffix).
ERPAG connects an item according to the SKU data, during the next synchronization, it will be newly created with the “unique” name.
4. The customer and supplier (vendor) have the same name
QuickBooks Online does not allow the supplier, customer or employee to have the same name.
In practice, it happens that at some point the buyer is also our supplier. This is a fairly common case in some European countries, as national accounting standards require that when a customer returns goods, this transaction must be entered as a new input of goods, Instead of voiding sales orders, we need to make a purchase order.
Another customer, vendor or employee is already using this name. Please use a different name.
Since there is no code/key (as there is an SKU in the item) in the QuickBooks Online list of the customers and suppliers, the search is done first via “Display name” and then through the “Company name”, and if the data is not found, then a new customer or supplier is automatically created.
In order to solve this problem, we need to manually open the Customer or Supplier (Vendor) in QuickBooks Online , where “Display name as” will be unique (eg we can add a suffix) and such a name cannot exist in ERPAG. “Company” information must be identical to the one in ERPAG.
Example (top picture):
When we activate synchronization from ERPAG, the application will search first for the “Acme Ltd” in “Display name”, and after it has not been found it will search through “Company”, since this information is identical, the invoice will be created for this customer.
When ERPAG automatically opens a customer or supplier, the “Company” and “Display name as” data are identical.
When the accounting period ends, administrators have a good practice to “close the books” with the appropriate date. This way, they prevent the documents from being accidentally inserted into the finished period.
The account period has been closed.
The account period has been closed and account books can not be updated through the QuickBooks Online Services API. Please use the QuickBooks Online website to make these changes
The first question is whether this document should really be booked under that date?
If it doesn’t need (and it will be posted under another given) in ERPAG, through the “bulk” action, we can change the status to “ignore”
While we create it manually in the QuickBooks Online with the wanted date.
If it is necessary to enter the documents into business books with that date (the administrator or accountant must decide), then it is necessary to “unlock” the books in QuickBooks Online.
“Closing the books” is probably done for a particular reason, so please always consult with your administrator or bookkeeper.
When opening the QuickBooks Online database, there are already predefined values. One of the default values is a warning (ie a ban on the API call) if we try to enter a new document (for example, invoice) and there is already a document with an identical number in the database.
We will not go into the reasons why it was done in QuickBooks Online , although ERPAGs document numbers are mostly unique as well. In case of Splitting, Voiding or Return of Goods, the newly created document retains a unique number. Then there is a problem with synchronization.
Duplicate Document Number Error: You must specify a different number. This number has already been used.
In QuickBooks Online, in the Company settings, turn off the parameters as shown in the pictures below.
There is another solution considering the voided documents – to change the status to ‘ignored’ through the bulk action.
And then void the document in the QuickBooks Online .
Note: Void options are a little bit advanced, so we advise to contact your Administrator or Accountant before proceeding with such action.
In order to work faster, data is often sent asynchronous, i.e. the order of sending data does not have to correspond to the order of receipt.
We sent a request to open a new supplier and then a Bill document related to that partner. Bill came first to the server (ie to the database). Since the data has not yet arrived (or it’s not already entered in the database), the document is not valid because there is no supplier in the database.
BadRequest inner Validation Exception was thrown. Details: Business Validation Error: Error occurred when setting up Styles due to parallel requests.
Simply run the synchronization again in a few moments.
to read more: https://www.erpag.com/news/quickbooks-online-and-erpag-integration
JSON/XML Designer in ERPAG is a visual tool that will allow users to transform data from the ERPAG database into JSON or XML format. This can be further used for future integration with API services. This tool provides a user-friendly interface where users can define...
The biggest change we developed is Automatization and Customization. This change is a huge milestone for us, and we will publish individual instructions for using the new features in the upcoming period. This module is divided into individual wholes: JSON Designer -...
ERPAG has the ability to use Blockly Script to send or receive data via the HTTP protocol. Integration of two systems via API (Application Programming Interface) is always a complex process, especially for someone with little experience. In this blog we will explain a...
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.