Item/Supplier comparison enquiry (DMR12401)

Item/Supplier comparison enquiry (DMR12402)

This panel is displayed if you entered an item on the initial panel. All suppliers from which the item can be purchased are displayed, i.e. all supplier that are defined on the Supplier information panel in the Item file. The suppliers are displayed in ranking order, which means the supplier with the best (lowest) ranking will be displayed on top.

Note: The ranking code is manually defined on the Supplier information panel in the Item file.

Function keys

Supplier quotation	Access the Supplier quotation enquiry.
Ranking sequence/Price sequence	Toggle the information displayed to either the suppliers in ranking order or in comparable price order.

Item: Displays the item entered as a selection.

Warehouse: Displays the warehouse entered on the selection panel.

Quantity: Displays the quantity entered on the selection panel.

Rnk: This column displays the supplier’s ranking in ascending order.

Supplier: This column displays the supplier number from which the item can be purchased.

Name: This column displays the name of the supplier.

Unit: This column denotes the unit for the item. This value is defined on the Item file, System units panel.

Curr: This column displays the primary currency of the supplier, retrieved from the Business partner file.

Price

This column displays the purchase price in supplier’s primary currency. The purchase price is retrieved according to the following:

Valid entry in the Agreement file. Select the lowest price if several exist.
Supplier/Item discount group has a discount defined in the Supplier discount file.
Quantity dependent prices exist in Item/Purchase price file.
Actual price 1 defined in Item/Purchase price file.

Comp. price: This column displays the comparable price in system currency which is also converted to “price per one”, i.e. the price is divided by the conversion factor for the unit.

Planning time

This column displays the planning time in days for the item/supplier combination.

The planning time is calculated as:

Lead time (retrieved from Item/Supplier file)
+ Transport time (retrieved from Supplier transport time table)
+ Administration time (retrieved from DIS control file)

Approved: This column denotes if you currently are allowed to purchase the item from this supplier. The code is retrieved from the Item file.

Quality rating: This column displays the quality rating that is given to the supplier, retrieved from the Item file.

Terms of delivery: This column displays the terms of delivery for this supplier, retrieved from the Business partner file.

Backlog: This column denotes if a backorder is allowed for this item when purchased from this supplier. If set to NO, a backorder will not be created even if the item is not delivered in full. This code, however, can be overridden during the Confirm purchase order reception note routine.

Lead time: This column displays the lead time, indicating the number of days it normally takes from Purchase order generation to the goods being sent from the supplier’s premises. The lead time is one of the factors that is used in the calculation to find the total planning time for the item.

BtB lead time

If the item is included on a BtB order, this column displays the BtB lead time. For a transit delivery, this is the number of days it will take from the purchase order creation to the goods being sent from the supplier’s premises to our transit stock.

If the item is to have a direct delivery, the BtB lead time is the number of days it will take from the purchase order creation to the goods being sent from the supplier’s premises directly to the customer.

Order discount: This column denotes if this supplier/item combination is to be included in the purchase order discount base. The order discount is a discount percentage given for the whole order.

Order discount %: This column displays the order discount in percentage format, retrieved from the Supplier file.

Manner of transport: This column displays a code from the Manner of transport table, indicating the most common used manner of transport for this supplier. The information is retrieved from the Item/Supplier file.

MOT description: This column displays the description for the manner of transport.

Order lines YTD: This column displays the number of order lines that have been generated for this item, year to date, retrieved from the Item file.

Order value YTD: This column displays the total order value for this item, year to date, retrieved from the Item file.

Supplier agreement number: Displays a code from the Supplier agreement file indicating the active general supplier agreement. This agreement is valid for the supplier for whom you are viewing information and for today’s date.

Supplier discount 1-9: These nine columns display the discount percentages to be used for calculating the discount allowed for the supplier and item discount group.

VAT included: This column denotes if VAT is included in the purchase price of the item.

Include VAT % code: This column displays the VAT handling code for the VAT percentage, if any, which is included in the purchase price.

Pack size: This column displays the pack size, from the Item file, that you want purchase units rounded up to (i.e. purchase units per package).

Price unit: A value in this column is only displayed if the PRCUNIT (Price unit handling) function is activated in the Function control file. Displays the unit in which the price is presented. See About price unit handling for more information.

Price from date: This column displays the start date, from the item file, of the validity period for the prices.

Price to date: This column displays the end date, from the Item file, of the validity period for the prices. If blank, the prices are to be valid indefinitely

Price 1: This column displays the Actual price 1 from the Item file, if today’s date is older than New price date in the Item file. Otherwise, displays New price 1. Prices are defined on the Purchase prices panel in the Item file.

Currency: This column displays the Actual currency from the Item file, if today’s date is older than New price date in the Item price file. Otherwise, displays New currency.

Quantity dependent prices: This column is set to YES or NO for the Actual quantity dependent pricing from the Item file, if today’s date is older than the New limit date in the Item/Purchase price file. Otherwise, it is set to YES or NO for the New quantity dependent pricing.

Price 2-5: These columns display the Actual price 2-5 from the Item file, if today’s date is older than New price date in the Item file. Otherwise, displays New price 2-5. Prices are defined on the Purchase prices panel in the Item file.

Discount 2-5: These columns display the Actual discount 2-5 from the Item file, if today’s date is older than New limit date in the Item/Purchase price file. Otherwise, displays New discount 2-5.

Limit 2-5: These columns display the Actual limit 2-5 from the Item file, if today’s date is older than New limit date in the Item/Purchase price file. Otherwise, displays New limit 2-5.

Item/Supplier comparison enquiry (DMR12405)

Related topics

This panel is displayed if you entered a supplier on the initial panel. All items which can be purchased from the entered supplier are displayed. The information is retrieved from the Item file.

Function keys

Supplier quotation

Access the Supplier quotation enquiry.

Selection fields

Supplier: Displays the supplier number and name entered as a selection.

Currency: Displays the system currency in which the prices are displayed.

Item: This column displays the item(s) which can be purchased from the selected supplier.

Unit: This column denotes the unit for the item. This value is defined on the Item file, System units panel.

Price

This column displays the purchase price in supplier’s primary currency.

Comp. price: This column displays the comparable price in system currency which has also been converted to “price per one”, i.e. the price is divided by the conversion factor for the unit. The figure displayed here has had the discounts from the Agreement file or Supplier discount file deducted. However, if the amount has been calculated in accordance with order discount by supplier, this amount is not deducted.

Rnk: This column displays the supplier’s ranking in ascending order.

Description: This column displays the item description.

Planning time

This column displays the planning time in days for the item/supplier combination.

The planning time is calculated as:

Lead time (retrieved from the Item/supplier file)
+ Transport time (retrieved from the Supplier transport time table)
+ Administration time (retrieved from the DIS control file)

Approved: This column denotes if you currently are allowed to purchase the item from this supplier. The code is retrieved from the Item file.

Quality rating: This column displays the quality rating that is given to the supplier, retrieved from the Item file.

Terms of delivery: This column displays the terms of delivery for this supplier, retrieved from the Business partner file.

Item/Supplier comparison enquiry (DMR12408)

Related topics

This panel displays detailed information for the supplier/Item combination selected on the previous panel.

Function keys

Non conf certificate	Access the Non-conformity certificate enquiry where you can view information about rejected goods for this item/supplier.
Supplier information	Access the Supplier information panel on which you can view more statistical information about the supplier.

Supplier: Displays the supplier number and name.

Item: Displays the item and item description.

Quantity: Displays the quantity entered on the initial panel.

Other price exists: Indicates if the supplier sells this item in Units other than the Default purchase unit. The price information on this panel refers to the Default purchase unit for the supplier. If set to YES, use the Item file enquiry to view the prices in the other unit.

Rank: Displays the ranking of the supplier for the item, retrieved from the Item file.

Lead time: Displays the lead time, indicating the number of days it normally takes from Purchase order generation to the goods being sent from the supplier’s premises. The lead time is one of the factors that is used in the calculation to find the total planning time for the item.

Backlog: Indicates if a backorder is allowed for this item when purchased from this supplier. If set to NO, a backorder will not be created even if the item is not delivered in full. This code, however, can be overridden during the Confirm purchase order reception note routine.

Approved: Indicates if purchase orders are allowed to be sent to this supplier for this item. The code is retrieved from the Item file.

BtB lead tim

If the item is included on a BtB order, displays the BtB lead time. For a transit delivery, this is the number of days it will take from the purchase order creation to the goods being sent from the supplier’s premises to our transit stock.

Order disc: Indicates if this supplier/item combination is to be included in the purchase order discount base. The order discount is a discount percentage given for the whole order.

Quality rate %: Displays the quality rate that is given to the supplier, retrieved from the Item file.

Planning time

Displays the planning time, in days, indicating the actual time it takes to replenish stock. Planning time is calculated as follows:

Administration time + Lead time + Supplier transport time

Order disc%: Displays the order discount in percentage format, retrieved from the Supplier file. A message will also be displayed at the bottom of this panel, indicating from where the price has been retrieved. In addition to this, the Agreement number, agreement price, agreement discount as well as supplier discounts will also be displayed.

Manner of transport: Displays a code from the Manner of transport table, indicating the most common used manner of transport for this supplier. The information is retrieved from the Item/Supplier file.

Order lines YTD: This field, which is automatically updated by the system, displays the number of order lines that have been generated for this item, year to date, retrieved from the Item file.

Order value YTD: This field, which is automatically updated by the system, displays the total order value for this item, year to date, retrieved from the Item file.

Pack size: Displays the pack size, from the Item file, that you want purchase units rounded up to (i.e. purchase units per package).

Price unit: Only displayed if the PRCUNIT (Price unit handling) function is activated in the Function control file. Displays the unit in which the price is presented. See About price unit handling for more information.

Price from date: Displays the start date, from the item file, of the validity period for the prices.

Price to date: Displays the end date, from the Item file, of the validity period for the prices. If blank, the prices are to be valid indefinitely

Price 1 – 5: Displays the Actual price 1-5 from the Item file, if today’s date is older than New price date in the Item file. Otherwise, displays New price 1-5. Prices are defined on the Purchase prices panel in the Item file.

Currency: Displays the Actual currency from the Item file, if today’s date is older than New price date in the Item price file. Otherwise, displays New currency.

Qty dep pric: This field is set to YES or NO for the Actual quantity dependent pricing from the Item file, if today’s date is older than the New limit date in the Item/Purchase price file. Otherwise, it is set to YES or NO for the New quantity dependent pricing.

Discounts 2-5: Displays the Actual discount 2-5 from the Item file, if today’s date is older than New limit date in the Item/Purchase price file. Otherwise, displays New discount 2-5.

Limits 2-5: Displays the Actual limit 2-5 from the Item file, if today’s date is older than New limit date in the Item/Purchase price file. Otherwise, displays New limit 2-5.

Item/Supplier comparison enquiry, Supplier information (DMR12409)

Related topics

This panel displays detailed information from the Supplier file.

Supplier: Displays the supplier number and name.

Terms of delivery: Displays a code from the Terms of delivery table, indicating the terms of delivery defined for the supplier in the Business partner file.

Manner of transport: Displays a code from the Manner of transport table, indicating the manner of transport defined for the supplier in the Item file.

Terms of payment: Displays a code from the Terms of payment table, indicating the terms of payment defined for the supplier in the Business partner file.

Number of orders YTD: Displays the total number of orders entered into the system, for this supplier, year to date.

Order value YTD: Displays the total purchase order value for this supplier, year to date.

Last reception date: Displays the last date when a reception from the supplier took place.

Receptions YTD: Displays the total number of receptions of the item, received from this supplier, year to date.

Receptions LY: Displays the total number of receptions of the item, received from this supplier, last year.

Returns YTD: Displays the total number of returns entered into the system for this supplier, year to date.

Returns LY: Displays the total number of returns entered into the system for this supplier, last year.

Discrepancies YTD: Displays the number of order lines, year to date, with a quantity discrepancy for this supplier.

Discrepancies LY: Displays the number of order lines, last year, with a quantity discrepancy for this supplier.

Late deliveries YTD: Displays the number of order lines delivered late for this supplier, year to date.

Late dispatches ly: Displays the number of order lines delivered late for this supplier, last year.

Early dispatches YTD: Displays the number of order lines delivered early for this supplier, year to date.

Early dispatches LY: Displays the number of order lines delivered early for this supplier, last year.

Approved supplier: Indicates if purchases from the supplier are approved. Items with the Use appr suppl only field set to YES in the Item file, can only be purchased from suppliers with this field set to YES.

ISO9000 certified: Indicates if this supplier is ISO9000 certified. The information is retrieved from the Item file.

Overall qual. rating: The quality rate is a value entered for each supplier to control that items are only purchased from a supplier that attains a certain quality rating.

Auditing authority: If the ISO9000 certified field is set to YES, displays the name of the company that certified the supplier.

Date last audit: If the ISO9000 certified field is set to YES, displays the date when the supplier was last audited.

Supplier agreem no: Displays a code from the Supplier agreement file indicating the active general supplier agreement from where the values in the Order val disc code, Terms of delivery, and Terms of payment fields on this panel were retrieved. This agreement is valid for the supplier for whom you are viewing information and for today’s date.

Order val disc code: Displays a code from the Order value discount table indicating the discount percentage based on the total purchase order value. If a code is defined for the supplier, the code is defaulted from the Supplier agreement file.

Terms of delivery: Displays a code from the Terms of delivery table as defined for the valid supplier agreement. This value will override the value defined in the Business partner/Supplier file when a purchase order is created.

Terms of payment: Displays a code from the Terms of payment table as defined for the valid supplier agreement. This value will override the value defined in the Business partner/Supplier file when a purchase order is created.