Browse By Tags

  • Data Type Conversion Errors in Explore - GL Transactions

    I was testing out the AP Module that we just acquired and posted a batch of vouchers. When attempting to run the GL Account Transactions task to view these posted transactions, I ran into two different errors: The varchar values it's referring to…

  • Data Type MD6 Rounding

    We have changed the MD6 data type to accommodate 6 decimals (11.6#). The field will accept the 6 decimals but when entering a Purchase Order however the price (GROPRI) rounds to 5 decimals when we save the order. (5.123456 saves as 5.123460) Any idea…

  • Unscheduled server restart error while VALDICO process after increasing the length of DES and AX3 data type.

    Hello All, I have increased the DES and AX3 data type length from Standard 30 Characters to 60 characters, but when I am performing dictionary validation, I am getting an error of Unscheduled Server Restart. I tried the same for other data types but…

  • Field Data Type AIN Issue

    Good morning I have added a field to SORDER, and then added that to SOH0. I am then receiving a heap error, but not sure what to do next. Anyone have any advice?

  • Increase the number of character in AX3 and DES data type

    Hello! It's possible to increase the number of characters in the data type AX3 and DES? We just have 30 characters, and the clients always need more than that. So the partners create a new field, or modify the std data type (this is not the best way…

  • The Workflow Rule Action - Run Stored Procedure

    The system administration guide discusses the workflow action 'run stored procedure'. This article expands on the information contained in the documentation. A workflow rule action of type 'run stored procedure' can be created very simply just like…

  • The Sage CRM StoredProc Data Type

    In the default system the StoredProc datatype is used to generate the reference id values for Case_referenceid Soln_referenceid When a new record is created, these columns invoke a call to the a Stored procedure called: eware_default_values.…

  • Getting the Database DataType for a field

    Occasionally you may be faced with a requirement to know what database datatype a field is before you start to work with it. This type of information is not held in the custom_edits table - only the Sage CRM entrytype is held there. These are all documented…

  • Why does N' appear in system generated SQL?

    You may have seen in the SQL logs that Sage CRM passes strings using an N prefix. This denotes that the subsequent string is in Unicode (the N actually stands for National language character set). Which means that you are passing an NCHAR, NVARCHAR or…

  • Selected Value of a New Data Types

    Hi, as you can read from the subject i created a new data type linked to a custom object(a simple one, just a table linked to him) that on selection show me a parameter, how can i change shown parameter in another field of the same table? I'm using…

  • Special Characters(,.?/"":;{}[]\-) Validation Required in Field level

    Hi Everyone, In X3 PU 6.5, I need to restrict the Account Number Field with special characters, where now its allowing to enter special characters like (-,.{}[]\>< etc..) with datatype A. Is there any possibilities to restrict the special characters…

  • How to enforce a field entry value to be exactly 5 digits?

    X3 PU 9.0.5 I'm trying to add a field to our GACCOUNT table and want the value to always be exactly five numbers when a user enters it (12345) If they enter less then 5 digits (1234), I want X3 to refuse to save the value. I don't want to pad the value…

*Community Hub is the new name for Sage City