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

We have a windows server 2012.
We are using QuickBook server 2012 and its update QuickBook server 2015.
We are facing below event id on regular basis.
<code>
Log Name: Application
Source: .NET Runtime
Date: 12/2/2015 1:01:00 PM
Event ID: 1026
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: WV-SERV2.weathervane.local
Description:
Application: dbextclr11.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.InvalidOperationException
</code>
When i searched internet i found out that this is related to dot net. but watching server features. It has dot net framework 1.1, 2.0, 3.5 and 4.5.1 installed.
So i ran an update for dot net 4.5.2 on the server but it terminated with error "the component store has been currrupted"
So i am unable to figure out what actually is happening and what is causing this issue.
0
Hi,

I have a laptop which fails to print correctly from QuickBooks.

It prints fine to all other printers, on the preview page it is fine, once printed to the Lexmark the image (company logo) in the top left corner takes up the correct amount of space but only shows the top left of the image, as if it were zoomed in.

This is also happening on a different laptop to a different printer, other users are not affected.

latest drivers are installed.

it does print normally to other printers, eg pdf printer, and then when printed from here it prints normally on suspect printer.

I hope that makes sense
thanks
Gareth
0
Hello,

I have QuickBooks Enterprise Solution Accountant version 15.  I have some important data files.  I just bought QuickBooks Pro 2016.  I am trying to access my data from previous version to Pro 2016 and I am running into issues doing so.  

I need help in converting/exporting from Accountant version 15 to Pro 2016.  I have tried various solutions and checked online for solution but it does not seem to help.  Any suggestions....?
0
Is possible to access the database of Quickbooks Point OF Sales desktop using C#?
0
When we had 2015 it worked great,

Upgraded to 2016 and it does not.

only 3 users logging in using Quick books 3 license pack.

Tried to install 2015 DB Manager but will not work with 2016 files get error on user side telling me to upgrade the DB manager on the server.

Service Will not even Start:

Did This:

1) Uninstalled all Versions of quickbooks and deleted Users from Profiles
2) Upon Reboot deleted all Intuit folders in Program files(86) and Public folders
3) Reinstalled Fresh 2016 and rebooted server.....Still Does not work????
4)  Checked Firewall but it is disabled.

How can I get the QBDBMgrN to start on this server???

Cjoego
0
Hi guys,

I am trying to move from Freshbooks (www.freshbooks.com) to Quickbooks. I can do an export of my contacts through Freshbooks, but i cannot do anything with all my invoices.

Does anyone know of a way to migrate this?
0
This one here is driving me nuts.  So, I had a user update their Quicken 2014 recently using the Auto Update tool provided by Intuit.  After that, QB never opened properly on the system again.  I suspected a data issue.  I try to create a brand spanking new company on the system and things error out with...

"Unfortunately QuickBooks encountered an unexpected error while creating this company file. Close and restart QuickBooks and create a new company file again."

QB after that wont open again.  Errors out.  I have to delete the company I tried to create.  Repeats process with same error.  

I then setup QB 2014 on a different box, applied all the updates and tested it by creating a new company.  That worked.  I then took this user's data (3 companies) and the converted and opened fine on the fresh install.  So that's really good news.  It's not a company data issue.  

So, this has to be a Windows, system issue with QB.  I tried uninstalling QB, deleting all dirs, removing the obvious reg keys and then installing a fresh copy.  But, I KEEP HAVING THE SAME ISSUE!  Is there a QB removal tool that wipes a system clean of QB for a fresh install? Is this a permissions issue somewhere?  I checked the C:\Users\Public\Documents\Intuit folder.  It looks fine to me.  Gave everyone full rights with no success. I'm at a loss here.  I'm missing something.  There's not much info online and was hoping someone has ran into this or a similar issue before.  Otherwise, I'm thinking …
0
Dear Experts,
I have one PC that I am not able to use Printer setup for QuickBooks 2015 pro.
I have tried reinstalling the QB but still no printer setup.  I can print a report to a default printer, but cannot print checks.
It is running Windows 8.1, and networked, there are other Windows 8.1 PCs on the network that has no issues.  The software version is the same.
Please advise.
0
Hello,

I am running QuickBooks Enterprise Edition 16.0 (x32), Microsoft Office 365 Home (x32), and Windows 7 (x64).

Any time I try to use the default QODBC application and connection settings (which work fine anywhere else), it crashes Excel. Any thoughts?
0
I get a very generic error when I try and use QODBC to create an invoice.  QODBC help states to use the format below:
INSERT INTO "InvoiceLine" ("InvoiceLineItemRefListID", "InvoiceLineDesc", 
"InvoiceLineRate", "InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefListID", 
"FQSaveToCache") VALUES ('250000-933272656', 'Building permit 1', 1.00000, 
1.00, '20000-999022286', 1)

INSERT INTO "InvoiceLine" ("InvoiceLineItemRefListID", "InvoiceLineDesc", 
"InvoiceLineRate", "InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefListID", 
"FQSaveToCache") VALUES ('250000-933272656', 'Building permit 2', 2.00000, 
2.00, '20000-999022286', 1)

INSERT INTO "InvoiceLine" ("InvoiceLineItemRefListID", "InvoiceLineDesc", 
"InvoiceLineRate", "InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefListID", 
"FQSaveToCache") VALUES ('250000-933272656', 'Building permit 3', 3.00000, 
3.00, '20000-999022286', 1)

INSERT INTO "Invoice" ("CustomerRefListID", "ARAccountRefListID", 
"TxnDate", "RefNumber", "BillAddressAddr1", "BillAddressAddr2", 
"BillAddressCity", "BillAddressState", "BillAddressPostalCode", 
"BillAddressCountry", "IsPending", "TermsRefListID", "DueDate", "ShipDate", 
"ItemSalesTaxRefListID", "Memo", "IsToBePrinted", 
"CustomerSalesTaxCodeRefListID") VALUES ('470001-1071525403', 
'40000-933270541', {d'2002-10-01'}, '1', 'Brad Lamb', '1921 Appleseed 
Lane', 'Bayshore', 'CA', '94326', 'USA', 0, '10000-933272658', 
{d'2002-10-31'}, {d'2002-10-01'}, '2E0000-93327265 6', 'Memo Test', 0, 

Open in new window

0
I'm trying to export Quick Books tables to Excel Using QODBC & Excel.

I understand this is done through "Power Query", couldn't figure out how to get that to work.

Excel 16 is installed. I was told it came with Power Query.

Somewhere I saw I should use MSQRY32.

I opened that I tried to construct a Query. It gives me the attached.

We downloaded the 30 day free trial of QOBDC.

How do I set the license for the trial version?

Or is this their not so subtle way of saying, "sorry, Charlie, can't use this with the 'free' version".

Thanks
qodbc.jpg
0
This is what I want to do:

1. I have five suppliers. I pay them every month a set amount (say $500) on the 15 and 29th of every month.
2. I would like to print out post-dated cheques for them for payments from January to June 2016. (I'm leaving the country and I would like to leave the cheques before I go.

So do I have to "write cheque" individually for each payment in Quicken?
Is there a way that I can set these up as recurring and then be able to print the cheques for all six months in one fell swoop?

I have Quicken 2016 for Mac.

Thanks for your help!
0
I'm looking to find a credit card that will provide me with free access to my current Equifax credit score.

I already have credit cards that provide me with free access to my Trans Union and Experian credit score. Now I am looking for a credit card that will provide me with free access to my Equifax credit score.

What credit cards offer this benefit?
0
Hi,

Quickbooks is set to create and send emails through outlook (an Office 365 account) to clients. On one of the computers in our office, this isn't working correctly. A significant number of clients can't open the emails (we think we have identified that it is clients without Outlook).

It seems they get a .dat file instead of a pdf

Any thoughts or solutions?
0
Does Excel Power Query allow you do directly access a Quick Books database & export (into Excel) the contents of any Quick Books table?

If so, can you provide a like to a "how to" on doing this?

Thanks
0
I am hearing stories that the latest update to QB 2014 (within the last few days) makes in not compatible with Windows 10.  Thoughts?
0
Hello Experts,

I have a small business and have a Liability account Due to Shareholder.

When I did my Income Tax recently, in order to offset my Business Income my accountant took money from my business and put it as personal income, which I understand.

In order to reflect this in my QuickBooks I thought to Debit my Salary Expense account and Credit my Due to Shareholder, but my accountant said not to go through my Due to Shareholder. How else can I do it?

Any help will be appreciated.
0
Using Premiere 2014 and all of a sudden the only two computers that are used to access Quickbooks get this script error at start up.

If you hit Yes everything works fine, but for 6 years we had no issues and now all of the sudden two different computers are displaying the same script error.

I have tried google and cannot come up with any answers.

IE is the default browser on both machines, Display a notification about every script error in IE is unchecked, all windows and IE updates are installed.

Any ideas?
sc.jpg
0
I am trying to get a customer setup on their SonicWall using NetExtender and be able to access QuickBooks Premier 2013 from the server.  We can login via a workstation with NetExtender fine and once connected we can access data from their SQL program with taking it off the server.  We cannot access QB - our accountant said we needed to install the QB programs on the server, which we did but still does not work.  It looks like we can open up the folder on the network but it wont open up the data.  Any thoughts on what we need to do in order to get QB to work via the VPN?  Thanks
0
I am trying to create a mail list from my customer base in Quickbooks Pro 2014 to send out a snail mail mailer.  I can use the Customer Contact List that gives me all the customer info I need, but I need to filter it by total spend by the customer.  I can't find such a filter for that particular report and I can't find a dedicated report that has all the data I need, so I thought I could combine two reports into one using Excel.  Normally I would think that wouldn't be too hard, considering I could just use a Sales by Customer Summary, match up the Customer names in the side by side reports, and then I'd have all the customer info I'd need to send a mailer (name, address, etc) plus I can choose which customers I want based on the dollar amount they've spent with my company.

The only problem is the first report generates the data using only active customers, and the second reports generates its data using ALL customers, active or not.  So the two databases do not line up customer for customer on the same line.  There does not appear to be a way to alter either report to include or exclude active customers using a filter.

The mailer is for 1000 customers so this isn't something I want to go through line by line to select the 1000 lucky ones.

Does anyone know a way to accomplish what I'm trying to do?  If you can offer a suggestion using the reporting features of Quickbooks that would be great.  If not, I'd be willing to purchase a third-party program that can manipulate …
0
Any help with this is greatly appreciated.

I have QuickBooks Pro 2013 which installs perfectly from my CD, however when I try to install the update files it fails saying "Error 1328. Error updating file C:\Config.Mao\#####.tmp"

The ##### above is various different .tmp files.

I have looked in the root of C\: (with hidden files shown) and cannot even see the Config.msi folder.
0
Hello,
When clicking on paper click it dissappears and there is no file.When clicking on attachment associated with our vendors the paper clip disappears and there is no scan where there once was. Has anyone seen this? Is there a way to restore just the attachment? Please Help
0
We're using QuickBooks Premier 2015 on Windows 10 and when I use the PDF printer within QuickBooks to save a report or an invoice to our Windows server share, I receive an error that the PDF printer is not working properly and cannot save the file. If I save the file to the desktop, or a local location, it works just fine. I've tried repairing QuickBooks, updating QuickBooks to the latest patch versions and have tried using the PDF printer repair utility from QuickBooks with no luck. Three other people use QuickBooks and do the same thing and they are able to save PDF's to the server share without a problem. It just seems to be this one user. I've also verified permissions on the server shares are correct. The user reported that she could save the files without issue a few weeks ago, and this just started happening.
0
i am trying to understand something and need your help.

we purchased a phone for $200 from a vendor called "Vendor"
we paid $200 by credit card.

we went to QB created a bill to Vendor for $200 and we paid it by the credit card.

we were charged by FedEx $20 to deliver the item, we created a bill for FedEx for $20 and paid it by check.

three days later the item arrived, we created a receiving voucher, and we split the fee/freight/discount so we have the accurate final cost at the POS as we mark up 10% from that. now the phone cost is $220. which is great.

we do financial exchange. we look in QB, to find that we owe VENDOR $220. which is not the case, we have to go and manually adjust that.

where did we go wrong? and how should it be done, to keep inventory and chart of account always UP TO DATE>

Thank you
0
Computer #1 has the database file and has shared the folder.

Computer #2 has a drive mapped the the database file on Computer #1.


If Computer #1 has a user logged in, while in Multi User Mode, Computer #2 receives a communication error H202.

Computer #2 can access and open the database file in Single User Mode when the User on Computer #2 is not logged into the database.

Computer #2 logs into the database and tries changing to Multi User mode and receives a "Cannot access the database" error, while Computer #1 has no user logged in.

I have run the "quickbooks connectivity tool", and it did not help.


Any ideas?

Thanks.
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
>