Viewing and Working with Transactions

Note: This feature requires at least one of the following modules licensed at your site:

        Chemical Inventory

        Form R Regulatory Reporting

        Tier II Regulatory Reporting

A transaction is a record of a specific product activity in your site's inventory: a receipt of a quantity of product, a transfer of a container from one location to another, a measure of a product's on-site quantity, and so on. Each transaction includes such details as when the activity occurred, which product—and how much of that product—was involved, where the activity happened, and more. Every transaction can be viewed individually or in the broader context of the product's transaction history.

Transaction Types vs. Groups / Detail vs. Summary Transactions

Each transaction belongs to a transaction type, and each transaction type belongs to a transaction group. Comply Plus provides a static set of transaction groups; these determine the effect of every transaction entered in your system. Administrators can create one or more transaction types for each group. This enables one sort of activity to have multiple types for separate treatment or categorization. Example: In the Usage transaction group, you might have two transaction types:

        One transaction type for product usages requiring certain regulatory reporting;

        A second transaction type for usages that are exempt from reporting.

Each transaction type is used for entering only detail transactions or summary transactions.

        Detail Transaction: A transaction reflecting an inventory measure or activity occurring on a specific date, often having a specific effect on a product's running balance. These can be entered for SDSs, parts, and lots. For details, see:

        SDS Detail Transactions

        Part Detail Transactions

        Lot Transactions (All lot transactions are detail transactions.)

        Summary Transaction: A transaction reflecting an inventory measure or activity occurring over a period of time. These can be entered for SDSs and parts only. For details, see:

        SDS Summary Transactions

        Part Summary Transactions

Whether a transaction type is used for detail or summary transactions is determined by its transaction group. Each group allows detail transaction types only, summary transaction types only, or both. If a group allows both, any administrator creating a transaction type within that group must select detail or summary for all of the new type's future transactions.

The following table shows all transaction groups offered in Comply Plus, including each group's representative icon, whether it allows detail and/or summary transactions, and its description and effect.

Note: If your site does not have the Chemical Inventory module licensed, you have access only to those transaction groups relevant to regulatory reporting activity.

Icon Transaction Group Detail/Summary Description and Effect

Adjustment Detail only A correction to a product balance by adding to it or subtracting from it. Positive values add to the running balance; negative values subtract from the running balance.

Average Summary only A measure of a product's average on-hand quantity during a specific period of time.

Disposal Both A disposal of a quantity of product. As a detail transaction, a Disposal subtracts from the product's running balance.

Fixed Value Detail only A correction to a product balance by replacing it with a new balance.

Maximum Summary only A measure of a product's greatest on-hand quantity during a specific period of time.

No Operation Both A record of inventory activity that indicates no change, such as an assessment confirming a product's balance is unchanged. As a detail transaction, a No Operation has no effect on a product's balance.

Physical Detail only A physically measured quantity that replaces a product's former balance.

Receipt Both A receipt of a quantity of product. As a detail transaction, a Receipt adds to a product's running balance.

Split Lot Detail only A division of a lot into multiple lots. This subtracts the new lots' balances from the parent lot's balance, and has no effect on the component product's overall running balance.

Start Lot Detail only The creation of a new lot. This defines the new lot's original balance, and has no effect on the component product's overall running balance.

Summary Summary only A miscellaneous measure of product quantity or activity during a specific time period. Administrators define the exact details and purpose of each Summary transaction type.

Transfer In Detail only A transfer of a quantity of product into a location. This adds to the product's running balance at that location. Paired with a Transfer Out transaction (see next).

Transfer Out Detail only A transfer of a quantity of product out of a location. This subtracts from the product's running balance at that location. Paired with a Transfer In transaction (see previous).

Usage Both A standard usage of a quantity of product. As a detail transaction, a Usage subtracts from the product's running balance.

Waste Both A quantity of product wasted during usage, often paired with a Usage transaction (see previous). As a detail transaction, a Waste has no effect on the product's overall running balance.

Searching for Transactions

You can search your site's entire history of transactions using the Transaction Search Center, which offers a variety of criteria for finding the transaction you seek. For details, see Searching for Transactions.

When searching for a transaction involving a specific product, consider opening that product and viewing its transaction history. This displays the desired transaction within the historical context of the product's other transactions. See the following for details:

        Viewing an SDS's Detail Transaction History

        Viewing an SDS's Summary Transaction History

        Viewing a Part's Detail Transaction History

        Viewing a Part's Summary Transaction History

        Viewing a Lot's Transaction History

When you find the transaction you seek and open it, this opens the Transaction Home page. See below for details on this page and the features it offers.

The Transaction Home page

The Transaction Home page is the first page you see when you open an individual transaction. This page shows the transaction's details (which you can edit if you have a required permissions) and links to related displays. The specific data items shown on this page are:

        Product Header: This header shows the identifying details of the product affected or measured by the transaction. This is the same header shown when you view or edit the data of a specific SDS, part, or lot, and provides links to several of the product's data areas.

        Transaction History: If a link to the product's transaction history is not provided in the product header (see previous), it is shown immediately below the header. Click this link to view the history in which the transaction appears. See one of the following for details, depending on the transaction's product and type:

        Viewing an SDS's Detail Transaction History

        Viewing an SDS's Summary Transaction History

        Viewing a Part's Detail Transaction History

        Viewing a Part's Summary Transaction History

        Viewing a Lot's Transaction History

        Transaction: The description entered when the transaction was added to your system.

        Product: The name of the product affected or measured by the transaction. Click this product's name to open its Home page. Below this name, the product's type is shown (SDS, Part, or Lot).

        Quantity: The quantity of product involved in or measured by the transaction.

        Transaction Type: The ID code and description of the transaction's type.

        Transaction Date: The date when the transaction occurred in inventory. (This may differ from the date when the transaction was entered.)

        Location: The site location where the transaction activity or measurement occurred.

        Import Row: The row of the transaction file from which this transaction was imported. (Shown only if the transaction was imported using Inventory Integration; see Inventory Integration for details.)

        Related Transaction: Click the related transaction to open its own Transaction Home page. A related transaction is shown only for transactions of the following transaction groups:

        Transfer In: The corresponding Transfer Out transaction that completes the product transfer.

        Transfer Out: The corresponding Transfer In transaction that completes the product transfer.

        Waste: The Usage transaction from which this Waste transaction was entered. If the Waste transaction was not entered from a Usage transaction (see Adding Waste Information to a Usage Transaction), a related transaction is not shown.

        Related Wastes: The descriptions and quantities of any Waste transactions entered from this Usage transaction (see Adding Waste Information to a Usage Transaction), shown only for Usage transactions. Click a related Waste's View () icon to open its own Transaction Home page.

        Attributes: The names and descriptions of any transaction attributes (additional notes or classifications) assigned to the transaction.

Transaction Features and Functions

See the following topics for details on finding, creating, viewing, and working with transactions:

        Searching for Transactions: Search your database of transactions and open the desired one.

        Entering Transactions: Use one of several methods to enter a new transaction to reflect a product inventory activity.

        Editing a Transaction: Change a transaction's description, date(s), quantity, type, and/or location.

        Adding/Removing Transaction Attributes: Add transaction attributes to—or remove them from—a transaction.

        Adding a Transaction to a Collection: Add a transaction to a collection of other transactions for easy reference and group data operations. (For details, see Collections.)

        Adding Waste Information to a Usage Transaction: Enter a new Waste transaction related to an existing Usage transaction to record the product quantity wasted during the usage.

        Deleting a Transaction: Delete a transaction, removing its effect from your inventory records.

        Inventory Integration: Enter new transactions in bulk by uploading a document containing their details.

        Threshold Lists: Define parameters to keep the quantities and activities of certain products, substances, and hazards within safe limits in your inventory.

Related Topics

        Searching for Transactions

        SDS Transactions

        Part Transactions

        Lot Transactions

        Viewing and Working with SDSs

        Viewing and Working with Parts

        Viewing and Working with Lots

        Viewing and Working with Chemicals