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

Hello everyone, pleas help me in setting up quick books server and database. What are the requirements? Currently its installed on one of standard workstation. I recently join this company and admin i IT. Please help and advise me. I have to transfer all this data to server. Please give me all requirements list so that can setup quick books database efficiently. Thanks.
0
Enroll in June's Course of the Month
LVL 8
Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

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
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
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 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
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
Technology Partners: We Want Your Opinion!
Technology Partners: 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!

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
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
Free Tool: IP Lookup
LVL 8
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hi, I'm having lots of issues with QuickBooks 2016 pdf converter, right now the pdf printer is not showing under the device and printers, I have tried the pdf repair tool from their website and it did not work, I have tried to repair the quickbooks software and it did not work, before deleting the printer I was getting an error 35 for printer not activated and now since its deletion I can't put it back, any help?
0
We have an RDS server set up on Server 2012 R2.  It has Quickbooks Desktop Enterprise Solutions:  Accountant 17.0, Quickbooks Premier Accountant Edition 2016, and Quickbooks Premier Accountant Edition 2017 installed.  There are fewer than 10 users.  

The RDS users all have local accounts, though the RDS server is part of a domain.  (We figured that by sticking with local accounts, that would ensure that the users had absolutely no access to any other network resources.)  All of the RDS users are members of the Remote Desktop Users and Users groups.  

The standard user is locked down and does not have access to browse the C: drive.  When setting up each user, we left administrator access enabled, then opened the database files in Quickbooks so they would show up in the list of recently opened files, and then removed administrator access.  This gave them the ability to open the database files through Quickbooks while restricting their ability to browse the C: drive.

The folder structure is a folder called Quickbooks located on the root of the C: drive, with subfolders for each user's company files.  Each user is the owner of its respective folder, and Creator Owner has full control.  Also, the local administrator, domain administrator, and system accounts have full control to the Quickbooks folder and all of its subfolders.  The users cannot browse to any folders (through the Quickbooks file-open prompt) aside from their own folder.  

The users who are using QB AE …
0
I am looking to survey the crowd for opinion on a server.  I would sincerely appreciate your weighing in.

For a small business of the following size / needs would this server be appropriate?

10 to 15 workstations on domain

Server (2012 R2) will be used Active directory, folder ridirection & shares.

There is a file maker file that is shared out to the workstations

The server runs a program from intacinternational.
http://www.intacinternational.com/wintac-2016-minimum-system-requirements

The server will host Quickbooks

These are the specs:

Dell PowerEdge T320 Xeon Server 2012 R2 Standard Redundant Power 32GB 12TB (6 x 2 SATA) H310

Would this be underkill / overkill?  

Thank you so much,
Tim
0
In QuickBooks Premiere 2017 I have a user who can't open the Accountant Center in at least two company files. I am able to open the same company files and get into the Accountant Center.

I checked the Open Windows view to verify that the Accountant Center window wasn't opening out of sight. I had the user try on different computers and the issue follows the user but I haven't been able to identify a cause in the profile.
0
We have a very odd problem, and talking to the support (if you want to call it that) at Quickbooks is useless.

We HAD a 2012R2 server with Quickbooks 17 and Office 2017 on it, the hardware was quick but not that great, running as a terminal server.  Whenever users would export certain types of reports to Excel it would take 15-20 minutes for reports that were not that large.

We recently purchased a 2016 server, all SSD drives, 128GB ram, 8 core XEON 3.8ghz Dell PowerEdge, also set up as a RDP server, we load QB on it, the machine is lightning fast, load Office 2017 on it, then try to export a report and again, just as slow as the old server.

This is very frustrating.  Server and QB are updated with latest software and patches.

Any ideas?
0
I am trying to send invoices from quickbooks through 'other' email exchange 2010 server.
When I send the message, it keeps prompting for password.

The Exchange 2010 server is configured to accept email relay (receive connector configured) with simple authentication.
Outlook anywhere connects with my UPN credentials, and I am able to login through OWA.
When I test the 'auth login' via telnet session, I get 'authentication unsuccessful'
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.