Sage X3 – Tips, Tricks and Components
Go to Set up →General Parameters →Formulas Expand Automatic Journal If there folder is multi-legislation, one needs to define legislation wise formula – refer SEED folder In few cases one needs to even define Document type as per formula – Refer below Image Now one can run Accounting Interface without error.
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:
We may come across the situation, where we want to enable or disable NEW button in window. Sage X3 has a special function to enable or disable new button in window. To enable new button, use the below syntax. Syntax: Enable GSTACRE Parameter details: Enable: Enable is the function that is used to enable the… Read More »
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.
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 »
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. Finally click on ok, system will prompt below message if automatic scheduling has been said to YES, say Ok and continue.… 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 »