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

Table of Contents
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
  9. Report Path: unc Path to CR Reports
  10. Logging Options:
  11. unCHECK Log Warnings
  12. unCHECK Log Notices
  13. unCHECK Log Debugs
  14. Click on Save
  15. 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
  4. User: sa or other user you setup
  5. Password: password
  6. Integrated Security

  7. CHECK for Integrated Security
  8. 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
  4. User: sa or other user you setup
  5. Password: password
  6. Integrated Security
  7. CHECK for Integrated Security
  8. Test Connection
  9. Click on Test Connection
  10. Click on OK
  11. Application Settings
  12. Report Path: unc Path to CR Reports
  13. Logging Options:
  14. unCHECK Log Warnings
  15. unCHECK Log Notices
  16. unCHECK Log Debugs
  17. Click on Save
  18. Click on Close
Server Configuration Manager
    Master Connection Settings
    Database Configuration
  1. DataPlus Server: ServerName
  2. DataPlus Database: DataBaseName
  3. Windows Authentication

  4. SQL User: sa
  5. SQL Password: password
  6. Integrated Security
  7. CHECK for Integrated Security
  8. Testing Connection

  9. Test Connection
  10. Click on OK
  11. Application Settings
  12. Report Path: unc Path to CR Reports
  13. Logging Options:
  14. unCHECK Log Warnings
  15. unCHECK Log Notices
  16. unCHECK Log Debugs
  17. Click on Save
  18. Click on Configure Applications >>
Server Configuration Manager
    Application Profiles
  1. Click on S50
  2. Application Settings
    ACT Credentials
  3. Database; ActDatabaseName click on [..] to browse to database
  4. User Name: ActUserName must be an ACT! administrator
  5. Password: ActPassword
  6. Confirm: ActPassword
  7. Test Connection
  8. Click on OK
  9. Database Configuration
  10. Database: dpS50 DataPlus database name
  11. Server: ServerName\Instance SQL Instance if applicable
  12. SQL User: sa
  13. SQL Password: password
  14. Check if you want integrated security
  15. Test Connection
  16. Click on OK
  17. Click on Update
  18. Click on OK
  19. 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 ...
  3. Click on Close & Review
  4. Create Users in ACT! from Employees
  5. In ACT
  6. Tools/Manage Users...
  7. Create New User
  8. Create User from Contact - Create a new User from an existing Contact.
  9. 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
  3. Click on Close
  4. or ...
  5. Click on Close & Review

DataPlus ACT! User Configuration
DataPlus Menu
  1. Open Act!
  2. No Menu Found
  3. DataPlus 4.0 Warning
  4. 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
  3. Click View Permissions Tab
  4. Check box for each "View Name" that will be accessed by "ACT! User"
  5. 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

  6. Remote Server:ServerName
  7. Click on Test Connection
  8. Click on Ok
  9. Custom MySQL Driver: MySQL ODBC 5.1 Driver (Default)
  10. 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.

  3. Employee Number: Employee Number Default
  4. Name: Contact * Required
  5. Birth Date: Birth Date * Required
  6. Street 1: Home Address 1 * Required
  7. Street 2: Home Address 2
  8. City: Home City * Required
  9. Province Home Province * Required
  10. Postal Code: Home Postal Code * Required
  11. Phone 1: Home Phone
  12. Phone 2: Alternate Phone
  13. Employee in USA: Home Country
  14. Sage ID: eEmployeeID Default
  15. Inactive: InActive
  16. Hire Date: Emp Date Hired
  17. SIN / SSN: Emp SSN
  18. Pay Periods: Emp Pay Periods * Required
  19. Tax Table: Emp Tax Table * Required
  20. State Allowance: Emp State Allowance
  21. State Status: Emp State Status
  22. Federal Allowances: Emp Federal Allowances
  23. Federal Status: Emp Federal Status
  24. Dependent Allowances: Emp Dependent Allowances
  25. 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.

  3. Vendor Number: Vendor Number Default
  4. Name: Company * Required
  5. Name: Contact * Required
  6. Street 1: Address 1 * Required
  7. Street 2: Address 2
  8. City: City * Required
  9. Province Province * Required
  10. Postal Code: Postal Code * Required
  11. Vendor in USA: Country
  12. Sage ID: eVendorID Default
  13. Inactive: InActive
  14. Email: E-mail
  15. Fax: Fax Phone
  16. Phone 1: Phone * Required
  17. Phone 2: Alternate Phone
  18. Currency Code: Currency Code
  19. Tax Id: Tax Id
  20. Web Site: Web Site
  21. 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.

  3. Customer Number: Customer Number Default
  4. Name: Company * Required
  5. Name: Contact * Required
  6. Street 1: Address 1 * Required
  7. Street 2: Address 2
  8. City: City * Required
  9. Province Province * Required
  10. Postal Code: Postal Code * Required
  11. Customer in USA: Country
  12. Sage ID: eCustomerID Default
  13. Inactive: InActive
  14. Email: E-mail
  15. Fax: Fax Phone
  16. Phone 1: Phone * Required
  17. Phone 2: Alternate Phone
  18. Currency Code: Currency Code
  19. Tax Id: Tax Id
  20. Web Site: Web Site
  21. 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
    Hogan Data eStore
    Act! CRM Solutions
    CRM
    CRM & Marketing Automation
    Marketing Automation
    Compare
    Pricing
    Try Growth Suite Starter
    Try Growth Suite
    Mobile Solutions
    Helpful Links
    ACTeStore.com
    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
    Contact Us
    Privacy Policy
    Return Policy
    Resources
    DataPlus Subscription
    DataPlus Maintenance
    QuoteWerks Maintenance
    DataPlus cloud
    Client Portal
    Partner Portal
    Partner Lead Submission
    Secure CC Authorization
    Secure CC Pre-Authorization

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