Rule - to be updated as a rule for each reconciliation type

The Reconcile Data process uses a rule to extract the data that will be reconciled.

A ReconData rule will need to be created for each reconciliation type to be processed. This rule contains a query that generates the data to be reconciled.

ReconData Rule

The table below details the contents of the ReconData rule. Refer to the Rules topic for information on how to manage rules.

Rule	Description
Name	The name must be set to ReconData_xxxxxxx, where xxxxxxx is the code of the reconciliation type to be processed. For example ReconData_Survey when reconciling surveyed material movements. Note: There must be one of these for each reconciliation type to be processed, as the data required for each reconciliation may be different.
Module	The module must be set to VolumeManagement.
XLM Query	The XLM Query to extract the data to be reconciled.

Rule

Description

Name

The name must be set to ReconData_xxxxxxx, where xxxxxxx is the code of the reconciliation type to be processed. For example ReconData_Survey when reconciling surveyed material movements.

Note: There must be one of these for each reconciliation type to be processed, as the data required for each reconciliation may be different.

Module

The module must be set to VolumeManagement.

XLM Query

The XLM Query to extract the data to be reconciled.

The table below details the structure of a query assigned to a ReconData rule to reconcile surveyed material movements. The rule would be called ReconData_Survey. Use Query Builder to preview the rule and make any required changes.

Note: The query must contain the mandatory named filter and the mandatory named outputs.

Rates Execute Results	Description
Table	To reconcile material movements the this would be set to the Load & Haul table.
Filters
Date	The filter must be named Date. The date range is used to filter the data by the selected period.
Location Group Code	Optional filter to be used to filter in (or out) transaction assigned to specified location groups.
Outputs
Haul Id	This output must be named ID. This is the unique id of the individual movement record that the reconciled value will be stored against.
Date	This output must be named Date. This is the date that the movement took place.
Source Code	This output must be named Source. This is the location the movement was moved FROM
Destination Code	This output must be named Destination. This is the location the movement was moved TO.
Haul Volume	This output must be named Value. Sum is set as the aggregation for this field. This is the actual volume that is hauled.
Haul Loads	This output must be named Loads. Sum is set as the aggregation for this field. This is the number of loads for the volume moved.
Material Type Code	This output must be named MaterialType. This is the material type of the movement.

Rates Execute Results

Description

Table

To reconcile material movements the this would be set to the Load & Haul table.

Filters

Date

The filter must be named Date. The date range is used to filter the data by the selected period.

Location Group Code

Optional filter to be used to filter in (or out) transaction assigned to specified location groups.

Outputs

Haul Id

This output must be named ID. This is the unique id of the individual movement record that the reconciled value will be stored against.

Date

This output must be named Date. This is the date that the movement took place.

Source Code

This output must be named Source. This is the location the movement was moved FROM

Destination Code

This output must be named Destination. This is the location the movement was moved TO.

Haul Volume

This output must be named Value. Sum is set as the aggregation for this field. This is the actual volume that is hauled.

Haul Loads

This output must be named Loads. Sum is set as the aggregation for this field. This is the number of loads for the volume moved.

Material Type Code

This output must be named MaterialType. This is the material type of the movement.

Note: Every location that is part of the query must be assigned to a Location Group that has been assigned to a Reconciliation Group.