Category Archives: Sage ERP X3

How to make use of Technical sheet (Questionnaire and Responses) In QC

You may come across a scenario where you would like to make use of a Technical sheet i.e. Needs to perform a number of tests and capture the same in ERP. By following below mentioned steps one can achieve the same. New Stuff: How to Know Start date of Week of any Year Go to… Read More: How to make use of Technical sheet (Questionnaire and Responses)… »

How to apply Group price search in Purchase Order?

Sage Enterprise Management provides a feature to invoke grouped pricing in the Purchase order. New Stuff: How to set the structure of import template to import Data and CSV file? To set this Group Price search to navigate through: Setup> General parameters> Parameter values The list of possible values is: No, Yes, On demand. No: No… Read More: How to apply Group price search in Purchase Order? »

How to Know Start date of Week of any Year?

In Sage ERP X3, you may come across the situation where you need to know start date of any week for any particular year. Sage X3 provides function to get the same. New Stuff:Use the solutions feature to build a Knowledge Base Function Name:  aweek (week_exp, year_exp) Week_exp   – Expression of the Integer type that… Read More: How to Know Start date of Week of any Year? »

How to set the structure of import template to import Data and CSV file?

You may come across the scenario where you were able to import data from DAT file but you were getting error from CSV file in Sage X3. To solve this problem you need to modify the structure of import template. New Stuff: Use the solutions feature to build a Knowledge Base To modify the structure, please… Read More: How to set the structure of import template to import… »

How to use and setup the functionality of early discount / late charges in Supplier Invoice

Go to Common data → BP tables → Early discount/late charge New Stuff: How to set the Price by default Standard cost? Do the setup as per the requirement by entering early discount/ late charges in days and its rate in percentage. As in the above Image – – (minus) indicates discount while rest are charges.… Read More: How to use and setup the functionality of early discount… »

How to set the Price by default Standard cost?

Sage X3 has an interesting feature where you can set the product price by default standard cost of the product. New Stuff: Restrict to create the direct supplier return. Navigate: Setup>General parameters>Parameter values. Set the parameter “PURPRICE”=Yes. Now when you create the Purchase order and if the purchase price of a product is not defined then… Read More: How to set the Price by default Standard cost? »

How to modify the number of records to be loaded in the ‘Last Read’ left list

In Sage ERP X3, screens display with a left list selection. The left list is used to navigate among a list of records which is accessed in recent time. You may have a scenario where you need increase or decrease the number of the records displayed as per the requirements. New Stuff: How to update multi-dimensional… Read More: How to modify the number of records to be loaded… »

How to update multi-dimensional values via Import Template in X3…?

There can be occasions when you want to create and/or update multi-dimensional attribute of an object in X3 via import template. Here we are describing how to achieve it using import template. New Stuff: Restrict to create the direct supplier return. To update a field having more than one dimension you need to specify its dimension using… Read More: How to update multi-dimensional values via Import Template in X3…? »