Tag Archives: Sage X3 technical blogs

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 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 Find the Number of Records in a Table?

Sage X3 has a solution which is used to find the number of records in a table with the help of keyword “nbrecord” along condition.  In order to know the number of records in the table, perform the below query. The output will be number of the clients available against the corresponding table.   About… Read More »

How to Create Contract Purchase Order in Sage X3?

A contract order is a long-term commitment with a supplier concerning one or more products, for a global quantity and value to be delivered. The contract order is further divided in shipment requests that are made as a function of the contract. A contract can also be intercompany or site transfer. These shipment requests are… Read More »

How to Increase the Address Lines for a Customer?

Sage X3 has a feature in which we can increase the address lines for a customer.  This feature can be achieved by following below steps:- Navigate to Set up → General parameters → Folders → SEED Under screens tab, there are various activity codes which are used for functional sizing of the screens. To increase… Read More »

How to Create a Stock Count in Sage X3?

Stock count is a process of counting inventory on a periodic basis throughout the year. This is a two-step process as explained below- A stock count session is generated to select the products and /or locations to be counted along with other parameters and selection criteria. A Count screen is used to check the count. To… Read More »

How to Setup commitments for a Particular Ledger?

If you come across a scenario where you want to setup automatic generation of commitments then Sage X3 provides a functionality “Commitments” in the Ledger. To set up this functionality: Step 1: Navigation: Set up – Organizational Structure – Ledger Step 2: Check the Commitments in the Type of accounting of ledger.   Now whenever… Read More »