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

By | September 30, 2019

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 functionality. This functionality is available only in Sage X3 version 12.


  • On sales order screen you will get the information about the stock availability and allocated quantity.
  • It’s helpful for displaying the negative stock message during the creation of sales order delivery, or else you will get the stock availability information during the creation of the sales order transaction.


1.Navigate to setup-> General parameter-> Parameter values-> VEN(sales)-> MIS group.

2.Click on the action of MIS group ->Go to detail.

3. Set SOHVALLIG parameter value to ‘Yes’ click on the Ok button.

Now we need to set the Availability of product flag on Sales order entry transaction screen.

Navigate To : Setup-> Sales-> Entry transaction-> Go to display tab-> Tick the “Availability of product” checkbox.

The ‘Availability of the product’ flag must be checked. As shown in the below Fig.

Now, Let’s go on to the sales order screen.

When you create the sales order transaction and enter a sales order line where the product has all the stock available you get a message like the highlighted below, letting you will know that there is stock available for this sales order line as shown in the below Fig. If you will enter the other product in second sales order line and that product is not available in the stock then it will display the message ‘Not available in stock’ as shown in the below Fig.

If you will go to the “Qty To Allocate” field, then in the available stock line it will display the information about ‘Allocated Qty’ and also display the ‘Available Stock’ on sales site as shown in below Fig.

After generating a sales order the available stock line will be blank.On this way you can know the stock availability on the sales order screen instead of stock inquiry screen.

Hope this works.

About Us
Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.

Greytrix caters to a wide range of Sage Enterprise Management (Sage X3) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage X3 for Sage and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3 (Sage Enterprise Management). Currently we are Sage X3 Implementation Partner in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit for Sage X3 to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star app listed on Salesforce AppExchange.

For more information on Sage X3 Integration and Services, please contact us at We will be glad to assist you.