This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hi ,
i found the following line in my inventory in "View inventory
transaction--> Adjustments"
Trans Type --- STDRECADJ
Quantity --- 50
Current Balance ----50
Physical Count ----- 0
even we have received a PO before and appear in the issue ant transfer
tab with quantity 50 , there is no balance at all for this item and when
i query the DB there is no records at all in the invbalances table for
this item
i never seen that beofre with MAXIMO which is very strange and i can not
give any explanation to my inventory or
financial staff
even i can not simulate the transaction again
is any body have any explanation for this transaction and its effect
we are MAXIMO 6.2 , DB sqlsserver
Thanks in Advance
> --
Samir Khodair
MAXIMO Engineer
If I understand this correctly, it sounds like:
1. The item is in a storeroom
2. The item was purchased (50 of them) for that storeroom
3. These 50 of that item were received for that storeroom
4. The 50 were issued/transferred out of that storeroom.
That would leave a correctly-reconciled Current Balance of "0" in that storeroom for that item. At that point, someone could:
1. Go to the Inventory application, select the item, and delete the entry from the Inventory Balances table window at the bottom of the main tab (that is the INVBALANCES table); and/or
2. Go to the Item Master application, select the item, and delete it from the storeroom on the Storerooms tab (at least you can in 6.x where I am; I think they've changed it a bit in 7.x).
Did that answer the question?
Travis Herron
--- In MAXIMO@yahoogroups.com, "samir_khodair2004" <s.khodair@...> wrote:
>
>
> Hi ,
>
> i found the following line in my inventory in "View inventory
> transaction--> Adjustments"
>
> Trans Type --- STDRECADJ
> Quantity --- 50
>
> Current Balance ----50
>
> Physical Count ----- 0
>
>
> even we have received a PO before and appear in the issue ant transfer
> tab with quantity 50 , there is no balance at all for this item and when
> i query the DB there is no records at all in the invbalances table for
> this item
>
>
> i never seen that beofre with MAXIMO which is very strange and i can not
> give any explanation to my inventory or
> financial staff
>
> even i can not simulate the transaction again
>
> is any body have any explanation for this transaction and its effect
>
> we are MAXIMO 6.2 , DB sqlsserver
>
> Thanks in Advance
>
> > --
> Samir Khodair
>
> MAXIMO Engineer
>
>
>
>
>
>
>
>
>
>
Hi Travis,
All what you mentioned happen except point number 4 , there is no issuance
/transfer of the item out of the inventory
Which surprise me ! and I cannot explain for the users
so i thought that the STDRECADJ caused this disappearance of the item from
the inventory balance but i could not found any document says that
On Wed, Dec 28, 2011 at 5:50 PM, Travis Herron <therron@pcci.edu> wrote:
> **
>
>
> If I understand this correctly, it sounds like:
>
> 1. The item is in a storeroom
> 2. The item was purchased (50 of them) for that storeroom
> 3. These 50 of that item were received for that storeroom
> 4. The 50 were issued/transferred out of that storeroom.
>
> That would leave a correctly-reconciled Current Balance of "0" in that
> storeroom for that item. At that point, someone could:
>
> 1. Go to the Inventory application, select the item, and delete the entry
> from the Inventory Balances table window at the bottom of the main tab
> (that is the INVBALANCES table); and/or
> 2. Go to the Item Master application, select the item, and delete it from
> the storeroom on the Storerooms tab (at least you can in 6.x where I am; I
> think they've changed it a bit in 7.x).
>
> Did that answer the question?
>
> Travis Herron
>
>
> --- In MAXIMO@yahoogroups.com, "samir_khodair2004" <s.khodair@...> wrote:
> >
> >
> > Hi ,
> >
> > i found the following line in my inventory in "View inventory
> > transaction--> Adjustments"
> >
> > Trans Type --- STDRECADJ
> > Quantity --- 50
> >
> > Current Balance ----50
> >
> > Physical Count ----- 0
> >
> >
> > even we have received a PO before and appear in the issue ant transfer
> > tab with quantity 50 , there is no balance at all for this item and when
> > i query the DB there is no records at all in the invbalances table for
> > this item
> >
> >
> > i never seen that beofre with MAXIMO which is very strange and i can not
> > give any explanation to my inventory or
> > financial staff
> >
> > even i can not simulate the transaction again
> >
> > is any body have any explanation for this transaction and its effect
> >
> > we are MAXIMO 6.2 , DB sqlsserver
> >
> > Thanks in Advance
> >
> > > --
> > Samir Khodair
> >
> > MAXIMO Engineer
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
--
Samir Khodair
IT Engineer
The STDRECADJ entry appears to be entered when there is a price change. It doesn't directly relate to the inventory balance.
For the disappearance of the 50, you should look in the Inventory Transactions --> Adjustments for a PCOUNTADJ or a CURBALADJ sometime after the 50 were received.
Travis Herron
--- In MAXIMO@yahoogroups.com, samir khodair <s.khodair@...> wrote:
>
> Hi Travis,
>
> All what you mentioned happen except point number 4 , there is no issuance
> /transfer of the item out of the inventory
>
> Which surprise me ! and I cannot explain for the users
>
> so i thought that the STDRECADJ caused this disappearance of the item from
> the inventory balance but i could not found any document says that
>
>
> On Wed, Dec 28, 2011 at 5:50 PM, Travis Herron <therron@...> wrote:
>
> > **
> >
> >
> > If I understand this correctly, it sounds like:
> >
> > 1. The item is in a storeroom
> > 2. The item was purchased (50 of them) for that storeroom
> > 3. These 50 of that item were received for that storeroom
> > 4. The 50 were issued/transferred out of that storeroom.
> >
> > That would leave a correctly-reconciled Current Balance of "0" in that
> > storeroom for that item. At that point, someone could:
> >
> > 1. Go to the Inventory application, select the item, and delete the entry
> > from the Inventory Balances table window at the bottom of the main tab
> > (that is the INVBALANCES table); and/or
> > 2. Go to the Item Master application, select the item, and delete it from
> > the storeroom on the Storerooms tab (at least you can in 6.x where I am; I
> > think they've changed it a bit in 7.x).
> >
> > Did that answer the question?
> >
> > Travis Herron
> >
> >
> > --- In MAXIMO@yahoogroups.com, "samir_khodair2004" <s.khodair@> wrote:
> > >
> > >
> > > Hi ,
> > >
> > > i found the following line in my inventory in "View inventory
> > > transaction--> Adjustments"
> > >
> > > Trans Type --- STDRECADJ
> > > Quantity --- 50
> > >
> > > Current Balance ----50
> > >
> > > Physical Count ----- 0
> > >
> > >
> > > even we have received a PO before and appear in the issue ant transfer
> > > tab with quantity 50 , there is no balance at all for this item and when
> > > i query the DB there is no records at all in the invbalances table for
> > > this item
> > >
> > >
> > > i never seen that beofre with MAXIMO which is very strange and i can not
> > > give any explanation to my inventory or
> > > financial staff
> > >
> > > even i can not simulate the transaction again
> > >
> > > is any body have any explanation for this transaction and its effect
> > >
> > > we are MAXIMO 6.2 , DB sqlsserver
> > >
> > > Thanks in Advance
> > >
> > > > --
> > > Samir Khodair
> > >
> > > MAXIMO Engineer
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
>
> --
> Samir Khodair
>
> IT Engineer
>
>
>
>