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 »
Locales in Sage X3 are specific language or regional settings that are used to modify the software to fit various languages or geographical regions. Language preferences, date formats, currency symbols, and other regional requirements are examples of these settings. For multinational or multilingual organizations, setting up locales is essential because it guarantees that users from… Read More »
In Sage X3, the creation of a miscellaneous receipt typically occurs for various reasons, and these receipts are used to record non-standard financial transactions or receipts that do not fit into the standard sales or purchase order processes. When you encounter an issue with an “Already Occupied Single-Product Location” it means that the system is… Read More »
