What's new in version 2508.0.0.0
Features
With the features added in this release of the Aptean EDI extension,
-
The GTIN text element in the Aptean EDI 810 port is mapped with the GTIN field value from the related Item Card page when the Filler2 field in the Aptean EDI 860 port and the GTIN text element in the Aptean EDI 850 port are empty.
-
The system, when configured, automatically generates Aptean EDI 856 messages through the job queue only if the original sales order was created via an Aptean EDI 850 message.
-
You can define the ports and port options to be installed by selecting the Install Aptean EDI Ports or Install SPS Ports action on the EDI Setup page.
-
The system maps the TotalQtytobeshipped, Weight, and Volume text elements to corresponding field values on the Warehouse Receipt page when processing the Aptean EDI 943, Aptean EDI 943 Level 3, and Aptean EDI 943 Level 4 messages, as follows:
-
The TotalQtytobeshipped text element is mapped to the Quantity to Receive field on the related Warehouse Receipt page.
-
The Weight text element is mapped to the value calculated as the product of the Gross Weight field from the Item Card page and the Quantity field on the Warehouse Receipt page.
-
The Volume text element is mapped to the value calculated as the product of the Unit Volume field value from the Item Card page and the Quantity field value on the Warehouse Receipt page.
If the warehouse receipt contains multiple lines, the system maps the sum of the values from each line and the text element values are mapped accordingly.Additionally, this functionality is available for warehouse receipts generated from sales return orders, transfer orders, and purchase orders when processing the Aptean EDI 943 messages. However, for Aptean EDI 943 Level 3 and Aptean EDI 943 Level 4 messages, it applies only to warehouse receipts generated from transfer orders.
-
-
The system supports lot-tracked, license plate-tracked, and catch weight items while processing the Aptean EDI 944 messages and the field values on the Warehouse Receipt page are mapped from the inbound file as follows:
Text element in inbound file Field in Business Central WarehouseLotID Lot No. (if it is a lot-tracked item) ExpirationDate Expiration Date (if it is a lot-tracked or license plate-tracked item) UCC128Label License Plate No. (if it is a license plate-tracked item) CatchWeightQuantity Weight Qty. To Receive (UoM) (if it is a catch weight item). The UoM can differ based on the configuration on the Catch Weight Setup page. CatchWeightUOM Unit of Measure Code (if it is a catch weight item) -
The system maps the newly added BillToName and ShipToName text elements to the Ship-to and Bill-to field values from the related sales order when processing Aptean EDI 855 messages.
-
The system handles the failed EDI messages efficiently and defines how you can reset the failed messages. To know more, see Handling EDI message failures and reset actions.
-
The system maps the field values in the UCC128 Package Label 5 report to the corresponding field values on the Posted Sales Shipment page as follows:
Field name in report Field name in Posted Sales Shipment page Carrier The Agent field value in the Shipment Method group on the Shipping FastTab B/L The Order No. field value on the General FastTab Pro The Package Tracking No. field value in the Shipment Method group on the Shipping FastTab Lot # The Lot No. field value on the Posted Item Tracking Lines page linked to the Posted Sales Shipment page. Expiration The Expiration Date field value on the Posted Item Tracking Lines page linked to the Posted Sales Shipment page. -
The system maps the following fields while processing the Aptean EDI 945 and Aptean EDI 945 Sales Order messages.
Text element in the inbound file Field name in EDI Packages page (Business Central) PalletTypeCode Carton Type Code Height Height Length Length Width Width Volume Cubage PalletGTIN GTIN Additionally, the following fields are mapped to the field values on the EDI Warehouse Document and EDI Document pages while processing the Aptean EDI 945 and Aptean EDI 945 Sales Order messages respectively as follows:
Text element in the inbound file Field name in EDI Warehouse Document page in Business Central (Aptean EDI 945 port) Field name in EDI Document page in Business Central (Aptean EDI 945 port) EquipmentNo. Equipment No. Equipment No. EquipmentDescription Equipment Description Equipment Description AppointmentNumber The Appt. Reference No. field value on the Shipping FastTab of the linked Warehouse Shipment page. The Appt. Reference No. field value on the Shipping FastTab of the linked Sales Order page. PRONumber - The Package Tracking No. field in the Shipment Method group on the Shipping and Billing FastTab of the linked Sales Order page. While processing the Aptean EDI 945 Level 4 message, the system maps the PalletTypeCode field value in the inbound file to the Carton Type Code field value on the associated EDI Package page.
-
While processing the Aptean EDI 940 and Aptean EDI 940 Sales Order messages, the system updates the Pack text element with the Qty. per Unit of Measure field value on the Item Unit of Measure page instead of the CartonPack text element in the inbound file associated with Aptean EDI 850 port. Additionally, the Volume text element is mapped to the Unit Volume field value on the Item Card page.
-
The text elements have been added and the following mapping has been made in the Aptean EDI 856, Aptean EDI 856 Consolidated and Aptean EDI 856 Level 4 ports:
Aptean EDI 856
The EquipmentNumber, PalletTiers, PalletBlocks, CountryofOrigin text elements have been added.
Section Text element Mapping detail Information WeightUOM Updated by default as LB Information EquipmentDescriptionCode The Equipment Description field value on the associated EDI Posted Document page. Information NumberofCartons The LadingQty field value in the 850 inbound file, if it is empty it will follow the standard process. Information Weight The TotalWeight field value in the 850 inbound file, if it is empty it will follow the standard process. Information BillofLading The BOLNumber field value in the 850 inbound file, if it is empty it will follow the standard process. Information PackageCode Updated by default as PLT, earlier it was CTN25. Information Seal The Seal Number field value on the associated EDI Posted Document page. Information Total Volume The product of the Unit Volume and the Quantity field values on the associated sales shipment line. If there are multiple lines, the sum of the line values are updated. OrderLevelRecord TaxAmount The VAT Base Amount field value on the associated sales shipment line. If there are multiple lines, the sum of the line values are updated. OrderLevelRecord PromoDealNumber The PromoDealNumber field value in the 850 inbound file. OrderLevelRecord NumberofCartons The LadingQty field value in the 850 inbound file, if it is empty it will follow the standard process. OrderLevelRecord FrieghtAmount The sum of the Unit Price field value, when the Type field value is set to Item(Charge) and the VAT Base Amount field value, when the Type field value is set to G/L Account. If there are multiple lines, the sum of the line values are updated. PackLevelRecord UOMofBoxDimension Updated by default as IN. ItemLevelRecord ProductionDate The Posting Date field value on the associated Item Ledger Entries page. ItemLevelRecord Volume The Unit Volume field value on the associated sales shipment line. ItemLevelRecord VolumeUOM Updated by default as CU. ItemLevelRecord PackDate The Posting Date field value on the associated Item Ledger Entries page. ItemLevelRecord WeightUOM Updated by default as LB. Aptean EDI 856 Consolidated
The EquipmentNumber, PalletTiers, PalletBlocks, and LineSequence text elements are added.
Section Text element Mapping detail Information WeightUOM Updated by default as LB. Information EquipmentDescriptionCode The Equipment Description field value on the associated EDI Posted Document page. Information NumberofCartons The LadingQty field value in the 850 inbound file, if it is empty it will follow the standard process. Information Weight The TotalWeight field value in the 850 inbound file, if it is empty it is updated with the No. field value in the associated sales shipment header. Information BillofLading The BOLNumber field value in the 850 inbound file, if it is empty it will follow the standard process. Information PackageCode Updated by default as PLT, earlier it was CTN25. Information TrailerNumber The Equipment No. field value on the associated EDI Posted Document page. Information Seal The Seal Number field value on the associated EDI Posted Document page. OrderLevelRecord Weight The TotalWeight field value in the 850 inbound file, if it is empty it will follow the standard process. OrderLevelRecord FrieghtAmount The sum of the Unit Price field value, when the Type field value is set to Item(Charge) and the VAT Base Amount field value, when the Type field value is set to G/L Account. If there are multiple lines, the sum of the line values are updated. OrderLevelRecord TaxAmount The VAT Base Amount field value on the associated sales shipment line. If there are multiple lines, the sum of the line values are updated. PackLevelRecord UOMofBoxDimension Updated by default as IN. ItemLevelRecord ProductionDate The Posting Date field value on the associated Item Ledger Entries page. ItemLevelRecord Volume The Unit Volume field value on the associated sales shipment line. ItemLevelRecord VolumeUOM Updated by default as CU. ItemLevelRecord PackDate The Posting Date field value on the associated Item Ledger Entries page. ItemLevelRecord Weight The product of the Gross Weight and the Quantity field values on the associated sales shipment line. If there are multiple lines, the sum of the line values are updated. ItemLevelRecord WeightUOM (duplicate) Updated by default as LB. ItemLevelRecord InnerPack The InnerPack field value in the 850 inbound file. If it is empty, the system checks if the ItemUnitofMeasure text element value matches the Unit of Measure Code field value in the associated sales shipment, then it updates the Qty. per Unit of Measure field value associated with that line. Aptean EDI 856 Level 4
The mapping for the PackageCode and Weight text elements in the Information section has been removed.
Section Text element Mapping detail Information WeightUOM Updated by default as LB. Information NumberofCartons The LadingQty field value in the 850 inbound file, if it is empty it is updated with the sum of the non-empty packages lines on the associated EDI Packages page. Information TaxAmount The VAT Base Amount field value on the associated sales shipment line. If there are multiple lines, the sum of the line values are updated. Information FrieghtAmount The sum of the Unit Price field value, when the Type field value is set to Item(Charge) and the VAT Base Amount field value, when the Type field value is set to G/L Account. If there are multiple lines, the sum of the line values are updated.
Enhancements/Modifications
The tooltip for the Send EDI PO on Release toggle on the EDI Setup page has been updated for better readability.
UI/UX changes
The following UI/UX changes have been made in this release.
- The Install Aptean EDI Ports and Install SPS Ports actions have been added to the EDI Setup page.
- The Lot # and Expiration field values have been added to the UCC128 Package Label 5 report.
- The Number of Cartons field on the UCC128 Package Label 5 report has been renamed to Number of Pallets.
Resolved issues
The following issues have been resolved in this release.
ID | Description |
---|---|
270404 | The system fails to process the Aptean EDI 850 message when the SAC02 text element has a value, and the associated G/L account does not have a translation value on the EDI Translations page. |
275964 | The system fails to process the Aptean EDI 850 messages when the ship-to address field value on the related Sales Order page has a foreign character (for example: é). |
270960 | The system incorrectly generates Aptean EDI 850 messages for purchase invoices, purchase return orders, and purchase credit memos when the Send EDI PO on Release toggle on the EDI Setup page is turned on and the Purch. Order Port Code field has a value on the related Vendor Card page. |
286270 | The system fails to update the discounts in the ServiceAllowanceChargeDetail text element of the inbound file when processing the Aptean EDI 810 message with the SAD_ALLOWANCE port option set to Yes. |