QuickBooks Q&A
Many of the help articles below are from information acquired through Intuit or Intuit troubleshooting forums, if any of these issues occur for you, you may want to seek help from qualified Intuit Quick books Technical Support help desk before attempting on your own.
Items imported to Quick Books from SMARTSystem:
1. Customer Maintenance additions and modifications
2. Vendor Maintenance additions and modifications
3. Inventory Item are created (note SMARTSystem settings creating Non-Inventory Items)
4. Inventory Adjustments
5. Inventory Modifications -Product Descriptions
6. Purchase Orders
7. Customer Invoice transactions
8. Customer Credit memos
Initial Troubleshooting You can Do yourself:
1. Do you have too many windows open or the same program open more than once.
2. Do you have it set to multi-user mode and are trying to use the Import tool? Set to Single user and try it.
3. Can you restart your computer? Does this fix the issue.
4. Have you checked if the printer is on and available to your computer.
5. Are you connected to the internet.
These may seem simple, but can save you some time. If you are in doubt. Take a screenshot and send us as much information as possible. We are happy to help!
ANY and ALL fatal/fail messages from Quick Books: Please contact Quick books immediately.
IF you get a pop-up Message that Quick books will not open, has failed in some way or anything else directly from the Quick books program there needs to be a call to Quick Books first. They have a diagnostic that they run to help you. You will also find the diagnostic link below but you should seek help from Intuit. SMARTSystem staff are not qualified to interpret these results and you should call Intuit as we will direct you there.
New Quick Help Solution 10-03-16
NON-Standard or Invalid Characters:
Sometimes having non-standard or invalid characters in your QuickBooks Online company name can lead to server and other errors in the application. To avoid and remedy these, you should make sure your company name consists of accepted characters only.
Here is a list of accepted characters:
•Alpha-numeric (A-Z, a-z, 0-9)
•Comma (,)
•Dot or period (.)
•Question mark (?)
•At symbol (@)
•Ampersand (&)
•Exclamation point (!)
•Number/pound sign (#)
•Single quote (‘)
•Tilde (~)
•Asterisk (*)
•Space ( )
•Underscore (_)
•Minus sign/hyphen (-)
•Semi-colon (;)
•Plus sign (+)
If you have any other special character in your company name that is not listed here, edit the company name by choosing Company > Preferences and click on Name on the left column. After you make your edits, try your task again and it should resolve any error you were getting. We found this help here: QB Intuit Answers Unacceptable Characters Question
New Quick Help Solution 10-12-2016
Credit Memo Adjustments:
Question: SMARTSystem Credit Memo adjustments to Quick Books Delivery/Freight Charges
Answer:
In Quick Books there is a “Shipping” Type account as an Inventory Item which is usually called “Delivery Charges”. (Needs to Match exactly the G/L account name to the QuickBooks name. If you use this method to record delivery charges.)
The G/L accounts in this item are directing the charges to the CORRECT G/L Account in Quick Books.
QB Peculiarities
1. Customer Names must be unique.
2. Vendor Names must be unique.
3. A Customer Name cannot be the same as a Vendor Name.
4. A Vendor Name cannot be the same as a Customer Name.
5. The Account No. field for each customer record in Quick Books is automatically updated with the SMARTSystem customer number. If this customer number is missing you will not be able to update your Customer Balances in SMARTSystem.
New Quick Help Solution 11-09-2016
If you receive the error from QuickBooks as a popup: “Runtime error 424 Object Required”
QuickBooks works best for the Import process if you switch it to single user mode. The error you are receiving has to do with it being in Multi-user mode and someone somewhere on your system has the “object” you are trying to import open on their machine. The reason it works most of the time in multi-user is because you got lucky and the person does not have what you are importing open.
If you are in single user. Restart your machine from the start button and try your import again. Be sure you are not still running a “hidden copy of QB” in your task manager. Contact Intuit Quick Books for help.
This has nothing to do with SMARTSystem.
New Quick Help Solution 11-16-2016
2 GB Company Data file
If you are receiving errors in your Quick books data file that look like: “Error: Item id ….has missing rows in the item history table.”
It is time to Call Intuit Quick Books Technical Support.
We are regularly told about such errors when a companies Quick Books file has reached 2 GB. This has nothing to do with “third party software.” It is due to a bug in the Quick Books software. (Which Intuit does not admit exists). Our software only feeds data to Quick Books, it does not actually store it in the Quick Books database, any errors Quick books is throwing are internal to the Quick Books programming.
To avoid this issue and prevent the Quick Books Database from malfunction many of our SMARTSystem clients create new Quick Books company files each year when the Quick Books Database reaches 2 GB.
New Quick Help Solution 12-5-2016
Link to QB help: QuickBooks Install Diagnostic Tool
You should use this tool only under supervision from Intuit or your IT professional. This is from Quickbooks Intuit site (This is not help for SMARTSystem issues):
QuickBooks Install Diagnostic Tool
The errors listed below can occur if your Operating System is damaged or one of the core Microsoft components that QuickBooks Desktop uses is unstable or not functioning correctly.
You can download and run the QuickBooks Install Diagnostic Tool to fix a wide variety of error messages you may receive when installing QuickBooks Desktop such as:
- 1603
- 1935
- 1904
- 1402
- Errors relating to damaged Microsoft .NET Framework
- Errors relating to damaged MSXML and C++
Detailed instructions
Important: The following troubleshooting steps are for the Windows operating system, which is not an Intuit product. The steps can become complex if errors occur while repairing or uninstalling .NET Framework. If you are not comfortable doing these steps on your own, Intuit recommends you consult with your computer’s manufacturer or other computer professional.
QuickBooks Install Diagnostic Tool is designed to automatically diagnose and fix issues with Microsoft .NET Framework, C++, and MSXML.
Prior to performing any manual steps to resolve Microsoft component related issues, it is recommended to run the tool first, as it can decrease the time needed to resolve the issue.
Solution 1: Use the QuickBooks Install Diagnostic Tool to resolve Microsoft .NET, MSXML, and C++ issues:
To use the QuickBooks Install Diagnostic Tool:
- Download the QuickBooks Install DiagnosticTool.
- When prompted, save the file to the local Desktop.
- Close any open programs then run the program by double-clicking on the QBInstall_Tool_v2.exe.
Note: It may take up to 20mins to complete, depending on your internet speed and computers performance. - Once the tool has completed, restart the machine to ensure proper update to components.
Optional: If you have a minute, could you please help us gather feedback on how the QuickBooks Install Diagnostic Tool worked out for you: Click here to provide feedback!
Solution 2: Try performing a Windows Update to install missing updates pertaining to .NET Framework, MSXML, and C++:
If these components are out of date, QuickBooks may not be able to install correctly. You can access Windows Update by pressing the Start key on your keyboard and typing “Windows Update.”
Important: If you encounter any errors performing a Windows Update, contact a qualified IT professional or Microsoft.
Solution 3: Fix problems with Microsoft components manually:
Even if the QB Install Tool does not solve your problem, you may still be able to fix problems Microsoft components manually. However, you should only try this if you are an IT professional or similarly-advanced Windows expert, or if you are working with one who can guide you.
To repair Microsoft .NET Framework manually: follow Solution 2 of this article.
To repair Microsoft MSXML manually: try all solutions in this article.
Solution 4: Try installing QuickBooks in Selective Startup:
Another process on your computer may be interfering with the QuickBooks installation. Follow these steps to temporarily eliminate everything but the essential processes you need to install the software.
If you still get an error when installing QuickBooks, or if you encounter errors while attempting any of these solutions, there may be a problem with your computer or your operating system. You should consult a trained IT professional for further help.
QB import – RUNTIME ERROR 75 path/file access error:
Solution:
Shutdown all programs and re-boot PC.
Open QBooks, if an error occurs that QB cannot find the company file contact QB support, otherwise re-run the import.
QB import does not work at first import no balance transfer. No invoices.
Check to see that the Accounts names match exactly for the import files set up.
In QB, Make sure that the Accounts are associated with their proper types.
ACCOUNTS RECEIVABLE MUST BE AN AR ACCOUNT.
If associated with “Other” it will not import: create a new AR with AR associated.
QB IMPORT using FAS:
Import of data using FAS gives this error when the data is not translated and set up to work with QB. This is done by a data fix done by FCS to allow the AR transfer in accounting. This is a Quoted service that is offered ahead of time in order to function.
Import from QB to SMART Error 76:
Complete shutdown then push button restart.
