To manually select a sales order or delivery type every time you enter data into your system. It can be a tedious task, especially when you have a long list to choose from. However, there’s a solution that can save you time and improve your efficiency. By setting up a preferred default for your sales… Read More »
In the last blog, we learned how to make global scripts. This blog will teach us how to make and use parameters. Parameters: The “Parameters” option shows all the parameters that are set up and can be used from the global scripts. Steps To create a new script parameter: In the upper left hand corner,… Read More »
In Sage ERP X3, the software offers flexibility in representing dates, allowing users to customize the date format to align with specific requirements. To determine the current date format being used in the application, you can use the Adonix calculator by pressing Ctrl+Alt+K on any X3 screen and entering ‘GFMD’ click on Ok from that… Read More »
As we know, Sage X3 provides the functionality of creating\updating the transactions using an Import/Export template. The export function in X3 is used to extract data from the database to ASCII type file (with fixed length or variable with separators), whose structure is described by an import/export template. Export functionality is basically used to fetch the… Read More »
In Sage X3 sometimes user want to keep or download the reports which are generated via crystal reports on the specified server path rather than printing the many more report in the preview mode or on the client work station. On the client workstation, the system will get hang if there are more than 50… Read More »
If you need to retrieve data based on a more complex query than just selecting the field from a single table, you will need this feature. The SQL Query can be as much complicated as the database provider can support. This means that you could join tables, do summarization and grouping without any issues. Follow… Read More »
Crystal Report, a powerful reporting tool allows users to create both portrait and landscape report. It provides the flexibility to design and customize reports based on the specific needs of the data being presented. Portrait Reports – In a portrait oriented report, the height of the page is greater than its width. Portrait reports are… Read More »
In the Sage X3 application, one of our clients is facing difficulties in storing strings of 250+ characters in Sage X3 tables. The standard for alphanumeric datatype in Sage X3 tables support only a length of 250 characters, and our client wanted to store strings exceeding this limit. To solve this problem, we discovered and… Read More »
Sage X3 allow users to retrieve and view consolidated records of transactions through various filters and parameters. Sage X3 is designed to offer flexibility and ease of use when it comes to accessing and analyzing data. Sage X3 provides dedicated inquiry screens for each module (Sales, Purchasing, Finance, etc.).These screens allow users to view, filter,… Read More »
In Sage X3, we can create Purchase Invoice transaction against Purchase Order as well as Purchase Receipt with any quantity and amount. But one of our client requested to add limit on the amount while creating Purchase Invoice against Purchase Order only. Customization Required: Invoice can be booked only against PO. Unless amount is lesser… Read More »