July 2009 - Posts

• SalesLogix ERP Link- How the sales order push to MAS determines which warehouse to use

  How ERP Link determines warehouse values when posting a Sales Order to MAS 500 from SalesLogix Read more Posted Jul 22 2009, 08:28 AM by Kris Halsrud with no comments Tags: ERP Link, MAS 500, SalesLogix 7.5, Troubleshooting

• ERP Link - Why do you hate the smallint?

  ERP Link will not work with SmallInt data types, even though they are a valid SalesLogix data type and can be selected when adding a field to the database in the SalesLogix Workgroup Administrator. Read more Posted Jul 16 2009, 12:04 PM by Kris Halsrud with 3 comment(s) Tags: ERP Link, SalesLogix 7.5, SQL Server, Troubleshooting

• Importing data into SalesLogix using SQL DTS - Part 3

  This is a continuation of part 1 and part 2. Part 1 I discussed setting up a SQL environment for importing and Part 2 talked about how to load in a source file into the import environment. In this post I am going to discuss actually transforming the data source so that it is in the format of SalesLogix. Read more Posted Jul 15 2009, 09:15 AM by Kris Halsrud with no comments Tags: SalesLogix, SQL Server

• A Bug in SalesLogix ERP Sync when not running it on the SalesLogix Server

  In an earlier post , I reviewed the ERP Sync component of the Sage ERP Link product.  We had a client who was unable to get ERP Sync to run.  They had everything set up correctly but when the job was executed using the command line switches... Read more Posted Jul 09 2009, 03:39 PM by Kris Halsrud with no comments Tags: ERP Link, MAS 500, SalesLogix 7.5

• Fixing SalesLogix Web Client Ticket Journal Date Display

  As you probably know, SalesLogix displays most date times in the database in UTC format. Normally the SalesLogix provider handles converting the UTC formatted dates to the local client date times. There are exceptions to this automatic adjustment. One such case is the Journal tab within the Ticket area of the SalesLogix web client. Read more Posted Jul 08 2009, 04:52 AM by Kris Halsrud with no comments Tags: SalesLogix 7.5, SalesLogix 7.5.1, SalesLogix Web

• OnCompletedActivity an oldy but goody- SalesLogix 6.2 VBScript

  We recently had a request to do some customizations for a client who wanted some validation done when completing an activity.  The only problem was they were on 6.2.  As you might know the Activity screens in SalesLogix 6.2 are part of the application... Read more Posted Jul 02 2009, 11:38 AM by Kris Halsrud with 2 comment(s) Tags: SalesLogix

• Handy code snippet for setting current group in SalesLogix 7.5 web

  How to set the current group in the SalesLogix 7.5 web client Read more Posted Jul 01 2009, 07:08 AM by Kris Halsrud with no comments Tags: SalesLogix 7.5, SalesLogix Web