Small and medium business | Business Central, N...

Latest purchase unit price is not captured to purchase order lines

(2) Share

Report

Posted on by SC666

125

Under Business central, I maintain price list under vendor card with valid starting date and ending date. I create the purchase order but the unit price is not capturing the latest unit price under vendor card price list.

I checked under item card, unit price and I can see the latest maintained purchase unit price.

I checked under vendor card, I can see the item purchase unit price under the vendor card.

But why when I am creating the purchase order for this item, the purchase line is not detecting the latest purchase price I maintained???

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Gregory Mavrogeorgis 120 on at

Like (1)

Report
Latest purchase unit price is not captured to purchase order lines

Why this happens
Business Central only applies a price if the PO line matches the price record exactly and the price is active on your work date. If any detail is off, it falls back to other costs.
Quick things to check (in order):

Price List is active & for Purchases

Status = Active (not Draft).

Type = Purchase.

It’s assigned to the Vendor (Price List → Assignments).

Dates

Your Work Date (My Settings) sits between the price’s Start/End dates.

Exact match on the line

Vendor is the same one that price is assigned to.

Item (and Variant, if you use variants) matches.

UOM matches (e.g., price in EACH, line also in EACH—BOX vs EACH won’t match).

Currency matches the PO (or the price is blank = LCY).

Minimum Qty: your PO quantity must be ≥ Min. Qty on the price.

Timing

If you updated the price after creating the PO, the line keeps the old value until you refresh it.

How to make the PO pick it up now

On the PO line: Line → Prices → Get Price (or “Update/Recalculate Unit Price”).

If still wrong, delete the Item No. and re-select it on the line after fixing the fields above—this forces a fresh price lookup.

If you’re using the older Purchase Prices screen instead of Price Lists

Open the item’s Purchase Prices and confirm Vendor, Currency, UOM, Dates, and Min Qty are all correct, then re-enter the line or use Get Price.

Small reminder
The Item Card “Unit Price” is a sales price. For POs, BC uses Purchase Price (or Last Direct Cost/Standard Cost if no match). So it has to find a matching purchase price record to use your number.
If you want, share a quick screenshot of your price record + the PO line (showing vendor, UOM, currency, qty, dates). I’ll point out the exact mismatch in seconds.

PLEASE IF YOU FOUND IT USEFULL MARK IT AS A VERIFIED ANSWER

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 90,799 Super User 2025 Season 2 on at

Like (1)

Report

Latest purchase unit price is not captured to purchase order lines

I did a quick test and there was no problem.

Posting Date

Work Date

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
SC666 125 on at

Like (0)

Report

Latest purchase unit price is not captured to purchase order lines

Hi All,

The posting date is within the starting date and ending date.

I cannot find anything related to vendor calculation under Purchases & Payable setup.

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 4,293 on at

Like (2)

Report
Latest purchase unit price is not captured to purchase order lines

Hi,

The purchase order is not picking the latest vendor price because Business Central applies pricing based on specific conditions, not just the most recent entry. From the image and your description, here are the likely reasons:

Effective Dates
Ensure the “Order date” field falls within the Starting Date and Ending Date of the price entry. Overlapping or expired dates can cause mismatches.

Unit of Measure
The PO line’s UOM must match the UOM in the vendor price list.

Currency Code
If the vendor price list has a currency code, the PO must use the same currency.

Mark true, “Does this answer your question” if it helps.

2 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Sahan Hasitha 1,017 on at

Like (3)

Report
Latest purchase unit price is not captured to purchase order lines

hi

· Price Calculation Setup

Business Central does not automatically pull from the Vendor Card price list unless the Purchase Price functionality is enabled.

Go to Purchases & Payables Setup → check if Use Vendor-Specific Prices or the new Price Calculation Method (depending on your version) is set correctly.

· Effective Date Issue

The Purchase Order “Order Date” or “Posting Date” must fall within the Starting Date / Ending Date of the Vendor Price.

If your PO date is outside that range, BC won’t pick up that price.

· Price List Hierarchy

BC uses a hierarchy:

Purchase Prices (old method) or Price Lists (new method).

If both exist, the system may give priority to the one configured in Price Calculation Setup.

· Vendor/Item Matching

Ensure the exact Vendor No. + Item No. + Unit of Measure + Currency Code match with what is on the Purchase Price list.

Even a different UOM (like PCS vs BOX) will stop the system from applying it.

1 people found this reply helpful.

Was this reply helpful? Yes No