Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
F
FTneelie
January 9, 2019
Question

multiple jobs limit for the same customer

  • January 9, 2019
  • 11 replies
  • 28 views

Hello,

I work for a software company that has a tool to export invoicing data from our software into QB. 

A client of ours has close to 7,700 jobs under one of their customers.   The export is completely dragging when exporting a new invoice to this customer while a payment exports without issue. 

I believe the issue is from the large number of jobs under this particular customer. 

 

What is the number of jobs Quick books recommends to stay under? 

Client is using Enterprise desktop. 

Thanks so much for any assistance!

 

 

 

 

11 replies

Angelyn_T
Angelyn_TModerator
Moderator
January 9, 2019

Hello there, @FTneelie.

 

I'm here to help share information about job types limits in QuickBooks Desktop (QBDT).

 

Please bear in mind that the exporting process may take some time depending on the size of the file and the number of transactions.

 

The job types limit in QBDT is 10,000, therefore, the 7,700 doesn't cause any issue with the process. To see the list of QBDT maximum number of list entries or list limits and custom fields, you may check this article: Maximum number of QuickBooks Desktop list entries (list limits and custom fields) .

 

Don't hesitate to add a comment below if you have any other concerns about QBDT list limits, we're always here to help. Have a wonderful day ahead!

qbteachmt
qbteachmt
Level 11
January 9, 2019

It seems they are making a New Job with every sale, then? "A client of ours has close to 7,700 jobs under one of their customers"

 

They would not need Jobs at all, in that example. Job = like Subcustomer, not Every individual Sale.

 

@Angelyn_T

This is Wrong for Enterprise: "The job types limit in QBDT is 10,000, therefore, the 7,700 doesn't cause any issue with the process."

 

Job Names, not Types.

 

If you read the link you provided, Enterprise handles over 100,000 and if you press F2, you see the total of All Names, in a QB File. Enterprise allows for one million, as noted in that url article, Note 2.

 

 

F
FTneelieAuthor
January 11, 2019

Hello Angelyn_T and qbteachmt,
Thank you both very much for your feedback!

I had my client run a test.  Would an EDITED invoice that previously dragged because it was 

NEW also drag?  The answer is no.  So to confirm it is only NEW invoices having an issue - everything else exports fine.  It seems  the creation of the job in QB is the big holdup for clients who have a lot of jobs already.  Once the job is created everything else if good to go. 

Any way around this big delay?

I suggested created a new client (same one) in QBs so it has a fresh start and when running reports and such the client would have to remember to include both now - fairly simple, but the 

client was not really interested in that. 

 I agree the client does not need to use Jobs - especially their line of work and all of my other clients do not use Jobs and do not have this issue. 

Can you just change your QBs from JOBS to CUSTOMERS easily?  Repercussions? 

 

Thank you again for all your input. 

Regards,

Neelie

 

 

 

 

 

qbteachmt
qbteachmt
Level 11
January 14, 2019

Hello Angelyn_T and qbteachmt,
Thank you both very much for your feedback!

OK I will suggest to my client to switch to JOBS again, but that is up to them - they may not want to do this.   If they do not switch then I am still left with my original problem. 

I am surmising the process of scrolling the big list of jobs and then inserting the new job is 

what is causing the problem-that is the only time there is a problem.  I don't know what else it could be.  

Any thoughts on this? 

Thank you for your time. 

Neelie

 

 


An invoice is not Dragged. Names are Moveable. Invoices have the name on them, and are linked = Relational to the Name. That's why it isn't One Invoice means New Name. If I work for you year after year, you are just the One Customer Name for me. If I work for your two different businesses, I would invoice you under Customer:Job, each Job = each of your Businesses. It's Subcustomer, not Each Sale. I want to see all sales, quotes and payments for that One Business of yours that I worked with you on, as that one Customer:Job Name. A Law Firm would do something similar: Client and Matter, so that your Name is Customer and Job = divorce or DUI or 1031 Exchange or Family Trust = Job Names, or What the charges related to.

 

The integrated tools are not Functioning for purposes of the QB Relational database, which uses Names as Key Fields. There should be a confirmation if that already exists or is New to QB, or New sublevel. I have a programming and SQL background. You can control these things. You need to understand the QB program interface and tables, though.

 

No, you don't start a new file. This is their Financial data, not a Names List. You are messing up people's financial records, used for Payroll and income tax filings, inventory and sales and sales taxes. Starting a new file is no Small Request. It's like telling a person: Let's change your entire family tree and DNA.

 

 

This is a Provision, not a Yes or No: "I agree the client does not need to use Jobs"

 

It's Not supposed to be done Using one Job for each Invoice. Whether or not they should use Jobs, is not the same question.

 

"especially their line of work and all of my other clients do not use Jobs and do not have this issue."

 

An integrator should not attempt to control how QB is used by the End User. The QB User decides if they need to use Customer:Job or not.

 

"Can you just change your QBs from JOBS to CUSTOMERS easily?"

 

This has already been Covered. Re-read the explanation for Opening any list in QB that has a hierarchy, see the little diamond handles to the left side, and Move things around. You can move Jobs to other Customers, Promote Job to be Customer, then Merge the names.

 

"Repercussions?"

 

You are changing the clarity, if that matters to the QB user. I would not want to Merge your Divorce, DUI and Family Trust legal work into OneName = for You, because as your attorney, I no longer see the details of what was done, charged, or when, for which of your Case Functions. That is called Client Matter in law firms, it is done by using Customer:Job in QB, and in reality, it matters to you and your attorney.

 

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement