How to check list of products purchased from same supplier

By | September 21, 2021

Sage X3 provides us functionality where we can check the number of products that are purchased from a single supplier and also can group and view them. The Grouping workbench that is found in Purchasing, Supply provides visibility of products purchased from specific suppliers and same site. Using this function and selecting the ACH Buyer transaction as an option, it lists products and suggestions for a specific supplier as well as for suppliers that are outside of the original selection criteria.

However, to have an accurate and up-to-date current and future material requirement, running MRP (Material Requirements Planning) helps matches your supply of components to the demand of the finished goods product. It searches through orders such as Sales orders and Work orders to give accurate requirements. Once MRP is ran and finished, navigating to the Grouping workbench function in Purchasing and selecting the ACH Buyer window will open with a range of fields to enter.

Fig 1: Grouping workbench

Entering the Site and a Product or a range of Products then clicking Search, will display a list of requirements.

Fig 2: Requirement list

Once the list of requirements is generated, clicking the action button, and selecting Products by supplier, it will show a list of products that purchased from the same supplier. Using the product by supplier, the buyer can see the supplier contact information, available QTYs for products, how many on order, what is the EOQ and the suggested quantities. The field Order qty. is open for data entry and the buyer can enter quantities in that field to immediately create an additional Purchase order suggestion (POS).

For example, looking at the first line for product BMS012, we see that available is 10 and the system has suggested 0 quantities to order from supplier NA052. If for any reason the buyer wants to increase the order quantity. Simply adding extra units and saving will add an extra line on the Grouping workbench. The same thing can be applied to the second line “COM001”.

Fig 3: Quantities

Once the new lines are added to the grouping workbench screen, clicking Generate from the Right panel will group selected different products for the same supplier and create a new log with the purchase order number for the suppliers specified and the products.

Fig 4 : Grouping workbench
Fig 5: log

Also, with this function, the buyer can open Product usage by clicking the action button on the grouping workbench and selecting Product usage, this will show a historical usage of how often the product has been used in a moving 36-month view as these amounts represent total products consumed for each month.

Hence in this manner we get all the details and list of product purchased from a supplier or group of supplier.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged 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 competence. 

Greytrix caters to a wide range of Sage X3, a Sage Business Cloud Solution, offerings. Our unique GUMU™ integrations include Sage X3 for Sage CRMSalesforce.com, Dynamics 365 CRM and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3. Currently we are Sage X3 Implementation Partner in East Africa, Middle East, Australia, Asia, US, UK. 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 and India Legislation for Sage X3 to Sage business partners, end users and Sage PSG worldwide. Greytrix Sales Commission App for Sage X3 simplifies commission calculations and postings on sales transactions.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

Greytrix is a recognized Sage champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU™ integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com, We would like to hear from you.