Ir al contenido principal

Entradas

Mostrando entradas de junio, 2021

Redondear un número al alza

############################################################## #** #* 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

How to Install and Manage Sage X3 Add-Ins in Microsoft Office

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: Select Add-ins: If Sage X3 appears on the list

How to Copy Detail Lines in Sage X3

  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 fields without going for individual assi