Related topics
- About purchase-related statistics
- About unit handling in IBS Enterprise
- Setting up the purchase pricing and supplier agreements functionality
This enquiry program allows you to compare purchase prices from different suppliers.
Depending on if you complete the Item field or the Supplier field, different information will be displayed on the next panel.
If you enter an item, all suppliers for that particular item will be displayed in ranking order, which means the supplier with the lowest (best) rank will be displayed on top.
If you enter a supplier, all items which can be purchased from the entered supplier will be displayed.
- Item
- Enter a code from the Item file, to view all suppliers from which this item can be purchased. If you complete this field, the Supplier field cannot be completed.
- Supplier
- Enter a valid supplier from the Business partner file, to view all items which can be purchased from this supplier. If you complete this field, the Item field cannot be completed.
- Warehouse
- Enter the warehouse that will receive the goods from this supplier. If no value is entered then the value defined in the Business partner file, Supplier file (GDMD0051) panel will be defaulted to this field.
- Quantity
- Optional entry. The quantity entered will be used to retrieve any quantity dependent prices.
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.
- Quantity
- Displays the quantity entered on the selection panel.
- Rnk
- Displays the supplier’s ranking in ascending order.
- Supplier
- Displays the supplier number from which the item can be purchased.
- Name
- Displays the name of the supplier.
- Curr
- Displays the primary currency of the supplier, retrieved from the Business partner file.
- Price
- 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
- Comparable price is displayed in system currency and also converted to “price per one”, i.e. the price is divided by the conversion factor for the unit.
- Pltm
- 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)
- Appr.
- Indicates if you currently are allowed to purchase the item from this supplier. The code is retrieved from the Item file.
- Q rate
- Displays the quality rate that is given to the supplier, retrieved from the Item file.
- TOD
- Displays the terms of delivery for this supplier, retrieved from the Business partner file.
Item/Supplier comparison enquiry (DMR12405)
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
- Displays the item(s) which can be purchased from the selected supplier.
- Item/description
- This field is only displayed if you click Shift info. Displays both the item and the item description.
- Price
- Displays the purchase price in supplier’s primary currency.
- Comp. price
- Comparable price is displayed in system currency and also 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
- Displays the supplier’s ranking in ascending order.
- Pltm
- 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)
- Appr.
- Indicates if you currently are allowed to purchase the item from this supplier. The code is retrieved from the Item file.
- Q rate
- Displays the quality rate that is given to the supplier, retrieved from the Item file.
- TOD
- Displays the terms of delivery for this supplier, retrieved from the Business partner file.
Item/Supplier comparison enquiry (DMR12408)
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.
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 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 tim
- 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.
- 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 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)
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.