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...
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...
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....
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...
Was each transaction in or out of the same binnum in that storeroom for that item?
Hello, We have a situation where we loaded an initial inventory CURBAL of 1 on an item when our location launched Maximo. the MATREC and MATUSE clearly show all transactions show the CURBAL should be 0. 5/1 - +1 - Item added via loader 6/5 - -1 - Issued to WO 6/13 - +1 - Received into inventory...
3815 Harrison AvenueCincinnati, OH 45211contact@moremaximo.com
Join CommunityInvite ColleaguesLearn MoreAbout UsTerms of Use