Friday, 13 November 2015

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.
Accounting Transaction:

Inventory GL Account (charge account) (20 X 0.5) = $10.00 Dr.
                Inventory Control Account (20 X 0.5) = $10.00 Cr.
 



2.            Return Previously Issued Items: -             Maximo When we hit Save button, Maximo writes a record in database table named MATUSETRANS with ISSUETYPE=RETURN, QUANTITY in Positive and LINECOST in negative.

Inventory GL Account (charge account) (20 X 0.5) = $10.00 Dr.
                Inventory Control Account (20 X 0.5) = $10.00 Cr.
 
 

No comments:

Post a Comment