Browse by Tags

• ERP Link
• SalesLogix
• SalesLogix 7.5
• SQL Server
• Troubleshooting

• MAS 500 checking a customers credit limit

  MAS offers a stored procedure that allows you to check if a custom has exceeded their credit limit.  The procedure is called "sparCreditCheck" and takes 8 parameters: @iCustKey - the customer key of the customer you want to check the credit... Posted Sep 09 2009, 03:46 PM by Kris Halsrud with | with 1 comment(s) Tags: MAS 500

• 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 Posted Jul 22 2009, 08:28 AM by Kris Halsrud with | with no comments Tags: ERP Link, MAS 500, SalesLogix 7.5, Troubleshooting

• 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... Posted Jul 09 2009, 03:39 PM by Kris Halsrud with | with no comments Tags: ERP Link, MAS 500, SalesLogix 7.5

• Sage SalesLogix ERP Link Sync

  In addition to the client side aspect of ERP Link there is a "server" side component that allows the ERP Link Queries to run and populate the data in SalesLogix. The queries provide the data that you see in SalesLogix for a customer like YTD sales, open payments, open invoices, etc. These data queries can only be executed through the ERP Link Sync utility. If you do not set up and run this utility, you will not see your financial data in SalesLogix! Posted Jun 18 2009, 08:50 AM by Kris Halsrud with | with 3 comment(s) Tags: ERP Link, MAS 500, SalesLogix

• SalesLogix ERP Link- An Overview

  With ERP Link, SalesLogix has the capability to integrate with MAS 500 in a more robust fashion than is possible with DynaLink. Lets take a look at the components of ERP Link. Overview of the Components First of all the actual ERP Link product is mainly... Posted Jun 17 2009, 06:51 AM by Kris Halsrud with | with 3 comment(s) Tags: ERP Link, MAS 500, SalesLogix

• Retrieving Sales Order defaults for a MAS 500 customer

  One of the useful stored procedures in MAS 500 that I have used quite a bit is spsoGetCustDflts. This stored procedure allows you to pass in customer parameters and have the system return to you nearly all of the customer attributes you would need to... Posted Jun 09 2009, 02:31 PM by Kris Halsrud with | with no comments Tags: MAS 500, SalesLogix, SQL Server

• MAS 500 Sales Orders - Kit Structure

  In my last blog I discussed how MAS 500 has a concept of Kits and where these are stored in relation to the item tables.  Similarly, the Kits can be added to Sales Orders.  This post discusses the structure of the Sales Order tables as it relates... Posted Dec 31 2008, 12:49 PM by Kris Halsrud with | with no comments Tags: MAS 500

• MAS 500 Items - Kit Structure

  In MAS 500 there is the concept of a "Kit" which is a group of items that are bundled together and sold as a single entity. Think of something like a computer which consists of various hardware and software components. The Kit itself has a separate... Posted Dec 30 2008, 09:45 AM by Kris Halsrud with | with no comments Tags: MAS 500

• Fetching Item Pricing from MAS 500

  MAS 500 has many, many stored procedures that allow various actions to be performed while enforcing business rules, such as adding, updating, or removing records, or retrieving values from the system.  This article will describe one of the more useful... Posted Aug 18 2008, 03:14 PM by Kris Halsrud with | with no comments Tags: MAS 500, SQL Server