Category Archives: standard

How to assign the technical sheet for each operation of work order in Sage X3?

You may come across a situation where you want to attach the Technical sheet to every operation of work order? Sage x3 has standard feature where you can attach the technical sheet. Follow the below steps to attach the technical sheet entry Navigate: Manufacturing ->Planning->Work order->Operations tab In management tab attach the technical sheet.

How to add a string in a new Line in Sage X3?

We may come across a scenario where we want to display message in new line, X3 has a function to achieve this.”chr$” function converts a numerical value in an ascii character, syntax as below. Syntax: chr$( exp_ent ). “chr$” returns a character whose ascii code corresponds to the argument (if there is a corresponding ascii… Read More »

Use of “nomap” variable in Sage X3

As we all know that Sage X3 can have more than one folder/application. So the question is how we will get to know current folder/application name while accessing Sage X3 ERP. Here X3 provide special “nomap” variable, which complete your requirement. nomap is a variable that is only accessible in read mode and which determines… Read More »

Set-ups and Process flow for Multi-level MRP in Sage X3 V7

Pre requisites for Multi-Level MRP Processing are same as the planning or normal MRP (Refer blog on Set Ups and Flow on MRP Process), except you needs to Define Multi Level BOM and Routing. Now the Multi-Level Planning can be achieved either by going directly to Manufacturing→Planning→Multi Level Planning OR It can also be done… Read More »

How to validate alphanumeric date field in Sage X3?

There can be occasions when you want to accept date input in an alphanumeric field in grid. As, alphanumeric field does not have calendar control so you need to validate the entry section by writing our own code. Here we are describing how to achieve same via code. Below is the code we have written after… Read More »

Making Bank Payments using the ACH NACHA Bank files from Sage X3

Every company has to make a series of payments to its Suppliers / Vendors. Nowadays, payments made using ACH are preferred by maximum companies because it not only saves time and money but is also easier and quicker to make payments/get paid with increased security while preventing the possibility of frauds. Many of the Sage… Read More »

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 »