Skip to main content

Notifications

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

Purchase Order Unit Cost Autopopulate

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
    TeddyH Profile Picture
    TeddyH 12,868 Super User 2024 Season 1 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.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 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
    JAngle Profile Picture
    JAngle 33,159 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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans