Financial Processes on Work Orders (2 of 3)

Last Updated on November 17, 2022 by maximosecrets

This is the second in a series of pages that examines the financial processes for work orders and would be applicable to Work Order Tracking and Quick Reporting applications. This page focuses on Work Order Actual Materials, specifically the transactions that create MATUSETRANS records. Direct issue Work Order Actual Material (MATRECTRANS) and Services (SERVRECTRANS) are entered in the Receiving and Invoices applications and this is where they will be covered.

This series will include:

  1. GL Defaulting on a Work Order, Labor and on Work Order Actual Labor, the LABTRANS record
  2. GL Defaulting on Work Order Actual Materials, the MATUSETRANS record
  3. GL Defaulting on Work Order Actual Tools, the TOOLTRANS record

Each page demonstrates, using examples and screenshots, how the two GL account fields, the debit GL account and the credit GL account, GLDEBITACCT and GLCREDITACCT respectively, are derived. A summary is provided at the end of each page.

This page will examine:

GL defaulting on a Work Order Actual Material record

The Work Order Tracking and Quick Reporting applications can perform both issues and returns of inventory items.

Material Issues

We will continue using work order 1338 which has a GL Account (GLACCOUNT) of 6100-200-300 defaulted entirely from the asset’s GL account field. This was demonstrated in part 1 of this series.

On the Actuals tab and Materials sub tab you can create a New Row or select multiple material records using the other three buttons. The transaction type is ISSUE and the GL Debit Account was modified in the third element, the Resource segment, from 6100-200-300 to 6100-200-200. The issue is against the CENTRAL storeroom, these storeroom issues are recorded in an object/table called MATUSETRANS. 

In Maximo, if a storeroom is not referenced, this is called a Direct Issue transaction, it applies to materials, services and tools. The item is issued directly to the work order as part of the receiving process without being checked into a storeroom and adjusting storeroom balances. You cannot perform Direct Issue transactions from the Actual – Materials tab, you always need to enter a storeroom. We will cover direct issue financial processes as part of a set of pages following the procurement financial processes.

The selected item is 4-L080 a Lockwasher.

If we navigate to the Item Master application we can see that the item belongs to the MECH commodity group.

In the Chart of Accounts application and the action Resource Codes, the commodity group of MECH has a partial GL account of ????-???-200. It is this resource code which is merged with the work order GL Account to form the GL debit account on the actual material transaction, resulting in 6100-200-200.

For the credit GL account on the work order actual material transaction, 6600-800-800, we can navigate to the Inventory application. There are two places where the inventory control account provides a default for material issues:

These fields are not normally shown, and I have unhidden them for the purpose of explaining the GL defaulting rules. In this example the Control Account has been derived from the Inventory Cost table window, the item 4-L080 has an Issue Cost Type of AVERAGE.

If the item is capitalized, the item’s Capital GL account is used for the GL Credit Account on the MATUSETRANS record. You will find that this is entered into the Inventory Cost GL Control Account (INVCOST.CONTROLACCOUNT). The Standard Cost and Average Cost will also be set to zero for capitalized items.

For an actual material transaction of type ISSUE there will be a negative quantity and a positive Line Cost.

Material Returns

Material returns can be performed by changing the Transaction Type to RETURN, selecting the item to return and the storeroom to return it to. The GL Debit Account and GL Credit Account are identical if you return the same item to the same storeroom, the GL defaulting is the same as for an ISSUE transaction.

For an actual material transaction of type RETURN there will be a positive quantity and a negative Line Cost.

Material Line Type

Maximo also allows you to record actual materials with a line type of Material. In this case you are not entering an item or storeroom, only a description of the material that was used. In this case there is no defaulting of the resource code, and the GL Debit Account will not be complete, which will require the user to use the GL Account Navigator to enter a value for the third segment of the GL Debit Account. 

The above screenshot is from the Quick Reporting application, the layout is a little different from Work Order Tracking.

An Actual Material record is saved to the MATUSETRANS object/table when you save the work order, and it cannot then be modified. GL validation is asking that you have a complete and valid GL debit account, with all segments filled in. A financial transaction can exist with a blank GL credit account.

Incidentally, when mistakes are made when entering actual materials in Work Order Tracking or Quick Reporting you cannot enter a negative quantity for either an ISSUE or RETURN transaction, but you can enter a negative unit cost. Here I have effectively reversed the previous Material line type of $10.00.

Summary – Work Order Actual Material (MATUSETRANS)

The GL account codes on work order actual materials (MATUSETRANS) entered either through Work Order Tracking or Quick Reporting can be defaulted both on the debit (blue) and credit side (mauve). This diagram only shows the material issues and returns from storerooms, and not direct issue items that follow through purchasing and receiving. 

On the debit side (GLDEBITACCT):

On the credit side (GLCREDITACCT):

On the Inventory application the control and other GL accounts are normally hidden, but if displayed they can be modified.

The debit and credit GL accounts for an ISSUE and a RETURN are identical. The difference is that:

2 responses to “Financial Processes on Work Orders (2 of 3)”

  1. Swapnil avatar

    Somehow the images are not visible and there are references to these images in the explanation. could you please fix those.

    1. maximosecrets avatar

      Hi Swapnil, I’ve checked on three devices against the original document and they are all there. If the text starts “The above screenshot…” it is referring to the screenshot above but not immediately above. Otherwise can you let me know the text where you think there is a missing image. I take it, it isn’t all 10 images? How many are missing? Regards

Leave a Reply

%d bloggers like this: