Maximo Open Forum

Was each transaction in or out of the same binnum in that storeroom for that item?

Two BINs were involved but the balance should still be 0. Noted below.  The remaining balance was in BIN 055. 

5/1 - +1 - Item added via loader  (to no bin)
6/5 -  -1 - Issued to WO  (from no bin)
6/13 - +1 - Received into inventory from PO  (received to BIN 055)
6/26 -  -1 - Issues to WO  (issued from BIN 055)
6/28 -   +1 - Returned to inventory from WO  (returned to BIN 055)
7/8 -   -1 - Issued to WO  (issued from BIN 055)

Hi @Charli Sanders!

There are 3 tables: 

MATRECTRANS for receipts

MATUSETRANS for Issues

INVTRANS for adjustments

Additionally, you should keep in mind that you should only consider some types. For example, in MATUSETRANS you should not contemplate transfers if they are within the same Storeroom. 

It would be very strange if this failed on Maximo, but anything is possible.

Regards! 

As Martin has hinted, I'd check the INVTRANS table.  It could be that someone has done a Physical Count and Reconciliation, and/or a Current Balance Adjustment, that would make your CURBAL seem "off."

In the Inventory application, fetch this Inventory record, open it, choose View Inventory Transactions, and look through all three tabs.

Hi Charli.

We're missing part of the story or perhaps we're making some assumptions. I've assumed that when you said that the item was added via MXLoader, that

a) the item only existed in the Item table

b) you were adding the item to a store increasing the balance by 1

However, you only mentioned MATUSETRANS and MATRECTRANS, and has been pointed out there is also the INVTRANS.  When an item is added to the store, that transaction is going into the INVTRANS.  This is also where you set the initial balance and it will have a transaction type of INSERTITEM.  Perhaps there was a balance added at this point.

Please go back to all transactions, expand them and check where the current balance field says for each transaction.

There is another part to this story.  It's possible that when the bin was created that a balance was added.  This would result in a CURBALADJ transaction in the INVTRANS table.

All-in-all, you can simply fix this by either doing a Current Balance Adjustment transaction or go through the reconciliation process.

I would be interested in knowing what you find/do.

Regards, Craig

Principal Consultant, COSOL

#IBMChampion