What's new in version 2515.1.0.0

Enhancements/Modifications

With this release of the Aptean EDI extension,

• The system supports multiple report types when processing the INVRPT D01B Item Journal Inbound message. If the ReportType field value in the inbound file is set to Inventory Adjustment Status, the system generates item journals. If it is set to Inventory Status Advice, the system generates physical inventory journals, which is an existing functionality. Additionally, the item journal type is determined by the value in the InventoryMovementDirectionCode text element:

  • Movement into inventory: The system creates a positive adjustment.
  • Movement out of inventory: The system creates a negative adjustment.

• The system calculates and updates the TaxBaseAmountExcludingPaymentDiscount and TaxBaseAmountIncludingPaymentDiscount text elements when processing the INVOIC D01B Sales Credit Memo Outbound and INVOIC D01B Sales Invoice Outbound messages as follows:

  • TaxBaseAmountIncludingPaymentDiscount: The system calculates this value as the Amount field value in the sales credit memo or sales invoice header minus the Payment Discount Amount field value.

    The formula is: TaxBaseAmountIncludingPaymentDiscount = Amount - Payment Discount Amount

  • TaxBaseAmountExcludingPaymentDiscount: The system sets this value to the Amount field value in the sales credit memo or sales invoice header.

    The formula is: TaxBaseAmountExcludingPaymentDiscount = Amount

  Additionally, the system updates the Amount text element in the PaymentHeader section. The system calculates this value as the Amount Including VAT field value multiplied by the Payment Discount % field value.

  The formula is: Amount = Amount Including VAT × Payment Discount %

• When the Aptean Beverage Empty Goods and Deposit Management, Drink -IT Edition, and Aptean Beverage Foundation Management, Drink -IT Edition, extensions are installed, the Mutually defined reference number type is displayed in the Reference section and Number text element has been updated with EANNL1 as a default value while processing the DESADV D01B L4 Sales Shipment Outbound and DESADV D01B L4 Transfer Shipment Outbound messages. Additionally, you can define catch weight details for catch weight items on the Catch Weight Setup page and send the related information from the Measurements section as follows:

  Text element	Mapped value
  Type	Weights (Default)
  Dimension	Net weight (Default)
  MeasurementCode	The Unit of Measure Code field value on the Catch Weight Setup page.
  Value	The weight quantity field value from the associated posted sales shipment or posted transfer shipment page.

• The system updates the TotalNumberofBoxes text element with the Qty. Packed field value on the EDI Package page when the EDI Package Type field value includes a pallet while processing the DESADV D01B L4 Sales Shipment Outbound or DESADV D01B L4 Transfer Shipment Outbound message. This enhancement addresses the issue reported in bug ID /#335136.

• The system inserts an allowance line in the TrailerAllowances and DetailAllowances sections for packaging items, with all price values set to 0, when the PACKAGE_ALLOWANCE port option is set to Yes while processing the INVOIC D01B Sales Credit Memo Outbound and INVOIC D01B Sales Invoice Outbound messages. Additionally, the system updates the QualifierAllowance and CodeTypeOfAllowance text elements with Charge and Returnable container values in the allowance sections.

• The system supports the Despatch Advice order type in addition to the Goods Receipt and Returns Advice order types while processing the RECADV D01B L4 WhseRcptImpBCW message.

• The system supports corrected invoice when the CREDIT_NOTE_TYPE port option is set to 384 while processing the INVOIC D01B Sales Credit Memo Outbound message. This updates the InvoiceType text element as Corrected Invoice and the amount, quantity, and allowance details in negative values. Additionally, the system updates the InvoiceNumber text element in the Reference section with the Apply To Doc. No. field value in the associated sales credit memo header.

• The system generates a warehouse receipt for a sales return order, purchase order, or transfer order using the source number provided in the Number field in the Reference section of the inbound file, where the Type field value is set to Order number (buyer).

  Earlier, the system used the OrderNumber text element for this purpose. For existing entries, the mapping must be changed manually. This enhancement addresses the issue reported in bug ID /#333359

• The system updates the details of the Quantity and Price sections while processing the INVOIC D01B Sales Credit Memo Outbound and INVOIC D01B Sales Invoice Outbound messages for catch weight items as follows:

  Type of document	Section	Text element	Mapped value
  Sales invoice or sales credit memo	Quantity	Type	Invoiced quantity
  		Value	The Weight Quantity field value in the posted sales invoice line or posted sales credit memo line.
  		MeasurementCode	The Applied Price UOM Code field value in the posted sales invoice line or posted sales credit memo line.
  	Price	Type	Invoice price
  		Value	The Applied Unit Price field value in the posted sales invoice line or posted sales credit memo line.
  		MeasurementCode	The Applied Price UOM Code field value in the posted sales invoice line or posted sales credit memo line.

  Additionally, the system displays only the Calculation net type when the NET_PRICE_ONLY port option is set to Yes. This functionality is available when the Aptean Catch Weight and Aptean Advanced Pricing extensions are installed.

• The system updates the TypeOfPallet text element with the value from the Packaging ISO field on the Packaging Types page while processing the DESADV D01B L4 Sales Shipment Outbound and DESADV D01B L4 Transfer Shipment Outbound messages. If the Packaging ISO field value is left blank, the system instead updates the TypeOfPallet text element with the value from the Code field on the Packaging Types page.

• The system displays only the Calculation Net order type in the Price section and updates the price values as 0 for packaging items when both the NET_PRICE_ONLY and PACKAGE_ALLOWANCE port options are set to Yes. This enhancement addresses the issue reported in bug ID #336711.

UI/UX changes

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

• The PACKAGE_ALLOWANCE port option has been added to the INVOIC D01B Sales Credit Memo Outbound and INVOIC D01B Sales Invoice Outbound ports.
• The NET_PRICE_ONLY port option has been added to the INVOIC D01B Sales Credit Memo Outbound and INVOIC D01B Sales Invoice Outbound ports.
• The CREDIT_NOTE_TYPE port option has been added to the INVOIC D01B Sales Credit Memo Outbound port.
• The Packaging ISO field has been added to the Packaging Types page.
• The Goods Receipt order type has been renamed as Despatch advice and Goods movement incoming order type has been renamed as Goods receipt in the RECADV D01B L4 WhseRcptImpBCW port.

Resolved issues

The following issues have been resolved in this release.