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

Purchase Price list for Vendor not working on Purchase order

(5) ShareShare
ReportReport
Posted on by 14
Hi All,
 
We've just gone live for a company and have added a purchase price list for a vendor.
 
When I go to create a purchase order, the "Direct Unit Cost" is filled in with what appears to be the last direct cost, converted to EURO.
 
(We transact in AUD, this PO/Vendor is in EURO)
 
The vendor price list setup is in EURO and appears to be correctly setup. I've tried both with "Allow updating defaults" on and off tried with a start date only and with start and end date. with Min qty on 0 and 1. No dice.
 
When I go into the vendor card, and select "Purchase Prices" all the lines are showing there and active. 
 
Please see below a line from the price list:
 
Line No. Price List Code Price Status Assign-to Type Assign-to No. (custom) Product Type Product No. (custom) Description Variant Code (custom) Work Type Code Unit of Measure Code (custom) Minimum Quantity Defines Currency Code Unit Price Cost Factor Direct Unit Cost Unit Cost Starting Date Ending Date Allow Line Disc. Line Discount % Allow Invoice Disc.
10000 PPL-00004 Active
Vendor
V-000014 Item 101.6200 EVOLUTION NEON LAMP 220V     EA 0 Price & Discount EUR 0 0 1.49 0 2025-05-26 2026-01-01 True 55 True
 
Any help is much appreaciated.
I have the same question (0)
  • Suggested answer
    Shauna Langley Profile Picture
    899 Moderator on at
    Hi,
     
    Can you confirm the currency code you have specified against the vendor?
     
    Usually if this is blank then BC will use the last direct cost from the item card.  The active prices from the item card or vendor card will not limit them by currency, I believe it will show any price relating to that vendor and the price is active.
     
    For example, my vendor 30000 has a blank currency code but displaying the purchase prices from the vendor card will include EUR prices.
     
     
    Hope that helps,
    Shauna
     
     
  • Suggested answer
    Jainam M. Kothari Profile Picture
    15,810 Super User 2026 Season 1 on at
    Hello,
     
    If a purchase order isn't picking up the vendor price list in a foreign currency (like EURO), it often defaults to the last direct cost due to mismatches in setup. To ensure the correct price is applied, verify that the PO currency matches the price list, the item and vendor codes align, the unit of measure is consistent, the quantity meets the minimum requirement, and the PO date falls within the price list’s validity period. Also, confirm the price list is active and try re-adding the PO line after making changes, as updates don’t always apply dynamically.
  • CU21121511-0 Profile Picture
    2 on at
    As someone based in England, I never expected ice hockey to feel so inclusive. The matches are intense, but the camaraderie among supporters makes it special. Following NIHL UK has shown me how British ice hockey thrives on dedication, and I feel proud to be part of a community that celebrates resilience.
  • Suggested answer
    YUN ZHU Profile Picture
    99,276 Super User 2026 Season 1 on at
    Besides currency, you also need to pay attention to the unit of measurement, starting date, and Minimum Quantity.
     
    Hope this can give you some hints.
    Thanks.
    ZHU

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 March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,974 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,131 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 628 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans