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...

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...

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 rece...