web
You’re offline. This is a read only version of the page.
close
Skip to main content
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!

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    125 on at
    RE: Purchase Order Unit Cost Autopopulate

    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,529 on at
    RE: Purchase Order Unit Cost Autopopulate

    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,241 Super User 2025 Season 2 on at
    RE: Purchase Order Unit Cost Autopopulate

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

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

#1
Sumit Singh Profile Picture

Sumit Singh 2,179

#2
OussamaSabbouh Profile Picture

OussamaSabbouh 1,999

#3
YUN ZHU Profile Picture

YUN ZHU 1,892 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans