Category Archives: Sage ERP X3

Deferred Deletion in Sage ERP X3

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 »

Assigning user level access to fields present on Screen

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 »

How to verify the file path and its accessibility in Sage ERP X3

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 »

Set Default Destination for a Crystal Report in Sage X3

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 »

Optimize the Performances when several Insertions of Database Lines must be done

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 »

How to generate a Sequence Number manually

You may come across the situation where we have to generate a sequence number manually, consider the following example. Where sale order number is ALLSONAO0110005, we want next sales order number to be generated is ALLSONAO0110008 to do so we have to go to the sequence number values screen. Add the seq counter, give next… Read More »