Download Interface Manual

Transcript
Table of Contents
Installation & Data Setup ................................................................................................................................ 4
Installing the interface program files...................................................................................................... 4
1. Backup the CFS and QuickBooks data. ....................................................................................... 4
2. Make sure the CFS program files are current. ........................................................................... 4
3. Setting in CFS> Update Master File to turn interface on. ........................................................ 4
4. The interface needs to be installed on the local drive of network workstations. ............. 4
5. Know the path to the QuickBooks company file. ..................................................................... 4
6. Know which QB user the interface will link to. ......................................................................... 4
7. Security and Permissions Settings ............................................................................................... 5
8. Download the CFS-QB_Interface_Files.zip .................................................................................. 5
9. To install in Windows XP: .............................................................................................................. 5
10.
For Vista, Windows 7, Windows 8, and later installation: .................................................. 5
Installation checklist .............................................................................................................................. 7
Sales_Reps.csv .............................................................................................................................................. 9
Import of QB customers into the CFS contact center - semi-automatic & optional ...................... 9
Troubleshooting Installation .............................................................................................................. 10
To uninstall the interface .................................................................................................................... 13
Data Setup - QuickBooks .......................................................................................................................... 14
1.
Tracking Inventory .................................................................................................................... 14
2.
Unit of Measure .......................................................................................................................... 14
3.
Customize the Estimate form in QB ...................................................................................... 14
4.
Chart of Accounts ..................................................................................................................... 14
5.
Required Items ........................................................................................................................... 14
CFS Data Setup ........................................................................................................................................... 15
Introduction ........................................................................................................................................... 15
Level 1 setup details ............................................................................................................................. 16
1.
Sales Tax ...................................................................................................................................... 16
2.
Part Numbers.............................................................................................................................. 16
3.
CFS Write-In Entries*: ............................................................................................................... 17
4.
Getting the CUSTOM parts into QuickBooks ....................................................................... 17
5.
Preparing for sales account designations of items ............................................................ 18
6.
Backup your primary data files. ............................................................................................. 18
7.
To associate the designator to the items in CFS: ............................................................... 18
Level 2 setup – tracking inventory .................................................................................................... 19
1.
Labor Records ............................................................................................................................ 19
2.
Alert!! PVC and/or ornamental fencing fabricator module users ................................... 20
3.
Unit of Measure .......................................................................................................................... 20
4.
Verify assemblies are flagged correctly................................................................................ 21
5.
CFS Part Numbers ...................................................................................................................... 22
6.
Preparing the CFS Master File export for Populating the QuickBooks Item List ......... 24
7.
Importing the items exported from CFS into QuickBooks ............................................... 25
8.
Recreate the CFS cross reference table ................................................................................. 25
9.
Importing assemblies into QB ................................................................................................ 25
Daily Activity ................................................................................................................................................... 27
Workflow ................................................................................................................................................. 28
Daily Use Explanation ............................................................................................................................... 29
Exporting Level 1 Jobs ......................................................................................................................... 29
Exporting Level 2 Jobs ......................................................................................................................... 29
Page 2 of 50