Tag: Development

  • Content Type

Evaluating strings in C# Code snippets

When checking for two (or more) different values for a property in a code snippet, you can't simply look at the string values without an error being thrown. For example: Sage.Entity.Interfaces.IAccount acc this.BindingSource.Current as Sage.Entity.Interfaces.IAccount; if (acc.type != "Customer" || acc.type != "Prospect")

Introducing the SalesLogix Mobile Developer Toolkit

I am very pleased to announce a new & free open source tool from Customer FX named the SalesLogix Mobile Developer Toolkit. This toolkit will make your life easier when working with the SalesLogix Mobile product and provide automation to some of the tedious tasks you have to complete before you actually get to start writing code. Let's take a look.

Extending Sublogix Entities

If you've followed my posts on Sublogix, or even better, given Sublogix a spin, you'll know that if you're doing SalesLogix development Sublogix can save you a ton of time and give you a much easier to use data access and entity model. This post will show you how to extend the Sublogix entities to give you even easier access and save even more time.

Modifying the QuickFind Lookup in the SalesLogix LAN client

The Quick Find functionality in the SalesLogix web client is a fast and easy way to look up information from many different areas in SalesLogix, but did you know you could modify the layout of the various lookups displayed in that interface? The functionality is a little hard to find if you don't know where to look, but this post will explain how you can modify the Quick Find lookups.

Launching Schedule Activity functionality in the SLX Web client

On a recent project, I worked on emulating functionality similar to what is found in the LAN client where a user is presented a dialog asking them to choose between different activity types then launching into the Schedule Activity functionality. I found this was fairly easy to duplicate in the web client, and in this post, I'll quickly go through the steps for creating that type of functionality.

Announcing the Open-Source SalesLogix .NET Extensions Helper Library

If you're working in the SalesLogix Windows (LAN) client, why not make as most use as possible of a modern development environment, language, and tools? The SalesLogix .NET Extensions feature in the SalesLogix Windows client is one of the best, and likely least used, features in the SalesLogix Windows client development story. A choice bewteen using an out-dated development environment and VBScript, with no possibility of using source control...

Changes in Sublogix Version 1.2

I've pushed version 1.2 of Sublogix to NuGet. There's some changes in how the custom entity templates are created by default. In previous versions of Sublogix, the custom entity templates used the display names for tables and fields in SalesLogix to create classes and properties. This caused several problems which this version addresses

Writing Queries for the SalesLogix SData API

In this fourth post in the SalesLogix SData series, I will introduce how to write queries for SalesLogix SData and will point to a useful resource as you get started, or more comfortable with SData. View the SalesLogix SData Developer series index SData Query Language Be sure to first take a look at my last […]

Retrieving Data via SData for SalesLogix

If you followed my last two posts, you'll know some basics of what SData is and how to get it to use in your projects. In this post, we will take this a step further and look at how to actually use it, starting with how to query data from SalesLogix.

Setting custom date ranges in Crystal

Recently, I had to develop a report which was to return data within a particular date range. Specifically, a user would need to select a date and the report would then return data from a range of Monday of the previous week to Friday of the current week. I was able to accomplish this fairly easily using Global and Local variables and a couple of different date functions.

An Overview of SData – The SalesLogix Web Enabled API

Chances are, if you work or use SalesLogix (or any Sage product) you've heard of SData by now. SData is a basically a web enabled API for SalesLogix allowing you to interact with SalesLogix data from an external application or website. The great thing about SData is that it is a specification that is implemented via RESTful web services. This means you're not limited to using SData with a particular technology (such as exclusively via .NE...

Advanced Pivoting in MSSQL

Using pivot queries in SQL is a great tool for rotating data, but what if you need to do something more complicated with multiple data sources and multiple columns? Recently, I had a request to pivot some data from multiple similar tables and to rotate that data into a columnar format.

Updating the Managed Quota Area for Sage SalesLogix

Often, when discussing reporting issues with clients I will bring up the Quota’s area of Sage SalesLogix.  If you do not know where this functionality is located, go to your Tools/Manage/Quota menu and the following screen will appear. On the upper pane you find a place to list the users you want to set a quota […]

A Demo of Sublogix – Simple Repository for SalesLogix

A few weeks ago I announced Sublogix. Sublogix is Customer FX project that provides a simple repository for SalesLogix development, allowing you to use an entity model and repository in any version of SalesLogix and is great for use in .NET Extensions in the LAN client, stand-alone or addon applications for SalesLogix or whatever. Death to SQL statements. Things are progressing nicely with Sublogix so I decided it was time to give you a closer lo...

Building a query-based lookup in SalesLogix Lan / Using SLX_Common to build query strings

I've previously posed about a number of useful functions available to you within the SLX_Common script in the LAN version of SalesLogix. I'd like to go a little further in-depth about a couple of functions which are helpful for creating new SQL Query strings. In a recent project, I needed to build a query interface similar to what you find in standard opportunity products view. The SLX_Common script holds a couple of functions that I ...

Running a SQL Update Statement from Saleslogix Web

I am working for a client who would like a button to set all of the records in a table to either “Valid” or “” (blank).  This then allows them to build groups on what records needs to be updated.  I started my adventure by reading Kris Halsrud’s post Retrieving the Manager in SalesLogix 7.5 Web .   The solution Kris […]