Tag Archives: Sage X3 Technical

How to execute a .bat file from Sage X3

You may come across the situation where you need to call a bat file from Sage X3. Consider the following example: – where you need to copy the GTM file with .txt extension to the test folder with some different file name, to do so write your command line code in a file and save… Read More: How to execute a .bat file from Sage X3 »

How to Close Open Table faster in Version 7 and above?

Sage X3 version 7 has a new Keyword/ function “LogicClose” which closes the open table/file faster than the close instruction of Sage ERP X3 which we used earlier in programming. LogicClose: This function closes a table logically. It releases the [F] buffer and any filters in a way that makes a further Local File execution much faster… Read More: How to Close Open Table faster in Version 7 and… »

Setup Multiple Sites for Company when there is One Dedicated Storage Site and Rest are Financial Sites Part- 2 (Contd…)

In some industries where the Company has only one Site which actually store and deliver goods and other sites are only financial sites which manage the payments. i.e the financial sites can be stores and the Storage site is a warehouse where goods are stored. E.g. Car showrooms can be financial sites in different part… Read More: Setup Multiple Sites for Company when there is One Dedicated… »

Mass Deletion of Records in Sage X3

If we want to delete the current record in Sage X3, simply press the Delete button. This deletion is possible only if the “referential integrity” constraints as defined in the data dictionary, are adhered to, depending on the situation. These controls can take a relatively long time to perform, and they are carried out immediately… Read More: Mass Deletion of Records in Sage X3 »

Find a particular value from a series of Numerical, Alphanumerical or Date Expressions or Variables

We may have come across a situation where you need to find a particular value from a series of numerical, alphanumerical or date expressions or variables. This can be achieved using “find”. Syntax: find(value_to_seek, list_exprg) value_to_seek is the value that needs to be found list_exprg is the series of numerical/alphanumerical/date expressions/variables Example: Consider an example… Read More: Find a particular value from a series of Numerical, Alphanumerical… »

Setup multiple sites for company when there is one dedicated Storage Site and rest are Financial Sites PART-1

In some industries where the Company has only one Site which actually stores and deliver goods and other sites are only financial sites which manage the payments. i.e. the financial sites can be stores and the Storage site is a warehouse where goods are stored. E.g. Car showrooms can be financial sites in different part… Read More: Setup multiple sites for company when there is one dedicated… »

How to copy all field values from one screen to another screen

We have a scenario where we need to copy all the values from screen one to screen two for display. To execute this functionality we have two option as follow: [M:xxx]=[M:yyy] Transmask[M:xxx] to [M:yyy] In this blog we will be detailising on Transmask where it copies the all the field from source mask to destination… Read More: How to copy all field values from one screen to… »

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: Assigning user level access to fields present on Screen »

Delivery address Set up for Loan Customer

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: Delivery address Set up for Loan Customer »

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: How to verify the file path and its accessibility in… »