Technical Blog Post
Abstract
How Does Maximo Calculate the Unit Cost of Reordered Items?
Body
Some people might think that their Unit Cost field inside their reorder PR is being wrongly populated, when they could actually be looking at the wrong fields. After accessing the Inventory application, you'll see many cost fields in the first tab (Standard Cost, Average Cost, Last Receipt Cost), which aren't considered by Maximo whenever a reorder runs.
If there is no primary vendor registered, the reordering process populates the Unit Cost from a vendor that is in the Reorder Details tab and, since it's an automatic process, the most up to date price has to be selected among those vendors, which are organized in descending order according to their Last Order Date.
The first vendor which has a Last Price that is bigger than zero is selected to populate the Unit Cost field.
In case there is no vendor (or all the vendors have no Last Order Date/Last Price) registered in the Reorder Details tab for that item, the Unit Cost will be set to zero.
Reorders and manual processes work in a different way, but you can get the same value for Unit Cost in both processes. If you insert a vendor in the PR prior to inserting the PR line, the Unit Cost will be the same as if the PR were being created by the reorder process (for that to work, the vendor must be the one with the latest Last Order Date in the Reorder Details tab). If no vendor is specified prior to the PR line insertion, the Last Receipt Cost inside the Inventory tab will be used instead of the vendor's Last Price.
UID
ibm11130835