Your Sage CRM Expert - My CRM Manager

We specialize in Sage CRM implementations and services. Sage CRM is highly customizable, incredibly fast, and very extendible to meet all your organizational needs.

Sage 300 CRM integration

Sage 300 CRM

Sage 300 CRM users have unparalleled access to accounting data without actually having access to the Sage 300 system (or consuming a Sage 300 license).

The Sage 300 integration is published by Sage, and all Sage 300 customers that are current with their Sage support plan are eligible for 1-free Sage CRM license. 

As you review the depth of the integration on this page, please keep in mind that having staff use Sage CRM provides them with all the Sage 300 functionality they are accustomed to for approximately 1/3 of the cost of a Sage 300 license.  Plus they get Sage CRM. 

Sage 300 CRM integration

What is Sage CRM?

Learn about Sage CRM and it's key benefits.

Test Drive before you commit

Sage CRM Pilot Package

How much is Sage CRM

Pricing Calculator

Table of Contents

Features and Benefits

Features

  • Customer and Vendor integration
  • Ability to define user access rights to Sage 300 data
  • Convert/promote companies in Sage CRM to Customers or Vendors in Sage 300
  • View Order and Invoice history from Sage CRM
  • Create new quotes and orders using Sage CRM that populate Sage 300
  • Lookup Inventory quantities

Benefits

  • Sage CRM users are more informed with their accounts
  • CRM users can look up information for themselves without needing to contact the accounting team
  • Reduces the need for Sage 300 licensing
  • Eliminates duplicate entry
  • Supports remote employees, including Order Entry

Customer Integration

Customer Record

From the customer (or vendor) record in Sage CRM, users can see key Sage 300 fields, but also have access to key Sage 300 functions. 

This image shows us key tabs across the top which we have explained in more depth below.

Users can also jump directly to creating a new Sage 300 Quote or Order from this screen.  When we use either of these two features, we are using Sage 300 inventory pricing.

Sage 300 CRM Customer Record

AR History

The A/R inquiry tab shows us invoice history for the account.  User can filter invoices by paid or unpaid and even dive into the specifics of that invoice including line item detail. 

Sage 300 CRM AR History

Customer Tab

The Customer tab opens up the same Customer tab we see within Sage 300.  From here we can go deeper into the sub-tabs of the account. 

Credit status, optional fields, statistics are all accessible to your front line staff, therefore eliminating their need to log directly into Sage 300.

Sage 300 CRM Customer Tab

Order Entry

An Order can be created from Sage CRM either from the context of an opportunity, or directly from the Company Summary screen.   If you do elect to directly create an order, a Sage CRM opportunity is created in the background automatically

sage 300 creating :: 1718048390

These order screens are Sage 300 order screens. So, the same rich functionality exists. 

Sage 300 CRM Order Screen

Vendor Integration

When most people think of CRMs integrating with accounting data, they think of customer records, but the Sage 300 CRM integration also works with Vendors.

Vendor Record

The fields highlighted in this image indicate the points of integration for vendor companies from Sage CRM.  

Note that just because these features exist, you may elect to restrict (hide) certain functionality from individual users.

Sage 300 CRM Vendor Record

AP Inquiry

From the AP history tab, we can view a list of documents, but also bring up the transaction itself by clicking on the Document Number hyperlink.

Sage 300 CRM AP Inquiry

Purchase Order Inquiry

From the purchase order tab, users can view OR create purchase orders.

Sage 300 CRM PO Inquiry

Item Inventory

CRM users can readily view inventory sold to a particular customer as well as what it was sold for.    

Please also notice the user has the ability to create a new Quote or new Order from this screen as well. 

Sage 300 CRM Item Inventory

Customizing the Sage 300 CRM Integration

While the Sage 300 to CRM integration is very strong, there are some situations when it makes sense to adjust the default integration.  Below are some examples.

Automatically bring over new customers from Sage 300 to CRM

By default, any new company can be created by either (a) promoting them from CRM into Sage 300, or (b) by using an import function to bring in companies from Sage 300 into Sage CRM.  

Related to option (b), some organizations require new companies to automatically get created within Sage CRM without user intervention. We accomplish this using a Windows scheduler routine. 

Automatically Refreshing the Salesperson value in CRM

For some organizations, the sales rep is defined and managed primarily in Sage 300.  And is subject to change. If this applies to you, we can have the sales rep value (aka account manager) update in CRM based on the change in Sage 300.  This can also include updating the territory (security) associated with the company record in Sage CRM.

Bringing over additional fields at the Company Level

Whether you need standard fields from Sage 300 to be brought over, or may you want some form of calculated measurement to display within CRM – you can.  We have done this before for Customers and Vendors. 

1 to Many: Mapping a Single CRM Company to Multiple Customer Records

By default, integrations between CRM and 300 allow for only a single relationship.  Example: 1 CRM company pointed to 1 Customer or Vendor record.  However, some organizations have multiple accounting databases with the same companies appearing in more than one database.  For these situations, we use an extension to the integration that allows for a single company record in CRM to be connected to multiple accounting databases (Customers or Vendors).  We refer to this requirement as 1 to Many. 

From the Linked Companies tab, we can establish the connection between the single Sage CRM company and multiple Sage 300 records, as well as define the default relationship. 

Sage 100 CRM 1 to Many

Requirements

The integration between Sage CRM and Sage 300 leverages Sage 300’s web-screens.  This means that your Sage 300 system must be either version 2019, version 2020, or version 2021 and that Sage 300 web-screens must be configured.  If Sage CRM will be accessed outside of the local area network (the Internet), this means that both Sage CRM and Sage 300 web-screens must be exposed to the Internet. 

This link brings up the compatibility chart for Sage CRM and Sage 300.

Test Drive before you commit

Sage CRM Pilot Package

How much is Sage CRM

Pricing Calculator

Schedule A Demo
Did you know that you can integrate your Sage 300 system with salesforce.com?
Did you know that you can integrate your Sage system with Salesforce.com?

Looking for Dedicated Sage CRM Help?
Contact My CRM Manager