QuickBooks POS Error 3170

QuickBooks POS error 3170 generally occurs when there is a duplicate name between QB Point of Sale and QB Desktop. When the error is encountered, a message pops up on your screen stated as [QODBC] Error: 3170 – There was an error when modifying a data extension named ‘Sent To FS’. QuickBooks error message: This action needs a valid closing date password. If you are also facing the same issue then don’t worry! With the help of this blog, you can easily fix POS error code 3170 as it covers all the possible solutions for this error.

Error: Updating of item ‘Service/Labour’ in QuickBooks Failed. Export canceled Details:

ErrorCode: 3170

Severity: Error

Description: There was an error when modifying an ItemService. Cannot use SaleAndPurchaseMod aggregate when the item is not reimbursable

Possible causes of QuickBooks POS error 3170

It is pretty important to know the reasons behind any errors to fix them. Likewise, it is also important to know the reason for QB POS error 3170 to fix it. These are:

  • The error can occur when the user attempts to alter an element of the vendor/customer list that is not complete or if the company file is corrupt.
  • In the background of Windows, some active programs might crash, leading to QuickBooks Point Of Sale Error 3170.
  • Some QuickBooks records have been removed by corrupting some other programs or files in the device itself.
  • If the QuickBooks POS app does not have the most recent updates available.

Troubleshooting methods to fix QuickBooks POS error 3170

Check out various troubleshooting methods to fix this error:

Method 1: Check the Activity Log

The error mainly consists of the name of the vendor or customer. If you already have the name of the vendor or customer then go to the next method or else perform the below-mentioned steps:

  • Go to the Customers menu within the QuickBooks Point of Sale
  • Next, select and click “Customer List”
  • After that, make a right-click on the column header
  • Now, move to the Customize columns and select the “QB Status” option
  • Sort out the list from the QuickBooks Status header
  • Find out the customer name which shows error status or that is not posting.

Method 2: Edit the Customer or the Vendor name

  • Initially, go to the Customers menu and choose Customer Center
  • Similarly, go to the Vendors menu and open Vendor Center
  • Next, click the name that you find in your first step and click “Edit”
  • Now, at the end of the name, you have to add number 1
  • Hit “Ok” and then run Financial Exchange.

Method 3: Merge the name that you edited above

If the above solutions do not resolve your issue then perform these steps as a final step by merging the edited name and creating a new name using Financial Exchange

  • Now, go to the “Edited name” and Double-click on the same button.
  • Next, you need to delete/remove the “1” number mentioned, and then click “Ok”
  • After that, QB prompt you to merge the vendor or customer to the vendor or customer that was created using Financial Exchange
  • At last, select “Yes”.

How to reach us?

accountingerror customer support

Get Expert’s Advice to Fix Your All Accounting & Bookkeeping Problems

Report an Issue
With AccountingErrors.Co you'll never have to deal with QuickBooks errors again. Ever.

About Us

AccountingErrors.Co is the most distinctive service provider that gives an endless source of inspiration. Our services guarantee you to make your QuickBooks related work more efficient and error-free by importing, exporting, and many others.


AccountingErrors.Co is a team of accounting expert and Intuit Certified QuickBooks® ProAdvisors® for certain Intuit® products. AccountingErrors.Co doesn’t claim itself to be the official representative of any of the logos, trademark and brand names of Intuit QuickBooks.