On-Line Analytical Processing (OLAP) is a kind of software that allows users to access and analyse business data stored in several, and sometimes extremely large, data bases. The definition and setup of OLAP data are multidimensional, which means the information may be compared in a variety of ways. Data cubes and data warehousing are two… Read More »
A product is any item or service you sell to serve a customer’s need or want. A product can be physical or virtual. Physical products include durable goods (such as cars, furniture, and computers) and nondurable goods. In Sage X3 we can define or assign product-site for one particular product from product-sites screen or from… Read More »
Sage Enterprise Intelligence is an intuitive business intelligence solution integrated with the Sage business management system that helps business users spend less time analyzing and reporting, making faster, more informed decisions. It provides all users with a simple solution for self-sufficient access and analysis of data, eliminating the need for disparate tools and expertise and… Read More »
MRP (Material requirements planning) is a production planning, scheduling and inventory control system used to manage manufacturing processes. We may follow below steps to make Purchase Suggestions in Sage X3. MRP setup on Product. Sales Order. MRP Processing. Enterprise planning. Step1: MRP setup on products: Navigate to : Common Data -> Products -> product site… Read More »
Sage X3 has provided the developers with an extensive feature called as Miscellaneous Tables. Miscellaneous Tables are logical tables to store codes/ List of Values for e.g. Rules, Terms, Payment Methods, etc., it comes handy whenever we need to provide users with options/ dropdowns to have strict data integrity. There are 2 types of the… Read More »
In one of our last Blog, we had seen the use of Calculator in Sage X3. Going further, we will now throw more light on the use and functionality of the same. To use the sigma formula, firstly we can open the calculator by pressing “Alt+Ctrl+k”. also you can open the calculator by selecting the calculator option… Read More »
In Sage X3, we recently faced an issue while processing a purchase order/Miscellaneous Receipt, “Valuation price null not authorized” which prevented the user from creating a purchase order. On debugging we found that this message can occur when the Valuation method found in the Common data->Products-> Product-site-> Cost is Standard cost, but it does not… Read More »
Sometimes we come across situations in Sage X3, where after creating a custom screen, you decide to create a separate menu item for that screen (as per client requirement or any other needs) and attach that particular menu item to the menu tree as per the respective & required module. But most of the time… Read More »
SEI defines the architectural view as a representation of a set of system elements and the relations associated with them. Moreover, SEI defines software architecture as a set of structures used to reason about the system dat comprise various system elements with their relations and external properties. In order to create view first we need… Read More »
As per the standard functionality of Sage X3, we can create Sales Delivery against Sales Order with the same quantity or more than the ordered quantity only if the stock of that particular product is available in the system. But one of our client wanted to have validation on delivered quantity on the basis of… Read More »
