We help IT Professionals succeed at work.

quickbooks work with the file on a synology NAS drive

Does anyone know of a way I can make quickbooks work with the file on a synology NAS drive
Comment
Watch Question

Andrew LeniartIT Professional | Freelance Journalist
CERTIFIED EXPERT
Author of the Year 2019
Distinguished Expert 2018

Commented:
If you map a drive letter to the folder the file resides on, then it should work fine, albeit slower. I've used that method to allow accountants to open files directly from a File Server share to do that. Quickbooks doesn't like UNC paths and will generally not work and cause issues without a mapped drive letter.
Business Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018
Commented:
If it is remote on a drive setup like this, you need to install the Server Manager. I do not think you can install the Server Manager on your NAS, so then this will not work.

To map a folder and use the file over a network drive like this is not supported and can break your company file, so do not do this.
Andrew LeniartIT Professional | Freelance Journalist
CERTIFIED EXPERT
Author of the Year 2019
Distinguished Expert 2018
Commented:
like this is not supported and can break your company file, so do not do this.
On an unstable network connection, yes, there can be issues, but that's also true for just about anything like MYOB, Handisoft etc.. I supported the accounting firm I worked with for over 17 years and we used the mapped drive letter method from QuickBooks versions back to v7 if memory serves.

Don't recall ever breaking a QBW file to the point where it couldn't be opened. Worst that ever happened was the transaction being worked on at the time of the network interruption was lost, and perhaps a rebuild required to restore integrity. Not an ideal solution I agree, but it does work.
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
QB is a very chatty database and I never recommend server access on anything but a fast LAN.  Too many issues from my Clients for using QB on slow networks remotely.
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
The issue I'm facing in the database manager will not recognize any mapped drives to the synology or network path need find a way to outsmart quick books to see the map as local
Andrew LeniartIT Professional | Freelance Journalist
CERTIFIED EXPERT
Author of the Year 2019
Distinguished Expert 2018

Commented:
I never recommend server access on anything but a fast LAN
Yep, agreed. Though most LANS these days run at GB speeds so it shouldn't be an issue. Back with the earlier QB versions, we were using it on a 100MB LAN and though it worked fine, it was quite slow. Still, it was more reliable than trying to get the accountants I was supporting at the time to remember copying the QB file back to the server after they updated it, so I just told them they had to live with it :)
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
I am using quick books for years the file is on the file server and have a map on all pc no issue but with the NAS I cannot make it work
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
The issue I'm facing in the database manager will not recognize any mapped drives

You can try using QuickBooks in MultiUser Mode on your local network with one Machine that owns the file. That keeps it off the NAS.
Andrew LeniartIT Professional | Freelance Journalist
CERTIFIED EXPERT
Author of the Year 2019
Distinguished Expert 2018

Commented:
The issue I'm facing in the database manager will not recognize any mapped drives to the synology or network path
That's because it's unsupported as John said :) We never bothered with using the database manager and opened the QBW file directly.

need find a way to outsmart quick books to see the map as local
A folder redirection via GPO could work for you here. Tried that?
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
As others pointed out, when quickbooks accesses a company file on a network device, it expects a QB database monitor to arbitrate access, creating the ..ND file...

Why not have the company file local on the system and use the backup tools to backup the company file to the synology drive?

Whether the file is on the synology drive or local, a second, third copy for backup purposes should be maintained. everything failes it is in many cases only a question of when.
John McNeilPrincipal
Commented:
Not sure if the Synology has ISCSI functionality but you create an ISCSI drive on your computer with the Synology as the target create the local drive in disk manager and then QuickBooks will recognize the drive as if it was local.

Regards,
JMN
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
QuickBooks is in MultiUser Mode and is hosting the multi user access
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
I did not mean to confuse things. What I meant was to have QuickBooks and its file on a local PC on the LAN network enabling other users to use it.
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
A folder redirection via GPO
why is it you think that if the share is doen via GP it should be different?
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
have QuickBooks and its file on a local PC
Will do so if will not be able to figure out something, but still trying
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
I think a share by GPO is a mapped drive and your NAS wants it as local
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
Iren the file doctor pointed to the file on the NAS selected the option workstation and got the following results (you can ignore the anti-virus issue since I also ren it when it was disabled and then this line was not there
qbws.JPGqbfd.JPG
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
I already opened on the NAS drive the ports recommended by intuit
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
Windows firewall I disabled for now
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
On this computer you can see all services are running
srv.JPG
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
Now I ren the file doctor as the server (don't think this is the right choice but still worth a try)
qbdfd.JPG
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
QBDDM.. comes from the Server Manager which I do not think will install as a program on your NAS
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
But don't you think the correct option should be workstation and there is does not complain about QBDDM
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
I am only suggesting Workstation because you cannot properly use a NAS.  

Otherwise, do you have a Server??  Then install the QB data file on a Server, not NAS.
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
No its a small office and thy want to Centralize all their stuff on one place I set then up this NAS works great till I got to qb
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
How many QB users?  Run it on a workstation on the local LAN. The workstation needs to be running all the time with QB running but it can be locked (running).
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
Run it on a workstation
This is how it is now, and if I will not figure out someway to make this work I will leave it as is. but trying if will be able to make it work it will make happy the client.
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
I tried opening qb by clicking on the file, qb started but then I got the following screen
EC.JPG
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
When I see that error, usually (not always) QBCFMonitor Service is not running and needs to be started. The other reason is a network blocking error.
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
QBCFMonitor Service is not running
It's running
srv.JPG
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
In database server manager / browse Will not open Network or show mapped drives
sf.JPG
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018
Commented:
Make sure the workstations running QuickBooks can map folders and files (NET USE Z: \\  mapping) on the other machine and that firewall is not blocking connections.
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
Have no issue mapping folder from other computer and on the NAS
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Take the NAS out of the loop.

If QuickBooks is on Workstations you probably do not need that. Uninstall the server manager and then folder sharing and multiuser mode should work.
John McNeilPrincipal
Commented:
As I  indicated above you can create an ISCSI host and target if it's a newer Synology to the workstation that will host the QB application.  You then share the QB drive from that local workstation and QB will allow you to go into multiuser mode.  1 caveat is you must leave that client workstation on all the time as your QB machine.  In most  of my client environments I just create a vm workstation and load the QB application there create the ISCSI on Synology and on the VM machine.  QB is happy and you can serve up the QB database from a NAS drive.  I have done this many times with WD NAS units but I am sure Synology work the same as long as it has ISCSI feature.
Andrew LeniartIT Professional | Freelance Journalist
CERTIFIED EXPERT
Author of the Year 2019
Distinguished Expert 2018
Commented:
If you create a Junction Link to the folder on the NAS drive, QuickBooks should see it as a local folder and behave accordingly.

You can use Junction v1.07 to create the link, or just use DOS and Powershell commands to achieve the same thing.

This discussion on Stack Exchange provides some excellent examples.

Hope that's helpful.

Regards, Andrew
John McNeilPrincipal

Commented:
Sorry not saying one way or the other is specifically better just that what your asking is possible if it is setup as I have indicated.
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
ISCSI
The problem with iscsi is that it still uses the actual pc resources to connect to the qb file, plus the backup will be split between the nas and the actual pc
John McNeilPrincipal
Commented:
QB will backup the files in the exact same way as it sees the data as located on a locally mounted drive.  I have not been able to perform this task without a wkstn to run additional services because of exactly what John Hurst said above regarding QBDDM.  That's why I generally put this on a separate VM workstation but I know that's not always possible in all situations.  Benefit of ISCSI is it will allow client side caching which will improve your QB systems database write and read cache dramatically over using  SMB.
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
Officially this will not work
https://forum.synology.com/enu/viewtopic.php?t=48954
https://community.intuit.com/questions/1439304-quickbooks-2016-on-nas

I am close to give up on this one I will have a look on  Junction although I think it only works to local files not to network shares, but will try.

Will also look in ISCSI
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Officially this will not work

That is pretty much where I began earlier.
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
That is pretty much where I began earlier
agree, but I thought I may find a some kind of workaround
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
For a multi-user, the only workaround is the iscsi solution suggested which will be making one PC as the host of the share and qb db manager Dan monitor and arbitrate access.

Have looked into a Linux/UNIX based file share cifs host on which qb Linux db monitor might be used, but have not located such ....
Abraham DeutschIT professional
Top Expert 2016

Author

Commented:
At the end I was not able to find a simple workaround, qb wants is data manager on the machine the file is since a LAN is linux it will not host data manager, with iscsi it may work but was not willing to invest more time for this client. I had the same issue with a sql program he has. would I know before that he wants it for more then regular file hosting I would look in to the 218+ which is  able to run its own virtual pc (I got him the 218 the + is like $50 more).
Thank you all for help me trying but had no luck on this one
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Thanks for the update and I was happy to work with you
So after talking to intuit  they gave me this solutions the works
Multi User Support

Follow the "Enable Alternate Setup Mode" in the bottom.

You will need to create a different users in QB for each person that will open the file
You can do that in QB under Company >> Set up users and password

Good luck