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
Fields marked with † will always prioritize the value from the warehouse shipment, if specified, and disregard any values from the sales order or transfer order.
| Consignment Field | Warehouse Shipment | Sales Order | Transfer Order |
|---|---|---|---|
| Shipping Time† | Shipping Time | Shipping Time | Shipping Time |
| Shipment Date | Shipment Date | – | – |
| Ship-From Location Code | Location Code | – | – |
| Shipping Agent Code† | Shipping Agent Code | Shipping Agent Code | Shipping Agent Code |
| Shipping Agent Service Code† | Shipping Agent Service Code | Shipping Agent Service Code | Shipping Agent Service Code |
| 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 | – | When Ship-To is Default/Custom Address: Sell-to Phone No. Alternative Address: Phone No. (from Ship to Address) | Phone No. |
| Ship To Email | – | When Ship-To is Default/Custom Address: Sell-to E-Mail Alternative Address: E-Mail (from Ship to Address) |
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.
