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.
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.
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:
Manual Purchase Orders
When a stock item is selected on a manually raised Purchase Order:
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:
If a Works Order component uses a different UOM from the stock item base:
-
The system first converts that component quantity back to the base unit,
-
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.
See also
Related
Other tasks