Supplier Product Pricing

The Supplier Product Pricing report provides the user with a comprehensive view of all available pricing for Location Products that are eligible for purchasing. The report displays all vendor prices and the contract status per Location Product for the selected Effective Date, in the current location's Primary Market and associated Secondary Markets (if any). Commissary and Warehouse issue prices will also be displayed, if applicable.  {Note}Closed: This report respects the location's setting for "Allow purchase from secondary Market Vendors of products with Vendor Bids/Contracts in primary Market" .  For more details, click ClosedHERE.

  • When set to 'Y': If the same vendor has pricing in the location's Primary Market AND one or more Secondary Markets, the report will only include the data for the Primary Market.
  • When set to 'N': The report will not include any secondary Market Vendor Bids for a product if an eligible Vendor Bid exists for the product in the Location's primary Market, unless the Primary Market Vendor is not available for Vendor Order." (i.e. - Vendor/Location record for primary Market Vendor has "Allow VO" = 'N').

 

Menu Paths: Net-Chef > Purchasing: Reports > Supplier Product Pricing
Menu Paths: Net-Chef > Reports: Purchasing > Supplier Product Pricing

 

Report Controls

Location (Cruise, Corporate only): Select the desired location from the drop-down

Effective Date: Calendar widget; can select any date

Group By: Supplier, Product (default), No Grouping

Funnel (Filters): Any report column; Master Order Type, Template, Category/Subcategory/Microcategory, User Defined Category (for 'Product'/'Location'), Department

Printer (Export): PDF, Excel, CSV formats

Report Columns (default view):

  • Universal Product Number – The company product’s universal product number.  {Note}Closed: This column is available when the preference to "Use Universal Company Product Number" is enabled.
  • Supplier Product Number – The vendor’s product number. If none exists, this displays the company product number.
  • Inventory Unit – The company product inventory unit.
  • Supplier Code, Name (hidden when grouped by Supplier) – The code/name of the supplier.
  • Supplier Unit – The unit of measure offered by the supplier.
  • Supplier Price – The price per Supplier Unit, in the market currency.
  • Conv. to Inv. Unit – The number of Inventory Units in 1 Supplier Unit.
  • Unit Price – The price per Inventory Unit, in the market currency.
  • Begin Date, End Date – Dates for the bid sheet to which the product is linked.
  • Brand – The brand entered for the product in the vendor bid record.
  • Supplier Currency – The Base Currency for the supplier.
  • Exchange Rate – The rate used to convert prices from the supplier currency to the market currency.
  • Supplier Currency Price – The price per Supplier Unit, in the supplier's currency.
  • Contract – Displays 'Y' (checked) or 'N' (not checked) to indicate whether the product is contracted to the supplier.
  • Split – Displays 'Y' (checked) or 'N' (not checked) to indicate whether the supplier unit can be "split".

Additional Columns (hidden by default):

  • Alternate Primary – Displays 'Y' (checked) or 'N' (not checked) to indicate whether the product is an alternate primary vendor product.
  • Tax Code – The tax code assigned to the product, either in the Company Product record or in Bid Master.
  • Price Incl. Tax – The price per Supplier Unit with the tax included.
  • Reference # – The name or number for the external contract document that includes this product.
  • Reference Line # – The line number within the contract document that refers to this product.
  • Contract Expiration Date – The expiration date of the bid/contract price as negotiated in the contract document; this is NOT the End Date for the bid/contract within the application.
  • Pricing Type – Displays 'Vendor Bid', 'Warehouse', or 'Commissary' to indicate the price source.
  • Primary Market – Displays 'Y' (checked) or 'N' (not checked) to indicate whether the market is the Primary Market for the location.
  • Market Currency – The Base Currency for the market.
  • Market – The market from which the vendor price was derived.

Additional Columns (other groupings):

  • Master Order Type – The master order type assigned to the company product.
  • Category, Subcategory, Microcategory – The category/subcategory/microcategory assigned to the company product.
  • Product Type – The product type assigned to the company product - 'Stock', 'Non Stock', 'Sales', or 'Intermediary'.
  • Product Name, Number – The company product name/number.
  • Issue Cost – The current per-unit cost of the location product, displayed in the location currency.
  • Active – Displays 'Y' (checked) or 'N' (not checked) to indicate whether the product is active.

 

 

Related Topics Link IconRelated Topics