QuickBooks

1K

Solutions

2

Articles & Videos

2K

Contributors

QuickBooks is an accounting software package geared mainly toward small and medium-sized businesses and offers on-premises accounting applications as well as cloud based versions that accept business payments, manage and pay bills, and payroll functions. QuickBooks includes remote access capabilities, remote payroll assistance and outsourcing, electronic payment functions, online banking and reconciliation, mapping features through integration, improved e-mail functionality, import from Excel spreadsheets, employee time tracking options, pre-authorization of electronic funds and new Help functions.

Share tech news, updates, or what's on your mind.

Sign up to Post

Network 1gb the main computer is wired with 1gb , a couple of wired computers and some wireless tablets that has AC Access Point.

What can I do to make it faster?

Just move to SSD hard drive? or there are other ways?

The main computer has windows 10 with a regular hdd.
0
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tomorrow I will be replacing two computers (easy), and replacing their server that runs quickbooks pro 2010 and is their DC for about 5 computers.
Their server is server 2003, the new server is 2012 essentials.

What is the best way attack to this?

I was thinking replace the two computers first and don't join to domain just yet.
Upgrade quickbooks to 2017 desktop pro on the old server.
Then start to set up the new server. Transfer the quickbooks files over after it is set up.

Is there a best way to do this?

Any help appreciated.
0
I am coordinating the build of a MS Access DB with some SQL and VBA on the backend that uses data from the Quickbooks (v17) SalesOrderLine Data to manage a production workflow system for a small parts manufacturing company.  All data comes from the SalesOrderLine table exclusively. I am looking for a Unique identifier in that table to use as a filter for various sorting and prioritizing purposes.  I have not been able to locate such a field in the SalesOrderLine Table.  

The application is functioning well with one component dependent on this unique field value.  I hope to deploy in production fairly quickly.  We are in UAT testing now and learned that this one piece needs resolution.

QB has two fields labeled FQPrimaryKey and another FQTxnLinkKey but neither are unique. Is there a possible line count within the sales order that I can add to a record TXNID that would make it Unique? Some other avenue to pursue?

Does anyone have any experience or suggestion relevant to this area of QB specifically?   If so, would you please share your thoughts and/or solutions?
0
I am repairing a part of an MS Access database where I need only the first part of a field from data pulled from QODBC Quickbooks.
QB Table SalesOrderLine.  QB Field ItemSalesOrderLineItemRefFullName].  Our data syntax is nnnnn-xx.  I want returned only the five digits and assign a Column name.  I am a novice attempting to repair someone elses work.  Suggestions please?

My select query works fine until I needed to parse out the first 5 characters in that field. The results will be placed into a form in the same MS Access DB.
0
QuickBooks is not letting me to register on Windows 10- just installed the 2011 version on Windows 10 and keeps crashing
0
Hi Experts,

I need to access a previous Sales Tax report, but when I do, I get the attached.

I don't understand why, because I have Adobe Acrobat Reader DC, File Version 17.009.20044.25828 installed on my Win 7 and use it daily.  Whats wrong?

Any help is  appreciated.
QB-PDF.png
0
I cannot figure out how to get my invoices to display the employee for each time sheet it imports into an invoice and list that as a data column
0
I have Quick books 2014 and need to have it on 2 computers. It opens find on the first computer but on the second computer it wants to change the password every time we login. How do I get around this problem? I have it set to multiple users. Both computer are windows 10.
Thank you.
0
I have a client for whom QuickBooks 2017 (Local copy NOT network version) is failing to load under Windows 10 Pro. It previously worked just fine. Recently AVG anti-virus was installed which corrupted the networking connections. AVG was uninstalled and networking resumed as normal.

An uninstall and reinstall of QuickBooks has not resolved the problem. QuickBooks support has essentially given up on the issue. Have tried it under safe mode ... same problem ... fails immediately upon starting to load up.

Any ideas? Seems only option is a complete reformat and install of Windows 10 pro and all software including QuickBooks. Not looking forward to that!

Regards, Dave Melnyk
0
I know, Quickbooks might be easier, but the wait will kill you.

Just updated a customer from Qbooks 2013 to 2014.  Everything went great.  One problem.  Their checkbook register has defaulted back to a starting entry of 03/01/15.  I backed up everything (and made spares of those).  I captured the .QBW and the .QBB's going back a year (most current today).  I did the restore of the company file and that works fine, but the checkbook register is as I mentioned earlier.

What am I missing?
0
Announcing the Most Valuable Experts of 2016
LVL 6
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

We have a system that was upgraded to Office 2016 from 2010.  We thought this issue may have been PC related so we built a new PC with Windows 10 and Office 2016 fresh installed.   The problem duplicated itself.  Here is the info:

Anytime an invoice is sent from Quickbooks 2017 using Outlook 2016, the email gets an Undeliverable message moments later with the following:

Your message did not reach some or all of the intended recipients

530 5.7.0 Authentication required


We are using MDaemon Outlook connector 4.0

I have checked the connector settings and SMTP Server requires authentication is checked and use same authentication as incoming server is checked.  

All other emails work fine.  Only emails sent through Quickbooks are an issue.
0
Hello everyone,
I was asked to set up email sending on Quickbooks 12.0 Contractor.  The user is using Office 365.  I tried to follow the steps as noted in this article https://community.intuit.com/articles/1501520-set-up-your-email-service-in-quickbooks-desktop, however there is no option to select Outlook and when I try webmail, I put in smtp.office365.com and ports 25 and I have also tried 587.  There is no where to put in a user name or password in the box either which confuses me more.  I think that this user may need to upgrade, but I am wondering if anyone has any sort of workaround or suggestions.  Thanks
0
Installed Quickbooks 2017 and installed the DB Manager on the 2016 Server.

It keeps kicking users out of multi-user mode and only allows Single User.

I keep having to stop the DNS Servcie and re-run the Scan and when everyone can get in

Kick the DNS Server back on again...

this is getting old.....

What is a Fix for the 2017 DB Manager using the Same Ports as the DNS Server.

I Wish to have Quickbooks change Not Microsoft Please.

Thanks

Cjoego
0
We have recently upgraded our Quickbooks multi-user  software from 2014 to 2017.  Since the upgrade, I have not been able to bet the multi-user function to work.  Nothing has changed with network (single server operating under Windows 2012 R2).  When starting up the database monitor, get an error message, "+Windows firewall: Connection sharing  not allowed".  I have verified that all firewall ports and  all qb programs have been adddwd to rhe exception rules,  I have even tried turning off the firewall, but still got error message.  Dies anyone have any suggestions?
1
Hi, I have a computer hosting the database server manager.

Quickbooks database server manager

I have my first client enabled for host mult-user access.   I mapped to the database server manager's share and I selected the following QBW file

Open a Company

However, I ran into this connectivity isssue with the QBW file on the client when contacting the server.

Problem with multi-user hosting setup
0
Hi,

I have been using Excel (Google Sheets) to manage my accounts / balance sheet for the last number of years.

- income with Tax breakdown on the left
- expenses with Tax breakdown on the right
- totals at the bottom

It works well for me, however I'm slightly concerned over how easy it is to update a cell in error with '10' vs '10000' without recognising it.

Can anyone recommend any software that provides the following:

- easy interface
- export for backup
- ability to duplicate line items (recurring expenses and income) so that when a recurring payment lands in my bank account, i can duplicate a previous record and update the date
- add note to each line item

Additional Benefits
- app
- receipt management

Thanks in advance for your help.
0
My credit score has greatly improved and the value of my home has also skyrocketed compared to how much is left on my current mortgage.

I would like to refinance my current mortgage and also draw money through a home equity line of credit to pay off other higher interest rate debt.

What are some good banks, credit unions, or financial institutions for doing this?
0
Yesterday I had a user whose computer shut down because it was running low on virtual memory.  This is a brand new (to her) computer that I bought because her last computer was having these problems.  I used a program to transfer over settings from her old machine, but I am wondering if somehow that program caused her problem to be transferred to the new machine.  She is using Office 2016 and Quickbooks Premier 2016.  
The machine is an Dell 9010 i5 3.4 ghz with 8 gb RAM with Windows 10.

The event viewer for yesterday shows this:
Windows successfully diagnosed a low virtual memory condition. The following programs consumed the most virtual memory: OUTLOOK.EXE (6288) consumed 30421221376 bytes, QBDBMgr.exe (9152) consumed 562049024 bytes, and QBW32.EXE (4964) consumed 380674048 bytes.

Did I do something wrong or is this user simply doomed?
0
Hi there,
I have recently been having some issue with Quickbooks 2010 communicating with Outlook 2010. usually I am able to solve these issue relatively quickly but this one is being real pain.
I am trying to email a paid invoice. When I select the option to email, the program either either crashes or gives an error message that it cant communicate with the pdf converter.

I am able to print to print to pdf but for some reason the emailing is just not working.

Here are the things I have tried.

1. Running the Quickbooks pdf converter tool from their website. I removed all of the quickbooks pdf converters from the printer list aswell as xps printer and ran the same tool again.

I also ran another tool that asked for the version and put a bunch of programs on the desktop but I cant remember the name of it.

2. I checked all settings pertaining to printing/emailing. The prefs have outlook selected for emailing.

3. I ran a repair on the quickbooks install.

4. I fully reinstalled the application.

5. I ran a repair on outlook and recreated the outlook profile.

6. A few other things I cant really remember, but im happy to try some things again :)


I feel like Ive tried everything here and on other sites about the issue, so any information you guys can give would be great!
0
On Demand Webinar: Networking for the Cloud Era
LVL 8
On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Quickbooks Scam

I had a client ask about using Quickbooks in multiple locations. My suggestion is to use the web version for eas of use and you get at least 3 user accounts vs having to buy multiple licensees for the desktop version.  

Just as I walked into the office I was told Quickbooks had already called in and was remoting in and working on it.  I asked my client which version and he was not sure.  I went to the computer and saw a big string of pings going through the command prompt.  Suspiciously, I  Jumped on the Teamviewer chat and asked if they are migrating to the web version or using the desktop. The "tech" asked if he could call me directly.  His voice was very hurried with a heavy accent and said if we went to the web version, payroll wouldn't work.  I know that is not correct and this didn't feel right and I asked if I could call him right back at the same time I ended the TV session.

Called into Intuit to verify and at the same time saw two payments from some electronic payment company that was not Intuit. One for $449.99 the other $999.99.  Both were for "Tech support" and not an actual product.  

I explained to my client he had been scammed.  In his email, I saw there was a password recovery. I asked if he gave out his password to the "tech".  Of course he did.  I had him change his password for his email account and quickbooks.  Next call was to the credit card company.  Right away there is a recording, "It looks like there are fraudulent …
3
 
LVL 6

Expert Comment

by:Brian Matis
Ugh... That sucks. Glad you were able to help them catch the problem quick. Nice work and thanks for sharing the head's up about this kind of thing.
0
 

Expert Comment

by:Daniella Barion
Thanks for sharing.  Unfortunately, these fraud events happen more than we can imagine.  We need to be always on alert.
1
I have a customer with a small 2008 Windows server. She thinks going to the Cloud will be cheaper and easier that using a file server.
I've looked to Del for a non-server solution that will work for them. They couldn't come up with a solution using Azure. I looked at OneDrive for Business  and I think it has a file locking if 2 people work on the same file. Plus not sure how Quickbooks will work when it's in the cloud.
I looked at AWS and looks like same file locking issues.

Any solutions for an inexpensive Cloud replacement that allows mapped drives and doesn't need syncing?
0
Getting this error after installing QuickBooks 2008 on a new Windows 7 Pro computer.
0
Users cannot log in MU mode from their workstations.
I found the QBCFMonitorService.exe is stopped, and pressing StartScan button in QBDSM enables users to log in Multi-User mode.
Looking at Event viewer, I found .Net Runtime error 1026 is being logged.
What can be done about this error?

I've tried:
https://community.intuit.com/articles/1257705
server is static IP
Full install of QB 2017 Premier on Windows Server 2016 Essentials
QuickBooksDB27 is local admin with r/w on shared directory
All latest patches/updates in Windows 2016 Essentials and QB.
QBCFMonitorService is set to Log On as Local Service Account



Below is the error:

Application: QBCFMonitorService.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.UnauthorizedAccessException
at System.IO.__Error.WinIOError(Int32, System.String)
at System.IO.File.InternalDelete(System.String, Boolean)
at System.IO.File.Delete(System.String)
at Intuit.SBM.DataHelper.CFScan.CFWatcher.DeleteDSNFile(System.String)
at Intuit.SBM.DataHelper.CFScan.CFWatcher.OnDeleted(System.Object, System.IO.FileSystemEventArgs)
at System.IO.FileSystemWatcher.OnDeleted(System.IO.FileSystemEventArgs)
at System.IO.FileSystemWatcher.NotifyFileSystemEventArgs(Int32, System.String)
at System.IO.FileSystemWatcher.CompletionStatusChanged(UInt32, UInt32, System.Threading.NativeOverlapped*)
at …
0
I started having issues runing the same quick books file from different workstations so I installed quick books data manager on my file server which only hosts the QB file) The files show up when I do a scan but when I open the quick books on a workstation the quick boos database server shows no files are connected.

When I run the file doctor the file is ok but when starting to diagnose the network connectivity the following msg comes up dll.JPG and when pressing continue the doctor just runs for ever.

the QuickBooksDB23 is running

I can open QB on all computers but only in single mode as I changed on all workstations not to host multi user access which should be done by the data manager on the file server
0
I am in the process of writing some integration processes between a Wordpress site and Quickbooks.

I need to know where I can get documentation on how Quickbooks imports data - data formats, API's etc - anything I need to automate the import of data.
0

QuickBooks

1K

Solutions

2

Articles & Videos

2K

Contributors

QuickBooks is an accounting software package geared mainly toward small and medium-sized businesses and offers on-premises accounting applications as well as cloud based versions that accept business payments, manage and pay bills, and payroll functions. QuickBooks includes remote access capabilities, remote payroll assistance and outsourcing, electronic payment functions, online banking and reconciliation, mapping features through integration, improved e-mail functionality, import from Excel spreadsheets, employee time tracking options, pre-authorization of electronic funds and new Help functions.