Create Purchase Requisition from Inventory Usage using Action Script (Customized Option) | IBM Maximo

Recently we had the requirement to disable the direct MR to PR automation. so instead of

creating direct PR from MR, the users will select a store on material requisition to reserve material

from store. When the MR is approved, the inventory usage is created from MR.

If the material is available in-store, storeroom will issue the material otherwise he clicks the option

to create Purchase Requisition (PR) from inventory usage.

So we developed this new functionality.

Note: This script contains a few custom attributes. I have commented those line, In your case please remove them.

Step 1:

First Add new Status for Inventory Usage Application: PR_CREATED

Step 2: Create Automation Script

Launch Point:        ACTION

Object:                  INVUSE

Variable:                v_mr

Binding Value:      INVUSELINE[MRNUM is null].MRNUM*

Relations:              INVUSE --> INVUSELINE -->MRNUM (child object:MR, mrnum=:mrnum)

Default Table Data in any Applications | Maximo

Add default table data to applications such a remarks and Default GL Account to the Inventory Usage application

1. in Application designer, drag a Section, change label as "Default Table Data" or whatever your want, and change input mode as "Default"
2. copy the Control ID of main Table and paste it into Data Source ID of new section created in step 1. 

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.