How to give space between string by coding You may come across a scenario were you need to provide the space between string.X3 has a function “space$(n)” which returns a string with n spaces, Syntax as below. Syntax: space$(nb_esp) space$(nb_esp) returns a string comprising nb_esp spaces(ascii code 32). This function is thus equivalent to string$(nb_esp,… Read More »
We may come across a situation, where we need to calculate a factorial of any integer. Sage X3 provides built-in function ‘fac’ to calculate the same. Fac: It calculates a factorial of any integer value. Syntax: fac(integer) To better understand this, refer the below snippet of code:
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
