How to upload employee records using txt file in Sage X3 People

In Sage X3 People for uploading and updating records a user should use the Import functions to either add a new record or update an existing records. Below is the navigation for import functionality.Navigate: – Usage -> Imports/Exports -> Imports Usage Screen To upload employee data by using standard functionality below are the steps to… Read More: How to upload employee records using txt file in Sage… »

Machine and Labor cost calculation in Sage X3

In Sage X3, we may come across a scenario where we need to calculate machine and labor time for the specific release quantity on basis of time, cost for machine and labor will be calculated. Navigate to -> Manufacturing -> Technical Data -> Standard Operation Declaration in standard operation Setup Time: 2 Hours Run Time:… Read More: Machine and Labor cost calculation in Sage X3 »

How to increase the range of product serial numbers while creating Miscellaneous Receipt through import/export template

A serial number is a series of characters that have been assigned to each product in the warehouse so that it remains separate and are identified in the warehouse system. Using serial numbers, you can easily track the location of goods in the warehouse. While trying to import file for creating miscellaneous receipt for serial… Read More: How to increase the range of product serial numbers while… »

How to display the stock availability on sales order screen in Sage X3 version 12

For every sales order transaction, we need a stock availability at sales site.In standard Sage X3 there is one stock inquiry screen for checking the stock availability on sales site.But instead of this,while during the sales order transaction if we want to see the available stock on the sales order screen,then Sage X3 provides standard… Read More: How to display the stock availability on sales order screen… »

How to generate Employee Payslip automatically in Sage X3 People?

In Sage X3 People, every employee has their payslip. Sage X3 People have a functionality where we can automatically generate payslip for a particular employee for a particular period. Navigate to : Payroll > Payslip > Payroll Initialization > Automatic generation The above screen pop-ups . Legislation: Select the legislation Registration start and end :… Read More: How to generate Employee Payslip automatically in Sage X3 People? »

Enabling Field Value by Default in Capital in Sage X3

In some cases, we require the field text to be entered in capitals. If we enter values in small letters then it may cause problem in case the field has some customization. We can handle this type of conversion (capitals to small and vice versa) by writing code. But, to easily handle this type of… Read More: Enabling Field Value by Default in Capital in Sage X3 »

How to assign report Destination based on condition

We may come under a situation where we have to set different destination according to the user or we have to set a destination for a user based on a particular condition. To set different destination based on user we can simply define this in : All -> Setup -> Destination -> Destination by user… Read More: How to assign report Destination based on condition »

How to add suppliers in the product-site level in Sage X3-Version 12

Sometimes we require to manage local suppliers to a specific site. There is an amendment made in Sage X3 version 12 where we can add suppliers at the product site level. Benefits: This functionality is useful for supplier product management rules by site. These rules are used in the supply planning as well as on… Read More: How to add suppliers in the product-site level in Sage… »

How to make the Function accessible in batch task

We may come across the scenario, where we need to make the customize function to be executed through the batch task. This process can be executed without manual intervention on the regular interval. Solution: Step 1: When we make the function we need to attach the Action. Step 2: The Action linked to the function… Read More: How to make the Function accessible in batch task »

How to resolve “No product to adjust” error in Adjustment of stock shortages process

We may come across a scenario where we deliver a product to customer even though there is no stock in X3 system. We can adjust that stock in system after a while for that we can use Adjustment of stock shortages functionality which is available in Sage X3. Using this function we can adjust manually… Read More: How to resolve “No product to adjust” error in Adjustment… »