Purchase Order Unit Cost Autopopulate

(0) Share

Report

Posted on by BobbyHelp

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!

All responses (3)

Answers (0)

Suggested answer

TeddyH 12,868 Super User 2024 Season 1 on at

Like (0)

Report

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 15,428 on at

Like (0)

Report

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 33,159 on at

Like (0)

Report

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.