Tag Archives: Sage X3 Technical

How to Sort Array in Ascending and Descending Order

Sorta-is used to sort arrays of single-dimensioned variables. Sorta, sorts the array in ascending order by default, to sort the array in descending we need to use Desc keyword. Syntax – Where, Sorta – Number Array List Number – number is length of an array or up to which number we want to sort Array… Read More »

Mass Generation of Purchase Order

You may come across a situation where you want to create Purchase order for many suppliers and products. Sage X3 provides a feature in which mass generation of Purchase Order can be done at once. To achieve this functionality, navigate to Purchasing → Orders → Buyers plan. Follow the below steps:- STEP 1 – STEP 2 –… Read More »

How to allow Manual Generation of Transaction ID for Sales Order?

In Sage X3, we may come across a scenario where we want to allow manual generation of transaction Id for sales order then Sage X3 provides a standard functionality Manual sequence no. Set Manual sequence no to “Yes” in sales order types for which manual generation of transaction Id should be allowed. Set up –… Read More »

How to Disable the Post Button in Invoice for the Particular User?

Sage X3 provide feature to disable the post button for the particular user. To successfully bring this functionality follow below steps. Step 1: Go to the Functional profile Step 2: Navigate to: Setup>Users>Functional profile Step 3: Remove the BPSVAL function of the profile code for which particular user is linked. Hope this helps. About Us… Read More »

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 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 Update Database Mass using “Update transaction” Utility

We may come across a scenario where we want to replace the old value of field with new one, In that case Sage X3 has the Utility through which user can achieve this feature. For Example: If User wants to update the package field of all the products from old value “C01” to new value… 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 »