web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Latest purchase unit price is not captured to purchase order lines

(3) ShareShare
ReportReport
Posted on by 266
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???
I have the same question (0)
  • Suggested answer
    Sahan Hasitha Profile Picture
    2,683 on at
    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.

     
  • Suggested answer
    Sumit Singh Profile Picture
    11,795 Super User 2026 Season 1 on at
    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:
    1. 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.
    2. Unit of Measure
      The PO line’s UOM must match the UOM in the vendor price list.
    3. 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.
  • SC666 Profile Picture
    266 on at
    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.
  • Suggested answer
    YUN ZHU Profile Picture
    101,162 Super User 2026 Season 1 on at
    I did a quick test and there was no problem.
    Posting Date
    Work Date
     
    Hope this helps.
    Thanks.
    ZHU
     
  • Grigorios Mavrogeorgis Profile Picture
    1,720 Super User 2026 Season 1 on at
    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):
    1. Price List is active & for Purchases
      • Status = Active (not Draft).
      • Type = Purchase.
      • It’s assigned to the Vendor (Price List → Assignments).
    2. Dates
      • Your Work Date (My Settings) sits between the price’s Start/End dates.
    3. 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.
    4. 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
  • Suggested answer
    Rishabh Kanaskar Profile Picture
    6,227 Super User 2026 Season 1 on at
    This usually happens because Business Central uses Purchases Price List (Item Vendor Catalog) logic, not just what’s on the Vendor Card or Item Card. The system determines the price based on a hierarchy and only applies it if certain conditions match.
     
    Key reasons why the latest price might not be picked up:
    > Price List Setup – Make sure the price list is active, has a status of Active, and the validity date covers the PO order date.
    > Direct Unit Cost on Item Card – If you have a cost defined directly on the Item Card, BC may use that instead of a price list if the price list setup is not fully valid.
    > Line Discount / Price Calculation Method – Check that "Price Includes VAT," "Currency Code," and "Variant Code" match the PO. Any mismatch can cause BC to skip the price list.
    > Purch. Prices vs Purch. Discounts Table – Make sure you’re editing the Purchase Prices table, not only the old fields on Vendor Card (those are mostly legacy and don’t drive pricing in modern BC).
    > PO Date – Ensure your PO Posting Date / Order Date falls within the Valid From–Valid To range of the price record.
     
    Solution:
    > Use Purchase Price Lists (Search → Price Lists) instead of relying on vendor card fields. Create a Purchase Price List for the vendor, add the item, set valid dates, and activate it. Then BC will automatically pick the price when you create a PO line.
     
    Thanks
    Rishabh

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,138 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,279 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,192

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans