Sage X3

ORIGEN DE LA FUENTE: AYUDA DE SAGE X3 https://online-help.sageerpx3.com/erp/12/ticket/how-to-delete-drop-a-folder-completely/?highlight=remove+folder Issue Summary This article describes how to completely delete or drop an X3 folder from an environment, including all disk, database and metadata elements. Details When a Folder needs to be deleted from an X3 instance it is necessary to make sure all elements are dropped or deleted: The folder record (and Endpoint) of course but also Database elements linked to that folder: Tables, views, schemas, users and logins. And, lastly, the disk directory (repository) containing the folder's files. Resolution Here is how to completely remove a Folder: 1. Delete the folder record from the X3 reference folder (Setup > General Parameters > Folders) 2. Go to the database administration tool (e.g. SQL Server Management Console, or even SQL+ or TOAD...) and delete the following elements from the your solution's database: All tables belongi...

  Creating a Function to Call a Requester in Sage X3 V7 and After By:  Net at Work Team   | Category:  ERP Fuente origen: https://www.netatwork.com/creating-a-function-to-call-a-requester-in-sage-x3-erp-v7-and-after/ Saving a few clicks to open something is a good opportunity to showcase the capabilities of a system like  Sage X3 , so when a client asked us to create a function to call a requester, we took on the challenge. After you create your requester in Sage X3, you can go to the set-up function where you built the requester and click ‘Run.’ You can also go to Reports > View queries, search for the appropriate query, and run it. To avoid searching for records or giving access to the view queries function, you can follow the steps below to create a function that will call a requester. The first step is to create a function in the development area. While it sounds complicated, it’s really very straightforward and requires very few pieces of informatio...

  The following subprogram launches the execution of a V6 batch request from V7 native code. Main principles of a V6 batch task A V6 batch task is associated with an X3 function that executes an action using the  Standard processing  template. A criteria window with associated masks is then defined. You need to provide all the required parameters for the batch task execution by filling in all the fields for these masks. For these reasons, calling the  ASYRMNGTREQ.CRERQT  subprogram requires you to define the mask fields by filling in the corresponding values. Subprogram definition The API is called with the corresponding funprog: Func ASYRMNGTREQ.CRERQT(ACTX,FOLD,USER,TASK,DAT,TIM,ARYPAR,ARYVAL,NBPAR,REQUEST,MESSAGE) The parameters are the following: *  ACTX  is the current context. *  FOLD  is the folder name. *  USER  is the user code for execution. *  TASK is the task name. *  DAT is the date of the requested execution,...

  Origen fuente: https://www.greytrix.com/blogs/sagex3/2011/12/20/how-to-display-wait-message-in-sage-erp-x3/ By  Greytrix   |   December 20, 2011 0 Comment Whenever we are executing any process in Sage X3, it becomes difficult for the user to understand the progress state, if the execution time lasts longer than usual. In such a case it is necessary that the user has an idea/ understanding of whether  the process is still ongoing or is completed. The status update information of a task is possible through either using progress bar or receiving wait messages, which will symbolize that the process is still in progress. Sage X3 provides a simple code which calls the wait messages easily. To display a wait message (Tempon) either assign a personalized text in the variable TIT, or choose a standard text by assigning a letter in the variable TIT. The default text is “Operation in Progress…”. Below is a list of common texts preceded by their code. V  validat...

  Fuente original: https://components365.rssing.com/chan-11443643/all_p21.html#c11443643a402?zx=813 July 28, 2016, 2:15 am :  Search RSSing for similar articles...  Next    How to Restrict the Users to Access Multiple Banks?  Previous    Get Year in a Date for Sage X3 version 7 In Sage X3, if you come across a scenario where you want to know count of fields defined in a particular screen, Sage X3 provides an inbuilt function to know number of fields defined within a particular screen. You can use this function if and only if the screen is open. Syntax: masknbf(<class|num_exp>) Where, class  – description of a screen num_exp  – numeric expression that describes a screen Refer the below screenshot for better understanding.  

############################################################## #** #* devuelve el valor correspondiente al coste oferta #* #* @param PS_NUM  > número #* @param PS_NDEC > número de decimales #*! Funprog REDONDEA_ALZA(PS_NUM,PS_NDEC) Value Decimal PS_NUM,PS_NDEC Local Char    LSTR(30) Local Decimal LPOT : LPOT = 1 Local Integer LCON   LSTR = format$("N:5."+num$(PS_NDEC),PS_NUM)   LSTR = ctrans(LSTR,",",".")   For LCON=1 To PS_NDEC     LPOT = LPOT * 0.1   Next End val(LSTR) + LPOT

When you enable an add-in, it adds custom commands and new features to Microsoft Office programs that help increase your productivity. In this blog post, we’ll review how to install the Sage X3 Add-In for MS Excel and what to do if your Sage X3 Add-In is missing. Fuente original: https://www.netatwork.com/how-to-install-and-manage-sage-x3-add-ins-in-ms-office/ How to Install the Sage X3 Add-In in Microsoft Excel Go to Administration > Utilities > Installation > Install addins for Office V11 Image:   V12 Image:   It should begin downloading the exe, open the exe Next > Install   Open Excel > File > Options   Select Add–Ins > Manage: COM Add-ins > Go   Check the “Excel AddIn for Sage” > Ok   You are now ready to export Excel-based reports/grids from Sage X3. How to troubleshoot and fix a missing Sage X3 add-in in Microsoft Excel Open the Microsoft Office product where the  Sage X3  add-in is missing. Go to Options: Se...

  Origen: https://www.greytrix.com/blogs/sagex3/2011/10/27/how-to-copy-detail-lines-in-sage-erp-x3/ By  Greytrix   |   October 27, 2011 0 Comment Consider a scenario where you have created a utility in Sage X3 and you need to create a GL Journal entry, based on the field inputs within the X3 custom screen. Now to achieve this, the option is to map all the custom screen fields with the Sage X3 Journal fields so that all the custom screen fields populate the detail lines in Journal. We can populate the Journal fields by assigning the Custom screen field with the Journal fields using the assignment statement for each field individually as listed below: [M:TARGETSCREEN]FIELD1 =  [M:SOURCESCREEN]FIELD1 [M:TARGETSCREEN]FIELD2 =  [M:SOURCESCREEN]FIELD2 [M:TARGETSCREEN]FIELD3 =  [M:SOURCESCREEN]FIELD3 And so on…… However, this surely becomes cumbersome if there are many fields within the table. While checking for another quick solution which can map the f...

Origen: Sage X3 https://online-help.sageerpx3.com/erp/12/technical-online-help/ El siguiente subprograma lanza la ejecución de una solicitud por lotes V6 desde el código nativo V7. Principios principales de una tarea por lotes V6 Una tarea por lotes V6 está asociada con una función X3 que ejecuta una acción utilizando la  plantilla de  procesamiento estándar  .  A continuación, se define una ventana de criterios con máscaras asociadas.  Debe proporcionar todos los parámetros necesarios para la ejecución de la tarea por lotes completando todos los campos de estas máscaras. Por estas razones, llamar al  ASYRMNGTREQ.CRERQT subprograma requiere que defina los campos de máscara completando los valores correspondientes. Definición de subprograma La API se llama con el funprog correspondiente: Func ASYRMNGTREQ.CRERQT(ACTX,FOLD,USER,TASK,DAT,TIM,ARYPAR,ARYVAL,NBPAR,REQUEST,MESSAGE) Los parámetros son los siguientes: *  ACTX es el contexto actual. *  ...

 Fuente origen: http://sagex3asia.blogspot.com/2017/04/sage-x3-add-new-left-list-browser-to.html Autor: https://www.blogger.com/profile/15857213250701606716 Puede ser útil para algunos ejecutivos de ventas poder ver las cantidades de productos disponibles antes de realizar un pedido para sus clientes en la pantalla Pedido de venta.  Puede hacerlo agregando un nuevo navegador de lista izquierda (objeto) en la pantalla de orden de venta, el ejecutivo de ventas siempre puede consultar este navegador antes de crear una nueva base de orden de venta en las cantidades disponibles para el producto en cada sitio del producto. Para lograr esto, primero, debe crear un nuevo objeto vinculando la tabla a la tabla 'Total del sitio del producto' de ITMMVT. Agregue los campos que desea mostrar en el navegador de la lista de la izquierda.  Puede agregar los campos en la pestaña Selección de otra tabla como ITMMASTER e ITMMVT. Vinculando la tabla entre ITMMVT con ITMMASTER en la ...

Origen: https://www.greytrix.com/blogs/sagex3/2013/05/02/how-to-check-active-activity-code/ By  Greytrix   |   May 2, 2013 0 Comment In Sage X3 we do many customizations and for each customization, we assign a unique activation code. The problem arrives when we write the code for different customization in single processing file and we have to deactivate one of the customizations. In that case, we need to look for a hook which will restrict the processing of the code related to a particular specific customization. To overcome the above problem X3 provides the feature of the Global variable to deactivate the Activity Code. To achieve this we need to do the following changes. Navigate through Development->Data and Parameters->Development setup->Global variable Create a new global variable that you want to use for the activity Code (refer below screenshot) and enter the formula for the activity code as: func AFNC.ACTIV(“ACTCODE”)      (where...

 Fuente de datos:  https://www.greytrix.com/blogs/sagex3/2020/07/27/how-to-call-an-api-through-postman-tool-and-map-with-x3-fields/ By  Greytrix   |   July 27, 2020 0 Comment We come across the scenario, where we will use POSTMAN software tool  to examine the working of external API. Postman is a simple GUI for sending HTTP requests and viewing responses. REST services are available in sage x3 that returns data in a JSON format. In this blog, we are going to visualize the mapping of fields from postman to x3 Rest web services. Example : In Postman IDE, 1.HTTP Request  — Request is the simplest way possible to make http calls. HTTP Request contains of Request Method, Request URL, Authorization, Request Header, Request Body. a. Request Method: Request method defines the type of request to be made. There are mainly four request methods, used for creating/updating, retrieving and deleting data. POST Request     — For Creating ...