Tag Archives: Sage X3 Technical assistance

How to Increase the Number of Signature in the workflow?

In a workflow the number of signatures results into creation of same number of users, those users are authorized to approve the request. You get an option to assign number of signatures in: Navigate: Setup > Workflow > User rules of assignment In the above example 4 users are created and conditions can be defined… Read More »

How to Enable EU VAT no. field.

If we come across a scenario where we want to find EU VAT no. field of the companies’ disabled then Sage x3 provides a standard functionality to enable the field. Steps to enable this functionality: Navigation: Common Data – Common Table – Countries. Navigate to the respective country for which EU VAT no. field has… Read More »

How to Delete Element from an Array?

Dela – Dela is used to delete elements from single-sized arrays, from a given index. Dela deletes the given index element and adds blank value or zero to the end, we need to know the index to use Dela Syntax – Dela Start Array List where, Start : Index element  & Array list :  list… Read More »

How to Create Manual Transaction Number for Purchase Order and Purchase Receipt?

In Sage X3, we may come across a scenario where we want to create transactions with any ID of any choice. By default, every time we create a new transaction, Sage X3 itself generates the next sequence number and assign it to the newly created transaction. But, it is difficult to remember this auto generated… Read More »

How to Make Invoice Number Field Editable for any Invoice?

In Sage X3, we may come across a scenario where we want to create invoice with any ID/number of our choice. By default, every time we create a new transaction, Sage X3 itself generates the next sequence number and assigns it to the newly created invoice. To overcome this, kindly refer to the below steps… Read More »

How to Upload the JAR file in the JAVA Bridge Server

We use the external resource like JAR file to execute our certain functionality, for which we need to upload the JAR file in the JAVA Bridge server and then we can access the same with 4GL code. Below are the steps to upload the JAR file in JAVA Bridge Server. Login into the JAVA bridge… Read More »

How to Solve “expression too large” error in Sage X3

You may come across the scenario where you get an “expression too large” as below. This is may be due to number of expressions reached to its limit. The cause to the problem is as follow. Cause – Sage X3 has a limitation when number of code files increases. The error comes not because of… Read More »

How to Roundup Decimal Number to the next Nearest Number.

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… Read More »

How to Restrict the Users to Access Multiple Banks?

One of our clients’ came up with new requirement, where they wanted to allow only few banks access to the users. Sage X3 has functionality where you can restrict the users to access multiple banks. Follow the below steps Add the Row level permission. Navigate To: Set up >Users>Row Level Permission. Assign the Row level… Read More »

How to Know Number of Fields Defined in a Screen?

In Sage X3, if you come across a scenario where you want to know count of fields defined in a particular screen, Sage X3 provides an inbuilt function to know number of fields defined within a particular screen. You can use this function if and only if the screen is open. Syntax: masknbf(<class|num_exp>) Where, class… Read More »