Knowledgebase

Suppliers Tab

Use these settings to choose how to process and manage additional features from Cim200.

Open: Stock Control > Stock Records > Enter New Stock Item | Suppliers
Open: Stock Control > Stock Records > Amend Stock Item Details | Suppliers
Open: Stock Control > Enquiries > View Stock Item Details | Suppliers

Note: The View Stock Item option allows you to view the items but not amend them.

In addition to the standard Item Supplier details that can be set in Sage, Cim200 adds further information to give insight into supplier performance.

Price Variance : Gives the buying price variance between the latest purchase order for that supplier and the oldest order, up to 2 years old.

OTIF Performance % : Calculates the On Time In Full performance by the supplier for deliveries of the selected item. The value gives the percentage of orders over the past 2 years which have been fully received within the Requested delivery date on the Purchase Order line.

Supplier Price Breaks

Add / Edit Supplier

Quantity price breaks: When setting up stock item suppliers, there is now the option to enter quantity price breaks. This feature allows you to define different price tiers or discounts based on the quantity of items being purchased from a specific supplier.

 

Default pricing for purchase orders: The quantity price breaks entered for each stock item supplier will be used as default pricing when raising purchase orders. This applies to both manual purchase order creation and when generating purchase orders from the Cim200 Material Requirements Planning (MRP) recommendations. The system will automatically apply the appropriate price based on the quantity being ordered, using the defined price breaks for the supplier.

 

By incorporating quantity price breaks in the stock item supplier setup, the system streamlines the purchase order creation process by automatically applying the correct pricing based on the ordered quantity. This feature helps optimize purchasing decisions, ensures accurate cost calculations, and potentially enables cost savings by taking advantage of volume-based pricing discounts offered by suppliers.

Carbon Footprint

If your supplier can provide you with the KgCO2e value that is associated with the manufacture of the component item, you can enter that figure against the stock item supplier record in the KgCO2e (per Each) field. This will then be used to calculate the Carbon Footprint of the items you manufacture whenever this item is issued to a Works Order.

Purchase Unit of Measure

The Purchase Unit of Measure enhancement allows users to specify the unit of measure used when purchasing a stock item from each supplier.

This provides greater accuracy and flexibility in handling supplier-specific buying units and ensures consistency across Purchase Orders, Trial Kitting, and MRP recommendations.

A new Purchase Unit of Measure field has been added to the Stock Item Supplier screen.

  • Purchase Unit of Measure – Select the purchase unit from the list of units of measure defined on the stock item.

Note: The field is only available where the Product Group is configured to use multiple units of measure.

Note: Existing stock item supplier records default to the stock item’s default UOM on upgrade.

When a purchase UOM is changed:

  • Users are prompted with a message advising that they may need to review List Price values and Supplier Price Breaks, as these are defined per unit.

 

Manual Purchase Orders
When a stock item is selected on a manually raised Purchase Order:

  • Cim200 checks the corresponding Stock Item Supplier record.

  • The Buying Unit and Buying Price Unit fields are automatically updated to match the supplier’s selected Purchase UOM.

This ensures the order quantity and pricing reflect the supplier’s preferred purchasing unit.

Note: This functionality does not extend to back-to-back sales orders

Trial Kitting
When generating Purchase Orders via Trial Kitting:

  • The Unit column is automatically updated to use the supplier’s specified Purchase Unit of Measure.

  • The Order Quantity is adjusted according to the defined UOM conversion ratio.

If a Works Order component uses a different UOM from the stock item base:

  1. The system first converts that component quantity back to the base unit,

  2. Then converts it again using the supplier’s Purchase UOM conversion ratio.

This logic applies to both Works Order and BOM Trial Kitting.

MRP
MRP takes into account the Purchase Unit of Measure defined on the supplier record when calculating order and demand quantities.

  • MRP recommendations are generated in the Purchase UOM, with quantities automatically converted using the defined conversion ratios.

  • The MRP Recommendation Object retains both:

    • The original demand/original recommended quantity (in stock unit), and

    • The converted purchase quantity (in purchase unit).

  • The Stock Profile and Tag Quantities are updated accordingly to ensure accurate reporting.

Raise Orders for Quotations
When generating orders from Quotations:

  • The system converts the quantity into the supplier’s Purchase UOM before raising the order.

  • Quantities are rounded up where necessary to ensure that total demand is fully covered, taking UOM precision into account.

Our Software: