Tag Archives: Sage X3 technical blogs

How to automatically allocate the work order

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

How to assign the allocation and issue rules on product categories?

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 »

How to avoid clashing between local variable and table column name?

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 »

How to Check Whether the Given Directory/ Path Exists or Not

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 »

How to disallow user to unblock an order?

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 »

Rounding off Net Unit Price in Sales Order

In a Sales order, while dealing with pricing we may want to round off net price to the nearest decimal. Sage X3 provides a parameter where we can set whether we want to round off the price or not. SALRND parameter is helpful when the pricing value is in decimals. This parameter stipulates whether a… Read More »

Know all Sage X3 table details on the go from one screen

Sage X3 have the functionality in which we can get all the information of all the Sage X3 tables along with the size of tables in a database from one screen only. New Stuff: How to validate a customer while importing Navigate to:  Development > Utilities > Verification > Database > Table report Enter your folder… Read More »

How to apply a new License in Sage X3 V7

Copy the new license to the server system where Sage X3 is installed. There are 2 ways in which we can update the license in Sage X3 V7: New Stuff: How to set the company code max & min size in Sage ERP X3 To install (or update) a license from within the Sage X3… Read More »

Import / Export Template in Sage Enterprise management (formerly Sage X3)

Sage X3 provides the functionality of creating\updating the transactions using an Import/Export template. A few days back we came across a scenario in which we need to create WO using Import/Export template. After some findings, we found it easy to do the same. You just need to follow the below-mentioned steps for Importing and exporting… Read More »

Back-to-back-order or Drop Shipment Setup in Sage ERP X3

In day to day life often it is the case when a company has to look for the drop shipment feature and it becomes a necessity to have the drop shipment in our system. Before we proceed with this feature in Sage X3, let me explain you the Significance of Drop Shipment in brief; Delivery of… Read More »