Inventory: Ingredient Price Bands

Overview

Price band functionality allows the maintaining of a single product with a single product code from a single supplier, but with varying prices applied. This could be for regional pricing differences or contractual reasons, for example.

In Recipe & Menu Engineering (RME), by default, a single price band exists. However, additional price bands can be configured where required. 

If price bands are configured in RME, they must also be configured in Inventory. These price bands are then applied to specific site and supplier combinations to control the prices for ordering and stock purposes.

All price band data in Inventory is managed in RME. Therefore in Inventory it is configuration, review, and use only - no management.

Configuration

Global Setting

A Fourth representative must enable the following global setting once all data is configured in RME: 

• Global Settings > Products > Organisation Settings > Default > Apply Product Banding to Organisation

The above global setting should not be enabled until all price band data is ready in RME.

Once enabled, a full sync of ingredient data to Inventory is required before the following configuration can be completed.

Orders cannot be placed until all configuration is in place, so the timing of configuration on a live organisation must be carefully considered and planned with a Fourth representative.

Price band data will only be synced for price bands with pricing held against ingredients exported to Inventory.

Role Setting

A Fourth representative must enable the following role setting agaisnt any profiles that should see price band pricing in Master Data once all data is configured in RME: 

Roles > Products > Purchasing > Purchase Product Cost Price Band

Supplier / Site / Price Band linking

Once the global setting is enabled, and ingredient price band data synced, links must be created between:

• Supplier
• Site
• Price Band

This linking controls the price that a site will see when creating an order for a supplier.

All stock-related pricing will be based on the Average Weighted Cost as usual

• Navigate to Setup > All Options > Browser Suppliers
• Choose the required supplier
• Select Where Used
• For existing Site/Supplier combinations select Update Nominal Code/Price Band to Site
  • Alternatively, to assign a supplier to a site for the first time, select Add Supplier/Price Band to Site/Change Depot
• Select all required locations and then Next

A screen will then display where a price band can be assigned to each site.

• Select the required price band from the drop-down for each site and then Save

This should be completed for all existing Supplier/Site combinations.

Fig.1 - Supplier / Site / Price Band linking

Placing Orders and Reviewing Price Band Prices

Placing Orders

At the point ingredient lists are loaded for ordering in either the mobile app or Inventory, the above linking will be checked to determine the required pricing that is displayed.

Orders will be placed, and expected Goods Received Notes will be created, with this value.

Receiving and Invoice reconciliation will happen as normal.

Reviewing Price Band Prices

It is possible to see all price band pricing held against an Ingredient from Master Data

• Navigate to Master Data
• Search/select the required Ingredient
• Select the Suppliers tab
• Select the (i) under the 'Band' heading

All available price band pricing will be displayed (see Fig.3).

Fig.2 - Suppliers tab, price band icons

Fig.3- Price band information

Related Articles

RME: Ingredient Price Bands