Viewing stock transactions per store

View stock transactions per store. The system maintains a history of every stock transaction per store. View information such as when a specific part was received to stock, how much the part cost, and to what purchase order the part belonged.

To view stock transactions per store:

  1. Open the Stores form.
  2. Select the store for which to view stock transactions, and then click the Transactions tab.
  3. View the stock transactions. The system displays the following information for each stock transaction in the Transactions list:
    The system displays the following information for each stock transaction in the Transactions list:
    Field Description
    Type The type of transaction with which the part was associated, e.g., Stock take, Issue or return, Goods received, etc.
    Part The code of the part with which the transaction was associated
    Description The description of the Part associated with the stock transaction
    Part Org. The organization of the Part associated with the stock transaction
    Transaction Qty. The quantity of the part involved in the stock transaction. Positive quantities designate an increase in the quantity of the part in inventory, such as a receipt. Negative quantities indicate a decrease in the quantity of the part in inventory, such as an issue or return.
    Date The date on which the stock transaction occurred
    Price The price of the part the system used for the transaction
    Originator If the part transaction is an issue, the system displays the User ID of the user from whom the stock transaction originated.
    Issued To If the part transaction is an issue, the system displays the Employee code of the person to which the part associated with the stock transaction was issued.
    Class The class of the part the system used for the stock transaction
    Class Org. The organization to which the class used for the stock transaction belongs
    Transaction Number The number identifying the stock transaction
    Line The line number of the part on the stock transaction involving the part, e.g., the line number on the requisition, purchase order, work order, etc.
    Status The current status of the stock transaction involving the part
    Pick Ticket If the stock transaction was associated with a pick ticket, the system displays the number.
    Work Order If the stock transaction was associated with a work order, the system displays the number.
    Activity If the stock transaction was associated with a work order, the system displays the activity on the work order for which the part transaction occurred.
    Purchase Order If the stock transaction was associated with a purchase order, the system displays the number.
    Purchase Order Org. The organization of the purchase order associated with the part transaction
    Requisition If the stock transaction was associated with a requisition, the system displays the number.
    Supplier The supplier for the requisition associated with the part transaction
    Bin The bin involved in the part transaction. For issue transactions, the system displays the bin location from which the part is issued. For receipts, the system displays the bin location into which the part is received.
    Lot The lot of the part involved in the transaction
    Asset ID The code of the equipment associated with the transaction
    Asset Org. The organization of the Asset ID associated with the stock transaction
    Parent Work Order

    If the transaction for the store is associated with a MEC work order, then the system displays the number identifying the parent multiple equipment work order associated with the transaction.

    Note: The system enables you to search for all transactions associated with a multiple equipment work order by defining a Quick Filter using Parent Work Order as part of the filter criteria.
    Scrapped Qty. The number of repairable spare parts that were scrapped for the stock transaction
    Warranty Indicates whether the part involved in the transaction is covered under warranty
    Consignment Indicates whether the stock transaction was associated with a part under consignment
    Direct Indicates whether the stock transaction was associated with a direct purchase item received directly to a work order, purchase order, etc.