Sage X3

Para las traducciones de COUNTRY: Ejemplos: func AFNC.TEXTRALAN("SPA","TABCOUNTRY","CRYDES",[F:ZBPR]CRY, "") func AFNC.TEXTRALAN("SPA","ATABDIV","LNGDES","6004", "22") Traducción de categorias: func AFNC.TEXTRALAN("SPA","ITMCATEG","TCLAXX",[M:ITM0]TCLCOD,"") Traducción de artículos: Call CHARGE_DEFITMDES("DES1AXX",GLANGUE,[F:ITM1]ITMREF,[M:SEA2]ITMDES1(nolign-1), "[F:ITM1]") From TRTX3

Origen fuente: http://online-help.sageerpx3.com/erp/wp-static-content/static-pages/en_US/v7dev/4gl_sql.html Autor: SAGE Commando SQL Sql  allows you to execute a  Select  statement in the database. Syntax For (VARIA_LIST) From DATAB_TYPE Sql SQL_STATEMENT As [CLASS] Next VARIA_LIST  is a list of  VARIA  separated by commas. VARIA  can contain one of the following syntaxes: DECLARATION   VARNAME DECLARATION   VARNAME  (  INDEX_SEP  ) DECLARATION  is a declaration keyword that can be  Char ,  Shortint ,  Integer ,  Date ,  TinyInt ,  Decimal ,  Clbfile ,  Blbfile ,  Datetime , or  Uuident . If  DECLARATION  is  Char ,  VARNAME  must be followed by  (N)  where  N  is the maximum size of the string, before a possible list of ( INDEX_SEP ). VARNAME  is a variable name starting with a letter, and followed by letters, digits, or underscores. INDEX_SEP  is a list of  DIMENSION  or  DIMENSION_RANGE  separated by commas. If 'N' commas are given, it describes an a

Autor: https://www.sagecity.com/members/regularguy Origen Artículo:  https://www.sagecity.com/support_communities/sage_erp_x3/b/sageerp_x3_product_support_blog/posts/creating-an-if-function-for-use-in-formula-wizard The company I work for is implementing the new Sage X3 PU11 and we are moving our customizations over, so I thought I'd take an opportunity to share a solution that we are moving from X3V6 to PU11. This solution will work for anyone with v6.5 through PU11. Occasionally, we’ve wanted to use some logic in our autojournals’ description field. This will produce journals with a specific bit of text in the description field to assist accounting managers with data aggregation, or provide additional info for our auditors. In my specific environment, I wanted to identify the document source for an invoice (usually a shipment) and if one doesn't exist I wanted to specify that one wasn't found. The formula wizard in X3 is great, but it lacks the abil