Configuration
These additional connector settings must be configured in App Xchange.
Connection Details
-
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 that of the Sage ODBC service user you previously recorded.)
-
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
-
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 you previously recorded for XChangeServiceUser.