Category Archives: Sage ERP X3

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 »

Set ups and Process of MRP /MPS in Sage X3 V7

Prerequisites are as it is- Go to Product Category or Product Site and do the following setups as per the requirements. Set Reorder Mode to “by MRP” or MPS based on requirement whether it is Manufacturing against SO or if it is being manufactured for stocking purpose. Reorder policy to “BNT” or whichever is suitable… 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 »

How to restrict user from creating receipt greater than PO quantity in Sage X3?

We came across a scenario where you want to restrict user from creating receipt greater than the PO quantity then Sage X3 provides standard functionality and allow over receipts. To set up this functionality: Step 1: Navigation: Set up – General Parameter’s – Purchase – Rest management Step 2: Set Allow over receipts as ‘NO’.… Read More »

How to restrict automatic closing of PO’s in Sage X3?

If you come across a scenario where you want to restrict automatic closing of PO’s in Sage X3.Here is a standard functionality for PO line closing method. To set up this functionality: Step 1: Navigation: Set up – General Parameter’s – Purchase – Rest Management. Step 2: Set Rest management to ‘Never’. Now even if… Read More »

How to do Prepayment with Tax in Sage X3?

Have you ever come across a circumstances in Sage X3 where you would like to  do prepayment with tax .Sage X3 has a feature where you can  do the prepayment with tax. To successfully bring this functionality follow below steps. Navigate to: Development>Activity codes>TPT activity code Select TPT activity code. Remove the check mark from… Read More »

How to do a case sensitive string comparison in Sage X3?

There can be a situation when we want to accept string in some text field by end user and want to check its existence in Sage X3 database ignoring case sensitivity. The toupper or tolower functions are very useful to perform this function. toupper is used to transform all the lower case letters of a… Read More »

How to change the state of any transaction using code in Sage X3?

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 »

How to assign an Icon to Customized module in Sage X3 V7

Sage X3 V7 have a new feature where we can assign an icon to any of the module. We have created a customized module ‘Test’ and assigned an Icon to it. Please refer below screenshot. To assign the module icon we need to follow following steps: Your icon image should be in ‘.png’ format. Icon… Read More »