Read Only Fields, Attribute Restriction in Security Group – IBM Maximo

A simple way to make a field read-only is by using application designer and change Input Mode to READONLY from that specific attribute property.

But to achieve this task for a specific security group, for that we need to create a ATTRIBUTE RESTRICTION in Security Group.

1. Launch Security Groups (Goto>Security> Security Group)
2. Select a group name that you would like to change. (e.g. MAXADMIN)
3. Click on Data Restrictions tab.
4. Enter a new row for the Attribute Restriction subtab, with the desired field information.(in my example:

Object: Locations

Attribute: Description

Application: Location

Type*: READONLY --------------------- (Change the Type to read-only.)

Revaluate: Yes)

Rapid BIRT Configuration with IBM Maximo 7.6 - IBM Maximo

1 install jre-7-windows-x64.exe into C:\java\jre7
2 Extract eclipse-reporting-kepler-SR1-win32-x86_64 into C:\birt_431\eclipse


#classes folder copy
cp -R C:\IBM\SMP\maximo\reports\birt\scriptlibrary\classes C:\birt_431\eclipse\plugins\org.eclipse.birt.report.viewer_4.3.1.v201309171028\birt\WEB-INF\

# oraclethin.jar driver copy
cp C:\IBM\SMP\maximo\applications\maximo\lib\oraclethin.jar  C:\birt_431\eclipse\plugins\org.eclipse.birt.report.viewer_4.3.1.v201309171028\birt\WEB-INF\lib\

Inventory Issue and Return Transactions deep inside – IBM Maximo

With Inventory Usage application, we can Issue and Return items between sites within the same organization.      

Maximo uses the date and time to Actual Date field to determine the Financial Period for transaction. And the Actual Date field defaults to the system date and time (sysdate).

1.            Issue Items: -     When we hit Save button, Maximo writes a record MATUSETRANS table in database with ISSUETYPE=ISSUE, negative QUANTITY, and LINECOST in positive. 

Example:

                Suppose we issue 20 items at the cost of 0.5$ each from storeroom.

Find all Inventory Items with Current Balance is Less Than 1 To Reorder, – IBM Maximo

Its a simple trick to query all those record whose current balance is less or equal to 0. Its a good one to see whether we should run Reorder or not. 

Create a Save a Query with just a simple step.

1. Click on where Clause in Advanced search button, and paste given code in it and then press Save Query Button, Enter Name (for example CURR BALANCE), Description and hit Save.
2. Now Newly created query is displayed in your Action Menu. Just click on query name (CURR BALANCE in my case). 

inventoryid in (select inventory.inventoryid

from inventory

inner join invbalances

on inventory.siteid = invbalances.siteid

and inventory.itemnum = invbalances.itemnum

and inventory.itemsetid = invbalances.itemsetid

and inventory.location = invbalances.location

and invbalances.curbal < 1)

Inventory Item, Current Count vs Physical Count. – IBM Maximo

Physical Count:

Physical count is what we actually have in our Storeroom/Inventory physically with specified date when we counted.

Current Balance/Count:

Current balance is what our inventory system is shown. 

If both are not same, then reconciliation should need to be done, so that they both counts will sync with each other.

For that, a two steps are needed in Maximo Inventory,

1. Open required inventory item, Action  > Inventory Adjustment > Physical Count and enter New Count