Scientific Logistics
- Megan Stanage (Unlicensed)
- Megan Stanage
Transport + Deliver's built-in activity optimization functionality is limited; therefore, Transport + Deliver has integrated with Scientific Logistics (Sci-Log) to perform more robust and flexible activity optimization.
Sustainability: Reduce Transportation
Use this modern route optimization solution to:
- Reduce transportation costs—decreasing routes and miles by 5%-20%.
- Shrink planning effort and cost, easily doubling the number of routes that can be managed by each route planner.
See Sustainability with Supply Chain Cloud for more information.
Setup
Azure Setup
D365 F&SCM Setup
System administration > Setup > Azure Active Directory applications
- Enter the Client ID ("Application ID" in Azure).
- Enter a Name for description purposes.
Select a User ID to tie this connection to.
Note
Avanade recommends selecting Admin as long as the Admin user has Transport + Deliver roles assigned and the following user configurations set up:
- System Administrator: Role assigned.
- Worker Operation Profile: Created for the operation(s) that will expect the activity back from Sci-Log.
- Company: Must be the same company that will receive data back from Sci-Log. (If Admin user must remain in a different company, you must create/use a different user on the Azure Active Directory Application.)
Logistics Execution > Setup > Parameters > Activity Optimization
| FIELD | DESCRIPTION |
|---|---|
| Activity Optimization Service | Select Scientific Logistics to route optimization requests externally to Sci-Log and have them returned to Transport + Deliver using the configured URLs. |
| Activity Optimization Service URL | This URL is provided by Sci-Log and is used to send optimization requests. |
| Activity Optimization Key | This is the authorization key provided by Sci-Log to authenticate optimization requests. Note Sci-Log refers to this as "credential." |
| Optimized Activity Build Service URL | The first of three return URLs you provide for Sci-Log to connect to when sending data back to Transport + Deliver. Replace "xxx" with the D365 F&O URL: "https://xxxx/api/services/LEXSciLogExternalDataServices/LEXSciLogExternalDataService/buildActivities" Note Sci-Log refers to this as "orders." |
| Optimized Activity Update Service URL | The second of three return URLs you provide for Sci-Log to connect to when sending data back to Transport + Deliver. Replace "xxx" with the D365 F&O URL: "https://xxxx/api/services/LEXSciLogExternalDataServices/LEXSciLogExternalDataService/updateActivities" |
| Customer Return Service URL | The third of three return URLs you provide for Sci-Log to connect to when sending data back to Transport + Deliver. Replace "xxx" with the D365 F&O URL: "https://xxxx/api/services/LEXSciLogExternalDataServices/LEXSciLogExternalDataService/processOptimizationWebRequests" |
| Note Type | Select the logistics order note type to send to Sci-Log. |
Activity Optimization
Logistics Execution > Common > All Logistics Orders
To send logistics orders to Sci-Log, select the desired orders on the All Logistics Orders list page and click Send to Optimization Engine.
After Sci-Log is finished optimizing the orders, it returns the routes to Transport + Deliver.
Transport + Deliver creates activities and automatically pairs the logistics orders in the specific order designated by Sci-Log.
Note
This flow is used when you desire to have Sci-Log build activities. Sci-Log can additionally optimize activities that have already been built.
Logistics Execution > Common > Load Building Workbench
To optimize individual activities from the Load Building Workbench, click Optimize Route.
This sends the activity details to Sci-Log to be optimized.
To optimize activities in batch, configure the Send Orders for Optimization periodic job.
Any records in the Records to include query are sent to Sci-Log for optimization.
To optimize stops in batch, configure the Send Stops for Optimization periodic job.
Parameters
Turn on the toggle for an order type(s) to allow the Records to include to be edited and to send the customers, vendors, and/or warehouses as stops to Sci-Log.
Sci-Log will then recognize these stops when optimizing orders and route accordingly.
Important
All records from D365 are sent to Sci-Log if you send stops with the Records to include queries wide open. This can result in performance issues.
If you plan to send stops, make sure the appropriate queries are filtered.
Troubleshooting
Additional D365 Environments on the Same Sci-Log Connection
You can have multiple D365 F&SCM environments pointing to the same Sci-Log connection.
To do this, you must have a new Azure application registration for each environment.
- Provide your Azure application credentials to Sci-Log:
- Authentication URL for Azure AAD: https://login.microsoftonline.com/DIRECTORYTENANTID/oauth2/token
- This stays the same because the Tenant ID does not change.
- Resource: Environment URL
- Client ID: Application ID ("Client ID" in D365 F&SCM)
- This should be different for each environment.
- Azure Secret Value: Value of client secret
- Authentication URL for Azure AAD: https://login.microsoftonline.com/DIRECTORYTENANTID/oauth2/token
- Update the Azure Active Directory applications form with the proper Client ID.
- Make sure the selected User ID on the Azure Active Directory applications form has proper Transport + Deliver roles.
- Update the URLs in the Activity Optimization section of Transport + Deliver Parameters.
"There was an error sending the data."
This indicates there is an incorrect connection. Double-check all your connection configurations.
"Worker not found for user Admin."
Integrations tie functionality to the Admin user so that it's not tied to a personal user that can quit.
Make sure your Admin user has a Transport + Deliver worker tied to it on the Azure Active Directory applications form (System administration > Setup > Azure Active Directory applications).