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...
Answered

Purchase Order Unit Cost Autopopulate

(0) ShareShare
ReportReport
Posted on by 105

Hi MS Community,

My purchasing team has a habit of not checking/editing the unit cost at the time of purchase order line creation because the system feature that auto-populates the unit cost. We fix the unit cost on the back end after the QTY receipt has been posted and invoice is ready to be posted. To be pro-active and avoid this issue going forward, is there a way to turn off auto-populate of the unit cost of an item when creating a new purchase order line?

In addition, is there a reason why this should not be turned off? One scenario I can think of is if the buyer forgets to input anything at all and left the unit cost box blank. If so, is there a way to flag a blank unit cost input box, like a warning window or block window?

Thank you in advance!

  • Suggested answer
    JAngle Profile Picture
    159 on at

    Setup a purchase price of 0. This is quicker to do with the new price experience - check feature management to see what you have enabled.

    Use an approval workflow and verify the amount including taxes is above 0. Status of an order must be released for it to accept a posting.

  • Suggested answer
    MahGah Profile Picture
    15,613 on at

    Hi

    We had the same issue. This is what we did to fix it.

    First, we could not find a way to turn off auto-populate unit cost. If you know the way please share here.

    But what we did

    1) For item with multiple vendor we made sure to setup a purchase price for each vendor.

    2) We realized "unit cost" goes wrong because of cycle count (item journal as an example). We made minor development that runs through Job Queue every night and update the Last Direct Cost based on the last Invoice. This way even if price cost change because of inventory transaction it gets updated to the last invoice.

    All that being said, we still only solved 85% of the issue. If price has changed and purchaser does not change the price in PO still you will have the issue.

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    14,306 Super User 2026 Season 1 on at

    Agree with what Josh said.

    Setup a purchase price with zero cost. Then turn on approval for zero amount.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 755 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 413 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 387 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans