Category Archives: Sage ERP X3

ERP Has The Answer To Everything

ERP or Enterprise Resource Planning solutions can help bring all your departments & employees on one single platform which can help optimize, reduce redundancy, remove re-work and manual errors by a major difference due to all being able to do their part of the work in a systematic and proper approved workflows. These workflows are… Read More »

Write line level field values in a single line through a table with the values in fixed number of fields during file creation

Sometimes while creating/writing to a file we might need to write values from a field in a grid but through a table and not by looping through the grid and the values would be written sequentially in a fixed number of fields in a single line in the file and assigning blank values to the… Read More »

How to enable Group pricing in Sage Enterprise Management

You may come across the situation where you need to use grouped pricing in Sage Enterprise Management. Navigate to → Setup → General parameters → Values → VEN Set the Value of ‘Group price management’ as ‘Yes’. Now the Price list type Grouped will be used for sales transactions. Hope this helps. About Us Greytrix… Read More »

How to print any report on the click of “Create” button for any transaction

You may come across the situation where you have printed the report while creation of any transaction. Consider an example for the same i.e we need to print the report “BONCDE2” while creating a purchase order to do so we have to go to the entry transaction of the purchase order and check Auto Print… Read More »

How to display data in the Traceability screen

In Sage Enterprise Management (Sage X3), we may come across a scenario where we have lot managed product and everything but not we get blank data in the traceability screen. This functionality can be achieved by the following steps:  Navigate to:  Common Data → Products → products → Controls tab For displaying product in the… Read More »

How to link Menu Item to Excel | Sage Enterprise Management

We have come across the requirement where excel data needs to be refreshed on the basis of Sage X3 data. This can be achieved with the below steps. We will need Sage addin available in the Microsoft Excel, this addin will link the data with Sage X3 database. If you will have Sage Addin available, this… Read More »

Entry point to update fields in additional line created during sales transaction in Sage Enterprise Management

This entry point is used during the automatic generation of a sales document line (quote, order, shipment, invoice) coming from a BOM breakdown or the generation of a free item from the price list search (normal or grouped). It is located at the end of the generation of the line and is used to insert… Read More »

Entry point to intervene in grouped price lists | Sage Enterprise Management

In Sage Enterprise Management, there may be a requirement where you want to update the price coming from grouped price lists. ‘RECHGROUP’ entry point is used to intervene in the three types of modifications carried out by the grouped price lists. Line modifications: The value 1 in the variable [M] GRPFLG (line no.) signifies that… Read More »

How to set the User as Employee in Sage Enterprise Management

In Sage Enterprise Management, there may be a requirement where you need to set the user as an employee. In this blog, we set the Sage X3 user as Employee. Follow the below steps to set up. Navigate To: Set up > User > Users > Parameters Set the “AUSHDKA” After-sales emplyoee equal to “Yes”.… Read More »

Reading Values from a csv file using a Separator

To read values from a csv file using a separator and writing the required values in a new file, follow the below steps- Open the directory where the csv file is located Specify the separator(e.g. “;”) and new line(e.g. “chr$(10)”) Read the values from a file Store the required values in variables Close the directory,… Read More »