Knowledge Base
PROGRAM: DataPlus for Sage 50 CA - Client Installation

Table of Contents
Preparing for installation
Installation / Configuration
Related FAQs
Client Installation
DataPlus Setup
    Welcome Screen
  1. Right click DataPlus-S100CA-Install.exe and "Run as administrator
  2. This will start the DataPlus 4.0 setup wizard.
  3. Click on Next >
DataPlus Setup
    License Agreement
  1. License Agreement
  2. If you agree, check "I accept the terms in the license agreement"
  3. Click on Next >
DataPlus Setup
    Client Components
  1. Check DataPlus Client
  2. Check Sage 50 CA Component
Only check "Sage 50 CA Component" if you intent to allow this user to push from Act to Sage 50 CA. Otherwise leave unchecked.
DataPlus Setup
    Choose Install Location
  1. Click on Install
DataPlus Setup
    Installing
DataPlus Setup
    Installation Complete
  1. Click on Next
DataPlus Setup
    Client Configuration
  1. Check Run Client Configuration
  2. Click on Finish
DataPlus Setup
    Create Settings
  1. Click on Yes
DataPlus Setup
    Master Connection Settings
    Database Configuration
  1. DataPlus Server:
  2. DataPlus Database:
  3. SQL User:
  4. SQL Password:
  5. CHECK for Integrated Security
  6. Test Connection
  7. Click on OK
    8. Application Settings
  8. Report Path: unc Path to CR Reports
  9. Logging Options:
  10. unCHECK Log Warnings
  11. unCHECK Log Notices
  12. unCHECK Log Debugs
  13. Click on Save
  14. Click on Close
DataPlus Setup
    Bridge Installation Version
  1. Click on Next >
DataPlus Setup
    Bridge Installing
DataPlus Setup
    Bridge Installation Complete
  1. Click on Close
DataPlus Setup
    Installing
DataPlus Setup
    Server Credentials
    Server Settings
  1. SQL Server Name: Server\SQLInstanceName
  2. Database Name: dpSage50

    3. Credential Settings Windows Authentication
  3. User: sa or other user you setup
  4. Password: password

    5. Integrated Security

  5. CHECK for Integrated Security
  6. Click on Next >
DataPlus Database Setup
    Perform Installation
  1. Click on Yes
DataPlus Database Setup
    Create Database
  1. Click on Yes
DataPlus Database Setup
    Create Database Finish
  1. Database created
  2. Click on Finish
Server Credentials
    Sage 50 CA Settings
  1. Internal Name Sage 50
  2. Sage 50 Server: YourServerName
  3. Company File: Path and name of Sage50 Company file. - In Sage 50 File/Properties
  4. User: Sage50User
  5. Password: Sage50UserPassword
  6. MySQL Driver MySQL odbc 5.1 Driver
    DataPlus Server Settings
  7. SQL Server Name: Server\SQLInstanceName
  8. Database Name: dpSage50
  9. User: SQLUserName
  10. Password: SQLUserPassword
  11. Click on Next >
DataPlus Database Setup
    Modify Database
  1. Notice informing you of installation.
  2. Click on Yes
DataPlus Database Setup
    Installer Notice
  1. Notice to open Sage 50 Company
    1. Is your Sage 50 program open to your current company database?
    2. Are you in 'multi-user mode'?
  2. Click on Yes
DataPlus Database Setup
    Installation Finished
  1. Click on Finish
DataPlus Database Setup
    Installation Complete
  1. Click Next >
DataPlus Database Setup
    Run Server Configuration
  1. CHECK to run Server Configuration
  2. Click on Finish
DataPlus Database Setup
    Run Server/Client Configuration
  1. CHECK to run Server Configuration
  2. CHECK to run Client Configuration
  3. Click on Finish
Client Configuration Manager
    Master Connection Settings
    Database Configuration
  1. DataPlus Server: ServerName
  2. DataPlus Database: DataBaseName
    3. Windows Authentication
  3. User: sa or other user you setup
  4. Password: password
    5. Integrated Security
  5. CHECK for Integrated Security
    6. Test Connection
  6. Click on Test Connection
  7. Click on OK
    8. Application Settings
  8. Report Path: unc Path to CR Reports
  9. Logging Options:
  10. unCHECK Log Warnings
  11. unCHECK Log Notices
  12. unCHECK Log Debugs
  13. Click on Save
  14. Click on Close
Server Configuration Manager
    Master Connection Settings
    Database Configuration
  1. DataPlus Server: ServerName
  2. DataPlus Database: DataBaseName

    3. Windows Authentication

  3. SQL User: sa
  4. SQL Password: password
    5. Integrated Security
  5. CHECK for Integrated Security

    6. Testing Connection

  6. Test Connection
  7. Click on OK
    8. Application Settings
  8. Report Path: unc Path to CR Reports
  9. Logging Options:
  10. unCHECK Log Warnings
  11. unCHECK Log Notices
  12. unCHECK Log Debugs
  13. Click on Save
  14. Click on Configure Applications >>
Server Configuration Manager
    Application Profiles
  1. Click on S50
    2. Application Settings
    ACT Credentials
  2. Database; ActDatabaseName click on [..] to browse to database
  3. User Name: ActUserName must be an ACT! administrator
  4. Password: ActPassword
  5. Confirm: ActPassword
  6. Test Connection
  7. Click on OK
    8. Database Configuration
  8. Database: dpS50 DataPlus database name
  9. Server: ServerName\Instance SQL Instance if applicable
  10. SQL User: sa
  11. SQL Password: password
  12. Check if you want integrated security
  13. Test Connection
  14. Click on OK
  15. Click on Update
  16. Click on OK
  17. Click on Close
DataPlus ACT! Manual Import - Employees Only
Server Configuration Manager
    Manual Import
  1. Open ACT!
  2. Click OK
    3. Note: DataPlus menus have not been configured. We will address this later in KB.
Server Configuration Manager
    Manual Import
  1. Tools/DataPlus 4.0/Manual Import

If you are using your own custom Act! database, the custom fields should be created.

In the Act Import process, DataPlus can create the custom fields.

Server Configuration Manager
    Manual Import
  1. Click on S50
  2. Click on Browse
Server Configuration Manager
    Manual Import
    Employee Only Import
  1. Check Enable Database Locking
  2. Check Only Run Selected Items
  3. Check S50: (500) Employee
  4. Check S50: (501) Employee Header
  5. Click on Okay

The purpose of importing employees only is to establish your connection to "Act Users"

Server Configuration Manager
    Manual Import
    Employee Only Import
  1. Click on Import Selected
Server Configuration Manager
    Manual Import
    Employee Only Import
    Import Complete
  1. Click on Close
    2. or ...
  2. Click on Close & Review
    3. Create Users in ACT! from Employees
  3. In ACT
  4. Tools/Manage Users...
  5. Create New User
  6. Create User from Contact - Create a new User from an existing Contact.
  7. Create users using the imported Employees

DataPlus ACT! Manual Import - Preferred Entities
Server Configuration Manager
    Manual Import All
  1. ReRun DataPlus Manual Import
  2. Check Enable Database Locking
  3. Use your default configuration
Server Configuration Manager
    Manual Import All
  1. Click on Close
    2. DataPlus Import
  2. Click on Close
    3. or ...
  3. Click on Close & Review

DataPlus ACT! User Configuration
DataPlus Menu
  1. Open Act!
    2. No Menu Found
  2. DataPlus 4.0 Warning
  3. Click OK
DataPlus menus have not been configured. When DataPlus is configured in the following steps, this message will be disabled.
DataPlus Menu
    Manage Permissions
  1. Act Menu
  2. Tools/DataPlus 4.0/Manage Permission
DataPlus menus have not been configured. When DataPlus is configured in the following steps, this message will be disabled.
DataPlus Menu
    Manage Permissions
    Current Connections
  1. Click Sage 50 CA

    2. Permissions
  2. Click View Permissions Tab
  3. Check box for each "View Name" that will be accessed by "ACT! User"
  4. You can double click the header to check or uncheck all
DataPlus Menu
    Manage Permissions
    Permissions
  1. Click Misc Permissions Tab
  2. Check View - enable views in ACT! DataPlus tab (overrides View Permissions)
  3. Check Export - export view to excel
  4. Check S50 Contact Push - Create Customer/Vendor/Employee
  5. - Edit Customer/Vendor
  6. Check S50 CONT Push - enables creating Contracts
  7. Check S50 EST Push - enables creating Estimates
  8. Check S50 INV Push - enables creating Invoices
  9. Check S50 SO Push - enables creating Sales Orders
  10. You can double click header or row to check or uncheck all
DataPlus Menu
    Sales Representative
    Permissions
  1. Click Sales Representative Tab
  2. Check Box for each sales representative for view permissions
  3. You can double click the header or row to check or uncheck all
  4. Click Save
  5. Click Close
  6. Click Yes
  7. Click OK
  • Most views have the "Sales Representative" from Sage 50 CA Accounting listed. Each Sales Representative will only be able to see view where they are the Sales Representative.
  • You can also enable Sales Representative to see other Sales Representative information. Example, sales manager may need to view each Sales Representative's views on their team.
  • DataPlus Tab should be available for each DataPlus Client after "DataPlus Client Install".
DataPlus Act! User Configuration
Push Configuration
    Determine Company Properties
  1. Sage 50 CA
  2. Menu Bar
  3. Choose File
  4. Choose Properties
    1. Company File
    2. Location
Push Configuration
  1. Open Act
  2. Menu Bar
  3. Choose Tools
  4. Choose Sage 50
  5. Choose Confibure Sage 50 Push
Push Configuration

    Connection
    This information is generated from the installation process. Verify your information.

    Company Settings

  1. Company File: drive:\path\company name
  2. User: User name
    Based on "Sage User Scenerio" you may have to change this user to a 2nd dedicated user for DataPlus.
  3. Password: password (7 characters max)
  4. Check Multi-user Mode

    5. Server

  5. Remote Server:ServerName
  6. Click on Test Connection
  7. Click on Ok
  8. Custom MySQL Driver: MySQL ODBC 5.1 Driver (Default)
  9. Click on Employee Mapping Tab

IMPORTANT: If "Test Connection" fails

Push Configuration

    Employee Mapping

    Employee Field Mapping

  1. Check Employee Push Enable

    2. You should not have to make any changes below.

  2. Employee Number: Employee Number Default
  3. Name: Contact * Required
  4. Birth Date: Birth Date * Required
  5. Street 1: Home Address 1 * Required
  6. Street 2: Home Address 2
  7. City: Home City * Required
  8. Province Home Province * Required
  9. Postal Code: Home Postal Code * Required
  10. Phone 1: Home Phone
  11. Phone 2: Alternate Phone
  12. Employee in USA: Home Country

  13. Sage ID: eEmployeeID Default
  14. Inactive: InActive
  15. Hire Date: Emp Date Hired
  16. SIN / SSN: Emp SSN
  17. Pay Periods: Emp Pay Periods * Required
  18. Tax Table: Emp Tax Table * Required
  19. State Allowance: Emp State Allowance
  20. State Status: Emp State Status
  21. Federal Allowances: Emp Federal Allowances
  22. Federal Status: Emp Federal Status
  23. Dependent Allowances: Emp Dependent Allowances
  24. Click on Vendor Mapping Tab
Push Configuration

    Vendor Mapping

    Vendor Field Mapping

  1. Check Vendor Push Enable

    2. You should not have to make any changes below.

  2. Vendor Number: Vendor Number Default
  3. Name: Company * Required
  4. Name: Contact * Required
  5. Street 1: Address 1 * Required
  6. Street 2: Address 2
  7. City: City * Required
  8. Province Province * Required
  9. Postal Code: Postal Code * Required
  10. Vendor in USA: Country

  11. Sage ID: eVendorID Default
  12. Inactive: InActive
  13. Email: E-mail
  14. Fax: Fax Phone
  15. Phone 1: Phone * Required
  16. Phone 2: Alternate Phone
  17. Currency Code: Currency Code
  18. Tax Id: Tax Id
  19. Web Site: Web Site
  20. Click on Customer Mapping Tab
Push Configuration

    Customer Mapping

    Customer Field Mapping

  1. Check Customer Push Enable

    2. You should not have to make any changes below.

  2. Customer Number: Customer Number Default
  3. Name: Company * Required
  4. Name: Contact * Required
  5. Street 1: Address 1 * Required
  6. Street 2: Address 2
  7. City: City * Required
  8. Province Province * Required
  9. Postal Code: Postal Code * Required
  10. Customer in USA: Country

  11. Sage ID: eCustomerID Default
  12. Inactive: InActive
  13. Email: E-mail
  14. Fax: Fax Phone
  15. Phone 1: Phone * Required
  16. Phone 2: Alternate Phone
  17. Currency Code: Currency Code
  18. Tax Id: Tax Id
  19. Web Site: Web Site
  20. Click on Naming Convention Tab
Sage 50 Connection Settings
    Sage 50 Connection Settings
    Determine your Sage Company Type

    Industry Type

  1. In Sage
  2. Menu Bar
  3. Setup
  4. Settings ...
  5. Expand Company
  6. Choose Information
  7. Industry Type: IndustryType
Sage 50 Connection Settings
    Sage 50 Connection Settings
    Naming Convention
  1. Industry IndustryType Choose your company industry type.
    1. Accommodation
    2. Agriculture
    3. Construction/Contractor
    4. Education Service
    5. Entertainment
    6. Food and Beverage
    7. Manufacturing/Industrial
    8. Medical/Dental
    9. Non-Profit
    10. Other
    11. Personal Service
    12. Professional Service
    13. REal Estate/Property
    14. Retail
    15. Service
    16. Transportation
  2. Transaction Types
    Based on the Industry type you choose, the type of transactions will be chosen.
    1. Estimate
    2. Contracts
    3. Invoices

    Type of transaction will change based on "Industry Type"

  • Click on Save

  • Click on Ok
    • Related FAQs
       
    Software Solutions
    DataPlus Integration
    DataPlus ERP Integration
    DataPlus Custom Integration
    DataPlus Addons
    DataPlus Plugins & Tools
    Hosting Solutions
    Mobile Solutions
    QuoteWerks Quoting Solutions
    QuoteWerks Integration
    QuoteWerks Subscription & Licensing
    Act! CRM Solutions
    CRM
    CRM & Marketing Automation
    Marketing Automation
    Pricing
    Mobile Solutions
    Helpful Links
    Act! Hosting Solutions
    Act! Mobile Messenger
    Act! ERP Integration
    Act! Custom Integration
    Act! Addons
    Act! Plugins & Tools
    Act! Training
    Act! Resources
    Act! Support
    Act! Community
    Act! Downloads & Updates
    Learning - Support
    Software Support
    Support (GoToAssist)
    Support Plans
    Training
    Act! Training
    KB Hogan Data / DataPlus
    KB Act! Questions
    KB QuoteWerks Questions
    Contact Us
    About Us
    How Can We Help You
    Privacy Policy
    Return Policy
    Resources
    DataPlus Subscription
    DataPlus Maintenance
    QuoteWerks Maintenance
    Partner Lead Submission
    Secure CC Authorization
    Secure CC Pre-Authorization

    Translate this page:
    ©1995 - 2019 HOGAN DATA | All rights reserved