Tag Archives: X3

How to automatically adjust shortages of outstanding sales order with recording of stock receipts

In order to make sure effective stock allocation and order fulfillment, integrating inventory management with sales order processing in Sage X3 is necessary for automating the adjustment of shortages in outstanding sales orders. In order to manage supply shortages more efficiently overall, you can eliminate errors, cut down on manual intervention, and set up automated… Read More: How to automatically adjust shortages of outstanding sales order with… »

How to concatenate a field in Sage X3 V7

In Sage X3 version 7 ,’Append’  allows concatenating a string or CLOB value to an existing string or CLOB. New Stuff: How to check if the transaction is being locked in another workstation? From a functional point of view, Append A, B is equivalent to A+=B if ‘A’ and ‘B’ are strings or CLOBs. Kindly refer to the below screen… Read More: How to concatenate a field in Sage X3 V7 »

How to restrict the Automatic allocation in Sage X3

An allocation is an amount of something, especially money, that is given to a particular person or used for a particular purpose. Allocation is the process of assigning product items from the inventory to shipping orders and then fulfilling the shipping orders from appropriate fulfilment sites such as drop-ship vendors, virtual sites, warehouses, or a… Read More: How to restrict the Automatic allocation in Sage X3 »

Adding run time selection criteria in SQL requester

You may come across a situation where you want to add criteria’s for SQL requester. Follow below instructions to add search criteria to the SQL requester. New Stuff: How to use Import to Excel functionality in version 7? Step 1: Go to Setup> Usage> Reports> SQL requester Parameter definition: If this field is entered, a… Read More: Adding run time selection criteria in SQL requester »