Browse By Tags

  • Posting Date Guidelines

    Hello! - Wondering if anyone has a simple and easy guide already prepared that could be used as mass communication regarding when and what needs to occur in the same month when reviewing before posting an entry. We have had document dates not matched…
  • Release 5.5b is now available on the Sage Portal for Sage Classic and Sage Premier!

    Release 5.5b for Sage Classic and Sage Premier is now available for download from the Sage Portal Release 5.5b is only mandatory for Ghana payrolls. It is strongly recommended that Lesotho users load the update by February 2021. All other tax countries…
  • Prevent postings for a previous period

    Sometimes you may want to stop transactions being posted before a certain date, for example, to close down a previous month or year, or to avoid accidental postings to 2020 now we're in 2021. It's easy to do this using the Lock Date option. Read more…
  • SORDER.SHIDAT_0 & SDELIVERYD.SHIDAT_0 not matching

    Hi, This may not be an error as much as a question as the internal workings of Sage X3. I've been setting up reports for our Sales department, but they weren't lining up wtih our Actuals. I realized that I was utilizing SORDER.SHIDAT_0 instead of SDELIVERYD…
  • Calculate week number?

    Has anyone calculated the week number from a date field? We're version 8.2.5.27
  • Date/Time fields, User Preferences and SOAP Web Services

    In this example, I want to explore how Sage CRM's SOAP web services interact with dates and times. The background for this article is the experience that a user may have within the main interface. As we can see in the image below this user has opted…
  • Setting or Updating Date Fields using a Table Level Script

    This little tip shows how you can use a Table Level Script to set a value for a field that is not displayed on the screen. In my example a customer needed to implement a business rule that when a user updates the company field 'Type' to be a Customer…
  • Working around Date/Time field issues in Web to Lead forms

    The feature 'Web to Lead' in Sage CRM enables you to create web pages for collecting lead information automatically. The process generates the HTML to define a web form page for entering lead details. This HTML page can be inserted into a corporate website…
  • Useful Date Functions

    Occasionally you will need to fetch a date from either the CRM database or perhaps from an external system that is then needs to be formatted so it looks like a CRM date. All users are able to set their date preferences. The are other articles that…
  • Add/Subtract Days to a Date and pass to a Record Object

    Dates can be a bit of a challenge. This article explains three points: how to convert a record's date field value into a JavaScript Date object. how to add/subtract days to a JavaScript Date object. how to pass a JavaScript Date object to a record…
  • Self Service Workarounds

    If you have been working with Self Service then you know that certain field entrytypes are not rendered in the same way in Self Service screens as they are in the main application extension ASP pages. These oddly behaving fields or entrytypes include…
  • Validation of Dates

    The validation of dates can be tricky. Partly this is due to JavaScript and partly down to the flexibility that Sage CRM provides in allowing dates to be presented. I have covered how default values dates can be controlled in the article: Populating…
  • Validating Time

    A way of validating time is possible by taking advantage of the way Date/Time fields are added into Sage CRM. For example if you add a new Date/Time field into the company table, e.g. comp_customersincedate there is a lot of additional functionality…
  • Populating Default Date Field Values

    This article has been updated. Create Script example Date/Time fields can can have their values set by using the DefaultType property. If DefaultType set to 6 then the field displays the Current Date/Time DefaultType = 6; If DefaultType set to 14…
  • Easy way of grabbing a user's date preferences

    In Sage CRM an individual user can set their own date preferences that control how CRM date and datetime fields are then displayed. This is done in the My CRM, Preferences tab screen. If you are trying to establish how a date calculation should be made…
  • Including Islamic Dates in Sage CRM

    This article has come about because of a question from a partner working on implementing Sage CRM where the customer would like dates shown according to the Hijri (Islamic) calendar. Please note that this posting can't be regarded as an authoritative…
  • Validating the Time field in a Date Time field

    Hi, I have a question about how to validate against the time field in the Date Time field. I have used a simply java script condition to eliminate any alphabetical characters from the date field but when trying to accomplish this on the time field…
  • Sage CRM 7.2: Set DefaultValue not update at the first time

    Hi, I'm doing calculation to find remaining day of the membership. Everything looks find except when I set 'DefaultValue', it was not updated at the first time. For instance, today date = 21 Feb and membership expiry date = 28 Feb so Days remaining…
  • WorkFlow not working

    Hi i am built workflow and the write the following code in summary .net page base .UseWorkflow = true ; base .AddWorkflowButtons( "Lease" ); but the workflow buttons not appear and when try to see the workflowid in the custome entity table there…
  • Escalation .Net

    hi please how i can solve Escalation for .Net when select it please check the attached picture
  • Sage CRM SP2 Setup ?????????

    Hi all i try to install sage crm sp2 setup from the community like the figure attached but its give me sage crmsp2 hotfix 3
  • Sage 300 ERP New Order /New Quotes Error 500????

    Hi, i am install sage crm 7.1 SP2 and integrate it with Accpac 300 ERP 2012 Every thing is ok but i have problem when go to company and try to make new order or new Quotes the below error happen Please any idea to help ???
  • Document .Net API

    Hi i am create custome entity .net api and then i create tab "Document" and System Act: librarylist but it back for me all document when add new document and its go out entity how can i add document tab ??? thanks
  • Date\Time Field Validation

    I have a field (quot_needby) that is a date time field. I need to set it up so that it will not allow\validate the date so that it can be no earlier than 48 hours from the current time. Not sure how to go about this. Anyone have any thoughts?
  • (Solved) Sage CRM Date Picker not working

    Hi All, After a recent upgrade to SP2 the Date picker on one of our Terminal Servers stopped working. Tried clearing the cache, updating Java and rebooting the Terminal Server. The calendar appears and user are able to click around the calendar…