Recommendations on what computer/server get
-
Personally for such a small/specific task, I'd get a [Beelink-type mini PC](https://www.amazon.ca/s?k=beelink+mini+pc) (I've come to love these little boxes). The backup concern is something else. Offline drives? Off-site drives? Even a handful of USB sticks would do it. Encrypt as needed. Don't overthink this. End of story.
By now I am using a software in a pentium 3 computer with Windows XP which works perfectly well but that don't cope with the new legal requirements, been trying another one in my NAS PHP+MySQL based that works perfectly (performance wise) and almost well (accountant wise), but the ones I am seeing require to be able to execute Microsoft SQL Server and therefore they ask for: Intel Xeon (*1) + 8 Gb RAM + 100 Gb SSD or SAS. Given their crazy requirements I thought of getting something that could run that software and some of the things I have now in my NAS at the same time and make it a little future proof... so go figure...
www.robotecnik.com[^] - robots, CNC and PLC programming
-
Are there hardware requirements for the software ? Are you the sole user of the data ? or your clients need access to the data ? Whatever your do, make sure your backup work; plan regular tests of your backups. I would use the server for a single purpose
CI/CD = Continuous Impediment/Continuous Despair
Yes, the requirements on their web site are: Intel Xeon (*1) + 8 Gb RAM + 100 Gb SSD or SAS. Given their crazy requirements I thought of getting something that could run that software and some of the things I have now in my NAS at the same time and make it a little future proof...
www.robotecnik.com[^] - robots, CNC and PLC programming
-
As Maximilien says, one server per role. I would put all financial activities (accounting, billing, etc.) on the same server Any decent financial package should allow copying the data from one machine to another - via backup and restore to the new machine, if nothing else. I would make sure that the seller has a documented method for transferring the software licence. Make sure of this before purchase! Where financial data is concerned, backups are extremely important. Nothing is more important to the Government than money. The specifications for the server depend very much on the requirements of the accounting etc. software. I would endure that the server is powerful enough to run all software simultaneously. You don't want to have to juggle between packages, especially if more than one person (e.g. you, your bookkeeper, and your accountant) are all using different programs simultaneously. Mention of the accountant brings to mind another thing. If he/she is an external contractor, he/she will need access to your financial records over the Internet. Do you have appropriate security for the server? Lastly, tax packages are typically validated for a given tax year, and are sold as subscriptions. Don't forget to budget for the subscription!
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows. -- 6079 Smith W.
I will be the only one remotely connecting to the server, at least by now, through a VPN and through the firewall. Backups must be done as nowadays: Keep one HDD copy at a different physical place and rotate it every month. I will have to ask all them about migrating the license... The requirements on their web site are: Intel Xeon (*1) + 8 Gb RAM + 100 Gb SSD or SAS. Given their crazy requirements I thought of getting something that could run that software and some of the things I have now in my NAS at the same time and make it a little future proof...
www.robotecnik.com[^] - robots, CNC and PLC programming
-
For financial data, you should also have a set of backups that are rotated off-site to a secure location on a regular basis. Assume the site with your server burns to the ground, how do you recover? (how long to acquire replacement hardware, software, data. This will give you an idea of how long you will be down. How old is the offsite data? What data can be reentered into the system to bring an off-site backup to current status. That is part of what makes cloud services attractive is that they can replicate your data to other geographically separate data centers and allow rapid recovery from disasters. But it all comes at a cost.)
-
I can't say I'm familiar with the accounting software options that exist out there, but I can't imagine even a phone would be underpowered for simple accounting tasks nowadays. In terms of technical requirements, I mean, obviously you don't wanna use a phone for that. But a server rack? 8TB of space? 32GB of RAM? Multiple hard drives and SSDs? Are you auditing the Pentagon? Any machine ought to do IMO for running the actual software; the real expense, I think, is going to be your backup system. And I suppose *this* is where you can blow any budget, depending on how crazy you wanna get. But that's really a separate thing.
The requirements on their web site are: Intel Xeon (*1) + 8 Gb RAM + 100 Gb SSD or SAS. Given their crazy requirements I thought of getting something that could run that software and some of the things I have now in my NAS at the same time and make it a little future proof... OF course I will have to store there 20 years of code, documentations, installation packages for the programs I have used and all their versions... Currently I have 6TB and I am using 80% of that. PS: ARRRR, I have some other big files there that are not work related and kid sister safe too.
www.robotecnik.com[^] - robots, CNC and PLC programming
-
Joan M wrote:
+/- 8TB of data space available would be nice. +/- 32GB RAM available would be nice.
Nice wishlist! Are you sure this is not overkill? I've got a 12+ y/o tower server in my home office. It was last rebuilt about 5 years ago when one of the original spinners crapped out, now running Server 2016 and no spinners, just 2 SSDs hanging out of the side and an external drive hooked up in the back. This old box still easily handles everything I throw at it. It's roles: 0: fileserver (all company projects/documentation/etc.) 1: webserver (public facing websites and ftp/sftp services) currently serving around 25 or so company/customer web apps. 2: database server (sql server) 3: print server 4: email server I'm considering moving the customer web apps/databases to the cloud and getting a laptop to run everything else.
"Go forth into the source" - Neal Morse "Hope is contagious"
The requirements on their web site are: Intel Xeon (*1) + 8 Gb RAM + 100 Gb SSD or SAS. Given their crazy requirements I thought of getting something that could run that software and some of the things I have now in my NAS at the same time and make it a little future proof... I plan to use it for the accounting software, GIT, PHP/MySQL, file server and nothing else. Truly I'd love being able to keep my NAS and let all this go... :mad:
www.robotecnik.com[^] - robots, CNC and PLC programming
-
If your accounting software needs that much horsepower, something's wrong. Me? I'd instantly create a VM and be done with it. Now I tend to buy higher end laptops, and I always get at least 64GB of ram. But as others have said, an itty-bitty cube PC with an external USB drive and you are done.
Charlie Gilley “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759 Has never been more appropriate.
The requirements on their web site are: Intel Xeon (*1) + 8 Gb RAM + 100 Gb SSD or SAS. Given their crazy requirements I thought of getting something that could run that software and some of the things I have now in my NAS at the same time and make it a little future proof... I agree you... something is wrong here... I have two options: paying for a monthly fee and not owning the program and therefore risking losing the data if I can't pay after a financial apocalypse (nothing that worries me much by now) or getting a massive computer and pay for a monthly fee to get maintenance... something that if I stop paying will leave me with a functional program and data.
www.robotecnik.com[^] - robots, CNC and PLC programming
-
Joan M wrote:
I could use require SSD and Windows to run.
I could see the second but I doubt the first. Unless perhaps you wanted to use floppies?
Joan M wrote:
Would it be better to get a tower server? or a rack server?...8TB of data space available would be nice.
What?!?! Just to run accounting software? Looking at 'QuickBooks Desktop' it does suggest 16GB of memory. It is not an online solution. Storage is 2.5GB on drive. And QuickBooks is probably overkill.
The requirements on their web site are: Intel Xeon (*1) + 8 Gb RAM + 100 Gb SSD or SAS. Given their crazy requirements I thought of getting something that could run that software and some of the things I have now in my NAS at the same time and make it a little future proof...
www.robotecnik.com[^] - robots, CNC and PLC programming
-
The requirements on their web site are: Intel Xeon (*1) + 8 Gb RAM + 100 Gb SSD or SAS. Given their crazy requirements I thought of getting something that could run that software and some of the things I have now in my NAS at the same time and make it a little future proof...
www.robotecnik.com[^] - robots, CNC and PLC programming
As others have said, a small "cube" PC should suffice. HOWEVER I see no mention of the required operating system. Recently my nephew consulted me on new server hardware to run the latest version of their ERP software, but that was nothing compared to the OS requirement (Windows Server 2019 minimum, CALs, SQL Server, 1 license per user) which could have tripled the cost of the replacement. What do they require? Will it run single user on Windows 10/11? Frankly, seeing as they only require 8GB ram I doubt that it merits a Xeon with Windows Server on it.
So old that I did my first coding in octal via switches on a DEC PDP 8
-
By now I am using a software in a pentium 3 computer with Windows XP which works perfectly well but that don't cope with the new legal requirements, been trying another one in my NAS PHP+MySQL based that works perfectly (performance wise) and almost well (accountant wise), but the ones I am seeing require to be able to execute Microsoft SQL Server and therefore they ask for: Intel Xeon (*1) + 8 Gb RAM + 100 Gb SSD or SAS. Given their crazy requirements I thought of getting something that could run that software and some of the things I have now in my NAS at the same time and make it a little future proof... so go figure...
www.robotecnik.com[^] - robots, CNC and PLC programming
Can you post what software you're looking at? The specs just seem out of line. I'm not sure what your accounting software is saving, but unless it's a lot of videos, MS SQL Express would probably exceed what you need. Here's the info: https://www.microsoft.com/en-us/download/details.aspx?id=101064 You can have up to 10GB of storage.
-
Can you post what software you're looking at? The specs just seem out of line. I'm not sure what your accounting software is saving, but unless it's a lot of videos, MS SQL Express would probably exceed what you need. Here's the info: https://www.microsoft.com/en-us/download/details.aspx?id=101064 You can have up to 10GB of storage.
I know, in fact our NAS with MySQL should be more than capable to move any amount of data we can require, but... those guys seem to point to very big companies unless you want to store everything in the cloud, then there are plenty of options. The software is SAGE 200, don't think this will be available out of Spain. I am looking at ODOO, let's see if those guys allow me to install their software into our NAS.
www.robotecnik.com[^] - robots, CNC and PLC programming
-
The requirements on their web site are: Intel Xeon (*1) + 8 Gb RAM + 100 Gb SSD or SAS. Given their crazy requirements I thought of getting something that could run that software and some of the things I have now in my NAS at the same time and make it a little future proof...
www.robotecnik.com[^] - robots, CNC and PLC programming
Joan M wrote:
The requirements on their web site are:
I pulled the previous post from their website. Click on "Hardware and operating system requirements" https://quickbooks.intuit.com/learn-support/en-us/help-article/product-system-requirements/system-requirements-quickbooks-desktop-2023/L36CSOf2x_US_en_US[^]
Disk Space...2.5GB of disk space
What it does say is the following. However that is just marketing noise because ANY software that is sourced on a SSD drive is going to be faster because SSD is faster. Absolutely does not mean it is required.
For the best performance, store your QuickBooks data file on a solid-state drive (SSD).
Also repeating what I said QuickBooks is likely overkill and there are alternatives. You can google the following
"QuickBooks Desktop" single user alternative
-
Hello all, INTRODUCTION Given the new accounting laws in our country, every company will need an accounting software that sticks to those laws. Even freelancers (as me) will have to adopt a software like that. I don't trust the cloud + I don't want to pay a fee every month to be able to use my accounting data. Now I own a NAS which is more than enough for my needs but is not capable to run the accounting programs I will be able to use in my country. Most of the accounting programs I could use require SSD and Windows to run. Getting a server would mean: * Getting a server, some SSD and HDD disks. * Getting an UPS. * Getting a small rack. * Getting a Windows server license. * Using our current NAS as backup for that server and keep doing our NAS extra backups with external USB HDDs. QUESTION What server / option would you recommend for this kind of job? Would it be better to get a tower server? or a rack server? As soon as we have children the server, NAS, UPS... will have to be placed inside a rack anyway. It would be nice to be able to have a mix of SSD and normal HDD, SSD for the OS and the accounting program and HDD to store everything else. +/- 8TB of data space available would be nice. +/- 32GB RAM available would be nice. Would it be better to install the accountant program inside a virtual machine? just to make it easier to move it from one server to another one in the future (if needed). Do you agree that it's better to get a server than a normal workstation for all this? And as a bonus... what would you use that server for apart of all mentioned before? Any additional hint/idea? Thank you all!
www.robotecnik.com[^] - robots, CNC and PLC programming
Joan M wrote:
As soon as we have children the server, NAS, UPS..
Yeah that probably isn't a good design idea. With children you need an entire room with a bolt lock at the top of the door. Where you can reach and they cannot (even on a chair.) That should work until they get big enough to understand and respect 'no'. Even better if you make sure that there is never anything fun in that room. Then even when they get older they will stay out.
-
By now I am using a software in a pentium 3 computer with Windows XP which works perfectly well but that don't cope with the new legal requirements, been trying another one in my NAS PHP+MySQL based that works perfectly (performance wise) and almost well (accountant wise), but the ones I am seeing require to be able to execute Microsoft SQL Server and therefore they ask for: Intel Xeon (*1) + 8 Gb RAM + 100 Gb SSD or SAS. Given their crazy requirements I thought of getting something that could run that software and some of the things I have now in my NAS at the same time and make it a little future proof... so go figure...
www.robotecnik.com[^] - robots, CNC and PLC programming
Joan M wrote:
the ones I am seeing require to be able to execute Microsoft SQL Server
Yeah, that's probably where the requirements are coming from. I love SQL Server, but a full-blown enterprise-level relational database like that is serious overkill for a single-user system. You also might have to look into the licensing for SQL Server if that isn't included, and it ain't very cheap. Are there alternatives that don't require SQL Server?
-
Joan M wrote:
The requirements on their web site are:
I pulled the previous post from their website. Click on "Hardware and operating system requirements" https://quickbooks.intuit.com/learn-support/en-us/help-article/product-system-requirements/system-requirements-quickbooks-desktop-2023/L36CSOf2x_US_en_US[^]
Disk Space...2.5GB of disk space
What it does say is the following. However that is just marketing noise because ANY software that is sourced on a SSD drive is going to be faster because SSD is faster. Absolutely does not mean it is required.
For the best performance, store your QuickBooks data file on a solid-state drive (SSD).
Also repeating what I said QuickBooks is likely overkill and there are alternatives. You can google the following
"QuickBooks Desktop" single user alternative
I already have an accountant software that is super old, but it works well, the only issue is that it's not maintained anymore by the manufacturer and currently it won't pass the new legislation. And I was trying to start another one that is based on PHP and MySQL and it makes more than what I need + it's free... but it won't cope with the legal requirements. The idea behind that legislation is that you can be charged 60k € only because you have a program that doesn't have a hash between invoices, that doesn't keep a log of any change made in critical documents and soon that it doesn't automatically send the invoices to the government as soon they are issued, you don't have to be doing something wrong with your program, but as you could do something wrong, they can punish you... This is crazy and creates stupid needs: the small companies can't follow up those rules and can't update their software on time and the big ones have softwares with crazy requirements that for sure I don't have. I guess the next year will be funny for lots of small companies here...
www.robotecnik.com[^] - robots, CNC and PLC programming
-
I know, in fact our NAS with MySQL should be more than capable to move any amount of data we can require, but... those guys seem to point to very big companies unless you want to store everything in the cloud, then there are plenty of options. The software is SAGE 200, don't think this will be available out of Spain. I am looking at ODOO, let's see if those guys allow me to install their software into our NAS.
www.robotecnik.com[^] - robots, CNC and PLC programming
Sage 200 is widely used in the UK, too. Is that the only option your government requirements allow, or is it just a recommendation?
-
Sage 200 is widely used in the UK, too. Is that the only option your government requirements allow, or is it just a recommendation?
Nope, the government issued a set of requisites for programs to follow and a few manufacturers will. Searching for an accounting program that can do this without being cloud based is becoming more complicated than expected. I've seen Sage 200, Vortex, A3ERP, SAP One, and a few others, maybe Odoo will be installable in the NAS we already have as it is based in PHP and Postgres and there are docker packages for that one. Let's hope this Monday the two Odoo partners I contacted will tell me their software follow the new regulations and that I can use it with the hardware I already own.
www.robotecnik.com[^] - robots, CNC and PLC programming
-
Hello all, INTRODUCTION Given the new accounting laws in our country, every company will need an accounting software that sticks to those laws. Even freelancers (as me) will have to adopt a software like that. I don't trust the cloud + I don't want to pay a fee every month to be able to use my accounting data. Now I own a NAS which is more than enough for my needs but is not capable to run the accounting programs I will be able to use in my country. Most of the accounting programs I could use require SSD and Windows to run. Getting a server would mean: * Getting a server, some SSD and HDD disks. * Getting an UPS. * Getting a small rack. * Getting a Windows server license. * Using our current NAS as backup for that server and keep doing our NAS extra backups with external USB HDDs. QUESTION What server / option would you recommend for this kind of job? Would it be better to get a tower server? or a rack server? As soon as we have children the server, NAS, UPS... will have to be placed inside a rack anyway. It would be nice to be able to have a mix of SSD and normal HDD, SSD for the OS and the accounting program and HDD to store everything else. +/- 8TB of data space available would be nice. +/- 32GB RAM available would be nice. Would it be better to install the accountant program inside a virtual machine? just to make it easier to move it from one server to another one in the future (if needed). Do you agree that it's better to get a server than a normal workstation for all this? And as a bonus... what would you use that server for apart of all mentioned before? Any additional hint/idea? Thank you all!
www.robotecnik.com[^] - robots, CNC and PLC programming
You REALLY should also backup your data to the cloud, even if it means you have to encrypt it yourself. If you get a fire, everything could be gone and that is NOT and acceptable situation for the tax department. The good thing is that accounting software has no special hardware requirements and yes, put it in a VM in order to easily move it around. Aside from the other concerns: don't you use an accountant to do all those things for you?
-
You REALLY should also backup your data to the cloud, even if it means you have to encrypt it yourself. If you get a fire, everything could be gone and that is NOT and acceptable situation for the tax department. The good thing is that accounting software has no special hardware requirements and yes, put it in a VM in order to easily move it around. Aside from the other concerns: don't you use an accountant to do all those things for you?
That's why I rotate the HDD used to make copies and I place them in a different physical location every month. I really don't like to send lots of important and sensitive data into the cloud... More if that data occupies a lot of space. Precisely the bad thing here is that any accounting software that copes with the new laws in my country have crazy requirements. Otherwise, I would have not made the post. Nope, making the repetitive tasks (invoices, expenses, ...) reduce a lot the monthly fee of the accountant... And I can check any results, payment dates... at any moment, it's much more convenient, cheaper and fast. Thanks for your post!
www.robotecnik.com[^] - robots, CNC and PLC programming
-
That's why I rotate the HDD used to make copies and I place them in a different physical location every month. I really don't like to send lots of important and sensitive data into the cloud... More if that data occupies a lot of space. Precisely the bad thing here is that any accounting software that copes with the new laws in my country have crazy requirements. Otherwise, I would have not made the post. Nope, making the repetitive tasks (invoices, expenses, ...) reduce a lot the monthly fee of the accountant... And I can check any results, payment dates... at any moment, it's much more convenient, cheaper and fast. Thanks for your post!
www.robotecnik.com[^] - robots, CNC and PLC programming
It should be easy enough to zip your backups into a file, encrypt the file with 256 bit AES encryption, and store the encrypted file in a dropbox account or onedrive or something else. Trusting your backup only to USB has a high risk of going wrong if a disaster should happen on the wrong moment.