Skip to content
Enhanced Planning Worksheet app iconEnhanced Planning WorksheetVendor planning

Vendor Prepaid Thresholds for Microsoft Dynamics 365 Business Central

Many vendors prepay freight or give better terms once an order reaches a minimum value or weight. Buyers who cannot see how close an order is to that line either miss the threshold or pad orders by guesswork.

Enhanced Planning Worksheet stores a minimum prepaid value and weight for each vendor and shows how much more value or weight the approved lines need to reach it.

How Vendor prepaid thresholds works in Enhanced Planning Worksheet

  1. A purchasing manager enters each vendor's minimum prepaid value and weight in Vendor Planning Prepaids.
  2. Buyers approve planning lines in Enhanced Planning Worksheet.
  3. The vendor summary and the FactBox show the amount and weight still needed for each vendor.
  4. The buyer adds lines, raises quantities, or holds the order until the vendor's minimum is reached.

Key capabilities

Vendor Planning Prepaids

A Vendor Planning Prepaids list holds each vendor's minimum prepaid value and minimum prepaid weight, with the vendor's currency and default purchaser code.

Amount to prepaid

The Enhanced Plan Vendor Summary compares total approved cost with the minimum prepaid value and shows the amount still needed.

Weight to prepaid

The same comparison runs on weight: total approved weight against the minimum prepaid weight, with the weight still needed.

Beside the line

The Vendor Planning Summary FactBox on the worksheet shows the same figures for the selected line's vendor, so the buyer sees the gap while deciding on a line.

Not only for distributors

Bulk raw material purchases, such as steel plate, have the same kind of minimums, so manufacturers use the thresholds too.

See Vendor prepaid thresholds on screen

Real screens from Enhanced Planning Worksheet, shown with demo data.

Details that matter on the floor

Value or weight

Some vendors set minimums by order value and some by weight. Both are tracked for each vendor.

The gap, not just the total

Showing the amount and weight still needed tells the buyer exactly how far the order is from the threshold.

Who uses Vendor prepaid thresholds

Purchasing managers

Set vendor minimums once and let buyers see progress toward them.

Buyers

Decide whether to add to an order to reach a vendor's prepaid minimum.

Supply chain analysts

Review how often orders reach vendor minimums.

Questions about Vendor prepaid thresholds

Can Business Central track vendor prepaid freight minimums?

With Enhanced Planning Worksheet, yes. Enter each vendor's minimum prepaid value and weight, and the vendor summary shows how much more the approved lines need to reach them.

Can thresholds be by weight instead of value?

Yes. Each vendor can have a minimum prepaid value, a minimum prepaid weight, or both, and Enhanced Planning Worksheet tracks the amount and weight still needed.

Where do buyers see progress toward the minimum?

On the Enhanced Plan Vendor Summary, and in the Vendor Planning Summary FactBox beside the planning lines.

Enhanced Planning Worksheet app icon

Part of Enhanced Planning Worksheet

Align Inventory with Demand and Optimize Vendor-Driven Purchasing.

Have a question about Vendor prepaid thresholds?

Send us a note and the Enhanced Planning Worksheet team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.

Ask a product question

Product Questions