This document provides detailed list on the mapping of fields and data flow involved in the process of creating a Pack-It consignment from a Warehouse Shipment in Microsoft Dynamics 365 Business Central.
Field Mapping on Consignment Creation
This information below provides a detailed overview of how the various consignment fields are mapped from the warehouse shipment itself or from the source documents of Warehouse Shipment lines, specifically Sales Orders and Transfer Orders
Shipping Fields
| Consignment Field | Warehouse Shipment | Sales Order | Transfer Order |
|---|---|---|---|
| Shipping Time | Shipping Time | Shipping Time (only if the warehouse shipment doesn’t have the time specified) | Shipping Time (only if the warehouse shipment doesn’t have the time specified) |
| Shipment Date | Shipment Date | – | – |
| Ship-From Location Code | Location Code | – | – |
| Shipping Agent Code | Shipping Agent Code (if available) | Shipping Agent Code (only if the warehouse shipment doesn’t have the code specified) | Shipping Agent Code (only if the warehouse shipment doesn’t have the code specified) |
| Shipping Agent Service Code | Shipping Agent Service Code (if available) | Shipping Agent Service Code (only if the warehouse shipment doesn’t have the code specified) | Shipping Agent Service Code (only if the warehouse shipment doesn’t have the code specified) |
| Ship To Contact | – | Ship-to Contact | Transfer-to Contact |
| Ship To Name | – | Ship-to Name | Transfer-to Name |
| Ship To Address | – | Ship-to Address | Transfer-to Address |
| Ship To Address 2 | – | Ship-to Address 2 | Transfer-to Address 2 |
| Ship To County | – | Ship-to County | Transfer-to County |
| Ship To Post Code | – | Ship-to Post Code | Transfer-to Post Code |
| Ship To Country/Region Code | – | Ship-to Country/Region Code | Country/Region Code |
| Ship To Code | – | Ship-to Code | Transfer-to Code |
| Ship To City | – | Ship-to City | Transfer-to City |
| Ship To No | – | Sell-to Customer No. | – |
| Ship To Customer Name | – | Sell-to Customer Name | – |
| Ship To Phone | – | Sell-to Phone No. | Phone No. |
| Ship To Email | – | Sell-to E-Mail |
External Document No.
The “External Document No.” is a combination of the numbers from all the related source documents of the warehouse shipment lines, including Sales Orders, Transfer Orders that have been assigned the same Consignment.
As an example it will be constructed as follows ‘SO-123,SO-456’.
Special Instructions
The “Special Instructions” field is populated by combining instructions from all the related source documents of the warehouse shipment lines, including Sales Orders, Transfer Orders assigned to the same Consignment.
As an example it will be constructed as follows “Please ensure that all items are packed separately, fragile items should be wrapped in bubble wrap.”.
Synchronization with Source Documents
Changes made directly on the Consignment will not sync with the source documents and Warehouse Shipment until the Warehouse Shipment is posted.
Upon posting, the following fields from the Consignment will be updated to the Posted Source Documents (e.g., Posted Sales Shipment and Transfer Shipment) and Posted Warehouse Shipment:
- Shipping Agent Code
- Shipping Agent Service Code
- Shipment Date
- Shipping Time
- Package Tracking No.
- Ship From Location Code
- Special Instructions
- Ship To Address fields
- Ship To Contact fields
This mapping ensures that the Consignment created from Warehouse Shipment Lines correctly reflects data from the related Sales Orders and Transfer Orders. It maintains synchronization with the source documents, ensuring that all relevant information is consistently updated when the Warehouse Shipment is posted.
