Sage 300 Connector Configuration

Real-time Action Processing

• This feature should always be enabled for optimal performance. Only disable it if you are advised to do so by support.

Sage 300 Database connection string

Create the Sage 300 Database connection string using info from your initial ERP setup. Insert the appropriate values into each field below, separated by semicolons (no spaces).

• Driver=Timberline Data (This may be different if you customized your Sage 300 install.)

• DBQ=[the path to the Sage 300 company data folder, which is first shown when you log into Sage 300 and select your company directory]

• UID=XChangeServiceUser (Reminder: This user name must exactly match the Sage application user you set up in step 3a of this guide.)

• PWD=[the password created for XChangeServiceUser]

• Add this text at the end of your connection string; it never changes: codepage=1252;dictionarymode=0;standardmode=1;maxcolsupport=1536;shortenames=0;databasetype=1;                                      

For example, Driver=Timberline Data; DBQ=\\SERVERNAME\Timberline Office\Data\COMPANY\; UID=XChangeServiceUser; PWD=Ch@rl!e1978; codepage=1252;dictionarymode=0;standardmode=1;maxcolsupport=1536;shortenames=0;databasetype=1; 

Xml Messaging Configuration

Enter values in the following fields:

AddressBookKey 

• 8826C49B-20E0-44f9-A797-0BE8C4226E1F

ServiceManagementKey

• C7FC4D2C-BBC3-4a0b-B58A-ED2A9CBDF07F

JobCostTransactionServiceKey

• 4DEB77A7-D9CD-4560-A52D-088AF3020D9A

DataConnectionUrl

• Enter the data folder path for your company. This should match your DBQ above.

GeneralLedgerKey

• 71948BDB-E50B-49ce-9893-B4E33460A8D5

GlDataConnectionUrl

• Enter the data folder path for your company. This should match your DBQ above.

GlTargetsUrl

• Enter the data folder path for your company’s GLMessaging.xml file. This is typically either \\SERVERNAME\TIMBERLINE OFFICE\9.5\Shared\Config\RoutingCatalogs\GL\GLMessaging.xml or C:\ProgramData\Sage\SERVERNAME\Timberline Office\9.5\Shared\GLMessaging.xml.

AccountsPayableKey

• 3BC2F783-5D10-480d-8F2D-C66C4B730937

AddressBookMessageTargets

• Enter the data folder path for your company’s ABMessageTargets.xml file. This is typically either \\SERVERNAME\TIMBERLINE OFFICE\9.5\Shared\Config\RoutingCatalogs\AB\ABMessageTargets.xml or C:\ProgramData\Sage\SERVERNAME\Timberline Office\9.5\Shared\ABMessageTargets.xml.

ApDataConnectionUrl

• Enter the data folder path for your company. This should match your DBQ above.

ApTargetsUrl

• Enter the data folder path for your company’s apMessaging.xml file. This is typically either \\SERVERNAME\TIMBERLINE OFFICE\9.5\Shared\Config\RoutingCatalogs\AP\apMessaging.xml or C:\ProgramData\Sage\SERVERNAME\Timberline Office\9.5\Shared\apMessaging.xml.

User

• XChangeServiceUser (Reminder: This user name must exactly match the Sage application user you set up in step 3a of this guide.)

Password

• Enter the password created for XChangeServiceUser.