Ir al contenido principal

Column Formatting in Sage X3

In this post for Sage X3 (now called Sage Enterprise Management) users, we will illustrate how you can add formatting rules to columns defined in the Columns section of a worksheet view in the SEI (Sage Enterprise Intelligence) business intelligence (BI) tool. For example, a rule can be defined to highlight margins above a certain amount in a different color and conversely, a rule can be defined to highlight margins below a predefined amount in a different color.
To format a column, right click on the desired field in the Column section of the worksheet view and from the context menu select Column Formatting.
Sage X3
The Column Formatting window will display to define or maintain formatting rules.
To add or define a new rule click the New Rule Sage X3 button
Sage X3
  • The rule edit window will appear where conditions on formatting the field/value in the worksheet view are defined.
    • Dependent Column defines the column which the rule or condition is based.
    • Compare with identifies what the Dependent Column field is compared with. Choices are Constant, Global Variable or Column.
    • Value Condition is the test. Choices are Containing, Equal to, Not containing, Beginning with, Is Null, and Ending with.  The box to the left of Value Condition is where the “with” value is maintained.  The “with” value file will change depending on the Compare with value selected above.
    • Level of rule applied allows the user to select the level where the formatting will be applied,
      • Everywhere: Will be applied to all the levels of the grid.
      • Last Level Only: Will be applied to the last level only (white rows).
      • This Group Only: Will be applied to the specific selected group.
      • Not This Group: Will be applied to all the groups except the one selected.
      • This Group and Lower Level: Will be applied to the specific group and all the subsequent groups selected after the grouping area.
      • This Group and Higher Level: Will be applied to the specific group and all the subsequent groups selected before the grouping area
    • Font Style: Chose from Regular, Italic, Bold and Bold Italic
    • Icon: Choose an optional icon from the following categories directional, emoji, flags, miscellaneous, and shapes
    • Color: Select font color
    • Background Color: Select cell background color
    • Background Option: Choose if the background color is to be applied on the full cell or only partially, based on the cell value or on the percentage that the cell is to the parent value.
 Sage X3
  • To maintain a rule, click the Maintain Rule Sage X3 button.
  • To delete a rule, click the Delete Rule Sage X3 button.
  • User the up and down Sage X3 Sage X3 arrows to change the order in which the rules are applied.
Sage X3
Sage X3
Total Row Formatting
By default, column totals appear at the top of the worksheet view before any content.  If you prefer to display totals at the bottom of the worksheet view, there is a worksheet property that will allow you to change the position.
Sage X3
  • Settings
    • Click the Wrench to open Worksheet Properties
  • Worksheet Properties
    • Click on Total Row to open properties
Sage X3
  • Total Row
    • Click the Top/Bottom button to switch positions
    • You can also change the Font and Background Color as well as add Label Text
Sage X3
Sage X3

Entradas populares de este blog

Valores de fstat

Fstat fstat  is a numeric status that is returned upon execution of a database operation, a sequential file operation, or a lock instruction. Syntax fstat Examples # MYTABLE is a table with a key called KEY1, that has a unique component called KEYVAL # Create a record in the table MYTABLE with they key value 1 if it doesn't exist Local File MYTABLE [MYT] Read [MYT]KEY1=1 If fstat [MYT]KEYVAL=1 : Write [MYT] If fstat MSG="The key was created in the mean time" Else MSG="Key created" Endif Else MSG="Key already exists" Endif Details fstat  is always set to '0' if the operation is successfully completed, and has a non-null value if there is an error: In a sequential read ( Getseq  and  Rdseq ),  fstat  is set to '1' at the end of the file. On  Lock ,  fstat  is set to '1' if the lock could not be performed. For a database operation ( Read ,  Look ,  Readlock ,  For ,  Write ,  ...
Leer más

How to create an additional line text (ACLOB) on purchase orders for internal notes

Sin conexión Kyle Klinger hace 1 día Origen:  https://www.sagecity.com/support_communities/sage_erp_x3/f/sage-x3-general-discussion-forum/143870/how-to-create-an-additional-line-text-aclob-on-purchase-orders-for-internal-notes I was trying to add internal notes to the purchase orders at a line level and was thought I would share a how to.  If you have a better way, please share.     Add column to PORDERQ; YLINTEX2, Type TXC   Save and validate table This is where the ID of the text will be stored at the record level, i.e. POQ~00000007, this is similar to field LINTEX  On screen POH2 Add column YLINTEX2, to Block 1. Most likely you will want this field to be hidden. On column NBLIG add a button action ACLOB2, description "Text internal" This button action will require an action parameter "CODE2", it will not be available until after save. Set the parameter "CODE2" to [M:POH2]YLINTEX2(nolign-2), the field that was just added....
Leer más

3 ways to send a mail from code in Sage X3, with more attachments too

Origen Fuente:  https://en.sagedev.it/sagex3/send-mail-from-code-with-attachments-sage-x3/ Autor:  https://en.sagedev.it/category/sagex3/ In this post I’ll show you how to send a mail from adonix code in Sage X3. The points we will face are: 1) Meladx/Send introduction 2) Sending  through  meladx (the best way for me: at the end with just a single code line you send a mail!) 3) Sending  through  Workflow 4) Sending  through  ENVOI_MAIL(…) From AWRKMEL Sending mail from code in Sage X3: Send vs meladx Sage X3 has two native ways for sending mails. The first way is  meladx  executable file, that you can find in  runtime\bin  directory. The seconde one is Send instruction, that was used to send mail through an application of the client station (for more information on “Send GSERMES”  go here ). The Meladx executable Meladx send messages through SMTP/POP3 protocols by means of the mail  ...
Leer más