How to create single Purchase Suggestion with multiple Sales Orders in Sage X3

By | March 10, 2023

MRP (Material requirements planning) is a production planning, scheduling and inventory control system used to manage manufacturing processes.

We may follow below steps to make Purchase Suggestions in Sage X3.

  1. MRP setup on Product.
  2. Sales Order.
  3. MRP Processing.
  4. Enterprise planning.

Step1: MRP setup on products:

Navigate to : Common Data -> Products -> product site

  1. Set Reorder Mode to “by MRP” based on the requirement.
  2. Set Reorder Policy to “BNT”.
  3. Set Suggestion type to “Purchase”.

4. Also set management mode to “Available Stock” on product screen.

Step2: Sales Order

Navigate to: Sales -> Orders -> orders

Create Sales Order using below example:

Product: BMS001, Site : AO012

Available Stock: 0

Now create the SO1 with quantity ‘100’.

Create SO2 with same product and site but different quantity 921. By created these SO’s you will see by the end suggestion will get created with 1021 quantity.

Step3: MRP Processing:

Run the MRP process

Navigate to: Stock -> Reorder -> MRP Processing

Enter the Stock Site ‘AO012’ and then click on the OK button. After running the MRP processing, you will get the below log file. Refer below screen shot.

Step4: Enterprise Planning

Navigate to: Purchasing -> Supply -> Enterprise Planning -> POS Purchase Suggestions

Fig04: Enterprise Planning Screen

Select site and product and click on search button which will display results as mentioned below.

Fig05: Purchase Suggestion Screen

As we can see in the above screenshot, system created single purchase suggestion for both the above  Sales Orders.

In this way, we can create a single purchase suggestion of multiple sales order.

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 X3 (Sage Enterprise Management) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage X3 for Sage CRM, Salesforce.com 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 x3@greytrix.com. We will be glad to assist you.