QuickBooks

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

QuickBooks - all versions - DB Mgr issues and MultiUser mode plus simple access to a company file on a Server.

I've read article after article and  they all give the same solutions over and over - which of course are valid.  Open ports on firewall, exclude AV from scanning QB folders, share permissions, etc.
Although QB is a fantastic accounting program for the small business, its data structure and sharing is something else.  We have QB database mgr installed on servers ranging from Microsoft 2008/2012/2016 domain controllers with Microsoft DNS, dedicated QB member servers (No DNS), Windows 7/10 PCs with DB mgr, etc.  All experience the same issues over and over.
The problem:  Either cannot switch to MultiUser mode or cannot access a specific company file.

Our solutions, depending on which platform QB DB Mgr is installed on is basically to perform a "Scan" from the DB Mgr and once its complete, all is good.  Of course on DC's we have to stop DNS (or modify QB to look at other ports that don't conflict) or restart the QB service or just do the scan.  We do find that if we open the QB program on the DB Mgr server and open a company file, there is never an issue but that is not something you can leave because certain functions require QB to be in single user mode to perform.  Even if we disable any firewalls on the DB servers we still get issues.  Many times, on standalone servers, running the Scan to search for company files give a network error.  Most of the time we …
0
Get expert help—faster!
LVL 12
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Hey Guys,

I am trying to public Quickbooks 2018 APP on RDS hosted on 2012 R2 Standard server.
Currently there is Outlook 2013 and Remote desktop connection which are successfully published.
There was Quickbooks 2017 that was published earlier but I removed it as I installed the latest version of quickbooks 2018
which I now want to publish.

Under my current collections, under RemoteAPP program I tried publishing it but it gives me an error saying the app cannot be published.

Status: Failed: Could not create a published application instanced on the server  server.domain.local.

It still for some reason adds to the list of Remote APP Program box. Screen shot:

Capture.JPG

Just to test I tried publishing calculator but same error. I could not find any errors entries in event log on this server.

When user logs on to the web portal for RDS, they only see Outlook 2013 and RDP shortcuts. I did tried rebooting server
but still the same.

What am I missing ? Are there additional steps those I need to take ?  This is the first time I am attempting publishing the app.

Thanks
0
Hi Experts,

My QuickBooks company file is damaged and not opening. Please help me to fix the problem. I have tried QuickBooks file doctor but didn't work.
0
After being hit with Ransomware, restoring from backup, and reinstalling applications as needed, I can't get the Quickbooks Database Server services started or the Quickbooks Database Server Manager to run. When I browse for files and 'Start Scan", it attempts to start the services after browsing the files, finding Quickbooks files. It claims the folder in which the company files live isn't shared. I guess that's technically true, but the directory one level up IS shared, so it's possible to browse to it from a network share. Then it tells me it is attempting to resolve Networking issues, and tells me after that to resolve network issues and try again later (not the exact syntax, obviously).

I have tried installing just the bare server (what we had done in the past), installing the full version of Quickbooks (2016 for the moment), uninstalling, rebooting the server (2008 R2), reinstalling just the database server, using the Quickbooks clean boot utility, disabling ALL firewalls (Kaspersky and WIndows Firewall), I can't get the QBDbMgrN to start and stay started. I can't get the QuickbooksDB26 started. For some reason it claims to be a service that should be started manually. I don't recall that having been the case in the past.  Also,  I don't think the QuickbooksDB26 ever disappeared, even after a clean install (using the Clean Install tool), an uninstall, and/or a reboot.

Previous to the ransomware, the server had Quickbooks 2015 and 2017 database servers installed. …
0
I have two flash that I am using to back up Quick books.  Each night I use "1" drive and the next night I use "2" drive.  The problem is, Quickbooks always uses the same drive letter to do it's backup.  However, Windows assigns a different drive letter each time I insert the different drive.
This problem also exists with sync back software.  If the backup drive is assigned "E" and I take the backup drive out, then the next time I plug it in, Windows might assign it a different drive letter and so Sync back can't back up until I manually assign it the same as before.  
 Is there a way to force windows 10 to keep the same drive letter to both drives?
0
.  This computer needs to host quickbooks, standard basic office apps will be installed and used on it; and other computers will sometimes remote desktop into it.   This computer is obviously overkill but we want Dell RAID 1 controller redundancy.  Is there a more reasonable Dell spec with real significant saving to be had.  I'm not just saying let's reduce quantity in these items to save a couple hundred bucks.  I'm thinking RAID redundancy but more like a $1000 dell tower.  PS - We do need the dual display port video card included.  Anyway, your thoughts?

Dell Precision Specs
0
I'm looking for alternatives for accessing QuickBooks Enterprise remotely.  I'm looking to upgrade a server that is currently in a workgroup environment. It's a Multipoint Server, so does not require Active Directory for RDS functionality.   The users need full functionality of QuickBooks, so QB Online not really an option.  

Since Multipoint is long gone, Windows Server Standard is the only option, necessitating AD for RDS functionality.  The user base really isn't large enough to justify a Domain Controller and AD, but there is a need to access QuickBooks out of the office.  Currently 7 QuickBooks users, with the possible addition of 1-2 more in the  near future.  So, I was wondering if something like Cisco Webex or something similar is a viable alternative?

The other issue is installing QB Desktop on the 7 users PC's and accessing the Company File via mapped drive.  What's the performance hit likely to be?

Thank-you for your input.

T
0
Need some help with remote users and QuickBooks database manager. I am running QB database manager on a Dell PowerEdge and using a TZ300 SonicWall for the vpn. remote users are connecting to the network via NetExtender. They are connecting great, they see all the network files and folders. They even see the QB database files fine. The problem is when opening QB it freezes after entering the password. QB opens you can select the company to open but after password, nothing. Anyone have any ideas? I'm sure its a setting on the SonicWall that needs set. A firewall access rule or something. Any ideas would be greatly appreciated.
0
Quickbooks 2018 runs in Safe Mode but crashes on startup in Normal Mode.  

We have a client with three Dells that will crash Quickbooks 2018 on startup in Normal Mode, but will run it fine in Safe Mode.  They are all running Windows 7 Pro 64-bit, and have AMD video cards.  (I mention this because I found an article suggesting that these issues might be due to AMD video card drivers.)  Two are Optiplex 7010s; one is a Precision M6700.  There is also Nobilis / Equus workstation with an i3, using Intel onboard video, and it runs QB 2018 without issue.  

All of these computers have earlier versions of QB installed, all of which run fine.  The problem exists whether running under the local user account (which is an administrator) or the local administrator account.  (There is no domain.)

If I run Windows in selective startup (or if I run Windows in Normal Mode with just the services that were enabled in Safe Mode), QB 2018 still crashes.  

I have done repair installs of QB 2018.  I've uninstalled and reinstalled it.  I recall reading that something with the Dot Nets could cause this issue, so I completely removed all Dot Nets, then reinstalled them by running the offline installer or by running the QB installer.  No change.

The error in the event log states:

Faulting application name: qbw32.exe, version: 28.0.4001.2806, time stamp: 0x598ca36d
Faulting module name: ucrtbase.DLL, version: 10.0.10586.212, time stamp: 0x56fa10f1
Exception code: 0xc0000417
Fault …
0
how can we out to this problem if you are facing corrupt or damaged quickbooks error?
0
Keep up with what's happening at Experts Exchange!
LVL 12
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

A potential small accounting client called and asked about setting up the following scenario:

They want to have their clients remote into a server, then log into Quickbooks to work on their own data. There might/would be multiple clients remoted into the server at any given time working on their own individual QB files. There are currently 10 clients, but that list would be fluid.

The potential client currently has no server, so the whole thing would need to be set up from scratch. Are we talking about a Terminal Server running under hyper-v on a Server 2016 host? VPN or SSL VPN connections using a business class router? Licensing?

Have never worked with Terminal Server/Remote Desktop Services, so am not familiar with all the bits and pieces needed to set this up..if it's possible.

Once I identify all the necessary pieces, I can put together a quote for them.

Would appreciate any and all pointers!

Thank you!
Mark
0
Client is a busy Coffee Shop that uses QuickBooks Desktop Enterprise 2017 in the back office.  They used to use Quickbooks Payments, and they’ve changed to another, from Vantiv.  Now they’re struggling with getting their credit card transactions from Vantiv into Quickbooks, with the same level of detail they enjoyed with syncing Quickbooks Payments.  

How do we link Quickbooks and Vantiv, to make “importing” credit card transaction detail into the Undeposited Funds possible?
0
I have a customer that has a shop laptop and an office desktop.  He has quickbooks on both computers.  The Office computer is where quickbooks files are kept (ie Public>public documents>intuit)
we had both computers set up as a homegroup and then the shop computer was map-networked to the public folder on the shop comptuter.   Everything was working fine until last night when the customer took the laptop home.  This morning, when he tried to re-connect, quickbooks could not find the quickbook files on the office computer.  When I came there, the home group somehow had been removed on the shop computer and after getting home group going on that computer, I still could not see the public folder from the shop laptop.  I can only see documents, pictures, music, & video files.  What am i missing or doing wrong?
0
I am using Quickbooks Enterprise in multi mode on my network. The Database manager and files are all stored on a local server. When I am on my LAN everything works great. I am trying to use my Sonicwall/ Netextender vpn connection into my LAN. I connect fine and open files and folders on the server no issue. I launch Quickbooks, select the company to open and sign in with username and password. Thats when Quickbooks locks up and stops responding. Anyone have any ideas on this one? The only thing I cant get to work on the vpn is Quickbooks.
0
We are trying to clone a client's machine that has Quickbooks and Quickbooks Point of Sale 2013. We are cloning from a old 80GB Seagate SATA drive to a NEW Crucial 250GB SSD using Acronis True image. The clone "successfully" finishes and we can boot the system with the SSD. The issue arises when we open MS Office or Quickbooks and it asks for a re-activation. Normally not a problem but  it alarms the customer who would like to do this to another machine that has had the HDD replaced many times (long story). In addition the original 100GB drive also ask for activation and can not find the POS files after the clone is done. This also happens on the SSD, but we believe that it is linked to what is causing the activation issue. Again, this aggravates the customer as we assured that the original drive will be untouched ( and it was ) but can not find any reason for this. we have resolved the POS issue.

My question is: Is there any absolute way that this can be done that not cause re-activation, or makes sure that the drive is a 100% true copy of the original?
0
QuickBooks 2018 and Outlook 2016
I want to include my Outlook signature (with included logo) on emails sent from QuickBooks.
I have signatures turned on for all emails but email from QuickBooks doesn't include it.
0
QB files - CurrentQB files from BackupHi,
 
 I have a situation where a Quickbooks  user downloaded transactions from the bank website and it altered multiple accounts this afternoon.
 Fortunately I perform file backup during night and also mid-day. So I see QB files as of this morning.
 How do I go about using QB files as of this morning?

Thanks.
0
Just installed Quick Book Enterprise 2018 that is said to come with QODBC to allow Microsoft Access to read its files.  I want to Microsoft Access to read Transaction Detail By Account report in a table in ACCDB format. Is it possible?  If so can you walk me through?
0
We use QuickBooks 2016 and we have lost the ability to send eMail through Outlook 2016. Have tried all the solutions on the Intuit site, our Mail API works correctly and preferences are set, etc.
0
Cloud Class® Course: MCSA MCSE Windows Server 2012
LVL 12
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Does anyone know of a way I can make quickbooks work with the file on a synology NAS drive
0
Thank you all in advance.

We setup a Windows 2012 R2 server to use for published/remote app. It is running as a VM and seems to have enough hardware resources available.
I have been able to get everything up and running and get users connected.

The issue is that when they close the app the process for that app is still running on the server and the next time they go in, they get a error that the app is already running,

Specifically, this is happening with QuickBooks Pro 2017.

Any ideas? I'm not really sure where to start.

Thanks,
0
What versions of QuickBooks allow checks to be printed?
0
Currently have a workgroup environment that with a server running Multipoint 2011, primarily for RemoteApp access for QuickBooks.  Company has grown since it was installed about 5 years ago. Now about 12 users in the main office with 4-5 accessing QuickBooks at any one time.  There are also about 10 laptop/tablet users in the field using MS Office Apps primarily.  They connect with cellular hotspots, so connections are variable.  Expect to add a few more in the near future. Approx 30 devices total, because some users have desktops and Surface Pro tablets.

Have NAS for storage currently, primarily for local backups.  Office and email is through Office 365.

We are needing to add more storage to centralize access, and update the server(s) for QuickBooks and adding a DC. Am considering on-premise vs cloud server options and wondering if it would be better to stay on-prem for the best performance.   Any recommendations would be helpful.
1
4 computers in workgroup accessing a network NAS...
NAS size is 3.57 TB...
When I do a full  backup it totals about 122 GB...
Of which 118 GB is all in one folder...
So...about 3+ TB is junk files...

Every now and then the NAS fills up...cannot save data to the NAS...
And after a few hours the NAS reduces the data back to it's normal size...have no clue as to why...
When I run Tree Size it seems to indicate that the Quickbooks data reporting too high allocation...

Seems to have started when I replaced 2 comptuers with brand new PC's...Win 10...
One of those PC's has QB installed and is the ONLY PC that access the QB data files located on the NAS...

Tree-Size.docx

Difficulty  getting work done as none of the 4 PC's can save data to the NAS...

Any ideas...suggetons appreciated...
0
I am trying to install QuickBooks 2016 on Linux using wine. I keep coming to the error, during installation, that it cannot find MSVCP120D.dll and MSVCR120D.dll. Numerous sites have pointed out that these are debugging DLLs not normally shipped (https://stackoverflow.com/questions/21707992/msvcp120d-dll-missing). I've tried everything I can think of including different version of wine, 32 and 64bit modes, linking MSVCP120D.dll to MSVCP120.dll ... None of the office workstations have MSVCP120D.dll even though 3 of them have the very same licensed copies of QuickBooks.

I think the bottom line is that I need to find these dll's. Any idea where I can get them? I've searched to no avail.
0

QuickBooks

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.

Top Experts In
QuickBooks
<
Monthly
>