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
- A purchasing manager enters each vendor's minimum prepaid value and weight in Vendor Planning Prepaids.
- Buyers approve planning lines in Enhanced Planning Worksheet.
- The vendor summary and the FactBox show the amount and weight still needed for each vendor.
- 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.
Related Enhanced Planning Worksheet features
All Enhanced Planning Worksheet features →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.
