Inventory is ordered in PeopleSoft ePro.  Once an invoice is received for materials, a receipt is created in Maximo automatically via a nightly batch process.  If the materials are being purchased for inventory they have to go into a central bucket since PeopleSoft purchasing does not use Inventory or part numbers.  This is done to accurately calculate the average cost per item for billing for our services.

Processes used to adjust inventory that has come in via the interfaces and now needs to be transferred to the correct storeroom at the correct average price:

  • View Inventory Transactions from the interface
  • Inventory Adjustments
    • Current Balance
    • Average Cost
  • Transfer Current Item
  • Adjust Phantom to account for transactions completed

Image of Inventory Menu


Quick Map - Fuel Inventory

WhatItemStoreroom
Receive real quantity and cost into Phantom Storeroom

UNLEADED

or

DIESEL

FUELINVENTORY
Transfer the real quantity and cost into the Real Storeroom

UNLEADED

or

DIESEL

GASOLINE
Adjust the Phantom Storeroom for the interface quantityFUELINVENTORYFUELINVENTORY


Quick Map - Other Inventory

WhatItemStoreroom
Receive real quantity and cost into Phantom StoreroomMaximo Part NumberOTHERINVENTORY
Transfer the real quantity and cost into the Real StoreroomMaximo Part Number

Correct Storeroom

ex:

LOCKSHOP

AUTOGARAGE

MACHINESHOP

etc.

Adjust the Phantom Storeroom for the interface quantityOTHERINVENTORYOTHERINVENTORY


Step-by-Step 

  • Phantom: Reconcile Balance in FUELINVENTORY > FUELINVENTORY or OTHERINVENTORY> OTHERINVENTORY
    • Write down current balance from portlet

Image of Inventory Portlet

    • Go to FUELINVENTORY > FUELINVENTORY OR OTHERINVENTORY > OTHERINVENTORY
    • View Inventory Transactions
    • Set Filter Received = 0
    • Download

Image of Inventory View Transactions Not Processed

    • Add Quantity in Excel
    • Quantity must = Current Balance
    • Select a transaction that has not been processed (Received toggle is to the left)
    • Find the actual invoice for the transaction.
    • Figure out the quantity purchased in the appropriate unit of measure.  This may come from the “paper” invoice.
    • Figure out the unit price.  You may need to use the “paper” invoice to figure this out since the quantity for blanket PO’s is not in the transaction.


  • Lies: Go to the Lies with Real Part #, Phantom Storeroom (e.g., UNLEADED or DIESEL > FUELINVENTORY or PN008087 > OTHERINVENTORY)
    • Don’t forget to Change the view to All Records
    • Verify the Current Balance = 0

Image of Inventory Lies


    • Inventory Adjustment > Average Cost
    • Enter the unit price calculated above in the New Average Cost (Don’t worry if there’s an existing Average Cost in this Phantom storeroom, the quantity must be zero so it calculates to zero)

Image of Average Cost Adjustment

    • Click Ok
    • Inventory Adjustments > Current Balance
    • Current Balance must be 0.00, if it is not someone did something wrong previously.
    • Enter New Balance as the Quantity that was invoiced (remember the quantity may not be the balance in the Phantom Inventory – you may have to calculate, see above

Image of Inventory Current Balance Adjustment

    • Click Ok


  • Reality: Transfer Current Item > This is what move the part into “Reality.”
    • Enter the actual quantity received from above.
    • Enter the “real” Storeroom.
    • Make sure the conversion factor says 1 (this will come in when you enter the storeroom)

Image of Inventory Transfer Current Item

    • Click on Ok


  • Phantom: Reduce the quantity in the Phantom Part # and Phantom Storeroom
    • Go Home
    • Click on the Item and Storeroom you are working on in the Central Inventory portlet
    • Inventory Adjustments > Current Balance
    • Change the New Balance to Current Balance – Quantity from the Phantom Transaction you just took care of (remember this may NOT be the quantity you used for the Lies and Reality, it won’t be for the blanket POs)
    • Click Ok
    • View Inventory Transactions
    • Open the ^ next to the transaction and click ONE TIME ONLY on the button to Toggle the Reception Status (a.k.a. done)

Image of View Inventory Transactions


Image of Inventory Toggle Reception Status

  • No labels