Browse By Tags

  • Create New Development SQL Database

    Hi, my company is using FAS Premier Depreciation and Tracking software. We have an Application server with FAS installed and then we have a SQL server instance with the production DB on it. We are in need of creating a 2nd SQL DB but on a differnet SQL…

  • Run-time error '-2147467859 (800004005)':

    Good day I just did an update and got the following. Update Version 2023 Update 2. This is on a Server with 4 Users. Only one user can work on Payroll other users get the following error. It asked me to create an account. I created one. Done Then…

  • Enable/Disable modification of an entry

    Normally, whenever you want to create any entry in sage X3, there are two ways, 1. either by clicking the "New Button" 2. "Modifying the existing entry", just need to remove the entry number, press TAB, and all of the attributes of the existing entry…

  • Sage CRM's RESTful API: SData (Part 10 of 10)

    In this article, I want to look at three different examples of how we can use the SData 2.0 based RESTful API within Sage CRM to carry out CRUD actions. Post (Insert) a new record into a system entity Post an Entry and link to an existing entity…

  • Sage CRM's RESTful API: SData (Part 9 of 10)

    We have seen previously in this series that we can make a request directed at an instance of Sage CRM using SData 2.0 to fetch some data from an entity. http://localhost/sdata/crmj/sagecrm2/-/company('28') The result received when we use SData…

  • Sage CRM's RESTful API: SData (Part 8 of 10)

    I said in my last article that SData 2.0 can not be considered a 'green field' solution because SData has been already used through out Sage CRM right from the start of the move to the new Java based architecture. The desire for compatibility between…

  • Sage CRM's RESTful API: SData (Part 7 of 10)

    The SData standard has always been about enabling all types of Sage applications, whether they are desktop, server, or web-based systems to communicate with each other easily. The standard provides the basis of the RESTful APIs that can be used by our…

  • Sage CRM's RESTful API: SData (Part 6 of 10)

    The classic SOAP web services provide us with an existing set of abilities to create, read, update and delete data. In this article I want to examine those web services in order to explain some of the limitations of the interface and why we can instead…

  • Sage CRM's RESTful API: SData (Part 5 of 10)

    In this article I want to think about security. This is both the security that governs the rights of access to the system and the access that is then granted to a user accpording to the policies implemented within Sage CRM. One of the first things to…

  • Sage CRM's RESTful API: SData (Part 4 of 10)

    In this article I want to consider the way in which the RESTful API allows system administrator to easily extend the reach of the API's access to data across custom entities and views with SData. It is very useful being able to retrieve data using end…

  • Sage CRM's RESTful API: SData (Part 3 of 10)

    In this article I want to start looking at the SData in action and start to understand what the RESTful API offers. And if we are going to work with SData then we need to have an instance of Sage CRM with which we can play. Here we need to work with…

  • Sage CRM's RESTful API: SData (Part 2 of 10)

    In this article I want to consider Sage CRM's Architecture, its development options and the importance that this places on the use of Web Services especially REST and SData for integration. We need to consider what is available to use now and look and…

  • Sage CRM's RESTful API: SData (Part 1 of 10)

    This article is the first of a new series of articles that will provide you with a jump start on developing with the new RESTful API for Sage CRM. Not everyone reading this will be familiar with SData and so I need to start from the beginning and explain…

  • Creating an appointment automatically

    Hi all, We are looking into way of triggering an automated appointment creation based on selection. For example: If I create a new appointment in sage CRM 7.1 and select "Holiday" as the action. Complete all relevant details on for the appointment…

  • How to create a custom field (UDF)

    Hi Sage City neighbours! I’m still learning here so please be patient. I would like to add a custom field to the BPC4 screen; BPs – Customer – Ship-to customer tab. The purpose of this field is only to store a 10 alphanumeric account number. This field…

  • How to jump and fill a header?

    Hi, I'm in the quote function (GESSQH) and I want to jump to the projects (GESOPP) with the header filled. Here is an example: If I have this quote and when I click "NEW PROJECT": It should jump to Projects and Fill the header, so…

  • Sage 50 API: Is it possible to create or modify employees? What payroll functions are available via the API?

    Sage 50 API: Is it possible to create or modify employees? What payroll functions are available via the API?

*Community Hub is the new name for Sage City