Improve company productivity with a Business Account.Sign Up

x

QuickBooksSponsored by Flatiron School

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

Problem with Turbo Tax copying data from Quick Books 2016. It is too late now but I need to solve this problem. I keep all my business details in QuickBooks 2016 and need to have Turbo Tax to pull the data over at the end of the year. This is the first year it could now. Keep getting an error "We are not able to access this company file because we cannot login to the file automatically. If the file is password-protected, enter the password in the password window, otherwise open company file in QuickBooks and try again." I have done all that but still have error.
Any help please. Thank you.
0
Free Tool: Port Scanner
LVL 12
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

What are the Benefits of using QuickBooks Pro in the BookKeeping?
0
how can we out to this problem if you are facing corrupt or damaged quickbooks error?
0
How can I get some important tips for Reconciliation in QuickBooks?
0
We use Quickbooks on a Remote server that our employees use Remote Desktop to access.  The setup works great for the most part, but we run into periodic printing issues that are fixed by rebooting the server.

I am thinking this is somehow related to the Quickbooks QBPRINT.QBP file, and the fact in our peak times we have 10-12 people on the server using Quickbooks.

The issue we run into happens periodically but I am unable to find a specific process that starts it.  Generally, when 1 person tries to print, they'll get an error saying the "File is already in use... " (and I think that's the QBPRINT.QBP file.  Once that error shows, no one will be able to print moving forward and we need to reboot to fix.

Any known issues or limitations that may be causing our issues?   Any setup or work-arounds that we need to implement to fix?

I'm not an expert in this area but is there some way to setup that file for multi-access or setup some type of spooling?  It seems perhaps the timing may be an issue with everyone using the system at the same time.
0
One of our companies uses QuickBooks 2011 accounting software.

An employee accidently closed the year by choosing the "Year End Copy" option when backing up the database. Is there a way to re-open the year?
0
I am trying to migrate data from Quickbooks Enterprise 17 to Dynamics GP 2013. I am using Microsofts RapidStart Migration tool. Three of the errors that show up in the log I cannot figure out. See below. Any help is appreciated.

Table Customer is not exported. For table Customer error message is: Invalid object name 'contactsdetail'.:  contacts in table customer. Source is: .
Table Vendor is not exported. For table Vendor error message is: Invalid object name 'additionalnotesdetail'.:  additionalnotes in table vendor. Source is: .
A total of 18 payment amounts have values less than or equal to zero. Refer to the Migration Troubleshooting topic in the RapidStart Migration help.
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
I am seeking some advice regarding an Azure configuration I have just done.

The client will be using:

Quickbooks Enterprise
Quotewerks Corporate edition
ACT!

The client has had these running on 2 Physical Servers (on-premise) both running Windows 2012 R2. Both physical servers ran Hyper-V. On one server 2 Virtual servers were set up - one as an AD DC and the other as an Application Server. The second physical server had RDS running as a Hyper-V Virtual Server and a second DC as a separate Virtual Server. From what I understand he was using Terminal Services through the RDS Server to provide a desktop for the clients to login to.

He engaged me to provide a complete cloud-based solution with no AD information being transferred from his existing domain.

My approach in Azure has been:

Azure Active Directory Domain Services
3 Virtual LANs - Master (10.0.0.0/24) and 2 subnet LANS - Management (10.0.1.0/24) and RDS (10.0.2.0/24)
2 Virtual Servers both on the RDS subnet with Windows 2016 Standard configured on one and Windows 2012 R2 / SQL Server 2012 on the other
1 Virtual Workstation (Windows 10 Pro) used for AD Management on the Management subnet

The Windows 2016 Virtual Server which will contain the applications is also configured with Hyper-V and RDS working with a Personal Virtual Desktop Collection of 5 Windows 10 Pro workstations (Gen2 virual workstations) which will be allocated to the users.

Access to the 5 workstations will be via the RDS Web …
0
Good morning,
      I have 2 servers, one a domain server and the other machine a Windows 7 machine setup for our quickbooks. We have 9 users usually that are connected at all times and can get to all shares on the domain server. Never lose connection etc.... Now 2 users that are trying to get to the quickbooks share on the Windows 7 machine can't keep connected to the share. I have checked power settings, regedit etc... The only way to re establish connection is to reboot the Quickbooks server(Windows 7 machine). Everyone else stays connected but 2 machines. Any suggestions?
0
The 14th Annual Expert Award Winners
LVL 7
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Anyone familiar of a company or individual that provides consulting or support for Expensify?  Looking for some sort of phone support - only support provided by the company is through email.  I am having problems with it's syncing/integration with QuickBooks.
0
We have a client that has 30 users on qbooks 2017 enterprise. they are running on a new dell server in hyper-v and using RDS. This environment has been running for 10+ years without an issue (other than quickbooks sucking). windows 10 dell pc's. the file runs well for a while then an error comes upthe error we get when quickbooks goes unresponsive. no one can get back in after this. we've had the file rebuilt thinking it was the file and it worked for 8 hours. intuit has been no help can't get a competent tech. watchgaurd firewall, cisco poe switch. backups using replibit device. we really need quickbooks high level tech expertise. we have a dba, programmer and two techs on the tshoot.

the file fails even from the console.

we tested on multiple stand alone pc's off the network and the file fails

we put the file on the hyper v host and attached local quickbooks installed pc's to it and it failed. (taking out rds).

the failure is not predictable happens 7 hours in, then may go another 1hr then 30 minutes, etc.

our log shows no discernible trend.
0
Hello,

I have an Employee that is unable to open a QuickBooks file. They get a "Missing name list problem", Quickbooks suggests to resort the list but how is that possible when we can't get into the file?
0
Hello experts,

Whenever I try to export reports to excel , it automatically change (duplicate) value of all entry. And most of the time it won’t even export. I am using multi user and we have 2 users and both are having same issue. I tried rebuilding data file but still having issue. I did quick book doctor scan and 0 issue found. Please help!
0
I have tried everything i know and i can not get quicken 2017 home and business to install.  When it comes to the installing netframe 4.6.1 page (also on that page is install quicken 2017 and update quicken 2017) it hangs up.  hard to know what it is hung up on because the check boxes do not visually get advanced or checked.   I have manually gone to microsoft and installed 4.6.1 and 4.6.2 and on the progess bar it always hangs at the same spot.  I have tried runing as adminstrator and i have looked to delete what has already been installed but do not find where that has landed.  I do not see it in the x86 folder. i am running the latest version of Windows 10 64bit.
Any suggestions.  Thanks
0
As of Quickbooks 2017 R5 and Quickbooks 2018 I am getting a licensing issue in XenDesktop

Citrix says its a 3rd party application issue
Quickbooks says they don't support Citrix

We have been using Quickbooks in XenDesktop for years just recently having issues.

what i have figured out so far
installing all additional packageds with the quickbooks 2018 installation doesn't affect the licensing service.

once quickbooks is installed

A netstat will show the following missing

picaSvc2.exe  1494
picaSvc2.exe 2598

Event viewer doesn't show any errors

citrix event viewer shows license not available when users attempt to login
if you use rdp instead of citrix your able to function fine.
0
When creating a "Summarize Payroll Data" report from Quickbooks to Excel, the "State Wage Listing" tab defaults to the wrong "Tax Tracking" filter.

It used to default to "SUI Company", but now defaults to "Medicare Additional Tax", and the desired outcome is that it defaults to "SUI Company" again. Office 2016 is used.

Intuit support provided varying feedback. One technician we spoke to seemed to know the issue and indicated a Microsoft Update might be responsible, other technicians weren't sure, or suggested we submit a feature request to the development team.

Has anyone come across this before, and found a solution?
0
I need to customize a report that shows which Invoices paid which Purchase Orders in QB's 2017. I can't get one to show both Invoice Number and PO Number at the same time.
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
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.

I am able to import a bill successfully, the issue I am having is the RefNo which is the invoice number does not show up. I used different variations for the heading such as TRNSrefno, RefNo, RefNu so far its still showing blank. another issue is that the vendor address doesnt show up, its not a new vendor. Do I have to have the address in the iif file?
thanks
0
I am new to QODBC but not SQL.  I am trying to eliminate manual data entry for a special project for my company.

On every invoice in our system, or each "Item" on each invoice, there is text field called "Description".  I need to replace the text that is currently in the "Description" field with the text "service".  See attachment for an example.

I want to update every invoice in our quickbooks database like this.  We need todo this, because we have private information in that text field, and I need to provide a copy of my quickbooks database to a 3rd party.

What would be the QODBC code to accomplish this?  I am open to another method (besides QODBC).  I just need to get this done ASAP.  I have also posted a freelance job post on upwork to see if I can pay someone to code this for me.

Thank you ahead of time for your help.
Accounting3.jpg
0
We have approximately 105 employees we send pay stubs to bi-weekly.  When sending the pay stubs to everyone the application times out on a random person.  The report is started again from where we left off, sometimes it will finish and sometimes it times out again on another random person.  The person that it times out on never receives their pay stub.  Is there a setting or something we are missing that will eliminate the timeout.
0
In a retirement enclave we want to provide service for tenants to pay one invoice per month that contains rent and then all utilities as line items.  we're kinda using Customers section in a non-stand way entering properties as customers.   I am thinking a work-around would be to enter all phone#s as line item with number in comments.
0
Looking for a solution (cheap) to count inventory the fastest way possible.  Currently we have no scan guns or wifi in the warehouse.  We house at least 100,000 items.  What I would like is a scan gun that I can load an excel worksheet that has columns for our Item# (Barcode data), Description, Qty and fill ins for bin locations so pickers can scan what's there and it will save to the spreadsheet in the gun.  Added feature would be a fill in line for bin location so future picking would be easier for our pickers.

I can then download the spreadsheet and reconcile with our QB inventory.

Any advice Experts?
0
I have a customer on Quickbooks Enterprise16 and their company file is just over 1GB. They have some performance issues and there is only so much tweaking I can do on their network to increase the speed. Wondering what options I have. I looked at the 'Condense data' option, but they didn't like some entries going from detailed to a single entry. Figured the next step would be to have a new company file. Is there a way to create a new company file with say all data from the last 2 years?

Or maybe there is another approach? I'm a networking person by trade who knows enough to get Quickbooks networked and functional!
0

QuickBooksSponsored by Flatiron School

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
>