Category Archives: Tips

Database Optimization Function in Sage X3

In sage x3, we have a function called database optimization which is used to track or create custom index. This function help us for easy reapplication when updating or migrating data set. It is useful  to create the indexes in order to achieve a specific optimization (for example in a report or to optimize a… Read More: Database Optimization Function in Sage X3 »

Default Dimensions associated with manufacturing in Sage X3

In Sage X3, for the entry of documents requiring analytical dimensions, a default dimensions function specifies how to enter these dimensions by default. Strictly speaking, they are not accounting documents (most of them are generated outside the Financials module), but they can generate postings. These setups are useful to enter the analytical allocations in all… Read More: Default Dimensions associated with manufacturing in Sage X3 »

Simulated Cost calculation in Sage X3

Sage X3 has a function that will compute the simulated cost of a product, a group of goods, or all products at a site depending on the cost type routing alternative, BOM with or without immediate update, and create a report that summarizes or details the results. Simulations of the cost are often used to… Read More: Simulated Cost calculation in Sage X3 »

Use of SOHAPPOST and SOHAPPCLE parameters

Sage X3 provide us multiple functions that can be triggered through signature management workflow. Here we will see some of them which are useful on sales order. As we know once we create a sales order the credit limit of customer gets updated. There can be a business requirement where user wants the credit limit… Read More: Use of SOHAPPOST and SOHAPPCLE parameters »

Functionality of Phantom Products in Sage X3

Phantoms are also used if you want to set up a flow line for a product where you are building to a specific time and need all the components available at the correct place. In the Manufacturing process, it becomes a very heavy task to create multiple Manufacturing Order on a daily basis for some… Read More: Functionality of Phantom Products in Sage X3 »

How to solve “404-cannot find module” error on Node.js V12

Node.js is an open source, cross-platform runtime environment for server-side and networking applications. Node.js applications are written in JavaScript, and can be run within the Node.js runtime on OSX, Microsoft Windows, Linux. Node.js on Sage X3: We come across scenario where x3 require integration with Node.js. It increases the efficiency of the development process as it fills… Read More: How to solve “404-cannot find module” error on Node.js V12 »

Entities in Operating Budget module in Sage X3

This function is used to define the hierarchical organization of the folder. The entities can be viewed as control centers designed to structure the budget forecast and monitoring according to the entity type: Entity controlling and monitoring a budget, Entity consuming the budget, Entity approving the budget allocated or the revisions carried out. Approval entity:… Read More: Entities in Operating Budget module in Sage X3 »

Validation on HSN Code

In Sage X3, we do have Indian Legislation addon module developed which is suitable for Indian business. Good and Service tax is part of the Indian Legislation where defining HSN code against product and service is mandatory. HSN stands for “Harmonized System of Nomenclature”. HSN code is a 6-digit uniform code that classifies 5000+ products… Read More: Validation on HSN Code »

Capturing Business terms dynamically in Sage X3

‘Terms and Conditions’ are important agreements for all types of business. It acts as a contract between the company and its customers/Supplier for the supply of goods or services. In Sage X3, users usually input the Terms and conditions in the ‘comments’ section in every screen and also needs to be captured at report level.… Read More: Capturing Business terms dynamically in Sage X3 »

How to flow data in a column of Inquiry Screens

In Sage X3, we have Inquiry screens which display all the information from tables based on a certain filter criteria. We recently had a requirement to add Description 2 and Description 3 fields in the Inquiry Screens. In this blog we will see how we can manually display Description 2 and Description 3 of a… Read More: How to flow data in a column of Inquiry Screens »