This Syracuse Server fixes EU VAT ID Validation (Relevant message is now displayed after the revalidation).
SyracuseServer 12.18.13.2 is available in portal my.sage.pt:
We are in the process of upgrading V12 Patch 18 data to Patch 33 and we are getting the error on screenshot below.
How can we resolve
Steps taken
- Brand new installation of V12 Patch 33 (New servers)
- Load V12 patch 18 folder
- On trying…
Bonjour à tous,
nous sommes en train de préparer la migration de nos bases de données actuellement sur SAGE 100 i7 vers SAGE 100c.
Sur une quinzaines de bases, seules 2 ont un soucis. Lorsque je fais un test de validation, ca tourne pendant des…
I need to validate an opportunity workflow rule based on the date the opportunity was created. For example the rule would only be valid if the creation date was before 03/10/2022.
Can anyone advise how/if this can be done?
Working on integration with my company's website, and I want to make sure that validation for SKU field is consistent.
By manually checking I've found that valid chars are A-Z a-z 0-9 !#$%&()_-./"'
But I would like to know exact rules. Thank you.
Are blocks missing from your screens all of a sudden? What is a block anyway? In this blog, I will review where to check you have areas(blocks) on entry screens that are suddenly not there. Let's jump right into this.
First, what are these blocks…
I got an error while choosing the endpoint of the imported folder v12.0.21 on the X3 version 12.0.26. "Create session error : The folder version is different from the version of the root folder." , As shown in the screenshot below :
Has anyone…
Due to different screen resolutions and window sizes the red arrow, that points to requrired fields that failed validation due to not being filled in, sometimes points to wrong fields when the row couldn't fit the arrow anymore.
I used this tutorial…
Hi.
I updated the order header view, adding a new field: allthing works correctly in Test environment!
For publish this upgrade into PRODUCTION evnvironment, I used "copy" operation, from TEST to PROD: it was successful.
When I tried to activate…
Validation errors on the IRP5/IT3a report indicate that there are incomplete/incorrect information on the payroll. These errors will not allow the IRP5 file to be created successfully.
We have highlighted known possible errors with their solutions to…
In a webservice you have to select a group for a parameter/value. What is the purpose of that?
Why do i get the following message,
[err] Field ZBPCEMP not expected into group GRP0.
when in my webservice definition the field is in Group0! Also…
This article has been prompted by a question I was asked at a recent Developer training course in Johannesburg, South Africa. I wrote some time ago an article called " Field Level Scripting in Search Screens " that discussed scripting in search screens…
The Values() and FormValues() collections are serverside methods that are analogous to the ASP Request.Form() and Request.QueryString() collections. In an ASP page we can see the submitted values of the HTML form by examining the Request.Form() collection…
If you have explored this idea in Sage CRM you will probably have discovered that the peculiar structure of the phone and email screens means that the regular options for screen based rules are not open to us.
The phone number table is invisible in…
The diagram below contains the objects, methods and properties that are the main ones used in the internal COM API of Sage CRM. These objects can be used in field level scripts; Create and Validate and also in TableLevel scripts and Workflow JScript conditions…
The Values() collection can be used in all serverside scripts to examine the passed in Values from a form.
Create Scripts
Validate Scripts
Tablelevel Scripts
Workflow Scripts
The Values() collection must always have an argument passed to…
I was asked recently about how to create a log of when data was changed within a particular screen. Now the requirement was focussed on the screen and not on the the record. If we had been interested in whenever data in the record changed then of course…
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…
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…
The CurrentUser object can be used in all serverside code including Create Scripts, Validation scripts, Table Level scripts and Workflow javascript conditions. It provides information about the current user session. You can list the properties of the…
Below are some code examples showing how Business Rules can be implemented on Text fields using the onChange and Validation script options within a screen.
The examples shown are:
The field may only contain letters and numbers
The field may…
Imagine a system where you may want to ensure that your users do not create any new support cases for a company that has had their status changed to "On Hold". The ideas discussed here would also apply to any record created as a child of a company or…
I was just answering an email about how a consultant could create a business rule that ensures data entered by the user matches a particular pattern. The specific example was needed to confirm that the code entered into a text field was only numeric and…
Imagine the situation where there may be a problem with allowing users to search against a entity with out putting in at least one search criterion. You may find the searching against companies too slow if people do not put in the company name for example…
