# Tag Archives: decimal

## Component’s requirement quantity shows blank value in Work Order in Sage X3

In Sage X3, we have manufacturing module which eases the manufacturing process and present a solution to create one Manufacturing order for finished product and semi-finished product’s components are compiled automatically in the manufacturing process. In Sage X3, before creating the Work order of any finished product, we will require BOM (Bill of Material) of… Read More »

## How to calculate remainder using x3 mod function

You may come across the situation, where you having arithmetic operation with numbers. You may want to calculate the remainder of division. New Stuff: How to open Sage ERP X3 Code file in Eclipse Editor in Version7? Sage X3 has a special function to calculate the remainder of division. mod: This function calculates the remainder of… Read More »

## How to roundup decimal number to two decimal places

In a situation dealing with arithmetic operations, you may want to roundup the calculation result to up to two decimal places. Sage X3 has a special function to roundup a decimal number to two decimal places. ar2: This function roundups a decimal number to two decimal places. Syntax:  ar2(exp_num) Parameter details: exp_num: Decimal number that… Read More »

## How to Truncate numbers after decimal point

You may come across a situation where you have a numeric operation and you want to truncate the number of digits after the decimal point. Sage ERP X3 has a special feature for truncating the numbers with the help of “fix” keyword. The type of result is an Integer or Decimal depending on whether the… Read More »

## Control Max Decimals of Currency in Sage X3

It is quite often that we do some customizations related to financial data in X3, and almost most of the times it has something related to the Amount field. In case if we have a customization where we need to modify the decimal places used in the currency data i.e. we need to have only… Read More »