Although Classes can be set up inside SMART, not all classes are the same when it comes to this runtime error message.
The troubleshoot: Verify classes are set up in Quick Books by going to Lists > Class List. If the class you have set up in SMARTSystem is not in the list, add it per Quick Books procedure. Now retry the import.
If the import still fails, you will need to verify the Quickbooks SDK program has been installed on your computer. To locate the program, go to Control Panel > Programs and Features. In the list of installed programs, you will see “Quickbooks SDK 7.0” If it is not in the list, call our Tech Support to get it installed properly.
Installing the Quick Books Import Tool has a very specific sequence of events to ensure it installs correctly. Missing a step can cause issues such as this runtime error. Even if your IT team is excellent at what they do, they will need to consult with our tech team to ensure a proper installation if they will be doing it, or request we do the installation for you.
SMARTSystem- Exporting Data to QuickBooks or your Accounting System
How to Export Data to QuickBooks from SMARTSystem
- Check if the days Sales Orders have been Invoiced. Go to End of Day> Invoice Print Verification
- If the popup says “All of the orders for delivery on (your date) have been invoiced.” You can continue with export to QuickBooks. If you receive a list of Invoices, those need to be processed before continuing:
- By clicking each sales order listed one at a time to display the sales order
- Invoice the sales order or change the delivery date
- Pick the Date Range Start >End Date. Then click the “Export Daily Activities to Quick Books” Button.
Note: leave the Start Date set to capture any back dated transactions. Usually, the End Date will be the last full day of operations.
- Items will save to your file and become available for import into Quick Books or your Accounting System:
- The Report: Invoice Register by Delivery Date will list all invoices and credits transferred for import to Quick Books or your Accounting System.
** Create a Backup of your QuickBooks company file at this time.
- Using the Quick Books Import Tool:
- You must have Quick Books open
- Switch to Single User Mode to prevent an import error by having another user access QB data until the Import process completes.
- Click Quick Books Import Tool icon
- Go to QuickBooks Import Tool:
- You need to Define Accounts first before first use to start Export process. Your Accounts will likely look different from the below example:
Alternate Settings in Import 7.0:
How to setup inventory in Quick Books as Non-Inventory Parts:
Click “Define Accounts” then check “Create New Inventory Items as Non-Inventory Parts” Click Save.
- Click the Browse button to Navigate to the file you want to import. Choose the most recent file in C:\WFSData\ExportFiles (Be sure that the file you are importing says “COMPLETE” and there is more than 1KB of data):
Click Open.
- Your source file will appear in the Browse box.
Click the Import Data to QuickBooks button.
- If the import was successful, you will receive a popup with the number of records successfully uploaded:
- Process Complete
- Export Customer Balances
- When the process is complete you will see this pop-up:
- Print Import Log
- The Today’s Invoice Register report is automatically created. It is strongly suggested that you print it as a record of what will be exported to QuickBooks after the QuickBooks Import Utility is run. Files are created at this location on your computer: , as shown below. When you run this again, the old files will move to the Backups folder and the new ones will display in place of the old ones.
- If you need to check what was in the “QB COMPLETE” file you can go to the file in C:\WFSData\ExportFiles and right click file and choose OPEN with>Notepad. You can File >Save As >Documents file if needed.
Do not delete the Backup files this may be your only source of past information from the EOD. They cannot be replaced. Although there are additional backup measures in place deleting files is not recommended. If you have a question, please call support 727-483-5306.
Import Back into SMARTSystem
If you have not done so from the earlier steps above:
Click on the “Export Customer Balances” and the export from Quick Books will begin:
When completed close the QB Import Tool.
Open SMARTSystem, File menu >Import Customer Balances.
The following screen will be displayed:
Click “Browse” to select the folder for Import:
C:\WFSData\ImportFiles
Click on “customerbalances.txt” to select.
Click on “Import Customer Balances” and your customer balances will be updated in the SMARTSystem:
When completed close the “Import Customer Balances” screen.
This completes the entire End-of-Day cycle from beginning to end.
SMARTSystem Management Training Series
Training Session #17B – SMARTSystem, QB Importer and QuickBooks Setup
Purpose: To establish the correct program settings for the SMARTSystem, QB Importer and QuickBooks based on the customer’s’ requirements.
Overview:
Section I is to establish settings for exporting SMARTSystem G/L accounts to QB for proper accounting of transactions.
Section II is to clearly define the settings on how purchase orders are being processed in QB.
Setting your Accounting System preferences in the SMARTSystem is done by an FCS Support person. They must log in under programmer security:
To select your Accounting System preferences in SMARTSystem:
Go to the Control Info menu > Utilities > Select Accounting System.
Section I
It is required that you setup and coordinate the G/L accounts between SMARTSystem and Quickbooks.
The G/L Account Descriptions are used to update QB, therefore when entered into the SMARTSystem they are correctly written exactly the same way, including upper and lower case letters. For example:
To use the G/L accounts established in the SMARTSystem on transactions being exported to QB, it is necessary to set the checkbox in your Selected Accounting System to “Export GL Accounts to QB” as shown below:
Click “Update System Control” to SAVE before exiting.
QB Importer:
When SMARTSystem is generating the G/L transactions the checkbox “Use Accounts from Imported Data” need to be set.
Section II
There are three areas to setup with Purchase Orders.
SMARTSystem:
To select your Accounting System preferences in SMARTSystem:
Go to the Control Info menu > Utilities > Select Accounting System.
When NOT processing Purchase Orders in QB, the two items circled in red are to be set as shown in the example below. When PO’s are being processed in QB reverse this sequence.
Click “Update System Control” to SAVE before exiting.
QB Importer:
When SMARTSystem is generating the G/L transactions the checkbox “Use Accounts from Imported Data” need to be set.
QuickBooks:
QB Inventory creation from SMARTSystem is OK as an Inventory Part when the “QB Inventory and purchase orders are active” is not checked in the QB Preferences because there will be no costs, sales or average cost creation. Inventory will go negative with sales coming in, but does not have any impact on cost of goods.
- Preferences is turned off (see Preferences on Edit Menu)
When QB Preferences are turned off:
* * End of Document * *
SMARTSystem Management Training Series
Training Session #11A – SMARTSystem End-of-Day Processing Summary
The following is a brief checklist of steps to close the day after completing Driver Check-in:
- Select the End-of-Day Menu:
2. Invoice Print Verification
3. Export Data To Accounting
a. Set the End Date to yesterday’s Delivery date. You do not want to process today’s invoiced orders:
b. When ready, click the button to
c. The End-of-Day process is completed when the Red EXPORT COMPLETE button is displayed.
d. There are three reports produced during this EOD process:
i. Invoice Register by Delivery Date
ii. Invoice Register by Route
iii. Invoice Payment Register
QB Import Tool Daily Operations
The sequence of events for daily importing of SMARTSystem transactions:
- Run the SMARTSystem End-of-Day process to export transactions from the SMARTSystem.
- Open your Quick Books with the administrator password, put Quick Books in Single User Mode and minimize.
- Double click on the Quick Books Import icon:
4. The following screen will be displayed:
5. Click the Browse button on the lower right side of the screen, navigate to the WFSData Folder, Export Files and the following will be displayed:
Click on the QB_COMPLETE entry to highlight it which is always at the top of the list. The files under QB_COMPLETE contain each transaction type that is consolidated in the QB_COMPLETE file. Therefore, you select only one file, QB_COMPLETE to process your End-of-Day Import to Quick Books.
Click the Open button to continue.
6. The screen will return with the selected QB_COMPLETE file in the “Source File:” area below:
7. Click “Import Data to QuickBooks” and when the import process is completed you will be notified by the number of records processed.
QB Import Security Questions (first time only)
The first time you import SMARTSystem records to Quick Books the following QB security questions will be displayed. Check the items highlight below:
After checking the two items above, click “Continue”.
After you click “Continue” Quick Books will want you to confirm your selection by clicking “Yes”
To finish the Quick Books security access process, click “Done” below:
QB Export Customer Balances
Normally, payments are manually posted against customer invoices and afterwards the customer balances are exported from Quick Books and Imported to SMARTSystem.
The sequence of events for daily exporting Quick Books Customer Balances that will be imported into the SMARTSystem is:
- After payments are posted to your customer accounts.
- Keep Quick Books open and minimized.
- Double click on the Quick Books Import icon:
4. The following screen will be displayed:
5. Click on the “Export Customer Balances” and the export from Quick Books will begin:
6. When completed close the QB Import Tool.
7. Open SMARTSystem, File, Import and Import Customer Balances.
8. The following screen will be displayed:
9. Click “Browse” to select the folder for Import:
C:\WFSData\ImportFiles
Click on “customerbalances.txt” to select.
10. Click on “Import Customer Balances” and your customer balances will be updated in the SMARTSystem:
11. When completed close this “Import Customer Balances” screen.
This completes the entire End-of-Day cycle from beginning to end.
QB Peculiarities
- Customer Names must be unique.
- Vendor Names must be unique.
- A Customer Name cannot be the same as a Vendor Name.
- A Vendor Name cannot be the same as a Customer Name.
- 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. See Quick Books, Customer Edit screen below:
