Set up a Reconciliation Template

Security Note: You need the Allow TW reconciliation maintenance security right in the Reconciliation user group security rights group for this activity.

Activity Steps

1. Select the Supply Chain panel in the Solution Explorer.
2. Expand the Reconciliation node.
3. Right-click a reconciliation category and select New Reconciliation Template from the menu.

   The Reconciliation Template displays.

4. Update the Name if required.
5. Complete the following fields.
   • Duration—Duration of the reconciliation template, in the nominated time period. This is the reconciliation period in which transactions into stockpiles at the collection of locations are used in the reconciliation (that is, for determining stock inputs and outputs, or for adjusting transactions in those process flows that flow into the collection of locations), in the selected period, from a predefined list: Days, Months and Years.
   • Default Start Time—Default start time in the day for a reconciliation performed using this reconciliation template.
6. To add a location to the reconciliation template:
   1. Right-click in the Locations field group and select Add from the menu.
   2. Expand the Business Areas tree and select the location.
   3. Select the Recon Type for the location.
      • Adjust—When the discrepancy is calculated for a reconciliation, adjustments are made to the stockpiles containing the defined products, brands and waste materials within the collection of business area locations specified for the reconciliation.

        No process flows display as they are not used for this type of reconciliation.

      • Factorise—When the discrepancy is calculated for a reconciliation, adjustments are made to the stockpiles containing the defined products, brands and waste materials within the collection of business area locations specified for the reconciliation, and adjustments are made to all the transactions that occurred within the reconciliation period, for all the products, brands and waste materials involved in the reconciliation. The discrepancy is shared, or factorised, between all the stockpiles on the end of the defined process flows, according to the defined Weight % for each process flow.

        Any process flows into the location are automatically added to the process flow table; if any additional process flows into the location are created at a later date, they can be dragged into this table from the Solution Explorer.

      Editable only if products have not been specified for the location in the reconciliation template.

   4. To add products for the location in the reconciliation template:
      1. Right-click in the Products field group and select Add from the menu.

         Note: If any products have been entered for the location, the Recon Type cannot be altered.

      2. Expand the Product Categories or Brand Categories tree and select the product or brand.
   5. If the Recon Type for the location is Factorise, to add a process flow for the product of the location in the reconciliation template:
      1. Right-click in the Process Flows For Selected Product field group and select Add from the menu.
      2. Expand the Process Flow Categories tree and select the process flow.

         Select from the process flows defined on the Supply Chain panel of the Solution Explorer.

         The process flow source or destination must match the reconciliation location.

      3. Update the Weight by which the process flow's transactions are to be proportionally adjusted.

         This is the confidence level used in adjusting tonnages in all transactions occurring within the defined reconciliation period, such that 0% would induce no transaction tonnages to be adjusted, and the higher the weight, the more the discrepancy is applied to the stockpile. For example, the movement of stock from one particular stockpile into the reconciliation location may incur greater loss of material in the stock movement compared to the movement of stock from another stockpile into the reconciliation location; making it more likely that any discrepancy would only involve stock from that stockpile.

7. If more than one location is defined, update the sequence to reflect the order in which the locations are to be reconciled.
8. Click Save.