Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

Transportation scenario – Manual rating

Scenario

In some circumstances, rules for the calculation of transportation charges cannot be defined in advance. In this situation, companies may need to manually define the rate based on the information received from transporters/carriers.

The manually defined rate should then be recorded in the system, so that freight bills and related invoices can be matched and reconciled.

Solution

The Transportation module allows to handle manual rating for both inbound and outbound processes. The following sections illustrate the step by step procedure and required configuration to apply manual rating to outbound transportation (Sales order).

Required configuration

  • Miscellaneous charges
    • Go to Transportation management -> Setup -> General -> Miscellaneous charges
    • Create a line where Charges module is “Customer”, Charges code is FRGHT INTR, Miscellaneous charge type is “None”

Walkthrough

  1. After running rate shop in Rate route workbench, if none of the proposed rates is correct/suitable for this load, close the Rate route workbench
  2. From Load planning workbench, select the Shipping carrier to be used and the Carrier service, for example FlowerMoving
  3. Press Rating and routing -> Manual rating
  4. Routes form and Route rate details form open.
  5. In Route rate details, press New, enter rate type “Rate”, rate amount of 100,00 USD.

  6. Close the form. Refresh the Route form. . It will show Rate of 100 in Rate, while Shipper rate and Customer rate are set to Zero on the Header.

  7. Execute warehouse work (pick and put).
  8. From Load planning workbench, confirm outbound shipment.
  9. Re-open the Route. The system has maintained the manual rates and applied to Shipper and Customer the same rate.

    Shipper and Customer rate have been set to 100. The system is updating these fields during shipment.


  10. From Sales line, press Financial -> Maintain Charges à transportation charges have been allocated to sales lines.

  11. From Load planning workbench, press related information -> Freight billing invoice -> Generate freight bill invoice
  12. The invoice is generated for the amount of 100,000.
  13. Match the freight billing invoice
  14. Submit for approval
  15. Check that vendor invoice has been generated.

Comments and tips

It is not possible to overwrite rates in the Routes form after shop rate. If the rate is not marked as Manual (see the Manual checkbox in Route header), then AX will recalculate it when confirming the outbound shipment.

The only way to avoid that the rate is recalculated is to manually set it in Route rate details as a User generated rate.