In this blog, we’ll explore the step-by-step process of creating data models, linking tables, adding fields. Once the tables have been added and linked, fields can be added to the Data Model. Click on the to open the Fields. Right-click on the Field to access to these options: Fig. 1. Add column Note: Fields can… Read More »
In logistics and supply chain management, internal containers refer to the various types of packaging or storage units used to transport and store goods within a facility or during transportation. These containers can include pallets, boxes, packs, big bags, barrels, bins, and others. Assigning unique identifiers, such as license plate numbers, to these internal containers… Read More »
In Sage X3, the concept of “annual envelopes” refers to predefined budgets or allocations that are set aside for specific purposes within an organization, typically on an annual basis. These envelopes are often used to manage expenses, track spending, and allocate resources effectively across various departments or cost centers. The renewal of annual envelopes in… Read More »
In this blog, I’ll demonstrate how to allow X3 to access specific directories beyond its default folders. These external storages are useful places to keep documents. Below are the steps, simplified to the fullest extent. Step 1: You can find the directory at (…\runtime\cfg). Inside this directory, you’ll see a file named configRuntime. Before making… Read More »
In Sage X3, we may come across this error ‘The certificate chain was issued by an authority that is not trusted’’ while trying to configure Application in the console. This issue occurs when you upgrade runtime to any version 95.2.85 and greater. Cause: Solution: To solve powershell error, follow below steps: Uninstall-module -Name SQLServer -RequiredVersion… Read More »
Sage X3 offers functionality allowing the consolidation of multiple orders into a single delivery. If your business process requires limiting such entries to prevent confusion during invoice report printing, follow the steps below: While creating Order there exist an option of Invoicing Mode, with choices including 1/Order, 1/Shipment, and 1/Invoice. Choose the ‘1/Order’ option. Users… Read More »
Introduction When you look at raw data, it can be hard to understand what it all means because it’s just a bunch of numbers or information. It’s difficult to see patterns or trends when the data is in this simple form. One tool that helps with visualizing data is called conditional formatting. This tool makes… Read More »
Retrieving data from a single table for the Sage X3 dashboard is straightforward. However, if you require data from multiple tables or linked tables, attempting to add a field from those tables triggers an error message: “Standard Query ‘QUERY_CODE’: Links not possible.” In our recent blog post, we’ve provided a clear solution to address this… Read More »
Revision management for sales orders was implemented to enable users to track updates made on sales orders for both headers and lines using a revision number. This new feature gives full visibility to the updates made by users to a sales order. Revision management allows you to easily and quickly track updates made on the… Read More »
This function is used to record the customer returns following a delivery or a supplier return in the case of inter-site or inter-company transfers. Once the return is carried out, the stock will be moved if necessary and it will be possible to print a return note and if required to enter a credit memo… Read More »
