QuickBooks Status Code 3170: Vendor/Customer List Modification Issue 

The QuickBooks Desktop application is being used by many businesses to handle their financial operations.  The QB application comes with a POS tool, which is made for stores and supply chain businesses to manage their inventory. While working with the customer/vendor name or list, you might encounter QuickBooks status code 3170 in your system if you wish to edit them. You can notice the following message on the screen when the issue arises:

“Error Message: [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.”

The issue can be caused by duplicate names of the vendors/customers. We will understand what we can do to overcome this situation in this blog.

If you need any help with your company file, you can get in touch with our experts.

You may also see: QuickBooks warning Windows updates not installed

Methods to Help You Overcome QuickBooks Status Code 3170

There are multiple effective methods through which you can fix the error 3170 in your system. 

Solution 1: Use the Verify and Rebuild Tool

The built-in tool for damaged company files can help you resolve the issue by following the steps as mentioned:

1. Go to the Window menu.
2. Click on the Close All option.
3. Then, head to the File menu.
4. Tap on the Utilities.
   
5. Now, click on the Verify Data option. The following results may pop up:
   • “QuickBooks detected no problems with your data.”: Your data is clean, and you do not need to do anything else.
   • An error message: Search for the specific error message on our QuickBooks Desktop support site for instructions on how to fix it.
   • “Your data has lost integrity.”: Data damage was found in the file. Proceed to rebuild your company file to resolve the issue.

Rebuild the Company Data

1. Head to the File menu.
2. Tap on the Utilities option.
3. Then choose the Rebuild Data option.
   
4. If the QB asks to create a backup for the company file, then press OK.
5. Choose where you wish to save the backup.
6. Then, press OK. 
7. Input the new name in the file name field.
8. Hit Save.
9. Now, tap on OK when the Rebuild has completed message appears.

By following the methods, you can seamlessly overcome the error and edit the customer or vendor list again.

Solution 2: Use the QuickBooks Tool Hub

You can use a dedicated application from Intuit and begin to download and install the QuickBooks Tool Hub. Then follow the steps as mentioned.

Use Quick Fix my Program

1. Launch the QB Tool Hub,
2. Move to the Program Problems section.
3. Then click on the Quick Fix my Program option.
   
4. Let the scan run and fix the issues with your application.

Use the QuickBooks File Doctor

1. Run the QB Tool Hub.
2. Go to the Company File Issues tab.
3. Next, tap on the QuickBooks File Doctor option.
   
4. Select the company file with the issue from the menu.
5. Click on Check your file.
6. Enter the QB admin password, then let the tool run and fix the issue.

The above-mentioned steps will help you overcome the issues and fix the problem in your system and the company file as well.

Solution 3: Remove the Duplicate Names

If you are facing error 3170 when you try to change the customer or vendor list, try the following steps to fix the issue and edit the duplicate name from the lists.

Verify the Activity Log

The error can arise if there are already existing file names in both QBDT and the Point of Sale software.

1. Go to the Customers menu.
2. Click on the Customer List option.
3. Then right-click on the column header.
4. Tap on the Customize Column menu.
5. Now, click on QB Status.
6. Verify the status of any names with the label Not Posting or Error Status.
7. Repeat the steps for the Vendor list and then move on to the next step.

Edit the Name

Once you checked if there are no errors in the customer or vendor, go through the steps below:

1. Head to the Customers menu.
2. Then, tap on the Customer Center or Vendors.
3. Tap on the Vendor Center option.
4. Now, right-click on the name, which is outlined.
5. Tap on Edit.
6. Add any digit to the name of the file.
7. Tap on OK to save the details. 

Merge the Name

After you have edited the same names, you can follow the steps to merge them with each other.

1. Right-click on the edited name.
2. Then, click on the Edit option.
3. Remove the digit that you added to the name.
4. Click on OK to save the details.
5. Now you will get a pop-up message to merge the edited customer or vendor with the one created by the financial exchange.
6. Click on Yes to confirm the changes.

Now, you can continue to work with your customers and vendors and check if the QuickBooks status code 3170 still shows up.

You may also read: QuickBooks POS Connectivity Tool

Solution 4: Fix the Windows Firewall

The issue can be seen if the antivirus application is blocking your tasks and operations. Here are the steps to fix it.

1. Tap on the Start menu.
2. Enter Windows Firewall in the search bar to open it.
3. Go to the Advanced Settings.
4. Now, right-click on the Inbound Rules.
5. Then, tap on the New Rule option.
6. Choose the Port and choose Next.
7. Ensure that TCP is selected.
8. Under the specific local port areas, enter the ports as per the QuickBooks version:
   • QuickBooks Desktop 2020 and later: 8019, XXXXX.
   • QuickBooks Desktop 2019: 8019, XXXXX.
   • QuickBooks Desktop 2018: 8019, 56728, 55378-55382.
   • QuickBooks Desktop 2017: 8019, 56727, 55373-55377.
9. Once you have entered the port number.
10. Tap on Next.
11. Click on the Allow the Connection option.
12. Again, hover on Next.
13. If prompted, select all profiles and click Next.
14. Now, create a new rule and allot a name such as QBPorts (year).
15. Click on Finish to save the changes.

These steps will help you to avoid firewall issues in your system with the application.

Possible Reasons Behind the QuickBooks Status Code 3170

You should be aware of the causes behind the issue in your QBDT application. Listed below are the reasons why it can cause problems in your case.

1. If a program crashes when running in the background, you may face error 3170 in your system.
2. When the antivirus or firewall application is blocking your QuickBooks operations.
3. If the company file is damaged or corrupted, then you might face the QuickBooks error 3170.
4. When the Point of Sale is not updated, it can also bring many errors in the QuickBooks application.
5. If the POS software crashes, you might encounter issues in your system with the vendor and customer lists.

Once you have understood the cases that can cause the issue in your system, you can easily overcome it.

QuickBooks Status Code 3170: A Quick View Table

Let us take a quick glance at error 3170 and what we have talked about it so far.

Conclusion

In this blog, we have talked about why and when you might encounter the QuickBooks status code 3170 in your system. We further included the steps that will help you to overcome the error and fix the problem. If you need any help with your POS service, feel free to get in touch with Proadvisor Solutions’ experts.

Frequently Asked Questions (FAQs)

Erica watson

Erica Watson is writing about accounting and bookkeeping for over 7+ years, making even the difficult technical topics easy to understand. She is skilled at creating content about popular accounting and tax softwares such as QuickBooks, Sage, Xero, Quicken, etc. Erica’s knowledge of such softwares allows her to create articles and guides that are both informative and easy to follow. Her writing builds trust with readers, thanks to her ability to explain things clearly while showing a real understanding of the industry.