Tag Archives: Sage X3 Technical assistance

How to enable/disable Statement Creation for Invoice in Sage X3?

We may come across the situation, where we want to enable/disable statement creation for particular invoice. Follow the below instructions to enable/Disable statement creation for invoice. Step1: Go to Setup–>Sales–>Invoices–>Invoices You will find the Invoice window and create a new invoice as shown below.   Step2: After creating invoice, click the Open items button in… Read More »

How to Get Parameter Value by User?

It is easy to get the parameter value when the value is defined at folder level. But what if we need the parameter value by User? Well! This blog will help you to get the parameter value by site with the help of the standard subprogram which is present in SUBAUS.src file. Below is the code… Read More »

How to Modify the Posting Date of Sage X3 Transactions?

Sage X3 provides a way to change the posting date of the transaction later after creation. Function: FUNIPTD (Posting date modification) Navigation: Inventory > Utilities > Valuation > Posting date modification Description: Function allow user to changes the posting date of the truncation created in Sage X3. Kindly refer to the below steps: Step 1:… Read More »

Restrict Sales Order for the Product which has a Life Start Date

If you come across a scenario where you want to restrict sales order for the product which has a service start date then Sage X3 provides a standard functionality “Product start-of-life date”. Product start-of-life date: it is not possible to enter sales orders for this product before its start-of-life date. To set up this functionality:… Read More »

Set Criteria for Sales Order Line Closing using Delivery Tolerance %

Sage X3 provides a feature to close a line of Sales order after partial shipment. User can set this criterion at Product level. The working of delivery tolerance % is illustrated below.                 To set the closing criteria go to Product > Sales tab. Define the value for “Delivery Tolerance %” which is used during… Read More »

How to Test Web Service in Sage X3 version 9

Manual Sage X3 web service testing method has been changed in Sage X3 V9. The ‘classic’ or ‘legacy’ method of web services no longer works in Sage X3 Product Update 9. Now user can directly test manual Sage X3 web service from Sage X3 screen. Please refer below steps for the same. Navigate: Administration—>Web Services—>Classic… Read More »

Verifying Duplication of Data in Sage x3

Sage X3 provides an inbuilt function to verify if there are any duplicate values in a series of variable or numeric expressions, alphanumeric expressions or dates. The function used for this purpose is UNI. If the series contain duplicate value(s), the UNI() will return the position of the duplicate value. If there are no duplicate… Read More »

Determine the Length of Data Type, Whose Internal Type is Alphanumeric

It’s Very obvious to declare the variables while developing any kind of application. These variables contains a value for particular field. While declaring this variable, we have to set the length of the variable. Two obvious way to set length and corresponding disadvantages: Check with the length of the field data type of that field.… Read More »

Determine PO line Closing Method using Delivery Tolerance %

You may come across a scenario where we want to set closing criteria for a purchase order taking into account the quantity that you receive. To set the closing criteria, go to Product → supply tab → purchasing. There is a field “Delivery Tolerance %” which is used during the receipt of goods. It is… Read More »

How to add Levels in Graphical Requester in Sage X3?

Sage X3 has a special in-built feature to add levels in graphical requester. Follow the below instructions to add levels to graphical requester. Step1: Go to Setup –>Usage –>Reports –>Graphical requester You will find the Graphical requester screen and create a record as shown below, In the below screen, we have added the “SORDER” and… Read More »