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.