What's new in version 2512.0.0.0

Features

With the features added in this release of the Aptean EDI extension,

• You can view the date, time, and name of the uploaded XSD file in the Flat file XSD conversion file field on the EDI Port Card page. This field is non-editable and the field value is automatically updated when you execute the Upload XSD action.

• The system skips any sales line with the Line Amount Excl. VAT field value set as 0.00, if the SKIP_ZERO_AMOUNT option is set to Yes on the EDI Port Card page, during the processing of Aptean EDI 810 and Aptean EDI 812 messages.

• The system updates the SAC02 text element in the service header allowances with the translation value of the associated No. field for sales lines where the item type is G/L Account, Resource, or Charge (Item) while processing the Aptean EDI 855 Outbound message. If the translation value does not exist for the selected line, the system skips the service allowance charge header detail for that line.
  Additionally, if the Unit Price Excl. VAT field contains a negative value, the SAC01 text element is mapped to A. The same logic applies when the inbound file includes SAC text elements and a sales order line is created automatically with the mapped values.

• The system maps the GTIN text element with the GTIN field value on the Item Card page when processing the Aptean EDI 810 message.

• The system supports the same logic used in Aptean EDI 850 when processing the Aptean EDI 860 message, based on the configuration of the following port options:

  • NAVPRICE and SYSTEMPRICE = Yes: The newly added sales lines use the Unit Price field value from the Sales Order page. Existing lines retain their price from the 850 inbound file.
  • VALIDATE = Yes: The system compares the price from the 860 inbound file with the Unit Price field value on the Sales Order page and prompts you to choose the correct value.
  • ROUND_QUANTITY = Yes: Decimal quantities are rounded to the nearest whole number.
  • INSERT_LINE_DISCOUNT = Yes: The Line Discount Amount and Line Discount % field values on the sales line are updated based on the AllowanceDetails text elements.
  • INSERT_LINE_DISCOUNT and SAD_ALLOWANCE = Yes: The Line Discount Amount and Line Discount % field values are updated based on the ServiceAllowanceChargeDetail text elements.

  If any of the port options are set to No, the system follows the standard EDI 860 processing logic.

• The system maps the BilltoDDCNo text element in the following hierarchy when processing the Aptean EDI 855 Outbound message.

  1. The BillToCode field value in the inbound file.
  2. The translation value of the Bill-to field value on the Shipping and Billing FastTab of the Sales Order page, if the sales order is created manually.
  3. The Bill-to field value on the Shipping and Billing FastTab of the Sales Order page, if the sales order is created manually.
  4. If all the above field values are empty, then the BilltoDDCNo text element is left blank.

• The system maps the text elements as follows while processing the Aptean EDI 856 and Aptean EDI 856 Consolidated messages.

  Text Element	Mapping Hierarchy
  ShipTo	The ShipToLocation field value in the inbound file. The translation value of the ship-to customer or ship-to code field value on the Posted Sales Shipment page. The GLN field value associated to the ship-to code on the Posted Sales Shipment page. The Ship-to Code field value on the Posted Sales Shipment page.
  UltimateConsigneeLocation	When the Aptean Ultimate Consignee extension is installed and the Ultimate Consignee Code field value is not blank on the associated Posted Sales Shipment page: The GLN field value associated with the Ultimate Consignee Code field value on the Posted Sales Shipment page is updated. The translation value of the Ultimate Consignee Code field value on the Posted Sales Shipment page is updated. When the extension is not installed and the Ultimate Consignee Code field value is blank on the associated Posted Sales Shipment page, the UltimateConsigneeLocation field value in the inbound file is updated.
  BuyerLocation	The BuyerLocation field value in the inbound file. The GLN field value associated to the sell-to customer on the Posted Sales Shipment page. The translation value of the Sell-to Customer No. field value on the Posted Sales Shipment page. The Sell-to Customer No. field value on the Posted Sales Shipment page.
  BillTo	The BillToLocation field value in the inbound file. The GLN field value associated to the bill-to customer on the Posted Sales Shipment page. The translation value of the Bill-to Customer No. field value on the Posted Sales Shipment page. The Bill-to Customer No. field value on the Posted Sales Shipment page.

• The system executes specific actions based on the value of the LineItemChangeCode text element while processing the Aptean EDI 860 message.

  Text element value	Action executed
  CF	Deletes the associated sales line.
  QD	Increases the quantity in the associated sales line and applies the UOM conversion.
  NC	Skips the associated sales line without any changes.

• The system skips the line and no changes are updated if the ChangeCode text element is set to NC when processing the Aptean EDI 860 message.

• When processing the Aptean EDI 860 message, the mappings for the ShipNotBeforeDate and ShipNotAfterDate text elements have been removed.

  Instead, the system maps:

  • The NotBeforeDate text element to:
    • The Start Request Ship Date field value on the EDI Document page.
    • The Shipment Date field value on the Sales Order page.
  • The NotAfterDate text element to:
    • The Requested Delivery Date field value on the Sales Order page.
    • The Third Date Record field value on the EDI Document page.

• The system generates EDI messages for all files uploaded via EDI One transaction and displays an error when processing messages associated with empty files without blocking the process for the correct messages.

• The Send Invoice action on the All EDI Messages page has been hidden to prevent unnecessary bulk invoice creation, as it generates invoices for all existing orders. However, you can restore the action through personalization if needed.

• You can generate labels in batch for single/multiple records by selecting the UCC Package Label (Batch) action on the relevant pages.

  
  This functionality works when the Aptean EDI extension is used with the Aptean LinkFresh or Aptean JustFood apps. However,

  • When Aptean LinkFresh is installed, the action is available on the Posted Sales Shipment, Warehouse Shipment, and Posted Warehouse Shipment pages.
  • When Aptean JustFood is installed, the action is available on the Posted Sales Shipment, Warehouse Shipment, Posted Warehouse Shipment, Shipping Containers, and Posted Shipping Containers pages.

  Additionally, the system automatically updates the Record Type and Record No. field values on the EDI Pkg Batch Selection dialog based on the selected record on the related page.

• The system sends customer data related to item information stored in the item reference table for the selected customer, when you process the Aptean EDI 832 message by selecting the Send Price Catalog action on the Customer Card page.

• The system maps the BuyersCurrency and SellersCurrency text elements as follows while processing the SPS Commerce 810 message.

  1. The translation value of the Currency Code field value on the Posted Sales Invoice page.
  2. The translation value of the LCY Code field value on the General Ledger Setup page.

• The system maps the PackUOM text element to the PackUOM field value from the Aptean EDI 850 inbound file when processing the Aptean EDI 810 message.

• The system represents the schema for the newly added ports in EDIFACT format, with port options available for EMEA customers. To know more, see EDI ports in EDIFACT format.

• You can define the Recipient GLN field value for outbound transactions in the following outbound EDI ports:

  • INSDES01B WhseShipExpBCW
  • ORDERS D96A PurchOrderExpBCW
  • DESADV D01B L4 Sales Shipment Outbound
  • DESADV D01B L4 Transfer Shipment Outbound
  • INVOIC D01B Sales Invoice Outbound
  • INVOIC D01B Sales Credit Memo Outbound
  • APERAK D96A Exp

• You can define the EDI port for a Logistics Service Provider (LSP) in the Purch. Order EDI Port Code field on the Location Card page associated with purchase orders. When sending the outbound orders, if both the vendor and the location have EDI port codes defined, the system displays a dialog to select an option to send the message. The available options are: Vendor, Logistics Service Provider, and Both.

• The system uses the EDI port code defined in the Shipment EDI Port Code field on the Location Card page when sending messages associated with the DESADV D01B L4 Transfer Shipment Outbound port.

Enhancements/Modifications

With this release of the Aptean EDI, the system maps the text element field values in the correct sequence in the EDI file format, ensuring accurate and ordered data representation for both inbound and outbound EDI ports. This enhancement addresses the issue reported in bug ID #298970.

UI/UX changes

The following UI/UX changes have been made in this release.

• The following ports have been added:
  • Aptean EDI 832
  • INSDES01B WhseShipExpBCW
  • INVRPTD01BItemJrnlImp
  • ORDERS D96A PurchOrderExpBCW
  • ORDERS D96A SalesOrderImp
  • DESADV D01B L4 Sales Shipment Outbound
  • DESADV D01B L4 Transfer Shipment Outbound
  • DESADVD01B L4 WhseShipImp
  • RECADV D01B L4 WhseRcptImpBCW
  • DELFOR D96A DelivFrcstImpBCW
  • INVOIC D01B Sales Invoice Outbound
  • INVOIC D01B Sales Credit Memo Outbound
  • APERAKD96A Exp
• The Send Price Catalog action has been added to the Customer Card page.
• The Recepient GLN field has been added to the following outbound ports:
  • INSDES01B WhseShipExpBCW
  • ORDERS D96A PurchOrderExpBCW
  • DESADV D01B L4 Sales Shipment Outbound
  • DESADV D01B L4 Transfer Shipment Outbound
  • INVOIC D01B Sales Invoice Outbound
  • INVOIC D01B Sales Credit Memo Outbound
  • APERAK D96A Exp
• The Purch. Order EDI Port Code and Shipment EDI Port Code fields have been added to the Location Card page.
• The SKIP_ZERO_AMOUNT port option has been added to the EDI Port Card page associated to the Aptean EDI 810 and 812 ports.
• The XSD field has been renamed to Flat file XSD conversion file on the EDI Port Card page.
• The Send Invoices action has been hidden from the All EDI Messages page.

  
  This action can be made visible through personalization.

Resolved issues

The following issues have been resolved in this release.