John’s Journal is a newsletter to provide SMARTSystem™ Users with the latest software highlights and solutions to improve business operations. SMARTSystem updates are included with your Software Support Plan (SSP).

We have added a new program that will reflag customer credit memos for export to accounting.

Exporting customer invoices and credits is a standard function of the SMARTSystem EOD (End of Day) processing.  The EOD process marks each customer invoice and credit memo to prevent exporting them more than once.  These two reflag programs give you the ability to reset the export flags so information can be re-export to accounting, if needed.

To select these programs, go to:

Management Menu ->

• Reflag Invoices for Export to Accounting
• Reflag Credit Memos for Export to Accounting

These programs work the same way to reflag both Invoices and Credit Memos.

First, select the Delivery (Ship) Date Range, Start Date and End Date, from the date filter to display information:

The *Export column heading can be double clicked to automatically check all of the export boxes displayed on the screen or, you can check only the individual items that you need to re-export.

When you are done selecting all of the items that need to be re-exported, click the “Save Changes” button

The next time that you run your EOD process:  The Invoices and/or Credit Memos that you marked will be exported with the EOD process and included for Import to your accounting program.

Our goal is to provide you with tools to make your job easier and improve your success with quality service delivered quickly. Your feedback is always welcome. If you have any questions, please contact us at Support@Floralcomputer.com or call 727-483-5306 for assistance. If you would like to submit an on-line support request, go to http://floralcomputersystems.freshdesk.com  and click on the “New support ticket” button. 

Thank you, John

John’s Journal is a newsletter to provide SMARTSystem™ Users with the latest software highlights and solutions to improve your business operations. SMARTSystem updates are included with your Software Support Plan (SSP).

This is an ALERT that we have recently become aware of a potential problem with Quick Books that could affect your operations.

Over the last 6 months, three of our customers have developed problems with their Quick Books.

As more data is added to Quick Books with each End of Day process the Company file will increase in size.  When it is over 2GB a condition may occur in Quick Books with inventory quantities showing incorrectly, costs being calculated incorrectly and inventory adjustment quantities may be applied for the wrong amount.  Also, this condition usually results in numerous negative inventory quantities and values in Quick Books.  Basically, the QB Company file becomes corrupt.  If you see these conditions, check the Company file size as shown below.  This action can save you a lot of time in determining the source of the problem with Quick Books.

As an alternative to Quick Books, we have been working with a CPA and Sage Accounting Software to provide an alternate solution for companies that manage a lot of accounting information.  There is a migration path available from Quick Books to the Sage.  We have been working with the Sage Accounting software over the last year and we are now ready to give you an alternative to Quick Books. Please call me if you are interested.

Otherwise, the solution to this problem is to create a new QB Company file before it reaches the 2GB limit.  Contact Intuit support if you have questions or how to create a new company file.

How to determine the QB Company file size

Press F2 in QB to show this screen.  The file size appears about half way down the page. 

Our goal is to provide you with tools to make your job easier and improve your success with quality service delivered quickly. Your feedback is always welcome. If you have any questions, please contact us at Support@Floralcomputer.com or call 727-483-5306 for assistance. If you would like to submit an on-line support request, go to http://floralcomputersystems.freshdesk.com  and click on the “New support ticket” button. 

Thank you,

John Henderson

John’s Journal is a newsletter to provide SMARTSystem™ Users with the latest software highlights and solutions to improve business operations.

Should you need to import a Sales Invoice to your Accounting System after an End-of-Day has been run, the following program can be used.

Under the Management Menu there is a program to “Reflag Invoices for Export to Accounting.”  

With this program you select the Start and End Dates of Sales Invoices to display on the screen below.  Just click the checkbox under Export to reset the invoice and then click on Save Changes.  The next End-of-Day process must be set to include the date of this invoice as the EOD Start Date.

Our goal is to provide you with software tools to make your job easier and improve your success with quality service delivered quickly.

Sincerely, John Henderson

Situation:  You’ve started the End of Day process in SMARTSystem.  You receive an error message that you are Unable to export End of Day data until errors are corrected.  Then you’ll see the name(s) of effected inventory items. 

What this means:  The inventory items you see in the list are missing their G/L account information. 

Solution: 

1. Make a note of the impacted inventory item(s).
2. Click OK on the message box
3. Stop the EOD export by clicking Exit. 
4. Open Inventory View (Inventory > Inventory View)
5. Search for the product code of the first item on the list you made.
6. Open the item’s detail record by double-clicking on it. 
7. Click on the Accounting Info tab. 
8. You will see that there are no G/L accounts listed for that item.  Assign it the proper accounts.
9. Click on Modify to save your changes.
10. Once all inventory items are corrected, run your End of Day again.  It will proceed without any more errors. 

SMARTSystem- Exporting Data to QuickBooks or your Accounting System

How to Export Data to QuickBooks from SMARTSystem

1. Check if the days Sales Orders have been Invoiced. Go to End of Day> Invoice Print Verification

1. 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:
   1. By clicking each sales order listed one at a time to display the sales order
   2. Invoice the sales order or change the delivery date

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

1. Items will save to your file and become available for import into Quick Books or your Accounting System:

   

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

3. Using the Quick Books Import Tool:
   1. You must have Quick Books open
   2. Switch to Single User Mode to prevent an import error by having another user access QB data until the Import process completes.

      

4. Click Quick Books Import Tool icon

   

5. Go to QuickBooks Import Tool:

   

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

   

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

8. Your source file will appear in the Browse box.

   

   Click the Import Data to QuickBooks button.

9. If the import was successful, you will receive a popup with the number of records successfully uploaded:

   

10. Process Complete
11. Export Customer Balances

    

12. When the process is complete you will see this pop-up:

14. Print Import Log

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

    

16. 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 EOD Checklist 

Date: ________________

   SMARTSystem Backup (Before EOD for the first month, then only periodically)

• File > Backup Database.

   SMARTSystem End of Day Delivery Date Verification

• End-of-Day > Invoice Print Verification > Select date > Click Check Date button > Click Exit button.

   SMARTSystem End of Day

• End-of-Day > Export to Accounting > Select end date > Click the Export Daily Activities to QB button (turns red when done).
• Optional: Print Invoice Payment Register or create PDF. (Store PDF report in WFSData\EOD folder)
• Print Invoice Register or create PDF. (Store PDF report in WFSData\EOD folder)
• Click the Exit button.

   Quick Books Backup

• File > Switch to Single User Mode.
• File > Backup Company > Create a Local Backup. Local Backup > Save it now > OK > Save in QB Local Backup folder on the Server or on your PC.

   Quick Books Import Tool – Import Data to QB

• Click the Browse button > In WFSData folder > Export Files > Select QB_Complete file > Click the Import Data to QB button.
• Processed a total of ### records. OK.   #

   Quick Books back to Multi User Mode.

   Fill out Deposit Sheet and Make the Deposit. $____________________

   Quick Books Import Tool – Export Customer Balances.

• Click the Export Customer Balances button.
• Customer Balances have been exported > OK.

   SMART System – Import Customer Balances from QB.

• File > Import > Import Customer Balances > Browse > WFSData: Import Files > Open the file > Click the Import Customer Balances button.

** End of Checklist **

Situation:  You’ve done your EOD and imported the transactions into QuickBooks.  There are some invoices that didn’t come into Quickbooks, but you didn’t see any error messages being thrown during the import.  At the end of the import, you see the message that XX number of records were processed.  Everything looked normal, but why are there invoices missing?

Resolution:  The only place you’ll see what happened during the import, in this type of situation, will be the QuickBook Import Tool log files.  These files are located in one of two places.

If you’re running Windows 7, then these files will be located in the C:\Program Files (x86)\Floral Computer Systems\Quick Books Import Tool 5.3.2 folder.

If you’re running Windows 8 or above, the log files will be located in the C:\WFSData\Quick Books Working\Quick Books Import Tool 5.3.2 folder.  There may be some slight variations on the folder names, but the Quick Books Import Tool folder will always be located in the WFSData folder.

The log files will be named “import_log_[date] [time].log” Here is an example of a log file name:  import_log_05-06-2019 14-17-12.log 

Open the most current log file and search for the customer’s name that didn’t come into QuickBooks.  This is the error message you’ll most likely see for that invoice:

Error: request 1: 3140: There is an invalid reference to QuickBooks Item “8000000B-1548357736” in the Invoice
line. QuickBooks error message: You cannot use the same tax item in both the line items and the txn tax.

What that means is that customer’s Sales Tax settings in QuickBooks is configured incorrectly and needs to be changed before the import will work. 

Normally, because SMARTSystem is logging sales tax, a customer needs to be set up in Quickbooks as “non-taxable” even though they are being charged sales tax.  The import tool takes the sales tax information from SMARTSystem and passes it over to Quickbooks.  If the tax settings are incorrect for the customer, Quickbooks will try to tax that customer again, and “get confused” because the sales tax is already included on the invoice. 

Verify the sales tax settings for the customer(s) whose invoices didn’t come in and correct them to be the same as your other “taxable” customers are set up in Quickbooks. Each company will have their own designated “non-tax type” name for this.

Also, verify the company preferences for sales tax are set to a non-taxable tax item.  This setting may be accessed by going to the Edit > Preferences menu item.  From there, locate the Sales Tax item in the left menu and verify the Company Preferences are set correctly.

You may then run the import again.  That should resolve the issue. 

Problem:

When end of day is run, the Invoice Payment Register is reporting one amount, but it doesn’t match what was brought in to Quick Books.  What is happening to cause this?

Changes were made to the sales orders associated with the invoices that were already in Quick Books. 

Any changes made to a sales order,will automatically cause the invoice to be updated with the changes.  The invoice then gets flagged to be re-exported.

The changes will not be imported to QB because the invoice is already there.  The updated invoices are listed on the Invoice Payment Register to let you know that something has changed and that QB needs to be updated manually.