Set up automatic freight reconciliation

This procedure shows how to set up data for automatic freight reconciliation. This is typically done by a warehouse manager.

Set up the freight bill type

  1. Go to Transportation management > Setup > Freight reconciliation > Freight bill type. The freight bill type defines how freight bills and carrier invoices should be matched.
  2. Select New.
  3. In the Freight bill type field, type a value.
  4. In the Engine assembly field, type Microsoft.Dynamics.Ax.Tms.dll. This is the standard Transportation management matching engine code library.
  5. In the Engine class field, type Microsoft.Dynamics.Ax.Tms.Bll.GenericNormalizer. This is the standard Transportation management matching engine class.
  6. Select New.
  7. In the Description field, choose the value that should match on the freight bill and the carrier invoice.
  8. In the Match required field, select one of the following values:
    • Yes – The value selected in the Description field must match on both the freight bill and the carrier invoice.
    • No – The value selected in the Description field can be blank on the freight bill or the carrier invoice.
  9. Select Save.

Set up the freight bill type assignment

  1. Close the page.
  2. Go to Transportation management > Setup > Freight reconciliation > Freight bill type assignments. The freight bill type assignment is used to specify which freight bill type is used for a particular carrier.
  3. Select New.
  4. In the Mode field, enter or select a value.
  5. In the Shipping carrier field, enter or select a value.
  6. In the Freight bill type field, select the freight bill type that you created earlier.
  7. Close the page.

Set up the audit master

  1. Go to Transportation management > Setup > Freight reconciliation > Audit master. The audit master defines the tolerance limits for automatic freight reconciliation. It specifies by how much the monetary amounts on the freight bill and the carrier invoice can differ and still allow reconciliation to occur. It also defines how to handle discrepancies.
  2. Select New.
  3. In the Audit master ID field, type a value.
  4. In the Shipping carrier field, select the same shipping carrier as you did earlier.
  5. In the Freight bill type field, select the freight bill type that you created earlier.
  6. Expand the Tolerance FastTab.
  7. In the Minimum tolerance level field, enter a number.
  8. In the Maximum tolerance level field, enter a number.
  9. Expand the Result FastTab.
  10. In the Overpayment reason code field, enter or select a value. If the monetary amounts differ on the freight bill and the carrier invoice, the overpayment and underpayment reason codes specify the accounts that the difference should be registered on, as long as the difference is within the tolerance levels.
  11. In the Underpayment reason code field, enter or select a value.
  12. Close the page.