There might be a scenario where user needs to change the state of any transaction. For example, user wants to alter transaction mode from “Modification” to “Create”. To accomplish this task Sage X3 have a simple variable “REP” which stores the transaction status and can be used to for this task. In below code snippet,… Read More »
You may come across the situation, where you may want to filter the production selection by descriptions. That is user will enter part of a product or product descriptions in product field and on tab out system will display only matching product in the selection list. The standard ITS product-site object being used for product… Read More »
You may come across a situation where you want to append leading Zeros to a number but don’t know how to achieve it. This can be handle with the help of the “format$” keyword which will append the leading Zeros to the number. Format$ : Dim is used to format the expression based on particular… Read More »
Sage X3 has a feature in which you can assign Delivery type to an Order type. This feature can be achieved by following below steps:- Navigate to Set up -> Sales -> Document types → Delivery types. Create as many types of deliveries as you want as shown in the below screen. Now go to… Read More »
Sage X3 has function where you can set the aggregate criteria of journal. Navigate to: Setup>Stock>Accounting Interface parameters If all the criteria are equal, one journal entry is created with as many lines as necessary. These lines can be aggregated by account, nature, tax code, entry title by using the automatic journal. For example: If… Read More »
Sage X3 has a feature where we can automatically allocate automated work order generated from sales order at the time of creation. To successfully implement this functionality follow below steps: Navigate to: Setup>Manufacturing>Entry transactions>Work orders>AUT (Automatic generation) Select AUT Automatic transaction. Select Automatic global () or Automatic Click on save Click on Validation button
You may come across a scenario where you want to set the allocation and issue rules on product categories. Sage X3 has standard feature where you can set the allocation rule. Create the allocation and issue rules on below path. Navigate: Setup>Stock>Allocation and issue rules Assign the above created allocation rule on product category. Now… Read More »
In Sage X3, we may come across the situation where we may be having some variable name declared in the code file and the same variable in table. Sage X3 has special keyword to make differentiation between local variable and the table variable as there can be same name used while declaring the local variable… Read More »
In Sage X3, we may come across a situation where we need to know whether the path or a particular directory exists or not. We can know this using following function: Syntax: filinfo(path_fil, arg_ent) Parameters: path_fil: Char type expression for the file path to be tested Arg_ent: Integer expression specifying the property to be found.… Read More »
Sage X3 has a parameter which can be used to disallow a particular user with the rights to unlock an order which has been put on hold manually or whose credit status is blocked. To disable a particular user to unblock sales order, please follow the following steps: Step 1: Go to Setup >General Parameters>Parameter values… Read More »
