EDI 3PL
EDI 3PL Documents - Picking list
EDI 3PL Documents - Picking list
The following setup is prerequisites for the picking list
EDI > Setup > 3PL setup
EDI > Setup > Document types: Picking list
EDI > Setup > Trading partners
Note: If the 3PL setup mappings are not assigned to the warehouse trading partner for an outbound document, the D365/EDI value will be sent, example Original instead of a mapped value.
An outbound picking list can be triggered via the following methods:
Each picking list document will also have an order purpose which is specified in Order purpose group and assigned to the Trading partner. Options:
Once the order has been picked by the 3PL, the pick information is sent back via the inbound Picking list registration document.
To view the picking list staging records, go to EDI > Documents > 3PL documents > Picking list. Use this page to review staging and process EDI Picking list documents to an Outbound file.
The following EDI fields are available on the list page.
| Field | Description |
|---|---|
| EDI number | EDI Staging table record id. Select EDI number or the Details button on the Action Pane, to view the details for the selected record. The number sequence is determined by EDI number on the EDI parameters. |
| Company | Legal entity of the document |
| Company GLN | The company’s global location number is shown here |
| Staging to target status | The current status of the staging record. Options include: • Not Started – The staging record has been created but no outbound file has yet been generated. • Error – The staging record has been processed, but no outbound file has been created. There are errors with the staging record that needs to be reviewed. • Completed – The staging record has been succesfully processed and added to the outbound file queue. • Canceled – The record has been manually canceled and will be excluded from processing. |
| Trading partner account | 3PL account assigned to the staging record |
| Trading partner GLN | The 3PL’s global location number is shown here |
| Picking route | Picking route Id |
| Reference | Identification if pick route is related to a sales order or transfer order |
| Order Id | Sales or transfer order’s identification |
| Customer requisition | Customer’s purchase order number (only where pick list is related to a sales order) |
| Your ref. | Customers reference (only where pick list is related to a sales order) |
| EDI order purpose | The EDI order purpose is shown here |
| Created date and time | The date and time the selected record was created in the staging table |
| Received | Indicates if the Functional acknowledgement inbound has been received from the trading partner for the outbound document record |
The following buttons are available on the Picking list Action Pane, tab Picking list to 3PL.
| Button | Description |
|---|---|
| Create selected files | Creates the outbound file for selected records where Staging to target status is set to Not started |
| Create files | Creates the outbound file for all records where Staging to target status is set to Not started |
| Outbound files | View the outbound file record created by the selected staging record |
| Trading partner | View the trading partner details in the Trading partners page |
| Picking list registration | View the picking list registration |
| Show log | If there are logs created within the Process to outbound step it is possible to review them at any time using this button. Shows only the current version. |
| Reset Status | You can reset the the Staging to target status to Not started. This can be used to reprocess the selected record/s. Documents can only be processed if Staging to target status is set to Not started. |
| Edit reset status recurrence | If the underlying issue was resolved after all the reset attempts have been completed the user can use this button to edit the recurrence field/s. This will: • Update Reset status profile to blank • Update the Reset status date/time to next time reset will run • Reset status attempts set to Zero and • Recurrence text updated with changed recurrence details |
| Reset template | Reset the template used to create the outbound file. Only enabled where the Staging to target status is set to Not started. |
| Cancel | Select Cancel to update the Staging to target status to Canceled. Button is enabled when the Staging to target status is not set to Completed. |
The following buttons are available on the Picking list’s Action Pane, tab Acknowledgement. The Acknowledgement tab is available on all outgoing documents staging pages and enables the user to view the Functional acknowledgement inbound that has been received and processed for the outbound document.
| Button | Description |
|---|---|
| Acknowledgement | Use this button to view the Functional acknowledgement inbound record received and processed for the outbound document. |
The following EDI Header staging fields are available on the header page.
| Field | Description | D365 source |
|---|---|---|
| Identification FastTab | ||
| Identification | ||
| EDI number | EDI Staging table record id | Original EDI number |
| Company | Legal entity of the document | |
| Company GLN | The company’s global location number is shown here | Company GLN |
| Template Id | The EDI template that will be used to create the outbound file | Trading partner > Template assigned to document type |
| Staging to target status | The current status of the staging record. Options include: • Not Started – The staging record has been created but no outbound file has yet been generated. • Error – Th staging record has been processed, but no outbound file has been created. There are errors with the staging record that needs to be reviewed. • Completed – The staging record has been succesfully processed and added to the outbound file queue. • Canceled – The record has been manually canceled and will be excluded from processing. |
|
| Reset status | ||
| Reset status profile | Reset status profile assigned to the file/document. This will default from EDI shared parameters or can be overridden on Trading partner’s incoming and outgoing documents. The profile can also be changed to another profile which will also reset the Reset status attempts to 0 and reset the Reset status date/time | |
| Reset status date/time | Next date/time automatic reset status will run | |
| Reset status attempts | Number of reset attempts already processed. The reset attempts will stop once this number reaches the End after as per assigned Reset status profile’s Recurrence | |
| Recurrence | Recurrence text. Contains standard details of Recurrence, for example: • Interval (recurrence pattern) • How many times the period will run (End after) • From date/time the recurrence will start |
|
| Overview | ||
| Picking Route | Picking route Id | Picking Route > Id |
| Warehouse | Warehouse for the picking list record | Picking Route > Warehouse |
| Reference | Identification if pick route is related to a sales order or transfer order | Picking route > Reference |
| Order Id | Sales or transfer order’s identification | Picking route > Number |
| Customer requisition | Customers purchase order number | Sales Order > Customer requisition |
| Your ref. | Customers reference | Sales Order > Customer reference |
| EDI order purpose | The EDI order purpose is shown here. Mapped value from Order purpose group |
Order purpose code |
| Status | ||
| Group control number | Group control number for the outbound document. To be used to match inbound functional acknowledgement, where applicable. | |
| Received | Indicates if the Functional acknowledgement inbound has been received from the trading partner for the outbound document record. | |
| General FastTab | ||
| Delivery | ||
| Name | Address for Delivery | Order > Delivery Address |
| Delivery address | Address for Delivery | Order > Delivery Address |
| Post box | Address for Delivery | Order > Delivery Address |
| Building complement | Address for Delivery | Order > Delivery Address |
| Street number | Address for Delivery | Order > Delivery Address |
| Street | Address for Delivery | Order > Delivery Address |
| City | Address for Delivery | Order > Delivery Address |
| Suburb | Address for Delivery | Order > Delivery Address |
| State | Address for Delivery | Order > Delivery Address |
| City | Address for Delivery | Order > Delivery Address |
| Postcode | Address for Delivery | Order > Delivery Address |
| Country/region | Address for Delivery | Order > Delivery Address |
| Note | ||
| Delivery note |
The following EDI Line staging fields are available on the lines page.
| Field | Description | D365 source |
|---|---|---|
| Line number | The line within the EDI table/file | Created by EDI. Incremented per each picking list line |
| Our item number | The D365 item number | Pick route line > Item Number |
| Bar code | D365 item id’s Bar code (based on unit) | Released products > Bar codes |
| GTIN | D365 item id’s GTIN (based on unit) | Released products > GTIN codes |
| Description | D365 item id’s Description | Released products > Product name |
| Lot Id | Lot id for the transfer order line | Order > Lot id |
| Quantity | Picking list quantity | Pick route line > Quantity |
| Unit | Picking list quantity’s unit | Released products > Inventory unit |
| Colour | Product dimensions – colour | Pick route line > Colour |
| Size | Product dimensions – Size | Pick route line > Size |
| Style | Product dimensions – Style | Pick route line > Style |
| Configuration | Product dimensions – Configuration | Pick route line > Configuration |
| Version | Product dimensions – Version | Pick route line > Version |
| Batch number | Tracking dimensions – Batch number | Pick route line > Batch number |
| Serial number | Tracking dimensions – Serial number | Pick route line > Serial number |
| Inventory status | Storage dimensions – Inventory status Mapped value for Inventory status |
Pick route line > Inventory status |