Sage X3

While dealing with arithmetic operations, you may want to roundup the calculation result to the next nearest number. Sage X3 has a special function to achieve this. ARR : rounds a number to the next nearest number. ARR ( exp_num1, exp_num2 ) Parameter details:   exp_num1: Decimal number that will pass to “arr” function. exp_num2: if value ‘1’ is passed then it will round to the next nearest number. Kindly refer to the below screen shot. Hope this helps.

This Sage X3 “how to” guide will explain the simple process for customizing the left list of a function in  Sage X3 (Enterprise Management) . The information found in the left list is controlled by the object of a function.  To make adjustments to the content in the left list in Sage X3 use the Objects (GESAOC) function by following the path Setup > General parameters > Personalization > Objects.  This function can be used to add fields to the left list from the primary table associated with functions header table.  This guide will focus on the changing the quick select left list of a function. In the screenshots below we show the example of the Create Date field being added to the Product left list. Object Personalization Function To begin personalizing the left list follow the path Setup > General Parameters > Personalization > Objects. At the Object code field, enter the three-character object code. If you do not have the object code it is also possible t

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. The Column Formatting window will display to define or maintain formatting rules. To add or define a new rule click the New Rule   button 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 Depe

Subcontract orders are created to purchase one or more services from a supplier without having to set up and use the  Sage X3  Manufacturing module (now called Sage Enterprise Management). Subcontract orders also allow tracking of components that come from stock and sent to a supplier along with components or material provided by the supplier. In this post we will illustrate creating subcontract orders without a work order in Sage X3. Sage X3 Setup: Purchasing subcontract parameters – EOM (Subcontract order management) Purchasing subcontract parameters – ACC (Accounting Interface) Activate Activity code LST – Subcontract deliveries Supplier being sent the subcontract order will also need to be setup as a customer if components are being sent to the supplier.  This will facilitate subcontract shipments. Create subcontract Location type and Locations. Setup subcontract parameters on the Ship-to customer in Customers Subcontract receipts require a

Adding a field to Address Tab on Customers (GESBPC) Resolution You have to declare 2 fields in the screen BPABPC [BPAC] For exemple, we add ZTEST field as below : 1) In BPABPC screen , you have to declare 2 fields:  -  ZTEST in the block 1 with input "Hidden" -   XZTEST in the block 2 with input "Enter" For the field XZTEST, you have to manage an action SPE : "After Change"  with this code : Script SPEBPA : ################### $ACTION Case ACTION  When default Endcase Return Subprog AM_XZTEST(VALEUR) Variable Char    VALEUR() [M]ZTEST([M]XNUMLIG) = VALEUR [M]FLMOD([M]XNUMLIG) = 1 End ######################## 2) And you have to manage entry point "REMP_ADRBPA"  from TRTBPA like below : ######################## $ACTION   Case ACTION     When "REMP_ADRBPA" : Gosub REMP   Endcase Return #-------------------------------------------------- # For populate specific fields  [M]Xzone # from field  [M]

You may come across the situation where you would like to hide fields in screen on a particular condition. Sage X3 has a special feature in which you can hide or display fields in with the help of “Chgfmt” keyword. Chgfmt :  It is used to change the format of the mask field. It is also used to display or hide any fields. New Stuff:   Filtering the Selection List in Sage X3 without object Syntax: Chgfmt [class] field with expr_c Parameter details: class:  name of the mask field:  name of the field expr_c: expression to hide a field. Kindly refer to the below snippet of code for better understanding Pour cacher : Pour un champ numérique :  Chgfmt   [ M ] <champ>  With   "-N:15" .. Pour un champ alpha:  Chgfmt   [ M ] <champ>  With   "-K:15" . Pour afficher : +N +K Puis affzo