WGits for Quickbooks Desktop

⌘K
  2. Home
  4. Docs
  6. WGits for Quickbooks Desk...
  8. Error Message List – QuickBooks Desktop

Error Message List – QuickBooks Desktop

  • User Guide Search

Choose from the list below (or use the search box above) to find error messages that can appear in the Need Review Screen on WGits QB along to access helpful solutions:

Below is a list of common error messages that can appear in the Need Review Screen on WGits QB along with the solutions:

The item ______ cannot be used in this line item. It does not have the correct type.
This means the SKU referenced in this error message is not pointing to the correct QuickBooks Item type. Ways this can happen:

A Bundle SKU in your eCommerce system is trying to map to an Inventory Part Item in QuickBooks.
A non-Bundle SKU in your eCommerce system is trying to map to a Group Item in QuickBooks.
A Bundle SKU in your eCommerce system is trying to map to a Service or Other Charge Item in QuickBooks.
A non-Bundle SKU in your eCommerce system is trying to map to a Service or Other Charge Item in QuickBooks.
Solution:
Point the appropriate Item types to the appropriate corresponding item types in QuickBooks.
I.e., Bundle SKUs need to point to Group Items.Non-Bundle SKUs need to point to Inventory Parts or Inventory Assemblies.

 

There was an error when converting the quantity “1” in the field “item quantity”. QuickBooks error message: You cannot set the quantity for items of this type.

This issue occurs if there is a Sales Tax Mapping item mismatch. Ensure the WGits QB map in the Data Map tab has the correct Sales Tax item pointed to the appropriately mapped Sales Tax Other Charge or Service item in QuickBooks. This could also happen for other Data Map fields such as Shipping or Handling.

 

There is an invalid reference to QuickBooks Item _______ in the Sales Receipt Line. QuickBooks error message: Invalid argument. The specified record does not exist in the list.
This means the SKU referenced in this error message is trying to point to an Item in QuickBooks that does not exist yet.
Solution:
You need to create the item in QuickBooks or use the WGits QB SKU Map to point to an existing Item name in QuickBooks.

 

Value was either too large or too small for a Decimal.
This issue occurs if the order was placed incorrectly with incalculable values. We’ve seen this if an order was placed in your eCommerce system with a SKU but with a quantity of zero. This is a rare issue and shouldn’t be common for you as an order can only be placed that way if the order was imported through an API.
Solution:
It probably shouldn’t be imported to QuickBooks anyways in this format. You may need to contact your eCommerce System support team to fix the order. Once that order is fixed, then we can import it properly.

 

This Order Number Already Exists in QuickBooks
This usually happens if an order has already been imported before and was re-attempted again due to using the Batch By Date Feature.
Solution:
Reject the order as it is not needed.

 

An attempt was made to modify a SalesReceipt 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 (this setting is in the Accounting Company Preferences), then try again.

This mouthful of a message just means that you are trying to batch this order which was placed during a date range that has now been closed in your Company file.
Solution:
Reopen the closed date range that you’ve set and then import your orders. Or if you have already reconciled these missing orders, values and inventory then you could reject this order.

 

There was an error when saving a SalesReceipt. QuickBooks error message: You have no items or one or more of your amounts is not associated with an item. Please enter an item.

This error message appears usually only when an order has been added to the DTC Platform via an API or an integration in an incorrect or improper way. The order contains a blank SKU line and a zero quantity and WGits QB flags these orders. This is different from a shipping only order. This is an order that has a SKU line item added but the SKU is null or missing.
Solution:
The order is likely not valid in your DTC Platform so you should reject this order in WGits QB and in your DTC Platform, you should take steps to remove or invalidate the order.

 

There was an error when saving a SalesReceipt. QuickBooks error message: Transaction amount must be positive.

  1. Most commonly this can occur if a Group in QuickBooks is set up incorrectly. A Group should be set up with an Inventory Assembly. If a Group is set up to only have sub-items added and their collective value is incorrect, too low or $0.00. Then if a Bundle Discount trying to apply it will be pulling the Bundle Discount from the eCommerce platform, but then is pulling the Group’s collective price from QuickBooks, resulting in the end price being negative.
  2. The second way that this message could occur is if an order is placed with a negative dollar amount. This is sometimes done for recording cash withdrawals from a POS drawer. It’s not a best practice or recommended as QuickBooks cannot assign a negative dollar amount to a Sales Receipt.

Solution:

  1. Ensure Bundles are set up this way: Group in QuickBooks must only contain an Inventory Assembly representing the proper price and products.
  2. Or don’t place orders that have a negative total. Negative totals should only be on refunds.

 

Value cannot be null.

This can happen with test order transfers or other kinds of order batches. If the Make Deposits window is open in QuickBooks when processing a batch, this can cause data to not flow into QuickBooks properly.

Solution: Don’t have the Make Deposits windows open in QuickBooks when attempting to process a batch or test orders.

 

HTTP protocol error. 517 Server Error. (Error: FFFFFFFC – HTTP protocol error. Busy interacting with QuickBooks.).

There are several different types of HTTP protocol error messages. This one means that at the time of the batch there may have been too many things going on with the QuickBooks correspondence for the batch to be successful. This should be a rare issue.
Solution:
Ensure your connection to QuickBooks is working with Remote Connector and re-attempt pushing this order through to QuickBooks.

 

HTTP protocol error. 517 Server Error. (Error: FFFFFFFC – HTTP protocol error. Could not start QuickBooks.).

This happens when Remote Connector is unsure of what company file to access or if the company file hasn’t been mapped to yet.
Solution:
Ensure Remote Connector knows which company file to point to. Usually, this requires assistance from support. Please call 707-927-3334 or email wgits@wineglassmarketing.com for assistance.

 

HTTP protocol error. 517 Server Error. (Error: FFFFFFFC – Connection failed: No connection could be made because the target machine actively refused it 127.0.0.1:8166*). *note this IP address could be different for you.

This can happen if QuickBooks is in an error state or if there is a report open in a closed QuickBooks file when a batch attempt is made. This can also occur if there was a dialogue box open, make deposits window, check payment, bank feed screen, an automated QuickBooks reminder, or the preferences screen open.
Solution:
Ensure that all reports are closed for all users and ensure that QuickBooks has not experienced an error and is displaying an error message attempting to terminate the active QuickBooks program. Double-check to ensure that other windows or dialogue boxes such as the make deposits screen or check payment screen are closed as well.

A good preventative step for this is to go to Edit > Preferences > Desktop View > in your personal preferences you should set the Desktop to not save when you log out. This will close all windows when you log out. If you have multiple users who log in to QuickBooks, this should be setup for all users.

 

[HTTP protocol error. 517 Server Error. (Error: FFFFFFFC – Timeout.).

A timeout means QuickBooks took too long to respond when we attempted to connect to the company file. This could be due to internet speed issues, server speed issues or connection issues of another sort. this could also be due to the Remote Connector being off. Remote Connector can sometimes be turned off when your PC Operating System does an update.
Solution:
Ensure all reports are closed for all users. Ensure that connection to the company file is accessible if using a shared folder or networked folder. Re-attempt the batch and see if the batch is successful as this may have been a one-time issue. It is also recommended that you ensure Remote Connector is on and actively running.

 

[HTTP protocol error. 517 Server Error. (Error: FFFFFFFC – HTTP protocol error. Unable to find the QuickBooks Request Processor on your system. Please make sure your application is running a 32-bit process and that QuickBooks 2002 Pro or higher is installed on your system, or use the Remote Connector. (Error: 0x80040430)..).

This most commonly happens if the Remote Connector Service program or Quickbooks QBW32.exe is running more than once in the Task Manager.

The next possible reason is that the application needs to be reauthorized in Quickbooks.
Solution:
Go into Task Manager > go to Details tab > and end tasks for duplicate tasks of RemoteConnectorService.exe (this has a higher likelihood of happening on a server)

The next solution to try is to go into QuickBooks (Single-User Mode as the Admin QB Account), then Edit > Preferences > Integrated Applications section > Click on the Remote Connector application > Click Reauthorize. It will not display any kind of response, but it will have reauthorized it. You should be able to resume batching again.

 

Error processing data source connection: The remote server returned an unexpected response: (308) Permanent Redirect.

This is most likely due to an integration connection issue. Usually, it is rare and means that there is an issue with the API with the eCommerce platform. It is possible that the eCommerce platform API code has changed and is no longer supported on the instance of WGits QB that you are running.

Solution:
Make sure you are running the most current version of WGits QB. If you are not sure if you have the current version please see our version release details page and also reopen WGits QB. Shortly after the software opens in the Dashboard in the grey message box, there will be a golden up-arrow inviting you to update to the newest version.

If you are on the newest version and this error persists please contact us immediately.

 

Object reference not set to an instance of an object.

This usually can occur if you are mapping sales on Departments and if there’s a Department that is missing. This can also happen if you enter your bottle size manually by hand to be incorrectly spelled such as 750ML rather than 750ml.

Solutions:
If you are using Department Mapping: Add the appropriate Departments that you haven’t had setup in your eCommerce system to resolve this issue moving forward. To resolve the orders that are stuck in the Need Review screen, click the arrow beside the “Edit” button of the order, and click the “Edit” button of the SKU that doesn’t have the department mapping properly. Insert the Department name into the Department field. Now you will be able to re-process the order in the Need Review screen. If it still gets stuck due to the same error, there could be another SKU missing a department or there could be a bottle size naming issue.

screen showing how to edit product in need review

screen showing edit product departments

If you are not using Department Mapping: Double-check and make sure that your bottle sizes are spelled correctly. Go to Setup > SKU Map > and make sure that the Bottle Size field is filled in with one of the dropdown options: Ie, 750ml, 1.5L, 375ml, etc. If a Bottle Size is misspelled to be 750ML, you will get the “Object reference not set to an instance of an object” error.

 

Error in AddSalesReceipt:There is an invalid reference to QuickBooks Ship Method “____________” in the Sales Order. QuickBooks error message: Invalid argument. The specified record does not exist in the list.

Solution:
Make sure your Shipping Methods exist in QuickBooks in the Ship Via list. These shipping methods may need to be mapped with the Ship Method mapper. Learn more about setting up your Ship Via list here.

 

Error in AddSalesReceipt:The string “___________” in the field “FullName” is too long.

Solution:
This particular error message appears if the item or field in question is longer than the QuickBooks Desktop character limit and/or doesn’t match the mapped item in QuickBooks. This error message can apply to Ship Via items, Customer Names, Items and much more. Learn more about your Ship Via list here.

 

QBO Error: – Validation Exception was thrown.Details:Invalid Type : Line.GroupLineDetail.ItemRef: Item must be of type bundle..

Solution:
This happens if you are selling a Bundle from your eCommerce system and it is being mapped to a non-bundle item in QuickBooks Online.

 

QBO Error: -1 – SKU _______ not found in QBO

Solution:
This error occurs if there is a SKU being sold in your eCommerce system, but it doesn’t match/exist in QBO.

 

SR/CM Order Number ________ already exists in Quickbooks.

Solution:
This message appears if your order that was attempted already exists in QuickBooks.

 

If any of your batching issues persist please do not hesitate to reach out to wgits@wineglassmarketing.com or call 707-927-3334 and ask for WGits Support.