What's new in version 2515.0.0.0
Features
With the features added in this release of the Aptean EDI extension,
-
The system updates the Number text element in the Reference section for sales and transfer orders when you execute the Send Pick action on the related Warehouse Shipment page while processing the INSDES D01B Warehouse Shipment Outbound message.
- When the warehouse shipment is created from a sales order, the Number text element is updated with the value from the VAT Registration No. field value on the sales order header.
- When the warehouse shipment is created from a transfer order, the Number text element is updated with the value from the VAT Registration No. field value on the Company Information page.
- You can define the alcohol content for beverage items on the EDI DrinkIT Measurements page and send the related information from the Measurements section while processing the DESADV D01B L4 Sales Shipment Outbound and DESADV D01B L4 Transfer Shipment Outbound messages. To know more, see Manage EDI Drink-IT measurements.
- When the Aptean Beverage Customs Document Management extension, Drink-IT Edition, is installed, the system updates the ARC No. field value on the header and lines of the Customs Document page from the Value text element in the Reference section when the Type text element is set to Quota number while processing the DESADV D01B L4 Warehouse Shipment Inbound message.
-
The system sends the address information like name, address, city, zip code and country in the INSDES D01b Warehouse Shipment Outbound message created through sales order, transfer order, and purchase return order when the related GLN and shipping agent field values are available for the PartnerQualifier text element type in the Partner section as follows:
Document type PartnerQualifier type Mapped field value for address details Sales order Buyer The GLN field value for the related sell-to customer. Supplier The GLN field value on the Company Information page. Delivery Party The GLN field value for the related ship-to code > The GLN field value for the related sell-to customer. Ultimate Consignee The GLN field value for the related ultimate consignee. This is applicable only when the Aptean Ultimate Consignee extension is installed. Warehouse Keeper The GLN field value for the related location. Carrier When the Aptean Beverage Customs Document Management extension, Drink-IT Edition, is installed, the translation value of the related shipping agent field on the EDI Translations page, only if the INCLUDE_CARRIER port option is set to Yes. Else, the Vendor No. field value on the related Shipping Agents page when the Aptean Transport extension is installed. Transfer order Delivery Party The GLN field value for the related transfer-to code. Warehouse Keeper The GLN field value for the related transfer-from code. Carrier When the Aptean Beverage Customs Document Management extension, Drink-IT Edition, is installed, the translation value of the related shipping agent on the EDI Translations page, only if the INCLUDE_CARRIER port option is set to Yes. Else, the Vendor No. field value on the related Shipping Agents page when the Aptean Transport extension is installed. Purchase order Buyer The GLN field value on the Company Information page. Seller The GLN field value for the related buy-from vendor. Delivery Party The GLN field value for the related ship-to code > The GLN field value for the related buy-from customer. Warehouse Keeper The GLN field value for the related location.
-
The system updates the Posting Date and Due Date field values on the Purchase Invoice page while processing the Aptean EDI 210 message as follows:
Field Mapping hierarchy Posting Date The InvoiceDate field value in the inbound file > Work date in the system. Due Date The NetDueDate field value in the inbound file > Sum of the Posting Date and Payment Terms Code field values on the related Purchase Invoice page > The Posting Date field value on the related Purchase Invoice page.
-
You can configure the Process Shipment Outbound Dispatch Advice Changes and Process Receipt Outbound Dispatch Advice field values on the EDI Setup page to automatically send the 940 and 943 messages respectively. To know more, see EDI Setup.
You can release the warehouse receipt only when the Aptean Mobile Warehouse Registration extension is installed.
- You can share and process your files in the Azure File Share storage location by selecting the Azure File Share option in the Type field on the EDI Setup page and also in the Connection Type field on the respective EDI Port Card page.
- The DESADV D96A L1 Sales Shipment Outbound and DESADV D96A L1 Transfer Shipment Outbound ports send outbound DESADV messages without the packaging segment. The Sales Shipment Outbound port is defined in the Shipment Port Code field on the Customer Card page associated with the Posted Sales Shipment page, while the Transfer Shipment Outbound port is defined in the Shipment EDI Port Code field on the Location Card page associated with the Posted Transfer Shipment page.
-
The system updates the SCACCode and Routing text elements in the following hierarchy when processing the Aptean EDI 940 messages associated with the warehouse shipment and sales order.
When the Shipping Agent Code field has a value, the system updates as follows:
SCACCode
- The SCAC field value on the Shipping Agents page.
- The translation value for the related shipping agent on the EDI Translations page.
- The Shipping Agent Code field value on the Warehouse Shipment page.
Routing
- The translation value for the related shipping agent on the EDI Translations page.
- The Shipping Agent Code field value on the Warehouse Shipment page.
When the Shipping Agent Code field value is blank, the system updates the text elements with the Agent and Agent Service field values from the associated Sales Order page.
This logic also applies to purchase orders when processing the Aptean EDI 943 messages.
The Agent and Agent Service fields are available on the Purchase Order page only when the Aptean Essentials extension is installed.
- The system updates the TotalTaxAmount text element in the Totals segment by summing the values in the TotalTaxAmount text elements in the TaxLine segments related to each tax line while processing the INVOIC D01B Sales Credit Memo Outbound and INVOIC D01B Sales Invoice Outbound messages.
-
The system updates the EDIUnitofMeasure text element when processing the Aptean EDI 850, Aptean EDI 860, and Aptean EDI 812 messages. The update follows this hierarchy:
- The unit of measure value in the inbound file
- The EDI translation value for the item unit of measure.
- The EDI translation value for the unit of measure.
- The Sales Unit of Measure field value on the Item Card page.
- The Base Unit of Measure field value on the Item Card page.
- The unit of measure value in the inbound file
- The system updates the Lot No. field value on the Item Tracking Lines and EDI Packages pages with the lot number value from the SPS Commerce 945 Sales Order message. Additionally, the system updates the SerialLotNumber and LotExpirationDate text elements with the same lot number and corresponding expiration date while processing the SPS Commerce 856 Consolidated message.
-
The system updates the Expiration Date field value on the Item Tracking Lines page based on the date values from the inbound file in the following order of priority while processing the RECADV D01B Warehouse Receipt Inbound message.
- Best before date
- Expiry date
- Sell by date
-
The system calculates the NumberOfPallets text element while processing the Aptean EDI 856 and 856 Consolidated messages as follows:
-
In the 856 message, the NumberOfPallets text element is calculated as the number of shipment lines for items with the Exclude from outbound EDI toggle turned off on the related Item Card page.
-
In the 856 Consolidated message, the NumberOfPallets text element is calculated as the total number of EDI packages for all items on the Posted Sales Shipment page, regardless of the Exclude from outbound EDI toggle configuration.
-
- You can send an INSDES D01B Warehouse Receipt Outbound message from a warehouse receipt created from a purchase order, sales return order, or transfer order.
Enhancements/Modifications
With this release of the Aptean EDI extension,
- The PartnerQualifier text element value has been changed to Supplier instead of Seller while processing the INSDES D01B Warehouse Shipment Outbound message.
- The system updates the Expiration Date field value with the system expiration date while processing the INVRPT D01B ItemJrnlImp message. If the system expiration date is empty, the field is updated with the Best Before Date value from the inbound file. If both values are empty, the field remains blank. This enhancement addresses the issue reported in bug ID #329681.
- The Dimension field value has been modified from Catch weight quantity to Net Weight in the RECADV D01B L4 WhseRcptImpBCW message. This enhancement addresses the issue reported in bug ID #330496.
- The mapping for the VendorStyleNumber and CustomerSKUCode text elements have been changed. The VendorStyleNumber text element maps to the Reference No. field on the Item Reference Entries page instead of the item number on the Purchase Order page, and the CustomerSKUCode text element maps to the item number on the Purchase Order page instead of the Reference No. field.
UI/UX changes
The following UI/UX changes have been made in this release.
- The DESADV D96A L1 Sales Shipment Outbound and DESADV D96A L1 Transfer Shipment Outbound ports have been added.
- The EDI DrinkIT Measurements page has been added.
- The Process Shipment Outbound Dispatch Advice Changes and Process Receipt Outbound Dispatch Advice fields have been added to the Process FastTab on the EDI Setup page.
- The Azure File Share option has been added to the Type field on the Default Connection FastTab of the EDI Setup page.
- The Azure File Share option has been added to the Connection Type field on the Connection FastTab of the EDI Port Card page.
- The INSDES D01B Warehouse Receipt Outbound port has been added.
Resolved issues
The following issues have been resolved in this release.
| ID | Description |
|---|---|
| 330593 | The system incorrectly skips all the EDI messages after processing the EDI port for which the Disable Automatic field is set to Processing during the execution of the EDI Job Queue. |
| 326723 | The system incorrectly updates the lot information even when the Batch Number option is not selected for the AddititionalItemIDType text element while processing the ORDERS D96A SalesOrderImp message. |
| 327862 | The system fails to display the Article section when EDI packages exist only at a pallet level and no cartons are available, while processing the DESADV D01B L4 Sales Shipment Outbound and DESADV D01B L4 Transfer Shipment Outbound messages. |
| 327865 | The system fails to update packaging information from the document lines of the XML message, even when the package is defined and the FB_USE_PCKG_LINES port option is set to Yes. Instead, it updates only the related packaging page. This issue occurs while processing the RECADV D01B L4 WhseRcptImpBCW and DESADV D01B L4 WhseShipImp messages. |
| 328539 | The system incorrectly updates charge details in the header allowance section instead of the detail allowance section for lines with multiple lots, based on the allocation in the Value Entry table that determines whether charges apply to the header or detail allowance. This issue occurs while processing the INVOIC D01B Sales Credit Memo Outbound and INVOIC D01B Sales Invoice Outbound messages. |
| 328557 | The system incorrectly calculates the total quantity to receive as the sum of all lines in the document instead of calculating the lot quantity and quantity to receive for each line while processing the RECADV D01B L4 WhseRcptImpBCW message. |
| 329681 |
|
| 330063 | The system incorrectly updates the Location Code and Forecast Quantity field values on the DELFOR Entries page when processing the DELFOR Delivery Forecast message. |
| 330496 | The system fails to update the Weight Qty. to Receive (KG) field value on the Warehouse Receipt page from the Value text element in the Measurement section for a catch weight item when processing the RECADV D01B L4 WhseRcptImpBCW message. |
| 206319 | The system incorrectly maps the unit of measure while processing the Aptean EDI 944 message because it uses the associated warehouse receipt number instead of the related item number. |
| 329183 | The system fails to convert the flat file while processing the Aptean EDI 943 Level 3 message as it contains an unsupported nested method. |
| 325982 | The system incorrectly updates the TPCode text element with the field value from the inbound file instead of using the value defined on the EDI Translation page when the TPCODE_TRANS_PRIO port option is set to Yes while processing the Aptean EDI 856 messages. |
| 328141 | An error occurs when creating the Aptean EDI 856 Consolidated message, as EDI packages are not created correctly when using the Aptean EDI 945 and 945 SO ports. |