LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Vipin Panwar
Level 1

QuickBooks Desktop

QuickBooks Desktop 2022 Enterprize Sync Issue:

 

When we sync a record the first time it gets synced. However, re-sync didn’t work as the CustomerListId is being changed (that is a kind of primary key) and when the Id mismatched with our database then sync does not work properly for those records.

 

For this, we need to get the CustomerListId from QuickBooks to avoid such discrepancy by some unique key like Agent Id, if someone help based on experience will be greatly appreciated.

 

Best Regards,

[Removed]

8 Comments 8
Giovann_G
Moderator

QuickBooks Desktop

Hello, Vipin.

 

I understand how important it is to sync your QuickBooks data with your database record. I can connect you with the best available help to get you the help you need.

 

Have you developed a database-connected app and integrated it into QuickBooks Desktop? If this is the case, only QuickBooks can assign the Customer ListId, which cannot be changed. 

 

QuickBooks may appear to cause a ListId change if you have a customer with job information and try to add a job to that customer. It could result in the data not syncing correctly because it doesn't match your database record.

 

I encourage you to visit our Intuit Developer's page and submit your questions. You can either log in or create a new account using this link: Intuit Developer. Someone from the developer's team will respond to any questions or concerns you have.

 

Do you need help sending an email of your sales forms, invoices, and statements to QuickBooks Desktop? If so, you can learn how to send them individually or in batches by reading this article: Email sales forms, invoices, and statements in QuickBooks Desktop.

 

Please let me know if you have any other QuickBooks concerns besides this one. I'll be around to assist you.

Vipin Panwar
Level 1

QuickBooks Desktop

Hello Giovann,

 

Thank you for your reply.

First of all can you please help us to know more about "QuickBooks may appear to cause a CustomerListID change if you have a customer with job information and try to add a job to that customer"?

Are you referring to a Job as shown in the attached snapshot? If Yes, then we confirm that we are not adding a job to the customer.

 

Further, we have analyzed the application production database and noticed that the CustomerListId has been changed compared to the QuickBooks database. so when we sync a record the CustomerListId as a unique identifier gets changed leads to an issue the sync does not work.

 

Thereafter we analyzed the scenarios offline to figure out when QuickBooks Desktop triggers to change the CustomerListId as a unique Identifier.

 

CustomerListId didn't change and VendorListID same,

     Case: When moving QB DB from 1 computer to another Computer location
     Case: Sync or Re-Sync

CustomerListId changed and VendorListID is the same,

     Case: When deleting a record (A record is a Job as per team)

 

I would appreciate it if you help us join a quick Zoom meeting and we explain the situation. I can send you the meeting invite upon your availability. Greatly appreciated.

 

Best Regards,

[Removed]

Vipin Panwar
Level 1

QuickBooks Desktop

 
Rasa-LilaM
QuickBooks Team

QuickBooks Desktop

Welcome back to the Community, Vipin Panwar.

 

I appreciate you providing more details about your issue, especially the screenshot. Let me direct you to the appropriate channel so you can resync the CustomerListId with the correct information.

 

To identify the source of the issue, we'll need to review the setup for your customers' information. However, in order to open an account, I have to collect personal information. Because the security of your data is our top priority, I recommend contacting our Technical Support Team. 

 

This way, you can go into greater detail about the situation. From there, our specialists will conduct a screen-sharing session to double-check why the CustomerListId changes when synced. 

 

To contact support:

 

  1. Open your QuickBooks and head to the Help menu to select QuickBooks Desktop Help.
  2. Choose Contact Us and provide a brief description of your issue.
  3. Select Let's talk and choose a way to connect with us.

 

Here's an article that provides detailed information on the support hours and types: Contact QuickBooks Desktop. You can learn more about how to manage your company's income as well as customer transactions and information by clicking on this link.

 

If you require additional assistance with any QuickBooks tasks, you can access our online resources. They're organized by topic so you can view each one quickly.

 

Keep me updated if you have any other customer-related concerns. Simply click the Reply button and post your comments.  I'm always ready to lend a helping hand. Have a wonderful day.

Vipin Panwar
Level 1

QuickBooks Desktop

Hi Vanessa,

 

Regards Case Number: 1586303188

Thank you for joining a meeting with us today and discussing the issue further. 

 

To further identify the source of the issue, as advised in the above thread we shared more detailed level information by sharing our screen on video conference and reviewed the setup for our customer's information to make the support team learn more about the issues.

 

Based on our conversation we didn't get a solution to the issue or original problem.

 

They (Vanessa from the QuickBooks Support team) mentioned this problem is beyond their scope and they suggested that we should contact the Intuit Developer team directly. We have no open channel to directly connect with the QuickBooks Intuit Developers.

 

Is there any way we can connect to the QuickBooks Developer team or via callback or email us?

 

Best Regards,

[Removed]

Email: [email address removed]

Contact: [Removed]

Mich_S
QuickBooks Team

QuickBooks Desktop

Yes, there's a way to connect with the Intuit Developer team directly, @Vipin Panwar. I'm here to walk you through the steps to reach them.

 

You can get in touch with our developers by posting your concern on their website. This way our developers will be able to engage with others and discuss programming and/or any syncing concerns.

 

Here's how:

 

  1. Log on to the Intuit Developers webpage.
  2. Click on QuickBooks Desktop under What do you need help with?.
  3. Pick Ask a Question.
  4. Sign into your existing Intuit Developer Account or create a new one.
  5. Type in your concern.
  6. Click on Ask.

 

Additionally, here's a guide on how you can handle sales forms in QBDT: Email sales forms, invoices, and statements in QuickBooks Desktop.

 

Keep in touch if you have other concerns with data management or QuickBooks in particular. The Community is available 24/7 for assistance. Take the best care!



 

Vipin Panwar
Level 1

QuickBooks Desktop

Dear Mich_S,

 

Thank you for your response.

 

Just to let you know we have posted our question in this thread using the suggested steps below by you.

We need a solution from a QuickBooks Support team as we are frustrated now and feel like a football (Go here and go there but no solution) round and round. Please bring someone upfront who can assist more focused on the solution to the mentioned issue in the above thread.

 

  1. Log on to the Intuit Developers webpage.
  2. Click on QuickBooks Desktop under What do you need help with?.
  3. Pick Ask a Question.
  4. Sign into your existing Intuit Developer Account or create a new one.
  5. Type in your concern.
  6. Click on Ask.

 

Regards,

Vipin Kumar

+31-[removed]

MJoy_D
Moderator

QuickBooks Desktop

Thank you for the response, @Vipin Panwar.

 

QuickBooks Community and Intuit Developer page are two different platforms. You can follow the steps provided by Mich_S above to get in touch with our developers. It's a separate place where you can get an answer from one of the experts handling API concerns. Check out our Intuit Developer Forum to get started. 

 

Also, here's how you fix errors you'll encounter when you use Web Connector in connecting third-party applications to QuickBooks Desktop: Fix common Web Connector errors in QuickBooks Desktop.

 

Let me know in the Reply section below if you have further questions. I'm always here to help. Have a wonderful day!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us