Generally we may come across a situation in Sage X3 to build a date from its constituent parts. gdat$ is the function to built a Date from its constituent parts i.e. small component part. Syntax:- gdat$( Day,Month,Year ) Parameters:- Day: Numerical integer expression for the value of the day. Month: Numerical integer expression for the value… Read More »
In Sage X3 while performing deferred deletion we may get the below error message.”Deferred deletion is not active for this object”. Navigate to: Development > Utilities > Miscellaneous > Deletions To avoid this message navigate to Development > Processing dictionary > Objects Checked the Deferred validation checkbox. Save and validate the object. Hope this blog… Read More »
In our earlier blog, we had discussed to change characteristics of lot. In this blog, we will see to change characteristics (dates information or user fields) of a lot in mass. Sage X3 has a separate screen to change characteristics of lot in mass. Navigate To: Inventory->Quality control->Lot Lot modifications->Lot mass change. Refer the below… Read More »
You may come across the situation, where you may want to give user-level access to fields present on Screen. In this case first create access code by navigating to below given path. Setup → users → access code Now assign this access code on required fields as shown below. Now this fields are accessible to… Read More »
You may come across a situation, where you want to run a particular process using code. You can use the run command for the same, Run allows you to execute a process. Syntax: Run prc_nam # Example: Execution of the “READ” process Run LECTURE The Run instruction executes a process. The process is searched for… Read More »
If you come across a scenario where you want to create a loan order and system is generating the below error after entering a loan customer on delivery address in sales order then. Go to Customer master. Common Data – BPS – Customers – Ship to Customer. Set Shipment Site and Loan location for the… Read More »
checkpath is a function that allows you to verify if a file path is in the white list of the engine and can be accessed. Syntax: checkpath(FILE_PATH,ACCESS_MODE) Parameters: FILE_PATH is the path of a file or a directory which accessibility must be checked. The files do not need to exist, the only check that is done… Read More »
In Sage X3, we may come across a scenario where you may need to set a particular dimension type as a default dimension for Sage X3 users. For example, we have created a new dimension type X and we want to set it as a default dimension type for users then we can easily do… Read More »
In Sage X3, we may come across a scenario where we may need to set a default destination for a particular report. Let’s assume that we have created a new report XYZ and by default, it’s getting printed in EXCEL format. But, we want to print the report in PDF format then we can easily… Read More »
Sage X3 provides a special function Writeb to write into a table. It works similar to Write function but it allows us to optimize the performances when several insertions of database lines must be done. Syntax: Writeb Writeb[CLASS] where, CLASS: a classidentifier that corresponds to the abbreviation used to open a database table. Writeb allows… Read More »
