Accounting-Inventory
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
Quick Map - Fuel Inventory
What | Item | Storeroom |
|---|---|---|
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 quantity | FUELINVENTORY | FUELINVENTORY |
Quick Map - Other Inventory
What | Item | Storeroom |
|---|---|---|
Receive real quantity and cost into Phantom Storeroom | Maximo Part Number | OTHERINVENTORY |
Transfer the real quantity and cost into the Real Storeroom | Maximo Part Number | Correct Storeroom ex: LOCKSHOP AUTOGARAGE MACHINESHOP etc. |
Adjust the Phantom Storeroom for the interface quantity | OTHERINVENTORY | OTHERINVENTORY |
Step-by-Step
Phantom: Reconcile Balance in FUELINVENTORY > FUELINVENTORY or OTHERINVENTORY> OTHERINVENTORY
Write down current balance from portlet
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
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)
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)