Harvest - Advanced Pricing for Food

Harvest - Advanced Pricing for Food

Advanced Pricing for Food – User Guide

Overview

Advanced Pricing for Food extends standard Business Central pricing by enabling the system to search across multiple Sales Price Lists - based on the Customer Price Group assigned to the Sell‑to or Ship‑to customer - to determine the correct unit price using:

  • Total quantity of all items on the order
  • Total net weight of all items
  • Total gross weight of all items


This enhancement supports food distributors and manufacturers who require:
  • Bracket‑based pricing driven by total order quantity or weight
  • Ship‑to-specific pricing, where different locations for the same customer may have different pricing rules

Using Bracket Pricing, multiple Sales Price Lists are linked to Customer Price Groups. When a customer is assigned to a Price Group, the system automatically evaluates the appropriate price list based on the bracket ranges.


Example:

Ketchup appears on two price lists:
  • Price List 1 → Maximum quantity  9  → $20.00 per case
  1. Price List 2 → Minimum quantity 10 → $18.00 per case

When entering a sales order:

  • Default price = $20.00
  • If total quantity exceeds 10, the system automatically reprices to $18.00


Before You Start

Before using Advanced Pricing for Food, ensure:

  • The Harvest – Advanced Pricing for Food extension is installed from Microsoft Marketplace.

How to use Advanced Pricing for Food

Bracket Pricing


Setup Bracket Groups

Bracket Groups define the minimum and maximum levels used to determine which Sales Price List applies. A single Bracket Group Code may be shared across multiple Customer Price Groups. Numbering is flexible and can follow any scheme.

When the "Show Applied Message" flag is set to "True", a message will show each time the order is released, confirming that Bracket Pricing has been applied.




Customer Price Groups


Bracket Based On

Defines how the system calculates the bracket total:

  • Total Qty. – Sum of all quantities on the sales order
  • Total Net Weight – Sum of (quantity × item net weight)
  • Total Gross Weight – Sum of (quantity × item gross weight)


Assign Bracket Groups to Customer Price Groups

When configuring:

  • Ensure bracket ranges do not overlap
  • Ensure the final bracket maximum covers the full expected range for the selected Bracket Based On method


How Bracket Pricing Works


When Bracket Pricing is set up, the user enters a sales order and the unit price will default on the sales order lines:




When the quantity is entered, and the order is released, the order will update with the appropriate bracket pricing:



If set up to do so, a confirmation message will display, confirming the update:



Ship‑to Pricing Setup


New Field on Ship‑to Address

A new field is added:

  • Customer Price Group

This allows Ship‑to locations to have pricing rules different from the Sell‑to customer.



How Ship‑to Pricing Works


Sales Order Header


If a Ship‑to Code is selected on the Shipping and Billing FastTab:

  • The system uses the Customer Price Group from the Ship‑to Address
  • This overrides the Sell‑to Customer’s Customer Price Group


Sales Order Lines

Pricing on each line is recalculated using:

  • The Ship‑to Customer Price Group
  • The associated Bracket Group
  • The applicable Sales Price List Code

Sales Price List Code





Troubleshooting

Issue

What to Check

I cannot see this feature

Confirm the extension is installed and you have the correct permissions.

I cannot save my changes

Ensure all required fields are completed and valid.

I do not see the expected price on sale order with ship-to

Ensure the customer ship-to address has Customer Price Group assigned and sales order has a ship-to one shipping & billing tab. 

I made a mistake

Make corrections and refresh the sales order

Related Articles

  • Customer Price Groups Setup
    Set up Customer Price Groups in Business Central – Microsoft Learn
  • Sales Price Lists Setup
    Set up Sales Price Lists in Business Central – Microsoft Learn

Need More Help?

Contact your support team, help desk, customer success representative, or internal system administrator for assistance.

    • Related Articles

    • Harvest - Advanced Lot Traceability for Food- End User Guide

      Purpose The Advanced Lot Traceability for Food module brings powerful, flexible lot number assignment , enabling food and beverage processors to apply structured, traceable lot numbers without relying on rigid number series. Built on proven ...

    • Harvest - Advanced Order Processing for Food

      Multiple Sales Order Warning – End User Guide Purpose This feature adds an informational prompt in Microsoft Dynamics 365 Business Central to help users identify when multiple sales orders exist for the same customer and delivery date. It is designed ...

    • Harvest – Allergen Management for Food

      Harvest - Allergen Management for Food Overview Harvest – Allergen Management provides end‑to‑end allergen tracking and compliance capabilities across the manufacturing and inventory lifecycle in Microsoft Dynamics 365 Business Central. The extension ...

    • Harvest - Surcharge Management for Food

      Harvest - Surcharge Management for Food Overview Use Harvest - Surcharge Management for Food to automatically calculate rule-based surcharges on sales orders and sales invoices in Microsoft Dynamics 365 Business Central. Surcharges can be used for ...

    • Harvest - Back Order Management for Food

      Harvest – Back Order Management for Food – User Guide Business Problem In standard Business Central functionality, a Purchase Order remains open until all quantities are fully received and invoiced. Vendors often short ship or over ship products, ...