This document explains how you download, upload, and display operational planning data.
Deliveries are selected and downloaded to an interface layer. An external system, such as a route optimization system, can retrieve the deliveries and replan them. They can then be uploaded to M3 BE by the route optimization system and the changes will update the M3 core tables.
Start 'Delivery. Open Toolbox' (MWS410). To download the selected delivery, select option 54='Download'.
It can be added to an existing message with other downloaded deliveries, or it can create a new message.
On the (MWS410/F) panel, you can display the integration status and message number for the downloaded delivery.
Start 'Delivery. Open Toolbox' (MWS410).
Prepare you selection of deliveries using F17.
Refine your selection by using option 22='Select/Deselect' to further exclude or re-include deliveries.
Press F11 Download all deliveries.
On the (MWS410/L) panel, choose the partner as defined in (MMS865). Select an existing message to add the deliveries with other downloaded deliveries, or let the message number blank to create a new message. Click Next.
On the (MWS410/F) panel you can display the integration status and message number for the downloaded deliveries. One or several messages may have been created; depending on the partner setup and the deliveries in the selection, deliveries have been downloaded into one message per warehouse or one message per place of load.
This method is only valid for a partner setup with the Download delivery field set to 1-' Yes per warehouse', or 2-'Yes per place of load'.
(MYS410) is used to select deliveries for downloading. Different criteria such as warehouse, date, and dispatch policy, can be specified. To simplify when the same selection criteria is used every time, you can define a selection set (MYS411).
Start 'Delivery. Select Downloads' (MYS410/E). Select the partner (a valid partner, in (MMS865)) and warehouse. You can also specify a selection set. Press F4. 'Selection Sets. Define' (MWS411) is started. Define a selection set on the B panel.
Open the (MWS410/F) panel.
Values on this panel will be retrieved from the selection set (MYS411) if a selection set is specified on the E panel. Otherwise, there will be no values in the entry fields. On the F-panel, you can also override values that were retrieved from the selection set.
Press Enter. The download delivery is created.
This method is only valid for a partner setup with Download delivery field set to 1-'Yes per warehouse'.
The M3 Job Scheduler allows standard M3 reporting or batch functions to run automatically according to a schedule. This function can be used for automatic downloads.
These steps provide an overview of the workflow for setting up job scheduling and running the schedule:
Define job scheduling category in 'Job Schedule Category. Open' (SHS050)
Define job scheduling function in 'Job Schedule Function. Open' (SHS030)
Define job scheduling programs in 'Job Schedule Program. Open' (SHS031)
Define job scheduling fields in 'Job Schedule Field. Open' (SHS035)
Schedule function in 'Job Schedule Information. Open' (SHS230) (SHS231)
Change or delete function schedule in 'Job Schedule Entry. Update' (SHS010)
This method is only valid for a partner setup with the Download delivery field set to 1-'Yes per warehouse'.
Start 'Transport Operation Planning. Open' (MYS450). Select the partner.
You can display the lowest and highest status for a message. These alternatives are valid for download:
10='Download' - Download record created
20='Download' - Downloaded to an external system and also retrieved by the external system
91='Download/Upload' - Closed, no update
99='Download' - Deleted *)
*) Status 99 is only valid for downloaded records. Uploaded records are just deleted and will not get status 99.
Options on the (MYS450/B) panel:
The E panel displays details about a message header.
To display details about the deliveries connected to a message, select option 11='Deliveries download'. 'Downloaded Deliveries. Open' (MYS451) is started.
The (MWS451/B) panel displays the downloaded deliveries and the status of them (see step 9 above).
The E, F, and G panels display detailed information about a downloaded delivery.
A set of APIs can be used by an external system to extract the list and details of deliveries downloaded and update the status to 20='Dely downloaded'.
|MYS450MI||AddDelivery||Add delivery upload|
|MYS450MI||LstDelPlaceLoad||List delivery per Place of load|
|MYS450MI||LstHead||List message header|
|MYS450MI||LstHeadSelect||List message header with selection|
|MYS450MI||PrcHead||Process message header|
Start 'Transportation Operation Planning. Open' (MYS450).
You can display the lowest and highest status for a message. These alternatives are valid for uploads:
The E panel displays details about a message header.
To display details about the deliveries connected to a message, select option 12='Deliveries upload'. 'Uploaded Deliveries. Open' (MYS453) is started.
The (MYS453/B) panel displays the deliveries connected to a message and the status. You can select a certain delivery for upload, select option 21='Execute'.
Deliveries with these statuses can be uploaded:
30='Upload - Upload record created'
45='Upload - Error found during validation by M3 BE'
The E, F, and G panels display detailed information about a delivery.
You can also manually create a delivery that is connected to a message on the (MYS453/A) panel.
|Program ID/ Panel||Field||The field indicates …|
|(CRS165/B)||Number series type||
…the number series type.
Use type T4.
Select the check box appropriately to enable deliveries to be downloaded to an external system for transportation planning via the M3 Transportation Operational Interface.
0- No, don't download deliveries for the partner
1- Yes, download deliveries for the partner, TOI messages are created per warehouse
2- Yes, download deliveries for the partner, TOI messages are created per place of load
|(MWS010/H)||450 Download deliveries||…if a delivery should be downloaded or not.|
|(MWS410/P)||Partner||… if the chosen partner exists and is eligible for delivery download.|