IBM Support

How Does Maximo Calculate the Unit Cost of Reordered Items?

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.

image

 

 

 

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.

image

 

 

 

The first vendor which has a Last Price that is bigger than zero is selected to populate the Unit Cost field.

image

 

 

 

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.

image

 

 

 

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.

[{"Business Unit":{"code":"BU005","label":"IoT"}, "Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11130835