Create and save process flow queries

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

You can create queries that include selected processes, substances, and substance categories. These queries can be used to display a graphical representation of processes, substances, and substance categories in the Process map form. The queries that you create can contain one or more processes, substances, or substance categories. You can define the appropriate information for each query by specifying criteria such as the type of process or substance category.

You can create four types of process map:

  • Model – Display processes and their process references, but no flow data.

  • Substance flow – Display processes and the aggregate flows between them.

  • Budget – Display processes and the aggregate budget flows between them.

  • Budget comparison – Display processes and a comparison of the actual and budgeted flows between them.

For example, you want to create a model query that displays the usage of electricity and natural gas in all the Site 1 locations in the organization. Electricity and natural gas are indirect energies. In the query, you include the following elements for processes, substances, and substance categories.

Filter

Query elements

Processes

Site 1-Main warehouse

Site 1-Quaratine warehouse

Site 1-Transit warehouse

Site 1-Vendor warehouse

Substances

Electricity

Natural gas

Substance Categories

Indirect energy

Create a query

  1. Click Compliance and internal controls > Common > Environmental sustainability > Environmental processes > Environmental process maps.

  2. Click New. Enter a name for the query and a brief description of the information that is included in the query.

  3. Select the model type of the query, and then click Query.

  4. In the Process map filter form, enter the date range for the query, if a date range is appropriate.

  5. Select among the available processes, substances, and substance categories to create the query that is used to display information in a process map. Then click Close.