You’re offline. This is a read only version of the page.
Skip to main content
Dynamics 365 Community
Cancel
Forums
Products
Finance
Business Central
Sales
Supply Chain Management
Customer Insights - Journeys
Customer Service
Field Service
Human Resources
Commerce
Project Service Automation
Customer Voice
Guides
Customer Insights - Data
Project Operations
Remote Assist
Fraud Protection
Intelligent Order Management
Product Visualize
Dynamics 365 general
Previous versions
Microsoft Dynamics GP
Microsoft Dynamics SL
Microsoft Dynamics NAV
Microsoft Dynamics AX
Microsoft Dynamics CRM
Microsoft Dynamics RMS
Dynamics Business Central migration
Microsoft solutions
FastTrack for Dynamics 365
Outbound to Real-Time Transition
Power Platform integration
Blogs
Community blog
Dynamics 365 blogs
User groups
Galleries
Ideas
Resources
Getting started
Community news
Leaderboard
Learn
Community support
Community events
Community feedback
FastTrack
TechTalks
Blogs
FastTrack forum
Outbound to Real-Time Transition forum
Partner case studies
Implementation guide
More
Search
Notifications
Announcements
No record found.
Dynamics 365 Community
/
Blogs
/
Streamlining Operations with D365FO and Power P...
/
Transportation management i...
Transportation management in Dynamics 365 Finance and Operations (D365FO)
mallesh varma
190
Follow
Like
(
0
)
Share
Report
Transportation management in Dynamics 365 Finance and Operations (D365FO) involves a set of processes and features designed to manage and optimize the transportation of goods. It includes functionalities for planning, executing, and monitoring transportation activities, as well as handling freight invoice reconciliation. Here’s an overview of how D365FO handles transportation management and freight invoice reconciliation:
Transportation Management Overview
Key Features:
Transportation Planning
: Helps in planning and optimizing transportation routes, consolidating shipments, and scheduling deliveries.
Carrier Management
: Manages relationships with carriers, including contract management, performance tracking, and rate agreements.
Load Planning
: Optimizes the loading of goods into transportation vehicles to maximize efficiency and reduce costs.
Execution
: Facilitates the execution of transportation activities, including shipment tracking and management.
Cost Management
: Tracks transportation costs, including freight, handling, and other related expenses.
Freight Invoice Reconciliation
Overview:
Freight invoice reconciliation ensures that the charges billed by carriers match the agreed-upon rates and the actual transportation services provided. This process helps in verifying and validating freight invoices before making payments.
Transportation management
in Dynamics 365 Finance and Operations (D365FO) involves configuring various setups to manage and optimize the movement of goods. Below is a comprehensive list of the essential setups in D365FO for transportation management.
Define global settings that control various aspects of transportation management, such as integration, default settings, and system behavior.
TMS > Setup > Freight Reconciliation > Billing group
the
Billing Group
setup under the Freight Reconciliation section of the Transportation Management System (TMS) is used to group similar billing lines together for the purpose of freight reconciliation and invoicing. This setup helps in organizing and categorizing billing information, making it easier to manage and reconcile freight costs.
TMS > Setup > Freight Reconciliation > Freight Bill type
The
Freight Bill Type
setup under the Freight Reconciliation section of the Transportation Management System (TMS) is used to categorize and define different types of freight bills. This setup helps in managing and processing various freight-related invoices received from carriers, facilitating accurate tracking, reconciliation, and payment of transportation costs.
TMS > Setup > Freight Reconciliation > Freight Bill assignments
the
Freight Bill Assignments
setup within the Freight Reconciliation module of the Transportation Management System (TMS) is used to link specific criteria to freight bill types for accurate categorization and management. This setup helps ensure that incoming freight bills are assigned to the correct freight bill types based on predefined conditions, facilitating efficient reconciliation and accounting processes.
TMS > Setup > Freight Reconciliation > Reconciliation reasons
The
Reconciliation Reasons
setup under the Freight Reconciliation section of the Transportation Management System (TMS) is used to define and manage the reasons for discrepancies that may arise during the freight reconciliation process. These reasons help categorize and explain differences between the expected freight costs and the actual charges billed by carriers. This setup is crucial for audit trails, financial accuracy, and process improvement.
TMS > Setup > Freight Reconciliation >Audit masters
The
Audit Masters
setup under the Freight Reconciliation section of the Transportation Management System (TMS) is used to define the audit parameters and criteria for auditing freight transactions. This setup helps organizations maintain an audit trail for freight-related activities, ensuring compliance, accuracy, and accountability in the freight reconciliation process.
TMS > Setup >Carriers > Shipping carriers
Specify the types of services offered by carriers (e.g., standard shipping, express delivery), Define the type of service provided by each carrier
Creating a sales order and releasing it to the warehouse in Dynamics 365 Finance and Operations (D365FO) involves several steps. Here's a high-level overview of the process:
Go to
Modules
>
Sales and marketing
>
Sales orders
>
All sales orders
.
With the sales order still open, navigate to the
Warehouse
tab in the action pane.
Click
Release to warehouse
.
In the
Release sales order to warehouse
dialog box:
Click
OK
to release the order to the warehouse.
Work Creation
: A work order is created for the warehouse workers to pick, pack, and ship the items.
Picking
: Warehouse workers will pick the items from the specified locations.
Packing and Shipping
: Items are packed and shipped according to the specified shipping method.
To view the load details associated with a sales order in Dynamics 365 Finance and Operations (D365FO)
Loads>Transportation > Rate route Workbench
In Dynamics 365 Finance and Operations (D365FO), the
Rate Route Workbench
is a feature within the Transportation Management System (TMS) used to determine the best routing and shipping rates for loads. This tool helps logistics and transportation managers optimize shipping decisions based on cost, transit time, carrier preferences, and other criteria.
To assign a carrier and rate to a load using the
Rate Route Workbench
in Dynamics 365 Finance and Operations (D365FO)
Following form opens.
Completing work in the warehouse in Dynamics 365 Finance and Operations (D365FO) involves finalizing various warehouse processes such as picking, packing, and shipping items associated with a sales order or load.
Complete the outbound shipment in Dynamics 365 Finance and Operations (D365FO), and update the load status from "Loaded" to "Shipped,"
Now, sales order has automatically freight charges
Freight charges codes setup:
Managing the
freight bill
involves creating and processing freight invoices associated with loads. This process ensures that the costs incurred for transportation are accurately recorded and billed. Here’s how you can handle freight bills via loads
Reconciliation process:
In Dynamics 365 Finance and Operations (D365FO), you have two main methods for handling carrier invoices that you receive:
Importing Carrier Invoices via Data Entities
Manual Entry into the System
You can handle carrier invoices in D365FO either by importing them through data entities, which is efficient for bulk processing, or by manually entering the details into the system for individual invoices. Both methods ensure that freight costs are accurately recorded and managed in the system.
Give the Invoice Number
Freight Invoice form can be seen under the TMS > Inquiries and reports.
Change the price If the carrier charges are different, I have changed the price 1520$ to 1550$
Enable the check mark for automatic matching.
Navigate to the Batch jobs.
Batch job is running. (System administrator> Inquiries and reports > Batch Jobs)
Batch running was successfully.
The workflow status changes it gives the details amounts matched and amounts reconciled.
Manual process
Click on the match freight Bills and Invoices
The invoice which we received from the carrier doesn’t match the amount we estimated.
Select the both the lines and click on the match.
Submit for the approval.
Not matched amount
Un select the Hide approved and check the Invoice details.
Invoice Journal
Each step involves specific actions and processes to ensure that transportation and logistics are handled efficiently and accurately.
Comments
Add new comment
Comment on this blog post
You don't have the appropriate permissions.
Welcome,
Profile
Messages
My activity
Sign out